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

5 rows where bioproject = "PRJNA306153" 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
4203528	4203528	PRJNA306153_S_NODE_1244_length_215_cov_5.209677_g1231_i0	PRJNA306153	1244	215	5.209677	11.20080555	Polytomella sp. Pringsheim 198.80	37502	Plants	Plants	195	2.98e-45	NTclustered	gi\|28193497\|emb\|AJ439528.1\|	37502	g1231	i0	85.263	22.9767441860465	190	27	88	1	23	211	524	335	Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene)	blastn	4940	195	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella sp. Pringsheim 198.80
9990401	9990401	PRJNA306153_S_NODE_2348_length_162_cov_13.278195_g2335_i0	PRJNA306153	2348	162	13.278195	21.5106759	Chlorophyta	3041	Plants	Plants	294	2.03e-75	NTclustered	gi\|1917464960\|gb\|MW136924.1\|	1249516	g2335	i0	99.383	99.7901234567901	162	1	100	0	1	162	319	480	Chaetophora lobata voucher QH201901 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	16166	294	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chaetophorales	Chaetophoraceae	Chaetophora	Chaetophora lobata
27168831	27168831	PRJNA306153_S_NODE_902_length_251_cov_3.536036_g889_i0	PRJNA306153	902	251	3.536036	8.87545036	Pedinophyceae sp. YPF-7	765719	Plants	Plants	131	9.18e-37	NR	CAG9462620.1	765719	g889	i0	72.3	18.8486055776892	83	23	99.2	0	249	1	10	92	CAG9462620.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	4731	131	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
27281593	27281593	PRJNA306153_S_NODE_1403_length_204_cov_5.017143_g1390_i0	PRJNA306153	1403	204	5.017143	10.23497172	Chlorellaceae	35461	Plants	Plants	73.6	1.22e-13	NR	PRW39386.1	3076	g1390	i0	57.4	6.11764705882353	61	25	88.2	1	204	25	198	258	PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana]	diamond	1248	74.3	0.990578734858681	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
30422183	30422183	PRJNA306153_S_NODE_1193_length_220_cov_3.570681_g1180_i0	PRJNA306153	1193	220	3.570681	7.8554982	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	103	6.22e-25	NR	KAF6257032.1	2650976	g1180	i0	70.8	11.6727272727273	72	19	95.5	1	216	7	63	134	KAF6257032.1 component of cytosolic 80S ribosome and 40S small subunit [Scenedesmus sp. NREL 46B-D3]	diamond	2568	103	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);;