metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA280983" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA280983" and tax_phylum = "Chordata"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1059007	1059007	PRJNA280983_P_NODE_5501_length_266_cov_1.861751_g5386_i0	PRJNA280983	5501	266	1.861751	4.95225766	Chordata	7711	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2921976426\|gb\|CP130422.1\|	8855	g5386	i0	100	0.661654135338346	29	0	11	0	136	164	26602771	26602743	Cairina moschata breed yongchun chromosome 7	blastn	176	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Cairina	Cairina moschata
4198774	4198774	PRJNA280983_P_NODE_5564_length_263_cov_23.228972_g5449_i0	PRJNA280983	5564	263	23.228972	61.09219636	Xenopus tropicalis	8364	Chordata	Chordata	56.5	0.002	NTclustered	gi\|91754111\|dbj\|AB244214.1\|	8364	g5449	i0	100	11.8098859315589	30	0	11	0	234	263	30	1	Xenopus (Silurana) tropicalis mRNA for thyroid hormone receptor beta, complete cds	blastn	3106	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
5475044	5475044	PRJNA280983_P_NODE_4505_length_309_cov_1.915385_g4390_i0	PRJNA280983	4505	309	1.915385	5.91853965	Python bivittatus	176946	Chordata	Chordata	196	1.26e-45	NTclustered	gi\|1391811451\|ref\|XM_007445385.2\|	176946	g4390	i0	85.87	6.22977346278317	184	26	60	0	2	185	305	122	PREDICTED: Python bivittatus ribosomal protein S25 (RPS25), partial mRNA	blastn	1925	196	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Pythonidae	Python	Python bivittatus
6749342	6749342	PRJNA280983_P_NODE_3686_length_351_cov_1.182119_g3571_i0	PRJNA280983	3686	351	1.182119	4.14923769	Branchiostoma belcheri	7741	Chordata	Chordata	220	8.59e-53	NTclustered	gi\|24266987\|gb\|AF548335.1\|	7741	g3571	i0	79.299	52.965811965812	314	65	89	0	35	348	137	450	Branchiostoma belcheri ribosomal protein S18 mRNA, complete cds	blastn	18591	220	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
8024961	8024961	PRJNA280983_P_NODE_7907_length_200_cov_1.013245_g7792_i0	PRJNA280983	7907	200	1.013245	2.02649	Varanus komodoensis	61221	Chordata	Chordata	117	6.0700000000000005e-22	NTclustered	gi\|2117959797\|ref\|XM_044420548.1\|	61221	g7792	i0	89.247	16.125	93	10	47	0	1	93	1190	1282	PREDICTED: Varanus komodoensis actin alpha 1, skeletal muscle (ACTA1), mRNA	blastn	3225	117	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Varanidae	Varanus	Varanus komodoensis
9987093	9987093	PRJNA280983_P_NODE_5748_length_257_cov_3.115385_g5633_i0	PRJNA280983	5748	257	3.115385	8.00653945	root	1	Root_unresolved	Root_unresolved	425	1.2e-114	NTclustered	gi\|2904934840\|gb\|PQ737764.1\|	10090	g5633	i0	100	325.377431906615	230	0	89	0	10	239	255	26	Mus musculus lncRNA174 lncRNA, complete sequence	blastn	83622	425	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11850275	11850275	PRJNA280983_P_NODE_2890_length_408_cov_11.100279_g2775_i0	PRJNA280983	2890	408	11.100279	45.28913832	Protobothrops mucrosquamatus	103944	Chordata	Chordata	54.7	0.011	NTclustered	gi\|1002583974\|ref\|XM_015815362.1\|	103944	g2775	i0	92.308	0.0955882352941176	39	1	10	2	1	39	1	37	PREDICTED: Protobothrops mucrosquamatus RE1-silencing transcription factor (LOC107286919), mRNA	blastn	39	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Protobothrops	Protobothrops mucrosquamatus
11850295	11850295	PRJNA280983_P_NODE_6750_length_228_cov_1.240223_g6635_i0	PRJNA280983	6750	228	1.240223	2.82770844	Styela clava	7725	Chordata	Chordata	239	1.45e-58	NTclustered	gi\|1981775934\|ref\|XM_039399307.1\|	7725	g6635	i0	88.718	80.4210526315789	195	22	86	0	33	227	1407	1213	PREDICTED: Styela clava tubulin beta chain (LOC120332124), mRNA	blastn	18336	239	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
13125486	13125486	PRJNA280983_P_NODE_11051_length_162_cov_0.902655_g10936_i0	PRJNA280983	11051	162	0.902655	1.4623011	Gallus gallus	9031	Chordata	Chordata	209	7.56e-50	NTclustered	gi\|297306101\|dbj\|AB556462.1\|	9031	g10936	i0	90.566	19.8703703703704	159	14	100	1	2	160	350	507	Gallus gallus DNA, CENP-A associated sequence, partial sequence, clone: CAIP#159	blastn	3219	209	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
13125487	13125487	PRJNA280983_P_NODE_11271_length_161_cov_0.910714_g11156_i0	PRJNA280983	11271	161	0.910714	1.46624954	Gallus gallus	9031	Chordata	Chordata	281	1.57e-71	NTclustered	gi\|2201755421\|ref\|XR_005854575.2\|	9031	g11156	i0	98.137	1	161	3	100	0	1	161	1976	1816	PREDICTED: Gallus gallus uncharacterized LOC121111882 (LOC121111882), ncRNA	blastn	161	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
13125522	13125522	PRJNA280983_P_NODE_8971_length_180_cov_1.534351_g8856_i0	PRJNA280983	8971	180	1.534351	2.7618318	Rhinatrema bivittatum	194408	Chordata	Chordata	52.8	0.015	NTclustered	gi\|1694542078\|ref\|XR_003853118.1\|	194408	g8856	i0	100	0.466666666666667	28	0	16	0	98	125	1142	1169	PREDICTED: Rhinatrema bivittatum uncharacterized LOC115078451 (LOC115078451), transcript variant X3, ncRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Rhinatrematidae	Rhinatrema	Rhinatrema bivittatum
13812340	13812340	PRJNA280983_P_NODE_10631_length_164_cov_0.886957_g10516_i0	PRJNA280983	10631	164	0.886957	1.45460948	Bovidae	9895	Chordata	Chordata	268	1.25e-67	NTclustered	gi\|1068294018\|gb\|KX592814.1\|	9913	g10516	i0	96.319	1434.73170731707	163	6	100	0	2	164	5529711	5529549	Bos taurus isolate Dominette_000065F genomic sequence	blastn	235296	268	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
13812358	13812358	PRJNA280983_P_NODE_691_length_889_cov_2.016667_g607_i0	PRJNA280983	691	889	2.016667	17.92816963	Podarcis	42163	Chordata	Chordata	54.7	0.025	NTclustered	gi\|1622036853\|ref\|XR_003706709.1\|	64176	g607	i0	100	0.195725534308211	29	0	3	0	715	743	1003	975	PREDICTED: Podarcis muralis uncharacterized LOC114597094 (LOC114597094), transcript variant X4, ncRNA	blastn	174	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis muralis
15086558	15086558	PRJNA280983_P_NODE_10052_length_166_cov_0.871795_g9937_i0	PRJNA280983	10052	166	0.871795	1.4471797	Cricetidae	337677	Chordata	Chordata	82.4	1.77e-11	NTclustered	gi\|1490740482\|ref\|XM_005343125.3\|	79684	g9937	i0	84.524	4.55421686746988	84	11	50	2	84	166	420	338	PREDICTED: Microtus ochrogaster ribosomal protein L10 like (Rpl10l), mRNA	blastn	756	82.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Microtus	Microtus ochrogaster
15674388	15674388	PRJNA280983_P_NODE_8133_length_195_cov_4.541096_g8018_i0	PRJNA280983	8133	195	4.541096	8.8551372	Cricetulus griseus	10029	Chordata	Chordata	56.5	0.001	NTclustered	gi\|1868070484\|ref\|XM_035459734.1\|	10029	g8018	i0	94.595	5.71282051282051	37	0	19	1	1	37	4887	4853	PREDICTED: Cricetulus griseus transmembrane and coiled-coil domain family 3 (Tmcc3), transcript variant X1, mRNA	blastn	1114	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
16361467	16361467	PRJNA280983_P_NODE_7553_length_208_cov_0.830189_g7438_i0	PRJNA280983	7553	208	0.830189	1.72679312	Aves	8782	Chordata	Chordata	128	2.94e-25	NTclustered	gi\|2280374172\|ref\|XM_049834830.1\|	8957	g7438	i0	85.366	10.2211538461538	123	18	59	0	85	207	829	707	PREDICTED: Accipiter gentilis ribosomal protein L8 (RPL8), mRNA	blastn	2126	128	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Accipitridae	Astur	Astur gentilis
18223317	18223317	PRJNA280983_P_NODE_1735_length_558_cov_1.375246_g1625_i0	PRJNA280983	1735	558	1.375246	7.67387268	Pleurodeles waltl	8319	Chordata	Chordata	91.6	1.16e-13	NTclustered	gi\|2833195971\|ref\|XM_069228677.1\|	8319	g1625	i0	83.505	0.173835125448029	97	16	17	0	461	557	1335	1239	PREDICTED: Pleurodeles waltl G protein subunit alpha i1 (GNAI1), mRNA	blastn	97	91.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
22048138	22048138	PRJNA280983_P_NODE_4858_length_292_cov_1.259259_g4743_i0	PRJNA280983	4858	292	1.259259	3.67703628	Bombina bombina	8345	Chordata	Chordata	134	9.4e-27	NTclustered	gi\|2445240817\|ref\|XM_053706482.1\|	8345	g4743	i0	85.271	19.9623287671233	129	19	44	0	164	292	790	662	PREDICTED: Bombina bombina ribosomal protein L8 (RPL8), mRNA	blastn	5829	134	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
24597781	24597781	PRJNA280983_P_NODE_6680_length_230_cov_1.127072_g6565_i0	PRJNA280983	6680	230	1.127072	2.5922656	Lethenteron reissneri	7753	Chordata	Chordata	62.1	3.41e-5	NTclustered	gi\|2635813043\|ref\|XM_061549290.1\|	7753	g6565	i0	100	8.57391304347826	33	0	14	0	127	159	3753	3785	PREDICTED: Lethenteron reissneri sex-determining region Y protein-like (LOC133340853), partial mRNA	blastn	1972	62.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;