metadata: contig_metadata: 6 rows where bioproject = "PRJNA867519", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA867519", tax_clade = "PVC group" 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_species
21638994	21638994	PRJNA867519_P_NODE_14377_length_310_cov_1.299578_g14223_i0	PRJNA867519	14377	310	1.299578	4.0286918	Lentisphaerae bacterium ADurb.BinA184	1852901	Bacteria	Bacteria	62	1.55e-9	NR	OPZ29049.1	1852901	g14223	i0	55.1	0.474193548387097	49	21	46.5	1	166	23	30	78	OPZ29049.1 MAG: Thioredoxin-1 [Lentisphaerae bacterium ADurb.BinA184]	diamond	147	62	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium ADurb.BinA184
27379572	27379572	PRJNA867519_P_NODE_33083_length_242_cov_0.911243_g32929_i0	PRJNA867519	33083	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	4.11e-11	NR	MFH0879619.1	1932692	g32929	i0	47.5	3.76859504132231	80	39	95.5	2	240	10	22	101	MFH0879619.1 hypothetical protein [Lentisphaerota bacterium]	diamond	912	68.6	0.994169096209913	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
28034436	28034436	PRJNA867519_P_NODE_30565_length_245_cov_0.895349_g30411_i0	PRJNA867519	30565	245	0.895349	2.19360505	Victivallales bacterium	2212475	Bacteria	Bacteria	50.1	6.62e-5	NR	HJO94879.1	2212475	g30411	i0	47.5	2.31428571428571	61	26	74.7	2	14	196	12	66	HJO94879.1 DJ-1/PfpI family protein [Victivallales bacterium]	diamond	567	50.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
30686922	30686922	PRJNA867519_P_NODE_13373_length_319_cov_1.621951_g13219_i0	PRJNA867519	13373	319	1.621951	5.17402369	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	110	1.9999999999999998e-26	NR	MCP3967708.1	1932692	g13219	i0	51.9	1.97492163009404	104	48	96.9	2	318	10	232	334	MCP3967708.1 branched-chain amino acid aminotransferase [Lentisphaerota bacterium]	diamond	630	110	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
31920082	31920082	PRJNA867519_P_NODE_177_length_1689_cov_3.480817_g123_i0	PRJNA867519	177	1689	3.480817	58.79099913	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	72.4	2.03e-9	NR	MBE6359156.1	1932692	g123	i0	31	0.326820603907638	184	105	32.5	6	589	1137	22	184	MBE6359156.1 hypothetical protein [Lentisphaerota bacterium]	diamond	552	72.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
32553203	32553203	PRJNA867519_P_NODE_34179_length_234_cov_2.428571_g34025_i0	PRJNA867519	34179	234	2.428571	5.68285614	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	62.8	2.75e-9	NR	MCM8541984.1	2461380	g34025	i0	45.5	3.48717948717949	66	36	84.6	0	17	214	373	438	MCM8541984.1 phosphotransferase [Lentisphaeraceae bacterium]	diamond	816	62.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaeraceae bacterium

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