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

12 rows where analysis = "diamond", bioproject = "PRJNA1200128" 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
26755860	26755860	PRJNA1200128_S_NODE_11001_length_245_cov_1.787129_g10892_i0	PRJNA1200128	11001	245	1.787129	4.37846605	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	43.5	0.0199	NR	MCJ8328656.1	2053569	g10892	i0	37.5	1.37142857142857	56	34	67.3	1	232	68	38	93	MCJ8328656.1 amidohydrolase family protein [Lentisphaeria bacterium]	diamond	336	43.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27388830	27388830	PRJNA1200128_S_NODE_33103_length_173_cov_1.084615_g32994_i0	PRJNA1200128	33103	173	1.084615	1.87638395	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.8	0.0432	NR	PYL54605.1	2026799	g32994	i0	44.4	0.780346820809249	45	24	76.3	1	1	132	26	70	PYL54605.1 MAG: hypothetical protein DMF29_06015 [Verrucomicrobiota bacterium]	diamond	135	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27514948	27514948	PRJNA1200128_S_NODE_28963_length_181_cov_1.021739_g28854_i0	PRJNA1200128	28963	181	1.021739	1.84934759	Pelagicoccus sp. SDUM812	2921790	Bacteria	Bacteria	42.7	0.0161	NR	WP_309019849.1	3041267	g28854	i0	39.2	0.845303867403315	51	31	84.5	0	6	158	34	84	WP_309019849.1 CehA/McbA family metallohydrolase [Pelagicoccus sp. SDUM812003]	diamond	153	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus sp. SDUM812003
28177749	28177749	PRJNA1200128_S_NODE_23546_length_194_cov_0.933775_g23437_i0	PRJNA1200128	23546	194	0.933775	1.8115235	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	44.7	0.00399	NR	MBN1796766.1	2813034	g23437	i0	38.2	0.850515463917526	55	25	71.1	1	161	24	31	85	MBN1796766.1 AmmeMemoRadiSam system radical SAM enzyme [Sedimentisphaerales bacterium]	diamond	165	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
28746331	28746331	PRJNA1200128_S_NODE_39887_length_162_cov_1.184874_g39778_i0	PRJNA1200128	39887	162	1.184874	1.91949588	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0311	NR	MFC1737531.1	2026780	g39778	i0	40.9	0.814814814814815	44	26	81.5	0	140	9	5	48	MFC1737531.1 PAC2 family protein [Planctomycetota bacterium]	diamond	132	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29504013	29504013	PRJNA1200128_S_NODE_48910_length_151_cov_0.944444_g48801_i0	PRJNA1200128	48910	151	0.944444	1.42611044	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	43.1	0.00786	NR	MFO7956648.1	2517210	g48801	i0	40.4	0.933774834437086	47	28	93.4	0	4	144	85	131	MFO7956648.1 divalent metal cation transporter [Candidatus Brocadiia bacterium]	diamond	141	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
29788105	29788105	PRJNA1200128_S_NODE_10771_length_247_cov_0.867647_g10662_i0	PRJNA1200128	10771	247	0.867647	2.14308809	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0268	NR	MDZ4198075.1	2212473	g10662	i0	40	0.668016194331984	55	30	65.6	2	69	230	149	201	MDZ4198075.1 Gfo/Idh/MocA family oxidoreductase [Kiritimatiellia bacterium]	diamond	165	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29914802	29914802	PRJNA1200128_S_NODE_8671_length_264_cov_7.723982_g8562_i0	PRJNA1200128	8671	264	7.723982	20.39131248	Opitutia bacterium	2026771	Bacteria	Bacteria	43.9	0.0189	NR	MBI5425267.1	2026771	g8562	i0	39.7	1.97727272727273	58	29	62.5	2	203	39	299	353	MBI5425267.1 glycoside hydrolase family 2 [Opitutia bacterium]	diamond	522	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31558159	31558159	PRJNA1200128_S_NODE_14656_length_224_cov_1.165746_g14547_i0	PRJNA1200128	14656	224	1.165746	2.61127104	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0394	NR	MDX1951866.1	2026799	g14547	i0	34.8	0.616071428571429	46	30	61.6	0	148	11	226	271	MDX1951866.1 POTRA domain-containing protein [Verrucomicrobiota bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31747631	31747631	PRJNA1200128_S_NODE_17477_length_212_cov_1.946746_g17368_i0	PRJNA1200128	17477	212	1.946746	4.12710152	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	43.1	0.0189	NR	MBP7216218.1	2035772	g17368	i0	35.7	0.792452830188679	56	36	79.2	0	191	24	3592	3647	MBP7216218.1 methyltransferase domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	168	43.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32570609	32570609	PRJNA1200128_S_NODE_8079_length_270_cov_3.070485_g7970_i0	PRJNA1200128	8079	270	3.070485	8.2903095	Prosthecobacter sp.	1965333	Bacteria	Bacteria	46.2	0.0031	NR	WP_395745445.1	1965333	g7970	i0	39.7	0.7	63	30	61.1	2	3	167	163	225	WP_395745445.1 O-antigen ligase family protein [Prosthecobacter sp.]	diamond	189	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32759242	32759242	PRJNA1200128_S_NODE_24140_length_192_cov_1.496644_g24031_i0	PRJNA1200128	24140	192	1.496644	2.87355648	Pirellula sp.	117	Bacteria	Bacteria	42.4	0.0256	NR	MCE2753667.1	117	g24031	i0	45.2	0.65625	42	23	65.6	0	32	157	356	397	MCE2753667.1 ammonium transporter [Pirellula sp.]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.

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