metadata: contig_metadata: 18 rows where bioproject = "PRJEB58983", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJEB58983", 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
125041	125041	PRJEB58983_P_NODE_32221_length_242_cov_2.106509_g31806_i0	PRJEB58983	32221	242	2.106509	5.09775178	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	142	3.25e-41	NR	GJM17675.1	2202153	g31806	i0	87.3	2.96280991735537	79	10	97.9	0	242	6	77	155	GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium]	diamond	717	142	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
992130	992130	PRJEB58983_P_NODE_25661_length_262_cov_1.280423_g25246_i0	PRJEB58983	25661	262	1.280423	3.35470826	Desulfocapsaceae	2886822	Bacteria	Bacteria	110	1.4e-19	NTclustered	gi\|2557433592\|gb\|CP050700.1\|	2653858	g25246	i0	88.889	19.9198473282443	90	8	34	2	16	104	5809087	5809175	Desulfopila sp. IMCC35008 chromosome, complete genome	blastn	5219	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila sp. IMCC35008
5227583	5227583	PRJEB58983_P_NODE_29605_length_248_cov_2.668571_g29190_i0	PRJEB58983	29605	248	2.668571	6.61805608	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	124	4.6899999999999996e-24	NTclustered	gi\|2621705002\|emb\|OY762289.1\|	2049043	g29190	i0	79.365	107.689516129032	189	30	75	7	62	246	713055	713238	MAG: Desulfovibrionaceae bacterium isolate 1e2121d5-5174-4668-bae3-9852897706ae genome assembly, chromosome: 1	blastn	26707	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
9051857	9051857	PRJEB58983_P_NODE_10968_length_379_cov_2.395425_g10553_i0	PRJEB58983	10968	379	2.395425	9.07866075	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	385	3.14e-102	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g10553	i0	85.224	207.018469656992	379	50	99	6	3	379	2609394	2609768	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	78460	385	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
9051974	9051974	PRJEB58983_P_NODE_16628_length_315_cov_1.190083_g16213_i0	PRJEB58983	16628	315	1.190083	3.74876145	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	257	5.8200000000000005e-64	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g16213	i0	85.433	112.946031746032	254	29	79	6	4	251	2609607	2609356	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	35578	257	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
12878607	12878607	PRJEB58983_P_NODE_28171_length_252_cov_1.681564_g27756_i0	PRJEB58983	28171	252	1.681564	4.23754128	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	138	3.55e-38	NR	RMF17518.1	2080303	g27756	i0	77.1	7.80952380952381	83	18	98.8	1	252	4	104	185	RMF17518.1 MAG: adenosylhomocysteinase, partial [Candidatus Dadabacteria bacterium]	diamond	1968	138	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
14153599	14153599	PRJEB58983_P_NODE_6572_length_481_cov_2.549020_g6158_i0	PRJEB58983	6572	481	2.54902	12.2607862	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	224	9.379999999999999e-54	NTclustered	gi\|2621713419\|emb\|OY771474.1\|	201089	g6158	i0	76.008	132.047817047817	471	91	96	17	1	459	1758350	1758810	MAG: uncultured Desulfobacterium sp. isolate 2c08e38e-77a0-468a-b8ca-c683eacf49f2 genome assembly, chromosome: 1	blastn	63515	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
21394201	21394201	PRJEB58983_P_NODE_29677_length_248_cov_1.954286_g29262_i0	PRJEB58983	29677	248	1.954286	4.84662928	Geotalea	2910589	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|221562406\|gb\|CP001390.1\|	316067	g29262	i0	90.498	171.733870967742	221	21	89	0	28	248	2115197	2114977	Geobacter daltonii FRC-32, complete genome	blastn	42590	292	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea daltonii
21801628	21801628	PRJEB58983_P_NODE_23618_length_271_cov_3.040404_g23203_i0	PRJEB58983	23618	271	3.040404	8.23949484	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	189	1.8199999999999998e-43	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g23203	i0	87.349	120.516605166052	166	20	61	1	96	261	1711957	1711793	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	32660	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
21801742	21801742	PRJEB58983_P_NODE_28458_length_251_cov_2.157303_g28043_i0	PRJEB58983	28458	251	2.157303	5.41483053	uncultured Desulfuromonas sp.	181013	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|2621704006\|emb\|OY762961.1\|	181013	g28043	i0	82.796	2.14741035856574	186	24	73	7	5	186	318391	318572	MAG: uncultured Desulfuromonas sp. isolate cad01da2-5f99-43ef-8b90-e7e0a75d6a39 genome assembly, chromosome: 1	blastn	539	159	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	uncultured Desulfuromonas sp.
21801880	21801880	PRJEB58983_P_NODE_35498_length_202_cov_4.821705_g35083_i0	PRJEB58983	35498	202	4.821705	9.7398441	Desulfosarcina alkanivorans	571177	Bacteria	Bacteria	176	1e-39	NTclustered	gi\|1773409569\|dbj\|AP021874.1\|	571177	g35083	i0	86.228	97.1831683168317	167	17	81	5	1	164	2620235	2620398	Desulfosarcina alkanivorans PL12 DNA, complete genome	blastn	19631	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina alkanivorans
28006216	28006216	PRJEB58983_P_NODE_25345_length_263_cov_2.557895_g24930_i0	PRJEB58983	25345	263	2.557895	6.72726385	Pseudomonadati	3379134	Bacteria	Bacteria	78.2	9.31e-15	NR	WP_028573666.1	53245	g24930	i0	95	7.75665399239544	40	2	45.6	0	144	263	1	40	WP_028573666.1 UDP-N-acetylglucosamine 4,6-dehydratase (inverting) [Desulfonatronovibrio hydrogenovorans]	diamond	2040	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae	Desulfonatronovibrio	Desulfonatronovibrio hydrogenovorans
28896709	28896709	PRJEB58983_P_NODE_10288_length_390_cov_2.082019_g9873_i0	PRJEB58983	10288	390	2.082019	8.1198741	Geomonas fuzhouensis	2847989	Bacteria	Bacteria	168	5.999999999999999e-49	NR	WP_224957445.1	2873701	g9873	i0	62	3.92307692307692	129	49	99.2	0	4	390	90	218	WP_224957445.1 branched-chain amino acid transaminase [Geomonas fuzhouensis]	diamond	1530	168	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas fuzhouensis
29048070	29048070	PRJEB58983_P_NODE_23988_length_270_cov_0.923858_g23573_i0	PRJEB58983	23988	270	0.923858	2.4944166	Desulfovibrio	872	Bacteria	Bacteria	75.9	1.79e-14	NR	NMC49336.1	885	g23573	i0	54.1	3.38888888888889	61	28	67.8	0	80	262	1	61	NMC49336.1 nickel pincer cofactor biosynthesis protein LarB [Desulfovibrio sp.]	diamond	915	76.3	0.99475753604194	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
31170789	31170789	PRJEB58983_P_NODE_14335_length_336_cov_1.942966_g13920_i0	PRJEB58983	14335	336	1.942966	6.52836576	Syntrophales bacterium	2928017	Bacteria	Bacteria	182	1.52e-51	NR	MCU0530745.1	2928017	g13920	i0	82.9	1.98214285714286	111	18	98.2	1	334	5	78	188	MCU0530745.1 S8 family peptidase [Syntrophales bacterium]	diamond	666	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
31613796	31613796	PRJEB58983_P_NODE_27856_length_253_cov_1.316667_g27441_i0	PRJEB58983	27856	253	1.316667	3.33116751	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	83.6	9.85e-17	NR	MEW6657415.1	2202153	g27441	i0	58.1	1.75494071146245	74	21	86.6	3	34	252	13	77	MEW6657415.1 toprim domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	444	83.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31961718	31961718	PRJEB58983_P_NODE_4178_length_598_cov_6.356190_g3770_i0	PRJEB58983	4178	598	6.35619	38.0100162	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	155	2.9e-45	NR	MCL1962067.1	2049043	g3770	i0	78.8	0.978260869565217	99	21	49.7	0	356	60	6	104	MCL1962067.1 putative addiction module antidote protein [Desulfovibrionaceae bacterium]	diamond	585	155	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
32751883	32751883	PRJEB58983_P_NODE_1180_length_1182_cov_2.399459_g912_i0	PRJEB58983	1180	1182	2.399459	28.36160538	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	68.9	6.64e-9	NR	MFO7686422.1	2044940	g912	i0	26	0.682741116751269	269	186	67.5	7	357	1154	23	281	MFO7686422.1 hypothetical protein [Desulfobacterales bacterium]	diamond	807	68.9	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);;