metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA309466" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA309466" 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
1063035	1063035	PRJNA309466_P_NODE_14401_length_174_cov_1.360000_g14344_i0	PRJNA309466	14401	174	1.36	2.3664	Trebouxia	13786	Plants	Plants	315	1.69e-81	NTclustered	gi\|189909382\|gb\|EU725860.1\|	13787	g14344	i0	99.422	99.4252873563218	173	1	99	0	2	174	375	203	Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast	blastn	17300	315	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia asymmetrica
2927415	2927415	PRJNA309466_P_NODE_10363_length_197_cov_1.378378_g10306_i0	PRJNA309466	10363	197	1.378378	2.71540466	Binuclearia lauterbornii	3087189	Plants	Plants	176	9.7e-40	NTclustered	gi\|2724824417\|gb\|PP746559.1\|	3087189	g10306	i0	85.629	75.5837563451777	167	24	85	0	16	182	27291	27125	Binuclearia lauterbornii culture SAG:68.94 mitochondrion, complete genome	blastn	14890	176	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Oocystaceae	Binuclearia	Binuclearia lauterbornii
4203937	4203937	PRJNA309466_P_NODE_12724_length_182_cov_2.744361_g12667_i0	PRJNA309466	12724	182	2.744361	4.99473702	Sarcinofilum mucosum	141643	Plants	Plants	250	5.1099999999999995e-62	NTclustered	gi\|1197510887\|ref\|NC_034709.1\|	141643	g12667	i0	95.57	134.214285714286	158	4	87	2	3	160	147333	147179	Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome	blastn	24427	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Sarcinofilaceae	Sarcinofilum	Sarcinofilum mucosum
6754458	6754458	PRJNA309466_P_NODE_15626_length_169_cov_0.866667_g15569_i0	PRJNA309466	15626	169	0.866667	1.46466723	Trebouxia aggregata	160068	Plants	Plants	244	2.1699999999999999e-60	NTclustered	gi\|162134245\|gb\|EU123948.1\|	160068	g15569	i0	94.872	123.491124260355	156	8	92	0	14	169	6222	6067	Trebouxia aggregata strain SAG 219-1d ribosomal protein S2 (rps2) gene, complete cds; tRNA-Met (trnMe(cau)) and large subunit ribosomal RNA (rnl) genes, complete sequence; putative site-specific DNA endonuclease (orf365) gene, complete cds; small subunit ribosomal RNA (rns) and tRNA-Met (trnMf(cau)) genes, complete sequence; cytochrome c oxidase subunit 1 (cox1), putative site-specific DNA endonuclease (orf335), and putative site-specific DNA endonuclease (orf256) genes, complete cds; tRNA-Phe (trnF(gaa)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; and apocytochrome b (cob) and putative site-specific DNA endonuclease (orf334) genes, complete cds; mitochondrial	blastn	20870	244	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
14405812	14405812	PRJNA309466_P_NODE_3912_length_295_cov_1.414634_g3856_i0	PRJNA309466	3912	295	1.414634	4.1731703	Chloroidium saccharophilum	3082	Plants	Plants	329	1.13e-85	NTclustered	gi\|283766139\|gb\|GQ921930.1\|	3082	g3856	i0	90.438	89.5118644067797	251	23	85	1	19	269	465	216	Pseudochlorella aquatica 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast	blastn	26406	329	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium saccharophilum

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