metadata: contig_metadata: 20 rows where bioproject = "PRJNA1137393", tax_kingdom = "Pseudomonadati" and tax

20 rows where bioproject = "PRJNA1137393", 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
4111811	4111811	PRJNA1137393_P_NODE_54164_length_166_cov_0.888889_g53648_i0	PRJNA1137393	54164	166	0.888889	1.47555574	Desulfosediminicola flagellatus	2569541	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1861338670\|gb\|CP050698.1\|	2569541	g53648	i0	100	0.849397590361446	29	0	17	0	26	54	3781549	3781521	Desulfosediminicola flagellatus strain IMCC35005 chromosome, complete genome	blastn	141	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfosediminicola	Desulfosediminicola flagellatus
5388037	5388037	PRJNA1137393_P_NODE_67945_length_163_cov_0.912281_g67429_i0	PRJNA1137393	67945	163	0.912281	1.48701803	Geobacter metallireducens	28232	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g67429	i0	92.308	1.07361963190184	39	3	24	0	72	110	2445666	2445704	Geobacter metallireducens GS-15, complete genome	blastn	175	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
7409969	7409969	PRJNA1137393_P_NODE_21866_length_196_cov_7.741497_g21350_i0	PRJNA1137393	21866	196	7.741497	15.17333412	Desulfurivibrio	427922	Bacteria	Bacteria	178	2.68e-40	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g21350	i0	84.53	110.326530612245	181	27	92	1	17	196	936	1116	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	21624	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
7409987	7409987	PRJNA1137393_P_NODE_29366_length_182_cov_2.270677_g28850_i0	PRJNA1137393	29366	182	2.270677	4.13263214	Geotalea	2910589	Bacteria	Bacteria	195	2.43e-45	NTclustered	gi\|470481994\|ref\|NR_076507.1\|	351604	g28850	i0	86.339	195.851648351648	183	20	99	5	2	181	532	352	Geobacter uraniireducens strain Rf4 23S ribosomal RNA gene, complete sequence	blastn	35645	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
13038383	13038383	PRJNA1137393_P_NODE_16851_length_213_cov_2.695122_g16335_i0	PRJNA1137393	16851	213	2.695122	5.74060986	Desulfosarcina widdelii	947919	Bacteria	Bacteria	207	3.78e-49	NTclustered	gi\|1773416083\|dbj\|AP021875.1\|	947919	g16335	i0	89.157	485.413145539906	166	18	78	0	6	171	6916668	6916503	Desulfosarcina widdelii PP31 DNA, complete genome	blastn	103393	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
13038536	13038536	PRJNA1137393_P_NODE_63991_length_164_cov_0.904348_g63475_i0	PRJNA1137393	63991	164	0.904348	1.48313072	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g63475	i0	98.171	1	164	3	100	0	1	164	2419513	2419350	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	164	287	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
14313722	14313722	PRJNA1137393_P_NODE_57032_length_165_cov_0.896552_g56516_i0	PRJNA1137393	57032	165	0.896552	1.4793108	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	105	4.65e-25	NR	MCF8029794.1	2683721	g56516	i0	96.3	0.981818181818182	54	2	98.2	0	164	3	339	392	MCF8029794.1 trimethylamine methyltransferase family protein [Desulfohalobiaceae bacterium]	diamond	162	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
15059723	15059723	PRJNA1137393_P_NODE_21912_length_196_cov_2.190476_g21396_i0	PRJNA1137393	21912	196	2.190476	4.29333296	Pseudomonadati	3379134	Bacteria	Bacteria	233	5.639999999999999e-57	NTclustered	gi\|2425841343\|dbj\|AP027151.1\|	351604	g21396	i0	88.947	279.295918367347	190	19	96	2	7	195	753578	753390	Geotalea uraniireducens NIT-SL11 DNA, complete genome	blastn	54742	235	0.991489361702128	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
15587576	15587576	PRJNA1137393_P_NODE_22433_length_195_cov_1.287671_g21917_i0	PRJNA1137393	22433	195	1.287671	2.51095845	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	135	1.6300000000000002e-27	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g21917	i0	80.791	93.8461538461538	177	31	90	3	1	176	1711875	1711701	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	18300	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
18883580	18883580	PRJNA1137393_P_NODE_10615_length_255_cov_1.009709_g10099_i0	PRJNA1137393	10615	255	1.009709	2.57475795	Bacteria	2	Bacteria	Bacteria	272	1.6299999999999998e-68	NTclustered	gi\|2518551120\|emb\|OX638332.1\|	2080303	g10099	i0	86.667	117.564705882353	255	22	100	3	1	255	22571	22813	MAG: Candidatus Dadabacteria bacterium isolate 28c7ac20-cd97-4a81-9be0-f5b43b5a8d2b genome assembly, chromosome: 1	blastn	29979	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
23984355	23984355	PRJNA1137393_P_NODE_18139_length_209_cov_0.893750_g17623_i0	PRJNA1137393	18139	209	0.89375	1.8679375	Geobacteraceae	213422	Bacteria	Bacteria	364	2.0699999999999992e-96	NTclustered	gi\|1976315905\|dbj\|AP024469.1\|	2495594	g17623	i0	98.544	527.53110047846906	206	3	99	0	4	209	736748	736543	Geobacter sp. SVR DNA, complete genome	blastn	110254	366	0.994535519125683	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR
27101898	27101898	PRJNA1137393_P_NODE_32342_length_178_cov_1.232558_g31826_i0	PRJNA1137393	32342	178	1.232558	2.19395324	Smithellaceae bacterium	2964540	Bacteria	Bacteria	87.4	2.86e-18	NR	MFA7177189.1	2964540	g31826	i0	81.4	2.98314606741573	59	11	99.4	0	178	2	1	59	MFA7177189.1 hypothetical protein [Smithellaceae bacterium]	diamond	531	87.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
27196635	27196635	PRJNA1137393_P_NODE_58402_length_165_cov_0.896552_g57886_i0	PRJNA1137393	58402	165	0.896552	1.4793108	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	45.4	0.00144	NR	MEF8823079.1	2683721	g57886	i0	70	0.545454545454545	30	9	54.5	0	3	92	630	659	MEF8823079.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Desulfohalobiaceae bacterium]	diamond	90	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
27228328	27228328	PRJNA1137393_P_NODE_69223_length_162_cov_2.123894_g68707_i0	PRJNA1137393	69223	162	2.123894	3.44070828	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	82.4	1.49e-17	NR	MEF8888567.1	2683721	g68707	i0	91.9	1.37037037037037	37	3	68.5	0	51	161	181	217	MEF8888567.1 radical SAM protein [Desulfohalobiaceae bacterium]	diamond	222	82.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
30164995	30164995	PRJNA1137393_P_NODE_55612_length_166_cov_0.888889_g55096_i0	PRJNA1137393	55612	166	0.888889	1.47555574	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	106	2.56e-25	NR	MEF8889204.1	2683721	g55096	i0	98.1	1.91566265060241	53	1	95.8	0	6	164	314	366	MEF8889204.1 trehalose-6-phosphate synthase [Desulfohalobiaceae bacterium]	diamond	318	106	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
30638970	30638970	PRJNA1137393_P_NODE_52693_length_166_cov_0.888889_g52177_i0	PRJNA1137393	52693	166	0.888889	1.47555574	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	55.8	1.67e-7	NR	MDJ0912425.1	2044940	g52177	i0	64.7	1.21084337349398	34	12	61.4	0	161	60	182	215	MDJ0912425.1 thermonuclease family protein [Desulfobacterales bacterium]	diamond	201	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
31682036	31682036	PRJNA1137393_P_NODE_40557_length_169_cov_0.866667_g40041_i0	PRJNA1137393	40557	169	0.866667	1.46466723	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	106	1.49e-26	NR	MEF8943583.1	2683721	g40041	i0	90.9	0.976331360946746	55	5	97.6	0	3	167	11	65	MEF8943583.1 polyphenol oxidase family protein [Desulfohalobiaceae bacterium]	diamond	165	106	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32188542	32188542	PRJNA1137393_P_NODE_62038_length_164_cov_0.904348_g61522_i0	PRJNA1137393	62038	164	0.904348	1.48313072	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	72	6e-13	NR	MEF8889342.1	2683721	g61522	i0	91.4	0.640243902439024	35	3	64	0	163	59	93	127	MEF8889342.1 FAD-dependent oxidoreductase [Desulfohalobiaceae bacterium]	diamond	105	72	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32252052	32252052	PRJNA1137393_P_NODE_61618_length_164_cov_0.904348_g61102_i0	PRJNA1137393	61618	164	0.904348	1.48313072	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	85.9	7.98e-18	NR	HTP65246.1	2282154	g61102	i0	72.2	0.98780487804878	54	15	98.8	0	162	1	1009	1062	HTP65246.1 exodeoxyribonuclease V subunit beta [Geobacteraceae bacterium]	diamond	162	85.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
32494075	32494075	PRJNA1137393_P_NODE_37399_length_171_cov_1.549180_g36883_i0	PRJNA1137393	37399	171	1.54918	2.6490978	Pseudomonadati	3379134	Bacteria	Bacteria	75.1	1.98e-15	NR	MDD2317129.1	2044940	g36883	i0	60.7	4.80701754385965	56	22	98.2	0	4	171	38	93	MDD2317129.1 hypothetical protein [Desulfobacterales bacterium]	diamond	822	75.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;