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

5 rows where bioproject = "PRJNA757618" 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
21135267	21135267	PRJNA757618_P_NODE_45097_length_243_cov_0.917647_g44045_i0	PRJNA757618	45097	243	0.917647	2.22988221	Trebouxia lynnae	1825957	Plants	Plants	433	6.69e-117	NTclustered	gi\|1016111943\|gb\|KU716051.1\|	1825957	g44045	i0	98.765	18.7695473251029	243	3	100	0	1	243	6923	6681	Trebouxia lynnae 26S-18S intergenic spacer region, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence; and 26S-18S rRNA intergenic spacer region, partial sequence	blastn	4561	433	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia lynnae
24959416	24959416	PRJNA757618_P_NODE_7480_length_418_cov_0.988406_g6428_i0	PRJNA757618	7480	418	0.988406	4.13153708	Trebouxia aggregata	160068	Plants	Plants	503	9.239999999999998e-138	NTclustered	gi\|162134340\|gb\|EU123979.1\|	160068	g6428	i0	89.474	97.0191387559809	418	17	100	13	1	418	2233	1843	Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast	blastn	40554	503	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
27115946	27115946	PRJNA757618_P_NODE_39002_length_246_cov_0.901734_g37950_i0	PRJNA757618	39002	246	0.901734	2.21826564	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	51.2	1.25e-5	NR	XP_005645335.1	574566	g37950	i0	50.8	1.30487804878049	59	20	72	2	15	191	29	78	XP_005645335.1 nucleic acid-binding protein [Coccomyxa subellipsoidea C-169]	diamond	321	51.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
28063588	28063588	PRJNA757618_P_NODE_28045_length_252_cov_0.871508_g26993_i0	PRJNA757618	28045	252	0.871508	2.19620016	Trebouxia sp. C	2796353	Plants	Plants	137	1.76e-35	NR	KAL3147179.1	3373145	g26993	i0	87.7	0.964285714285714	81	9	96.4	1	245	3	76	155	KAL3147179.1 hypothetical protein ABBQ32_002684 [Trebouxia sp. C0010 RCD-2024]	diamond	243	137	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
31190001	31190001	PRJNA757618_P_NODE_28035_length_252_cov_0.871508_g26983_i0	PRJNA757618	28035	252	0.871508	2.19620016	Haematococcus lacustris	44745	Plants	Plants	48.5	3.93e-4	NR	KAJ9506076.1	44745	g26983	i0	41.5	2.91666666666667	65	35	73.8	1	210	25	501	565	KAJ9506076.1 hypothetical protein QJQ45_016585 [Haematococcus lacustris]	diamond	735	48.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris

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