metadata: contig_metadata: 6 rows where bioproject = "PRJNA1167252" and tax

6 rows where bioproject = "PRJNA1167252" and tax_clade = "core chlorophytes"

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
20715674	20715674	PRJNA1167252_P_NODE_16197_length_304_cov_2.744589_g15924_i0	PRJNA1167252	16197	304	2.744589	8.34355056	Volvox carteri	3067	Plants	Plants	52.8	0.028	NTclustered	gi\|302844358\|ref\|XM_002953674.1\|	3068	g15924	i0	100	0.0921052631578947	28	0	9	0	12	39	3924	3897	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_118441), partial mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
23266856	23266856	PRJNA1167252_P_NODE_28299_length_244_cov_0.912281_g28026_i0	PRJNA1167252	28299	244	0.912281	2.22596564	Koliella corcontica	155904	Plants	Plants	95.3	3.61e-15	NTclustered	gi\|2724824266\|gb\|PP746555.1\|	155904	g28026	i0	89.474	19.155737704918	76	7	31	1	75	149	53977	54052	Koliella corcontica culture SAG:24.84 mitochondrion, complete genome	blastn	4674	95.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Koliellaceae	Koliella	Koliella corcontica
27514488	27514488	PRJNA1167252_P_NODE_22643_length_253_cov_0.866667_g22370_i0	PRJNA1167252	22643	253	0.866667	2.19266751	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	78.2	1.47e-14	NR	XP_005651065.1	574566	g22370	i0	60	2.00395256916996	55	22	65.2	0	88	252	323	377	XP_005651065.1 hypothetical protein COCSUDRAFT_64531 [Coccomyxa subellipsoidea C-169]	diamond	507	78.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
27672513	27672513	PRJNA1167252_P_NODE_23204_length_252_cov_0.871508_g22931_i0	PRJNA1167252	23204	252	0.871508	2.19620016	Trebouxia sp. C	2796353	Plants	Plants	60.1	3.13e-8	NR	KAL0051908.1	2905655	g22931	i0	33.7	1.02380952380952	86	54	98.8	2	251	3	95	180	KAL0051908.1 hypothetical protein WJX82_004341 [Trebouxia sp. C0006]	diamond	258	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0006
28998797	28998797	PRJNA1167252_P_NODE_25268_length_249_cov_0.886364_g24995_i0	PRJNA1167252	25268	249	0.886364	2.20704636	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	54.7	2.47e-6	NR	KAG1679537.1	1653778	g24995	i0	37.7	1.8433734939759	77	47	91.6	1	242	15	181	257	KAG1679537.1 hypothetical protein FOA52_011139 [Chlamydomonas sp. UWO 241]	diamond	459	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
31968614	31968614	PRJNA1167252_P_NODE_7778_length_460_cov_1.516796_g7505_i0	PRJNA1167252	7778	460	1.516796	6.9772616	Chlamydomonas schloesseri	2026947	Plants	Plants	87.8	6.95e-17	NR	KAG2453415.1	2026947	g7505	i0	36	3.26086956521739	164	87	98.5	3	3	455	259	417	KAG2453415.1 hypothetical protein HYH02_001638 [Chlamydomonas schloesseri]	diamond	1500	87.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas schloesseri

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