metadata: contig_metadata: 5 rows where bioproject = "PRJNA448207" and tax

5 rows where bioproject = "PRJNA448207" 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
4266007	4266007	PRJNA448207_S_NODE_2124_length_307_cov_1.239316_g2113_i0	PRJNA448207	2124	307	1.239316	3.80470012	Volvox carteri	3067	Plants	Plants	54.7	0.008	NTclustered	gi\|302848849\|ref\|XM_002955910.1\|	3068	g2113	i0	96.875	0.37785016286645	32	1	10	0	83	114	1546	1577	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_119243), partial mRNA	blastn	116	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
17669950	17669950	PRJNA448207_P_NODE_26334_length_250_cov_0.870056_g26171_i0	PRJNA448207	26334	250	0.870056	2.17514	Chlorophyceae	3166	Plants	Plants	63.9	1.05e-5	NTclustered	gi\|2082244669\|ref\|XM_043061635.1\|	3055	g26171	i0	91.489	17.72	47	3	19	1	135	181	14337	14292	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g213652v5), mRNA	blastn	4430	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
27566107	27566107	PRJNA448207_S_NODE_3324_length_253_cov_2.883333_g3313_i0	PRJNA448207	3324	253	2.883333	7.29483249	Eukaryota	2759	Plants	Plants	96.3	2.9e-22	NR	KAJ9505876.1	44745	g3313	i0	75.5	6.27272727272727	53	13	62.8	0	3	161	186	238	KAJ9505876.1 hypothetical protein QJQ45_010054 [Haematococcus lacustris]	diamond	1587	97.1	0.991761071060762	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
31687898	31687898	PRJNA448207_S_NODE_1537_length_350_cov_1.321300_g1526_i0	PRJNA448207	1537	350	1.3213	4.62455	Helicosporidium sp. ATCC 5	1907511	Plants	Plants	164	6.36e-49	NR	KDD76381.1	1291522	g1526	i0	65.8	0.951428571428571	111	38	95.1	0	1	333	67	177	KDD76381.1 hypothetical protein H632_c248p2 [Helicosporidium sp. ATCC 50920]	diamond	333	164	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
32731324	32731324	PRJNA448207_P_NODE_7840_length_436_cov_1.377410_g7678_i0	PRJNA448207	7840	436	1.37741	6.0055076	Helicosporidium sp. ATCC 5	1907511	Plants	Plants	191	4.42e-59	NR	KDD76381.1	1291522	g7678	i0	61.4	1.92660550458716	140	54	96.3	0	434	15	38	177	KDD76381.1 hypothetical protein H632_c248p2 [Helicosporidium sp. ATCC 50920]	diamond	840	191	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920

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