metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA929940" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA929940" and tax_phylum = "Streptophyta"

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
909133	909133	PRJNA929940_S_NODE_14261_length_261_cov_2.013393_g14026_i0	PRJNA929940	14261	261	2.013393	5.25495573	Eutrema salsugineum	72664	Plants	Plants	427	3.38e-115	NTclustered	gi\|1350246345\|ref\|XM_006405707.2\|	72664	g14026	i0	96.169	99.3869731800766	261	10	100	0	1	261	180	440	PREDICTED: Eutrema salsugineum ribulose bisphosphate carboxylase small chain 3B, chloroplastic (LOC18022834), mRNA	blastn	25940	427	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Eutrema	Eutrema salsugineum
2184486	2184486	PRJNA929940_S_NODE_46702_length_165_cov_0.953125_g46467_i0	PRJNA929940	46702	165	0.953125	1.57265625	Eutrema salsugineum	72664	Plants	Plants	233	4.5899999999999994e-57	NTclustered	gi\|1350335559\|ref\|XM_006390163.2\|	72664	g46467	i0	92.262	22.2181818181818	168	7	98	3	1	162	483	650	PREDICTED: Eutrema salsugineum dehydrin ERD14 (LOC18009193), mRNA	blastn	3666	233	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Eutrema	Eutrema salsugineum
3460005	3460005	PRJNA929940_S_NODE_2463_length_490_cov_2.423841_g2234_i0	PRJNA929940	2463	490	2.423841	11.8768209	Oryza sativa	4530	Plants	Plants	867	0	NTclustered	gi\|116641941\|emb\|CT837279.1\|	39946	g2234	i0	98.571	66.1775510204082	490	7	100	0	1	490	45	534	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA112N02, full insert sequence	blastn	32427	867	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
3806813	3806813	PRJNA929940_S_NODE_32983_length_189_cov_1.407895_g32748_i0	PRJNA929940	32983	189	1.407895	2.66092155	Brassicaceae	3700	Plants	Plants	261	2.4800000000000002e-65	NTclustered	gi\|2258243583\|ref\|XM_013807524.3\|	3708	g32748	i0	91.534	17.984126984127	189	16	100	0	1	189	472	284	PREDICTED: Brassica napus early light-induced protein 1, chloroplastic (LOC106367694), mRNA	blastn	3399	261	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus
3806814	3806814	PRJNA929940_S_NODE_52763_length_157_cov_1.658333_g52528_i0	PRJNA929940	52763	157	1.658333	2.60358281	Brassica	3705	Plants	Plants	163	5.74e-36	NTclustered	gi\|2258156154\|ref\|XM_013830865.3\|	3708	g52528	i0	86.486	12.3184713375796	148	20	94	0	10	157	306	159	PREDICTED: Brassica napus stress-induced protein KIN2 (LOC106390410), mRNA	blastn	1934	163	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus
5083093	5083093	PRJNA929940_S_NODE_38984_length_177_cov_1.028571_g38749_i0	PRJNA929940	38984	177	1.028571	1.82057067	Eutrema	98005	Plants	Plants	274	2.93e-69	NTclustered	gi\|1350229919\|ref\|XM_006408158.2\|	72664	g38749	i0	94.444	83.0960451977401	180	6	100	4	1	177	1211	1033	PREDICTED: Eutrema salsugineum glyceraldehyde-3-phosphate dehydrogenase, cytosolic (LOC18024927), mRNA	blastn	14708	274	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Eutrema	Eutrema salsugineum
6012384	6012384	PRJNA929940_S_NODE_36365_length_181_cov_3.993056_g36130_i0	PRJNA929940	36365	181	3.993056	7.22743136	Oryza sativa	4530	Plants	Plants	298	1.79e-76	NTclustered	gi\|116641941\|emb\|CT837279.1\|	39946	g36130	i0	96.685	10.0939226519337	181	3	100	3	1	181	1190	1013	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA112N02, full insert sequence	blastn	1827	298	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
10183462	10183462	PRJNA929940_S_NODE_22568_length_218_cov_3.022099_g22333_i0	PRJNA929940	22568	218	3.022099	6.58817582	Brassicaceae	3700	Plants	Plants	320	4.78e-83	NTclustered	gi\|1338581028\|ref\|XM_006284554.2\|	81985	g22333	i0	94.686	99.8715596330275	207	9	94	2	1	205	428	634	PREDICTED: Capsella rubella ribulose bisphosphate carboxylase small chain 3B, chloroplastic (LOC17878658), mRNA	blastn	21772	322	0.993788819875776	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Capsella	Capsella rubella
16212073	16212073	PRJNA929940_S_NODE_48733_length_162_cov_1.552000_g48498_i0	PRJNA929940	48733	162	1.552	2.51424	Oryza sativa	4530	Plants	Plants	191	2.74e-44	NTclustered	gi\|116641950\|emb\|CT837288.1\|	39946	g48498	i0	88.125	1.98765432098765	160	19	99	0	3	162	83	242	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA128K01, full insert sequence	blastn	322	191	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
18760743	18760743	PRJNA929940_S_NODE_37655_length_179_cov_1.908451_g37420_i0	PRJNA929940	37655	179	1.908451	3.41612729	Jacobaea vulgaris	98722	Plants	Plants	67.6	5.42e-7	NTclustered	gi\|2918395482\|emb\|OZ238158.1\|	98722	g37420	i0	86.154	0.363128491620112	65	5	35	3	117	179	16984826	16984888	Jacobaea vulgaris genome assembly, chromosome: 10	blastn	65	67.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Jacobaea	Jacobaea vulgaris
20035740	20035740	PRJNA929940_S_NODE_57116_length_152_cov_2.339130_g56881_i0	PRJNA929940	57116	152	2.33913	3.5554776	Oryza sativa	4530	Plants	Plants	270	3.15e-68	NTclustered	gi\|116641941\|emb\|CT837279.1\|	39946	g56881	i0	98.684	1.26315789473684	152	2	100	0	1	152	822	671	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA112N02, full insert sequence	blastn	192	270	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
24206366	24206366	PRJNA929940_S_NODE_49599_length_161_cov_1.427419_g49364_i0	PRJNA929940	49599	161	1.427419	2.29814459	Brassica	3705	Plants	Plants	233	4.45e-57	NTclustered	gi\|2258181960\|ref\|XM_013873627.3\|	3708	g49364	i0	93.082	100.732919254658	159	11	99	0	1	159	272	114	PREDICTED: Brassica napus chlorophyll a-b binding protein 1, chloroplastic (LOC106432786), mRNA	blastn	16218	233	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus

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);;