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

5 rows where analysis = "blastn", bioproject = "PRJEB80557" and tax_clade = "PVC group"

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
8649636	8649636	PRJEB80557_S_NODE_10307_length_285_cov_1.745763_g9911_i0	PRJEB80557	10307	285	1.745763	4.97542455	Bacteria	2	Bacteria	Bacteria	200	8.879999999999999e-47	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g9911	i0	87.719	315.263157894737	171	21	60	0	38	208	2382991	2382821	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	89850	200	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
13749901	13749901	PRJEB80557_S_NODE_15491_length_238_cov_1.915344_g15095_i0	PRJEB80557	15491	238	1.915344	4.55851872	Candidatus Rhabdochlamydia	292833	Bacteria	Bacteria	174	4.37e-39	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g15095	i0	81.304	87.0042016806723	230	30	94	13	1	223	1019902	1019679	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	20707	174	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
16715764	16715764	PRJEB80557_S_NODE_19074_length_217_cov_1.535714_g18678_i0	PRJEB80557	19074	217	1.535714	3.33249938	Aquisphaera giovannonii	406548	Bacteria	Bacteria	307	3.7e-79	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g18678	i0	92.202	142.861751152074	218	15	100	2	1	217	9143890	9143674	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	31001	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
17990661	17990661	PRJEB80557_S_NODE_27095_length_185_cov_2.264706_g26699_i0	PRJEB80557	27095	185	2.264706	4.1897061	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	137	4.24e-28	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g26699	i0	80.749	54.227027027027	187	26	99	9	2	185	588142	588321	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	10032	137	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
20540126	20540126	PRJEB80557_S_NODE_36497_length_163_cov_1.333333_g36101_i0	PRJEB80557	36497	163	1.333333	2.17333279	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	207	2.74e-49	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g36101	i0	90.625	14.4601226993865	160	10	96	4	1	157	1599306	1599149	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	2357	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7

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