metadata: contig_metadata: 14 rows where bioproject = "PRJNA752572" and tax

14 rows where bioproject = "PRJNA752572" and tax_phylum = "Thermodesulfobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
10932555	10932555	PRJNA752572_P_NODE_105289_length_263_cov_1.692982_g104782_i0	PRJNA752572	105289	263	1.692982	4.45254266	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	112	8.360000000000001e-29	NR	GJM17743.1	2202153	g104782	i0	69	1.98479087452471	87	27	99.2	0	2	262	120	206	GJM17743.1 MAG: hypothetical protein DHS20C13_30700 [Thermodesulfobacteriota bacterium]	diamond	522	112	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
12681001	12681001	PRJNA752572_P_NODE_23490_length_560_cov_2.569524_g23034_i0	PRJNA752572	23490	560	2.569524	14.3893344	Pseudomonadati	3379134	Bacteria	Bacteria	682	0	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g23034	i0	88.75	167.423214285714	560	60	99	3	1	557	1712468	1713027	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	93757	682	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
20327848	20327848	PRJNA752572_P_NODE_78616_length_306_cov_3.678967_g78109_i0	PRJNA752572	78616	306	3.678967	11.25763902	Thermodesulfatator	241192	Bacteria	Bacteria	148	3.5399999999999992e-31	NTclustered	gi\|470488503\|ref\|NR_076874.1\|	171695	g78109	i0	88.618	94.0490196078431	123	12	40	2	1	121	1912	1790	Thermodesulfatator indicus strain CIR29812 23S ribosomal RNA gene, complete sequence	blastn	28779	148	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator indicus
26831401	26831401	PRJNA752572_P_NODE_132501_length_233_cov_1.484848_g131994_i0	PRJNA752572	132501	233	1.484848	3.45969584	Geomonas limicola	2740186	Bacteria	Bacteria	60.8	1.35e-8	NR	WP_183360495.1	2740186	g131994	i0	66.7	0.927038626609442	36	12	46.4	0	177	70	213	248	WP_183360495.1 multicopper oxidase domain-containing protein [Geomonas limicola]	diamond	216	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas limicola
27811197	27811197	PRJNA752572_P_NODE_266784_length_164_cov_1.806202_g266277_i0	PRJNA752572	266784	164	1.806202	2.96217128	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	41.2	0.0445	NR	MCF6289532.1	2044940	g266277	i0	59.3	0.49390243902439	27	11	49.4	0	10	90	145	171	MCF6289532.1 DUF4338 domain-containing protein [Desulfobacterales bacterium]	diamond	81	41.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
27874110	27874110	PRJNA752572_P_NODE_195065_length_191_cov_1.025641_g194558_i0	PRJNA752572	195065	191	1.025641	1.95897431	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	52.4	7.4e-6	NR	HAO22905.1	2049433	g194558	i0	42.1	0.895287958115183	57	33	89.5	0	184	14	340	396	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	171	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
28884412	28884412	PRJNA752572_P_NODE_184428_length_196_cov_2.223602_g183921_i0	PRJNA752572	184428	196	2.223602	4.35825992	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	42.7	0.0206	NR	MBQ4133630.1	2049043	g183921	i0	32.8	0.887755102040816	58	37	85.7	1	195	28	368	425	MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium]	diamond	174	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
28915811	28915811	PRJNA752572_P_NODE_23988_length_554_cov_3.836224_g23529_i0	PRJNA752572	23988	554	3.836224	21.25268096	Desulfovibrio inopinatus	102109	Bacteria	Bacteria	140	3.5699999999999995e-35	NR	WP_027186307.1	102109	g23529	i0	42.9	1.97653429602888	189	90	93.1	5	520	5	306	493	WP_027186307.1 amidohydrolase [Desulfovibrio inopinatus]	diamond	1095	140	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio inopinatus
30147382	30147382	PRJNA752572_P_NODE_154972_length_215_cov_1.327778_g154465_i0	PRJNA752572	154972	215	1.327778	2.8547227	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	84	7.78e-17	NR	HAO22905.1	2049433	g154465	i0	46.5	0.990697674418605	71	38	99.1	0	2	214	410	480	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	213	84	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31189916	31189916	PRJNA752572_P_NODE_135_length_2958_cov_3.650701_g116_i0	PRJNA752572	135	2958	3.650701	107.98773558	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	54.7	4.57e-4	NR	GJM17643.1	2202153	g116	i0	25.3	0.228194726166329	225	133	21.4	7	2193	2825	10	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	675	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31506800	31506800	PRJNA752572_P_NODE_276156_length_162_cov_1.220472_g275649_i0	PRJNA752572	276156	162	1.220472	1.97716464	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	43.5	0.00688	NR	HAO22905.1	2049433	g275649	i0	39.6	0.981481481481482	53	32	98.1	0	159	1	173	225	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	159	43.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31664602	31664602	PRJNA752572_P_NODE_214397_length_181_cov_1.917808_g213890_i0	PRJNA752572	214397	181	1.917808	3.47123248	Desulfomonile tiedjei	2358	Bacteria	Bacteria	55.8	3.93e-7	NR	MBI4965355.1	2358	g213890	i0	48.2	0.92817679558011	56	28	91.2	1	180	16	140	195	MBI4965355.1 hypothetical protein [Desulfomonile tiedjei]	diamond	168	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
31917796	31917796	PRJNA752572_P_NODE_64997_length_338_cov_2.204620_g64490_i0	PRJNA752572	64997	338	2.20462	7.4516156	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	122	3.7899999999999997e-32	NR	GJM17626.1	2202153	g64490	i0	60	0.976331360946746	110	42	97.6	2	338	9	83	190	GJM17626.1 MAG: hypothetical protein DHS20C13_29530 [Thermodesulfobacteriota bacterium]	diamond	330	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32644846	32644846	PRJNA752572_P_NODE_97320_length_274_cov_1.857741_g96813_i0	PRJNA752572	97320	274	1.857741	5.09021034	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	87.8	7.72e-18	NR	HAO22905.1	2049433	g96813	i0	41.8	0.996350364963504	91	53	99.6	0	1	273	276	366	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	273	87.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae 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);;