metadata: contig_metadata: 9 rows where bioproject = "PRJEB6055" and tax

9 rows where bioproject = "PRJEB6055" 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
2267494	2267494	PRJEB6055_S_NODE_1822_length_225_cov_2.494737_g1798_i0	PRJEB6055	1822	225	2.494737	5.61315825	Chloroidium	1034479	Plants	Plants	411	2.869999999999999e-110	NTclustered	gi\|694226606\|gb\|KM116463.1\|	63675	g1798	i0	99.556	99.3288888888889	225	1	100	0	1	225	2461	2685	Chloroidium angustoellipsoideum strain SAG 2041 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence	blastn	22349	411	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium angustoellipsoideum
2675602	2675602	PRJEB6055_S_NODE_1203_length_257_cov_6.581081_g1179_i0	PRJEB6055	1203	257	6.581081	16.91337817	Chloroidium sp. KL-2023a	3031248	Plants	Plants	424	4.3e-114	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g1179	i0	97.571	143.260700389105	247	6	96	0	10	256	219900	220146	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	36818	424	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
7369752	7369752	PRJEB6055_S_NODE_1406_length_244_cov_13885.430622_g1382_i0	PRJEB6055	1406	244	13885.430622	33880.45071768	Trebouxiophyceae	75966	Plants	Plants	231	2.63e-56	NTclustered	gi\|21631\|emb\|Z21553.1\|	13787	g1382	i0	100	51.2295081967213	125	0	51	0	120	244	1557	1433	T.asymmetrica gene encoding 18S ribosomal RNA	blastn	12500	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia asymmetrica
11603974	11603974	PRJEB6055_S_NODE_3430_length_183_cov_2.162162_g3406_i0	PRJEB6055	3430	183	2.162162	3.95675646	Mantoniella tinhauana	3097027	Plants	Plants	84.2	5.53e-12	NTclustered	gi\|2735153290\|gb\|CP140075.1\|	3097027	g3406	i0	80.508	1.20218579234973	118	16	62	6	70	183	581454	581340	Mantoniella tinhauana isolate LFS chromosome 14	blastn	220	84.2	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
12879189	12879189	PRJEB6055_S_NODE_5091_length_159_cov_5.032258_g5067_i0	PRJEB6055	5091	159	5.032258	8.00129022	Chloroidium sp. KL-2023a	3031248	Plants	Plants	250	4.3499999999999996e-62	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g5067	i0	97.917	121.849056603774	144	3	91	0	1	144	220313	220456	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	19374	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
15427946	15427946	PRJEB6055_S_NODE_2113_length_215_cov_2.900000_g2089_i0	PRJEB6055	2113	215	2.9	6.235	Trebouxia sp. ex Placidium sp. PJ-2019a	2571973	Plants	Plants	398	2.1099999999999997e-106	NTclustered	gi\|1691252205\|emb\|LR586036.1\|	2571973	g2089	i0	100	100.032558139535	215	0	100	0	1	215	210	424	Trebouxia sp. ex Placidium sp. PJ-2019a partial 26S rRNA gene, isolate Trebouxia sp. pj16 ex Placidium sp. PJ-2019a	blastn	21507	398	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. ex Placidium sp. PJ-2019a
27026758	27026758	PRJEB6055_S_NODE_662_length_312_cov_4.191336_g638_i0	PRJEB6055	662	312	4.191336	13.07696832	Eukaryota	2759	Plants	Plants	80.1	1.61e-15	NR	KAJ9529013.1	44745	g638	i0	50.6	3.15384615384615	83	41	79.8	0	281	33	171	253	KAJ9529013.1 hypothetical protein QJQ45_007086 [Haematococcus lacustris]	diamond	984	80.9	0.990111248454882	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
31360955	31360955	PRJEB6055_S_NODE_2876_length_194_cov_1.138365_g2852_i0	PRJEB6055	2876	194	1.138365	2.2084281	Volvox carteri f. nagariensis	3068	Plants	Plants	43.1	0.0144	NR	XP_002951961.1	3068	g2852	i0	48.9	1.00515463917526	45	19	69.6	1	4	138	598	638	XP_002951961.1 cysteine protease [Volvox carteri f. nagariensis]	diamond	195	43.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
31575542	31575542	PRJEB6055_S_NODE_2256_length_210_cov_2.451429_g2232_i0	PRJEB6055	2256	210	2.451429	5.1480009	Eukaryota	2759	Plants	Plants	87	1.58e-19	NR	CAD7696009.1	121088	g2232	i0	76.5	11.6571428571429	51	12	72.9	0	1	153	121	171	CAD7696009.1 unnamed protein product [Ostreobium quekettii]	diamond	2448	87.8	0.990888382687927	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii

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