metadata: contig_metadata: 17 rows where bioproject = "PRJDB9741", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJDB9741", tax_kingdom = "Pseudomonadati" 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
2560696	2560696	PRJDB9741_P_NODE_16843_length_183_cov_1.888060_g16526_i0	PRJDB9741	16843	183	1.88806	3.4551498	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	200	5.259999999999999e-47	NTclustered	gi\|2621704922\|emb\|OY762209.1\|	2660714	g16526	i0	86.486	165.852459016393	185	21	100	4	1	183	3508622	3508440	MAG: Syntrophorhabdaceae bacterium isolate b67c53bf-795e-48b1-b0c8-2f1cb1e3683a genome assembly, chromosome: 1	blastn	30351	200	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
6389085	6389085	PRJDB9741_P_NODE_20166_length_177_cov_3.625000_g19849_i0	PRJDB9741	20166	177	3.625	6.41625	Pelobacter propionicus	29543	Bacteria	Bacteria	152	1.43e-32	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g19849	i0	82.286	0.988700564971751	175	31	99	0	3	177	3478850	3478676	Pelobacter propionicus DSM 2379, complete genome	blastn	175	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
14039175	14039175	PRJDB9741_P_NODE_9512_length_210_cov_2.701863_g9195_i0	PRJDB9741	9512	210	2.701863	5.6739123	Syntrophales bacterium	2928017	Bacteria	Bacteria	104	5.02e-18	NTclustered	gi\|2621706256\|emb\|OY764159.1\|	2928017	g9195	i0	85.577	6.5	104	9	47	4	1	98	1469682	1469579	MAG: Syntrophales bacterium isolate 28fc5764-0b9a-428c-a12f-8ca866e14e1d genome assembly, chromosome: 1	blastn	1365	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
17862869	17862869	PRJDB9741_P_NODE_4555_length_302_cov_2.596838_g4239_i0	PRJDB9741	4555	302	2.596838	7.84245076	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	206	2.04e-48	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g4239	i0	79.605	76.205298013245	304	48	99	13	5	302	886541	886836	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	23014	206	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
20411426	20411426	PRJDB9741_P_NODE_10317_length_205_cov_1.564103_g10000_i0	PRJDB9741	10317	205	1.564103	3.20641115	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	58.4	3.85e-4	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g10000	i0	100	1.06829268292683	31	0	15	0	95	125	3214337	3214307	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	219	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
21687504	21687504	PRJDB9741_P_NODE_28118_length_167_cov_0.864407_g27801_i0	PRJDB9741	28118	167	0.864407	1.44355969	Geomonas subterranea	2847989	Bacteria	Bacteria	86.1	1.38e-12	NTclustered	gi\|2060227305\|gb\|CP077683.1\|	2847989	g27801	i0	93.103	0.694610778443114	58	4	35	0	109	166	473488	473545	Geomonas subterranea strain RG2 chromosome, complete genome	blastn	116	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas subterranea
21687625	21687625	PRJDB9741_P_NODE_41698_length_157_cov_2.518519_g41381_i0	PRJDB9741	41698	157	2.518519	3.95407483	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	94	1.04e-20	NR	MEA5114808.1	2282154	g41381	i0	88.5	0.993630573248408	52	6	99.4	0	156	1	3	54	MEA5114808.1 KUP/HAK/KT family potassium transporter [Geobacteraceae bacterium]	diamond	156	94	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
27696283	27696283	PRJDB9741_P_NODE_34704_length_163_cov_3.035088_g34387_i0	PRJDB9741	34704	163	3.035088	4.94719344	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	94	1.13e-20	NR	MEA5114581.1	2282154	g34387	i0	87	0.993865030674847	54	7	99.4	0	1	162	74	127	MEA5114581.1 M3 family oligoendopeptidase [Geobacteraceae bacterium]	diamond	162	94	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
27885368	27885368	PRJDB9741_P_NODE_18525_length_180_cov_2.427481_g18208_i0	PRJDB9741	18525	180	2.4274810000000002	4.3694658	Geobacter sp.	46610	Bacteria	Bacteria	102	7.98e-24	NR	RII26998.1	46610	g18208	i0	74.6	1.96666666666667	59	15	98.3	0	3	179	114	172	RII26998.1 MAG: hypothetical protein CXR31_06965 [Geobacter sp.]	diamond	354	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
28011911	28011911	PRJDB9741_P_NODE_41905_length_156_cov_2.785047_g41588_i0	PRJDB9741	41905	156	2.785047	4.34467332	Pelobacter propionicus	29543	Bacteria	Bacteria	73.9	6.93e-14	NR	WP_011736280.1	29543	g41588	i0	63.5	1.96153846153846	52	19	100	0	156	1	201	252	WP_011736280.1 type IV pilus biogenesis protein PilM [Pelobacter propionicus]	diamond	306	73.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
28295765	28295765	PRJDB9741_P_NODE_20786_length_176_cov_2.874016_g20469_i0	PRJDB9741	20786	176	2.874016	5.05826816	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	112	8.9e-28	NR	MBL0224796.1	2282154	g20469	i0	87.9	5.93181818181818	58	7	98.9	0	2	175	219	276	MBL0224796.1 branched-chain amino acid ABC transporter substrate-binding protein [Geobacteraceae bacterium]	diamond	1044	112	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
28353012	28353012	PRJDB9741_P_NODE_24066_length_171_cov_2.221311_g23749_i0	PRJDB9741	24066	171	2.221311	3.79844181	Geobacter	28231	Bacteria	Bacteria	98.6	5.2599999999999997e-23	NR	RQW88116.1	46610	g23749	i0	78.6	2.85964912280702	56	12	98.2	0	169	2	9	64	RQW88116.1 MAG: peptidoglycan-binding protein [Geobacter sp.]	diamond	489	99.4	0.991951710261569	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
28927321	28927321	PRJDB9741_P_NODE_21268_length_176_cov_1.259843_g20951_i0	PRJDB9741	21268	176	1.259843	2.21732368	Desulfoprunum benzoelyticum	1506996	Bacteria	Bacteria	117	1.06e-28	NR	WP_183350515.1	1506996	g20951	i0	93.1	0.988636363636364	58	4	98.9	0	2	175	621	678	WP_183350515.1 AAA family ATPase [Desulfoprunum benzoelyticum]	diamond	174	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfoprunum	Desulfoprunum benzoelyticum
29400910	29400910	PRJDB9741_P_NODE_18309_length_181_cov_1.303030_g17992_i0	PRJDB9741	18309	181	1.30303	2.3584843	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	125	1.13e-32	NR	MEA5115453.1	2282154	g17992	i0	95	0.994475138121547	60	3	99.4	0	1	180	241	300	MEA5115453.1 sorbosone dehydrogenase family protein [Geobacteraceae bacterium]	diamond	180	125	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
29463693	29463693	PRJDB9741_P_NODE_34510_length_164_cov_0.886957_g34193_i0	PRJDB9741	34510	164	0.886957	1.45460948	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	92.4	3.96e-20	NR	NVN92419.1	2099678	g34193	i0	87	2.96341463414634	54	7	98.8	0	163	2	206	259	NVN92419.1 TIGR04442 family protein [Desulfuromonadales bacterium]	diamond	486	92.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
29842991	29842991	PRJDB9741_P_NODE_30271_length_166_cov_0.871795_g29954_i0	PRJDB9741	30271	166	0.871795	1.4471797	Candidatus Desulfovibrio intestinipullorum	2838536	Bacteria	Bacteria	121	7.43e-32	NR	HIW01641.1	2838536	g29954	i0	100	0.975903614457831	54	0	97.6	0	164	3	201	254	HIW01641.1 ATP-binding protein [Candidatus Desulfovibrio intestinipullorum]	diamond	162	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Candidatus Desulfovibrio intestinipullorum
30343065	30343065	PRJDB9741_P_NODE_30592_length_166_cov_0.871795_g30275_i0	PRJDB9741	30592	166	0.871795	1.4471797	Bacteria	2	Bacteria	Bacteria	72	2.77e-13	NR	WP_011735917.1	29543	g30275	i0	64	4.62650602409639	50	17	90.4	1	159	10	97	145	WP_011735917.1 SIR2 family NAD-dependent protein deacylase [Pelobacter propionicus]	diamond	768	72	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus

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