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

5 rows where bioproject = "PRJNA690234" 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
28199040	28199040	PRJNA690234_P_NODE_10906_length_385_cov_3.192308_g10540_i0	PRJNA690234	10906	385	3.192308	12.2903858	Chlorellaceae	35461	Plants	Plants	66.6	1.91e-10	NR	XP_011396990.1	3075	g10540	i0	31.5	1.93246753246753	124	84	96.6	1	13	384	62	184	XP_011396990.1 ATP synthase subunit O, mitochondrial [Auxenochlorella protothecoides]	diamond	744	66.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
29746132	29746132	PRJNA690234_P_NODE_24430_length_256_cov_1.524590_g24063_i0	PRJNA690234	24430	256	1.52459	3.9029504	Chlamydomonadales	3042	Plants	Plants	88.6	2.04e-18	NR	KAF5829124.1	3046	g24063	i0	48.7	3.65625	78	40	91.4	0	3	236	109	186	KAF5829124.1 hypothetical protein DUNSADRAFT_16524 [Dunaliella salina]	diamond	936	88.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
31378084	31378084	PRJNA690234_P_NODE_14256_length_336_cov_1.532319_g13889_i0	PRJNA690234	14256	336	1.532319	5.14859184	Auxenochlorella protothecoides	3075	Plants	Plants	134	4.87e-35	NR	RMZ53131.1	3075	g13889	i0	63.1	2.75892857142857	103	37	91.1	1	334	29	326	428	RMZ53131.1 hypothetical protein APUTEX25_005120, partial [Auxenochlorella protothecoides]	diamond	927	134	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
32022140	32022140	PRJNA690234_P_NODE_15098_length_327_cov_1.074803_g14731_i0	PRJNA690234	15098	327	1.074803	3.51460581	Scenedesmaceae	3086	Plants	Plants	45.1	0.0156	NR	WIA29829.1	3088	g14731	i0	44.6	1.54128440366972	56	30	50.5	1	192	28	620	675	WIA29829.1 hypothetical protein OEZ86_012300 [Tetradesmus obliquus]	diamond	504	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
32800361	32800361	PRJNA690234_P_NODE_6080_length_525_cov_2.055310_g5716_i0	PRJNA690234	6080	525	2.05531	10.7903775	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	76.3	1.41e-12	NR	KAF6257747.1	2650976	g5716	i0	33.1	0.948571428571429	166	105	93.1	4	525	37	131	293	KAF6257747.1 RNA polymerase I-associated factor PAF67-domain-containing protein [Scenedesmus sp. NREL 46B-D3]	diamond	498	76.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3

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