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

5 rows where bioproject = "PRJNA826497" 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
9748688	9748688	PRJNA826497_S_NODE_588_length_385_cov_4.988636_g548_i0	PRJNA826497	588	385	4.988636	19.2062486	Jenufa minuta	993092	Plants	Plants	575	1.7599999999999996e-159	NTclustered	gi\|959124355\|ref\|NC_028582.1\|	993092	g548	i0	95.543	111.979220779221	359	16	93	0	27	385	103086	103444	Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome	blastn	43112	575	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae			Jenufa	Jenufa minuta
14848744	14848744	PRJNA826497_S_NODE_9332_length_191_cov_4.158228_g9292_i0	PRJNA826497	9332	191	4.158228	7.94221548	Chloroidium ellipsoideum	63676	Plants	Plants	281	1.92e-71	NTclustered	gi\|535783\|dbj\|D17810.1\|CHLLSURRNA	63676	g9292	i0	93.194	97.5392670157068	191	13	100	0	1	191	279	89	Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron	blastn	18630	281	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium ellipsoideum
25046954	25046954	PRJNA826497_S_NODE_18760_length_153_cov_22.941667_g18720_i0	PRJNA826497	18760	153	22.941667	35.10075051	Lobosphaera incisa	312850	Plants	Plants	276	6.83e-70	NTclustered	gi\|725650896\|ref\|NC_025533.1\|	312850	g18720	i0	99.346	107.254901960784	153	0	100	1	1	153	2736	2887	Lobosphaera incisa culture-collection SAG:2007 chloroplast, complete genome	blastn	16410	276	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Lobosphaera	Lobosphaera incisa
27686662	27686662	PRJNA826497_S_NODE_13984_length_169_cov_2.441176_g13944_i0	PRJNA826497	13984	169	2.441176	4.12558744	Chlamydomonas eustigma	1157962	Plants	Plants	48.1	1.54e-4	NR	GAX80893.1	1157962	g13944	i0	47.2	1.91715976331361	53	25	88.8	1	5	154	184	236	GAX80893.1 hypothetical protein CEUSTIGMA_g8328.t1 [Chlamydomonas eustigma]	diamond	324	48.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
31074259	31074259	PRJNA826497_S_NODE_13135_length_172_cov_6.309353_g13095_i0	PRJNA826497	13135	172	6.309353	10.85208716	Chlorophyta	3041	Plants	Plants	88.2	4.69e-21	NR	KAF5826115.1	3046	g13095	i0	80	6.73255813953488	55	11	95.9	0	170	6	36	90	KAF5826115.1 ribosomal protein L36 component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina]	diamond	1158	88.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina

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