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

5 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Lentisphaerota"

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
15920827	15920827	PRJNA642647_P_NODE_1813_length_258_cov_1.886878_g1763_i0	PRJNA642647	1813	258	1.886878	4.86814524	Victivallaceae bacterium	2793042	Bacteria	Bacteria	283	7.649999999999999e-72	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g1763	i0	86.905	182.701550387597	252	33	98	0	1	252	1449406	1449155	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	47137	283	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
17736491	17736491	PRJNA642647_P_NODE_854_length_383_cov_2.156069_g804_i0	PRJNA642647	854	383	2.156069	8.25774427	Bacteria	2	Bacteria	Bacteria	176	2.08e-39	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g804	i0	75.668	48.1331592689295	374	80	96	10	12	379	2384145	2383777	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	18435	176	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
24110435	24110435	PRJNA642647_P_NODE_2099_length_238_cov_2.039801_g2049_i0	PRJNA642647	2099	238	2.039801	4.85472638	Bacteria	2	Bacteria	Bacteria	174	4.37e-39	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g2049	i0	93.966	475.357142857143	116	6	48	1	121	235	2074068	2074183	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	113135	174	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
24844290	24844290	PRJNA642647_P_NODE_1300_length_306_cov_6.587361_g1250_i0	PRJNA642647	1300	306	6.587361	20.15732466	Lentisphaera profundi	1658616	Bacteria	Bacteria	346	1.17e-90	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g1250	i0	87.055	200.885620915033	309	36	100	4	1	306	2072998	2073305	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	61471	346	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
24844302	24844302	PRJNA642647_P_NODE_2200_length_232_cov_1.538462_g2150_i0	PRJNA642647	2200	232	1.538462	3.56923184	Lentisphaera profundi	1658616	Bacteria	Bacteria	226	1.1599999999999999e-54	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g2150	i0	85.088	61.0301724137931	228	27	97	7	1	224	2074750	2074526	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	14159	226	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi

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