metadata: contig_metadata: 21 rows where bioproject = "PRJNA1067370" and tax

21 rows where bioproject = "PRJNA1067370" 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
4007376	4007376	PRJNA1067370_P_NODE_49364_length_298_cov_1.244444_g48816_i0	PRJNA1067370	49364	298	1.244444	3.70844312	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	422	1.83e-113	NTclustered	gi\|2621785158\|emb\|OY781616.1\|	2795000	g48816	i0	92.282	290.852348993289	298	21	99	2	1	297	627482	627186	MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1	blastn	86674	422	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
5283867	5283867	PRJNA1067370_P_NODE_74245_length_258_cov_1.664865_g73696_i0	PRJNA1067370	74245	258	1.664865	4.2953517	Desulfovibrio mangrovi	2976983	Bacteria	Bacteria	398	2.62e-106	NTclustered	gi\|2330538096\|gb\|CP104208.1\|	2976983	g73696	i0	97.826	230.562015503876	230	5	89	0	29	258	1675691	1675920	Desulfovibrio mangrovi strain FT415 chromosome, complete genome	blastn	59485	398	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio mangrovi
7390864	7390864	PRJNA1067370_P_NODE_107766_length_243_cov_0.905882_g107217_i0	PRJNA1067370	107766	243	0.905882	2.20129326	Geobacter	28231	Bacteria	Bacteria	272	1.5399999999999998e-68	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g107217	i0	86.831	357.777777777778	243	32	100	0	1	243	2784467	2784709	Geobacter sulfurreducens strain AM-1 genome	blastn	86940	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
11659295	11659295	PRJNA1067370_P_NODE_19630_length_423_cov_3.988571_g19082_i0	PRJNA1067370	19630	423	3.988571	16.87165533	Desulfuromonas acetoxidans	891	Bacteria	Bacteria	351	3.59e-92	NTclustered	gi\|662020026\|ref\|NR_121913.1\|	891	g19082	i0	83.206	187.730496453901	393	56	91	9	37	423	1218	830	Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence	blastn	79410	351	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas acetoxidans
25239470	25239470	PRJNA1067370_P_NODE_16180_length_461_cov_2.141753_g15632_i0	PRJNA1067370	16180	461	2.141753	9.87348133	Pseudodesulfovibrio	2035811	Bacteria	Bacteria	545	1.68e-150	NTclustered	gi\|485099208\|ref\|NR_102600.1\|	879567	g15632	i0	88.121	446.1431670282	463	49	99	4	1	459	1339	1799	Desulfovibrio piezophilus strain C1TLV30 23S ribosomal RNA gene, complete sequence	blastn	205672	545	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio piezophilus
26592127	26592127	PRJNA1067370_P_NODE_4561_length_821_cov_2.030749_g4081_i0	PRJNA1067370	4561	821	2.030749	16.67244929	Desulfovibrio cuneatus	159728	Bacteria	Bacteria	78.2	1.9e-13	NR	WP_051258216.1	159728	g4081	i0	47.4	0.416565164433618	114	55	40.2	2	352	23	2	114	WP_051258216.1 pesticin C-terminus-like muramidase [Desulfovibrio cuneatus]	diamond	342	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio cuneatus
27856855	27856855	PRJNA1067370_P_NODE_81085_length_251_cov_0.865169_g80536_i0	PRJNA1067370	81085	251	0.865169	2.17157419	Pseudodesulfovibrio sediminis	2810563	Bacteria	Bacteria	61.2	4.36e-10	NR	WP_229591809.1	2810563	g80536	i0	66.7	0.466135458167331	39	13	46.6	0	117	1	1	39	WP_229591809.1 RNA recognition motif domain-containing protein [Pseudodesulfovibrio sediminis]	diamond	117	61.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sediminis
28709616	28709616	PRJNA1067370_P_NODE_95467_length_246_cov_2.722543_g94918_i0	PRJNA1067370	95467	246	2.722543	6.69745578	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	42	0.0368	NR	HYA43157.1	2052185	g94918	i0	34.4	0.74390243902439	61	38	74.4	1	238	56	23	81	HYA43157.1 potassium channel family protein [Syntrophobacteraceae bacterium]	diamond	183	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
29246162	29246162	PRJNA1067370_P_NODE_53809_length_289_cov_1.407407_g53260_i0	PRJNA1067370	53809	289	1.407407	4.06740623	Syntrophobacterales bacterium	2282155	Bacteria	Bacteria	149	1.81e-41	NR	MEJ2092418.1	2282155	g53260	i0	74	1.99307958477509	96	25	99.7	0	2	289	92	187	MEJ2092418.1 glycosyltransferase family 2 protein [Syntrophobacterales bacterium]	diamond	576	149	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium
29404070	29404070	PRJNA1067370_P_NODE_53909_length_289_cov_1.268519_g53360_i0	PRJNA1067370	53909	289	1.268519	3.66601991	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	46.2	7.62e-4	NR	MCG8553506.1	2044940	g53360	i0	27.6	1.01730103806228	98	67	97.6	1	284	3	8	105	MCG8553506.1 hypothetical protein [Desulfobacterales bacterium]	diamond	294	46.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29435224	29435224	PRJNA1067370_P_NODE_102670_length_244_cov_1.350877_g102121_i0	PRJNA1067370	102670	244	1.350877	3.29613988	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	47.4	8.94e-4	NR	MCB2182907.1	2053307	g102121	i0	56.8	0.959016393442623	37	16	45.5	0	141	31	14	50	MCB2182907.1 glutamine synthetase III [Desulfobulbaceae bacterium]	diamond	234	47.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
30090312	30090312	PRJNA1067370_P_NODE_19872_length_421_cov_2.212644_g19324_i0	PRJNA1067370	19872	421	2.212644	9.31523124	Pseudomonadati	3379134	Bacteria	Bacteria	96.3	3.4800000000000006e-21	NR	WP_321495025.1	240139	g19324	i0	47	5.07363420427553	115	54	79.8	2	75	410	61	171	WP_321495025.1 DUF4197 domain-containing protein [uncultured Desulfobacter sp.]	diamond	2136	96.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	uncultured Desulfobacter sp.
30098677	30098677	PRJNA1067370_P_NODE_37792_length_326_cov_1.217391_g37244_i0	PRJNA1067370	37792	326	1.217391	3.96869466	Candidatus Electronema halotolerans	3036122	Bacteria	Bacteria	68.6	8.54e-11	NR	CAK8714776.1	3036122	g37244	i0	37.9	0.947852760736196	103	52	89.3	3	325	35	112	208	CAK8714776.1 hypothetical protein GCAAIG_04140 [Candidatus Electronema halotolerans]	diamond	309	68.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema halotolerans
30375268	30375268	PRJNA1067370_P_NODE_23132_length_395_cov_1.630435_g22584_i0	PRJNA1067370	23132	395	1.630435	6.44021825	Bacteria	2	Bacteria	Bacteria	112	6.79e-27	NR	MBI4962568.1	2358	g22584	i0	46.4	2.58227848101266	112	59	84.3	1	49	381	5	116	MBI4962568.1 Tat pathway signal protein [Desulfomonile tiedjei]	diamond	1020	113	0.991150442477876	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
30572559	30572559	PRJNA1067370_P_NODE_97953_length_246_cov_0.890173_g97404_i0	PRJNA1067370	97953	246	0.890173	2.18982558	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.1	0.00565	NR	MFQ5843315.1	2202153	g97404	i0	31	0.707317073170732	58	36	65.9	2	38	199	4	61	MFQ5843315.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	174	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31109644	31109644	PRJNA1067370_P_NODE_111395_length_242_cov_0.911243_g110846_i0	PRJNA1067370	111395	242	0.911243	2.20520806	Maridesulfovibrio hydrothermalis	191026	Bacteria	Bacteria	45.4	0.00418	NR	WP_015337732.1	191026	g110846	i0	38.8	0.607438016528926	49	29	60.7	1	237	91	316	363	WP_015337732.1 PAS domain-containing sensor histidine kinase [Maridesulfovibrio hydrothermalis]	diamond	147	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio hydrothermalis
31204119	31204119	PRJNA1067370_P_NODE_111695_length_242_cov_0.911243_g111146_i0	PRJNA1067370	111695	242	0.911243	2.20520806	Desulfogranum marinum	453220	Bacteria	Bacteria	108	3.4e-25	NR	WP_232370840.1	453220	g111146	i0	69.6	2.76446280991736	69	16	85.5	1	27	233	273	336	WP_232370840.1 5-histidylcysteine sulfoxide synthase [Desulfogranum marinum]	diamond	669	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfogranum	Desulfogranum marinum
31584443	31584443	PRJNA1067370_P_NODE_79796_length_251_cov_0.865169_g79247_i0	PRJNA1067370	79796	251	0.865169	2.17157419	Smithella sp.	2053614	Bacteria	Bacteria	50.4	7.38e-5	NR	MEN6620309.1	2053614	g79247	i0	44.8	0.693227091633466	58	32	69.3	0	182	9	36	93	MEN6620309.1 ankyrin repeat domain-containing protein [Smithella sp.]	diamond	174	50.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
31900452	31900452	PRJNA1067370_P_NODE_100217_length_245_cov_0.895349_g99668_i0	PRJNA1067370	100217	245	0.895349	2.19360505	Desulfosarcina sp. BuS5	933262	Bacteria	Bacteria	90.1	4.55e-19	NR	WP_035266092.1	933262	g99668	i0	53.2	0.96734693877551	79	36	95.5	1	9	242	23	101	WP_035266092.1 RNA-guided endonuclease InsQ/TnpB family protein [Desulfosarcina sp. BuS5]	diamond	237	90.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina sp. BuS5
32050372	32050372	PRJNA1067370_P_NODE_97238_length_246_cov_0.890173_g96689_i0	PRJNA1067370	97238	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	58.2	2.12e-8	NR	TES90568.1	2049433	g96689	i0	38.5	5.29268292682927	78	46	95.1	2	244	11	52	127	TES90568.1 MAG: ester cyclase [Desulfobacteraceae bacterium]	diamond	1302	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
32216998	32216998	PRJNA1067370_P_NODE_58278_length_282_cov_1.861244_g57729_i0	PRJNA1067370	58278	282	1.861244	5.24870808	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	156	1.15e-45	NR	GJM17674.1	2202153	g57729	i0	90.5	1.8936170212766	84	8	89.4	0	29	280	7	90	GJM17674.1 MAG: hypothetical protein DHS20C13_30010 [Thermodesulfobacteriota bacterium]	diamond	534	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota 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);;