metadata: contig_metadata: 18 rows where bioproject = "PRJNA744060" and tax

18 rows where bioproject = "PRJNA744060" 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
7101981	7101981	PRJNA744060_P_NODE_30926_length_295_cov_1.369369_g30597_i0	PRJNA744060	30926	295	1.369369	4.03963855	Desulfococcus multivorans	897	Bacteria	Bacteria	219	2.55e-52	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g30597	i0	80.13	13.0779661016949	307	49	100	8	1	295	3504500	3504806	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	3858	219	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
7102233	7102233	PRJNA744060_P_NODE_46526_length_249_cov_0.886364_g46197_i0	PRJNA744060	46526	249	0.886364	2.20704636	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	183	7.659999999999998e-42	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g46197	i0	80.478	156.140562248996	251	40	99	7	3	249	887073	887318	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	38879	183	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
8376691	8376691	PRJNA744060_P_NODE_36547_length_274_cov_1.164179_g36218_i0	PRJNA744060	36547	274	1.164179	3.18985046	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	75	5.37e-9	NTclustered	gi\|1863426051\|gb\|CP045506.1\|	2773299	g36218	i0	85.714	0.737226277372263	70	10	26	0	120	189	1225291	1225222	Desulfolutivibrio sulfoxidireducens strain DSM 106783 chromosome, complete genome	blastn	202	75	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
8851538	8851538	PRJNA744060_P_NODE_47367_length_247_cov_3.068966_g47038_i0	PRJNA744060	47367	247	3.068966	7.58034602	Desulfosudis	2904716	Bacteria	Bacteria	132	2.79e-26	NTclustered	gi\|158508843\|gb\|CP000859.1\|	96561	g47038	i0	77.419	37.0445344129555	248	39	98	16	6	246	683136	683373	Desulfococcus oleovorans Hxd3, complete genome	blastn	9150	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosudaceae	Desulfosudis	Desulfosudis oleivorans
16025882	16025882	PRJNA744060_P_NODE_30573_length_296_cov_2.080717_g30244_i0	PRJNA744060	30573	296	2.080717	6.15892232	Pseudodesulfovibrio mercurii	641491	Bacteria	Bacteria	220	7.12e-53	NTclustered	gi\|365906293\|gb\|CP003220.1\|	641491	g30244	i0	80.556	82.0236486486486	288	54	97	2	7	293	3782196	3781910	Pseudodesulfovibrio mercurii strain ND132 chromosome, complete genome	blastn	24279	220	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio mercurii
26767864	26767864	PRJNA744060_P_NODE_23581_length_334_cov_2.180077_g23252_i0	PRJNA744060	23581	334	2.180077	7.28145718	Geobacter sp. FeAm	46610	Bacteria	Bacteria	55.1	5.22e-6	NR	WP_168205902.1	2597769	g23252	i0	39.8	3.02694610778443	93	47	82.6	3	334	59	357	441	WP_168205902.1 FG-GAP-like repeat-containing protein [Geobacter sp. FeAm09]	diamond	1011	55.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. FeAm09
26873171	26873171	PRJNA744060_P_NODE_45041_length_251_cov_1.449438_g44712_i0	PRJNA744060	45041	251	1.449438	3.63808938	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	6.01e-5	NR	KPA16706.1	1509431	g44712	i0	46.3	1.61354581673307	67	35	78.9	1	204	7	4455	4521	KPA16706.1 secreted protein containing PKD domain protein, partial [Candidatus Magnetomorum sp. HK-1]	diamond	405	50.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
28095004	28095004	PRJNA744060_P_NODE_36765_length_273_cov_1.750000_g36436_i0	PRJNA744060	36765	273	1.75	4.7775	Desulforhabdus amnigena	40218	Bacteria	Bacteria	61.2	3.13e-9	NR	WP_281795411.1	40218	g36436	i0	40.5	0.923076923076923	84	48	92.3	2	265	14	2	83	WP_281795411.1 RNA recognition motif domain-containing protein [Desulforhabdus amnigena]	diamond	252	61.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus amnigena
28189467	28189467	PRJNA744060_P_NODE_33366_length_285_cov_1.471698_g33037_i0	PRJNA744060	33366	285	1.471698	4.1943393	Fundidesulfovibrio putealis	270496	Bacteria	Bacteria	101	1.2e-22	NR	WP_027191627.1	270496	g33037	i0	53.2	3.78947368421053	94	44	98.9	0	284	3	11	104	WP_027191627.1 glutamine synthetase III [Fundidesulfovibrio putealis]	diamond	1080	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Fundidesulfovibrio	Fundidesulfovibrio putealis
28284257	28284257	PRJNA744060_P_NODE_55266_length_203_cov_4.530769_g54937_i0	PRJNA744060	55266	203	4.530769	9.19746107	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	73.6	1.56e-13	NR	MCP3873292.1	2049433	g54937	i0	65.3	1.44827586206897	49	16	72.4	1	148	2	114	161	MCP3873292.1 SDR family NAD(P)-dependent oxidoreductase [Desulfobacteraceae bacterium]	diamond	294	73.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
28705008	28705008	PRJNA744060_P_NODE_52947_length_234_cov_2.503106_g52618_i0	PRJNA744060	52947	234	2.503106	5.85726804	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.00912	NR	RMG44227.1	2080303	g52618	i0	46	1.28205128205128	50	19	64.1	1	3	152	367	408	RMG44227.1 MAG: phosphoglycerate dehydrogenase [Candidatus Dadabacteria bacterium]	diamond	300	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
28789442	28789442	PRJNA744060_P_NODE_39327_length_265_cov_1.546875_g38998_i0	PRJNA744060	39327	265	1.546875	4.09921875	Desulfobacterales bacterium HSG2	3055596	Bacteria	Bacteria	65.9	3.47e-10	NR	MDM8552622.1	3055596	g38998	i0	55.9	3.15849056603774	59	24	64.5	1	93	263	28	86	MDM8552622.1 trypsin-like serine protease [Desulfobacterales bacterium HSG2]	diamond	837	65.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium HSG2
29115447	29115447	PRJNA744060_P_NODE_38108_length_269_cov_1.173469_g37779_i0	PRJNA744060	38108	269	1.173469	3.15663161	Bacteria	2	Bacteria	Bacteria	51.6	3.99e-5	NR	MBF0233315.1	2006184	g37779	i0	34.2	5.28624535315985	79	43	88.1	2	239	3	758	827	MBF0233315.1 amino acid adenylation domain-containing protein [Desulfamplus sp.]	diamond	1422	52	0.992307692307692	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfamplus	Desulfamplus sp.
29547187	29547187	PRJNA744060_P_NODE_16430_length_397_cov_2.663580_g16101_i0	PRJNA744060	16430	397	2.66358	10.5744126	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	57.8	6.69e-8	NR	MDY6851586.1	2202153	g16101	i0	65.8	3.38539042821159	38	13	28.7	0	396	283	61	98	MDY6851586.1 F0F1 ATP synthase subunit beta [Thermodesulfobacteriota bacterium]	diamond	1344	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30021293	30021293	PRJNA744060_P_NODE_49531_length_244_cov_1.824561_g49202_i0	PRJNA744060	49531	244	1.824561	4.45192884	Candidatus Desulfaltia sp.	3060595	Bacteria	Bacteria	42.4	0.0213	NR	MDO9565119.1	3060595	g49202	i0	45.5	0.676229508196721	55	28	65.2	1	225	67	54	108	MDO9565119.1 hypothetical protein [Candidatus Desulfaltia sp.]	diamond	165	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales		Candidatus Desulfaltia	Candidatus Desulfaltia sp.
30031165	30031165	PRJNA744060_P_NODE_12131_length_460_cov_2.121447_g11803_i0	PRJNA744060	12131	460	2.121447	9.7586562	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	1.05e-10	NR	NJD92220.1	46610	g11803	i0	39.2	4.29782608695652	97	55	62.6	2	393	106	8	101	NJD92220.1 50S ribosomal protein L24 [Geobacter sp.]	diamond	1977	66.2	0.995468277945619	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
30315988	30315988	PRJNA744060_P_NODE_30632_length_296_cov_1.641256_g30303_i0	PRJNA744060	30632	296	1.641256	4.85811776	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	78.2	4.21e-15	NR	MDJ0668874.1	2044940	g30303	i0	49.4	5.14864864864865	85	41	84.1	1	5	253	19	103	MDJ0668874.1 FAD-containing oxidoreductase [Desulfobacterales bacterium]	diamond	1524	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32582124	32582124	PRJNA744060_P_NODE_12479_length_454_cov_1.687664_g12151_i0	PRJNA744060	12479	454	1.687664	7.66199456	Candidatus Magnetomorum sp.	2739430	Bacteria	Bacteria	59.7	4.76e-7	NR	MBF0450489.1	2739430	g12151	i0	37.5	0.740088105726872	112	62	72.7	5	23	352	211	316	MBF0450489.1 tandem-95 repeat protein [Candidatus Magnetomorum sp.]	diamond	336	59.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum 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);;