metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax_phylum = "Chlorophyta"

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
449484	449484	PRJNA485080_P_NODE_7001_length_377_cov_0.983553_g6907_i0	PRJNA485080	7001	377	0.983553	3.70799481	Chlorella variabilis	554065	Plants	Plants	394	5.18e-105	NTclustered	gi\|552833560\|ref\|XM_005848496.1\|	554065	g6907	i0	92.701	65.8461538461538	274	19	73	1	1	274	199	471	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59661) mRNA, complete cds	blastn	24824	394	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
4276124	4276124	PRJNA485080_P_NODE_22104_length_251_cov_0.865169_g22010_i0	PRJNA485080	22104	251	0.865169	2.17157419	Pseudopediastrum integrum	271402	Plants	Plants	56.5	0.002	NTclustered	gi\|1418583254\|ref\|NC_037921.1\|	271402	g22010	i0	100	0.119521912350598	30	0	12	0	93	122	13679	13650	Pseudopediastrum integrum voucher ACOI 577 chloroplast, complete genome	blastn	30	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Hydrodictyaceae	Pseudopediastrum	Pseudopediastrum integrum
10653077	10653077	PRJNA485080_P_NODE_44049_length_207_cov_4.873134_g43955_i0	PRJNA485080	44049	207	4.873134	10.08738738	Chlamydomonas reinhardtii	3055	Plants	Plants	130	8.13e-26	NTclustered	gi\|2082241745\|ref\|XM_001697474.2\|	3055	g43955	i0	92.308	43.9661835748792	91	7	44	0	1	91	697	787	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g156900v5), mRNA	blastn	9101	130	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
15751709	15751709	PRJNA485080_P_NODE_18253_length_271_cov_1.555556_g18159_i0	PRJNA485080	18253	271	1.555556	4.21555676	Chlorella ohadii	2649997	Plants	Plants	158	5.12e-34	NTclustered	gi\|1756037927\|gb\|MK086142.1\|	2649997	g18159	i0	84.713	0.579335793357934	157	24	58	0	115	271	423	267	Chlorella ohadii chloroplast photosystem II 10 kDa protein mRNA, complete cds; nuclear gene for chloroplast product	blastn	157	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
24675245	24675245	PRJNA485080_P_NODE_32100_length_246_cov_0.890173_g32006_i0	PRJNA485080	32100	246	0.890173	2.18982558	Chlorella variabilis	554065	Plants	Plants	254	5.68e-63	NTclustered	gi\|552831256\|ref\|XM_005848026.1\|	554065	g32006	i0	85.656	18.3861788617886	244	31	98	4	5	246	445	204	Chlorella variabilis hypothetical protein (CHLNCDRAFT_30965) mRNA, complete cds	blastn	4523	254	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis

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