metadata: contig_metadata: 8 rows where bioproject = "PRJNA1195374" and tax

8 rows where bioproject = "PRJNA1195374" 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
7420422	7420422	PRJNA1195374_P_NODE_16226_length_562_cov_1.259714_g15885_i0	PRJNA1195374	16226	562	1.259714	7.07959268	Pseudomonadati	3379134	Bacteria	Bacteria	226	3.12e-70	NR	MBM4154607.1	1932692	g15885	i0	64.4	1.88967971530249	177	60	94.5	2	533	3	29	202	MBM4154607.1 porphobilinogen synthase [Lentisphaerota bacterium]	diamond	1062	226	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
7975605	7975605	PRJNA1195374_P_NODE_75607_length_248_cov_0.880000_g75263_i0	PRJNA1195374	75607	248	0.88	2.1824	Lentisphaerae bacterium GWF2_49_21	1798573	Bacteria	Bacteria	145	7.949999999999999e-40	NR	OGV36410.1	1798573	g75263	i0	86.6	4.95967741935484	82	11	99.2	0	248	3	129	210	OGV36410.1 MAG: L-threonine dehydrogenase [Lentisphaerae bacterium GWF2_49_21]	diamond	1230	145	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_49_21
28177598	28177598	PRJNA1195374_P_NODE_57446_length_286_cov_1.708920_g57102_i0	PRJNA1195374	57446	286	1.70892	4.8875112	Victivallales bacterium	2212475	Bacteria	Bacteria	55.5	2.23e-6	NR	MBP5673196.1	2212475	g57102	i0	55.8	0.545454545454545	52	23	54.5	0	4	159	3367	3418	MBP5673196.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Victivallales bacterium]	diamond	156	55.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
28481013	28481013	PRJNA1195374_P_NODE_47746_length_319_cov_1.922764_g47402_i0	PRJNA1195374	47746	319	1.922764	6.13361716	Bacteria	2	Bacteria	Bacteria	131	1.08e-34	NR	WP_007279063.1	256847	g47402	i0	57.8	16.0532915360502	102	43	95.9	0	2	307	62	163	WP_007279063.1 NADPH-dependent aldehyde reductase Ahr [Lentisphaera araneosa]	diamond	5121	131	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera araneosa
28746196	28746196	PRJNA1195374_P_NODE_82187_length_243_cov_0.905882_g81843_i0	PRJNA1195374	82187	243	0.905882	2.20129326	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	50.1	8.92e-5	NR	MCK5835192.1	2053569	g81843	i0	37.5	0.987654320987654	80	29	98.8	3	3	242	166	224	MCK5835192.1 SDR family oxidoreductase [Lentisphaeria bacterium]	diamond	240	50.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29409170	29409170	PRJNA1195374_P_NODE_52909_length_300_cov_1.603524_g52565_i0	PRJNA1195374	52909	300	1.603524	4.810572	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	97.4	1.81e-21	NR	MCX6986046.1	1932692	g52565	i0	68.1	1.38	69	22	69	0	293	87	320	388	MCX6986046.1 iron-containing alcohol dehydrogenase [Lentisphaerota bacterium]	diamond	414	97.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30799014	30799014	PRJNA1195374_P_NODE_84334_length_241_cov_1.375000_g83990_i0	PRJNA1195374	84334	241	1.375	3.31375	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	44.3	0.0106	NR	HQC52911.1	2053569	g83990	i0	40.9	0.547717842323652	44	21	54.8	1	199	68	540	578	HQC52911.1 hypothetical protein [Lentisphaeria bacterium]	diamond	132	44.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32557824	32557824	PRJNA1195374_P_NODE_74099_length_249_cov_0.875000_g73755_i0	PRJNA1195374	74099	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	58.2	1.47e-7	NR	MBM4144131.1	1932692	g73755	i0	45.8	1.86746987951807	72	33	86.7	2	34	249	339	404	MBM4144131.1 tyrosine--tRNA ligase [Lentisphaerota bacterium]	diamond	465	58.5	0.994871794871795	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;