metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA630162" 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
26681816	26681816	PRJNA630162_P_NODE_138081_length_167_cov_1.864407_g136558_i0	PRJNA630162	138081	167	1.864407	3.11355969	Pseudomonadati	3379134	Bacteria	Bacteria	102	1.69e-23	NR	NLL83912.1	1932692	g136558	i0	79.6	6.79041916167665	54	11	97	0	5	166	234	287	NLL83912.1 phosphoenolpyruvate carboxykinase (GTP) [Lentisphaerota bacterium]	diamond	1134	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27017387	27017387	PRJNA630162_P_NODE_156022_length_163_cov_0.912281_g154499_i0	PRJNA630162	156022	163	0.912281	1.48701803	Victivallales bacterium	2212475	Bacteria	Bacteria	77.8	2.51e-15	NR	MDD3118209.1	2212475	g154499	i0	67.9	5.85276073619632	53	17	97.5	0	161	3	210	262	MDD3118209.1 signal recognition particle-docking protein FtsY [Victivallales bacterium]	diamond	954	77.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
27112288	27112288	PRJNA630162_P_NODE_71522_length_212_cov_2.233129_g69999_i0	PRJNA630162	71522	212	2.233129	4.73423348	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	44.3	0.00224	NR	MCM8539258.1	2461380	g69999	i0	63	0.382075471698113	27	10	38.2	0	21	101	35	61	MCM8539258.1 hypothetical protein [Lentisphaeraceae bacterium]	diamond	81	44.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae		Lentisphaeraceae bacterium
28880786	28880786	PRJNA630162_P_NODE_93088_length_190_cov_1.241135_g91565_i0	PRJNA630162	93088	190	1.241135	2.3581565	Victivallales bacterium	2212475	Bacteria	Bacteria	83.2	4.85e-17	NR	HJO92920.1	2212475	g91565	i0	65.6	0.963157894736842	61	21	96.3	0	8	190	103	163	HJO92920.1 Gfo/Idh/MocA family oxidoreductase [Victivallales bacterium]	diamond	183	83.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
29038847	29038847	PRJNA630162_P_NODE_127828_length_170_cov_2.479339_g126305_i0	PRJNA630162	127828	170	2.479339	4.2148763	Victivallis lenta	2606640	Bacteria	Bacteria	72.8	1.15e-13	NR	WP_273306626.1	2606640	g126305	i0	71.2	0.917647058823529	52	15	91.8	0	9	164	17	68	WP_273306626.1 phage antirepressor [Victivallis lenta]	diamond	156	72.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis lenta
29985918	29985918	PRJNA630162_P_NODE_143671_length_166_cov_0.888889_g142148_i0	PRJNA630162	143671	166	0.888889	1.47555574	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	102	9.21e-24	NR	MBR7138624.1	2053569	g142148	i0	94.2	1.87951807228916	52	3	94	0	157	2	4	55	MBR7138624.1 elongation factor G [Lentisphaeria bacterium]	diamond	312	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
30206931	30206931	PRJNA630162_P_NODE_78232_length_203_cov_3.103896_g76709_i0	PRJNA630162	78232	203	3.103896	6.30090888	Victivallales bacterium	2212475	Bacteria	Bacteria	42.4	0.0295	NR	MBQ7651300.1	2212475	g76709	i0	34	0.783251231527094	53	30	70.9	1	166	23	2	54	MBQ7651300.1 hypothetical protein [Victivallales bacterium]	diamond	159	42.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
31344868	31344868	PRJNA630162_P_NODE_65116_length_219_cov_1.947059_g63593_i0	PRJNA630162	65116	219	1.947059	4.26405921	Lentisphaerae bacterium GWF2_5	1932692	Bacteria	Bacteria	136	1.84e-35	NR	OGV57835.1	1798574	g63593	i0	93	0.972602739726027	71	5	97.3	0	215	3	248	318	OGV57835.1 MAG: hypothetical protein A2X45_20070 [Lentisphaerae bacterium GWF2_50_93]	diamond	213	136	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_50_93
31660844	31660844	PRJNA630162_P_NODE_40557_length_279_cov_2.365217_g39034_i0	PRJNA630162	40557	279	2.365217	6.59895543	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	118	1.27e-28	NR	MDT8390606.1	2053569	g39034	i0	58.7	1.95698924731183	92	36	96.8	1	277	8	694	785	MDT8390606.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Lentisphaeria bacterium]	diamond	546	118	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31724081	31724081	PRJNA630162_P_NODE_124317_length_172_cov_1.658537_g122794_i0	PRJNA630162	124317	172	1.658537	2.85268364	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	92.4	3.9900000000000005e-21	NR	MEI6422123.1	1932692	g122794	i0	82.4	1.77906976744186	51	9	89	0	168	16	202	252	MEI6422123.1 sugar phosphate isomerase/epimerase [Lentisphaerota bacterium]	diamond	306	92.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32135614	32135614	PRJNA630162_P_NODE_143978_length_166_cov_0.888889_g142455_i0	PRJNA630162	143978	166	0.888889	1.47555574	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	98.2	3.73e-22	NR	NLF17510.1	1932692	g142455	i0	86.8	0.957831325301205	53	7	95.8	0	161	3	380	432	NLF17510.1 AMP-binding protein [Lentisphaerota bacterium]	diamond	159	98.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32483776	32483776	PRJNA630162_P_NODE_70759_length_212_cov_2.674847_g69236_i0	PRJNA630162	70759	212	2.674847	5.67067564	Lentisphaerae bacterium RIFOXYA12_FULL_48_11	1798578	Bacteria	Bacteria	48.1	8.99e-5	NR	OGV64821.1	1798578	g69236	i0	76.7	1.38679245283019	30	7	42.5	0	13	102	25	54	OGV64821.1 MAG: 30S ribosomal protein S8 [Lentisphaerae bacterium RIFOXYA12_FULL_48_11]	diamond	294	48.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium RIFOXYA12_FULL_48_11

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