metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
936346	936346	PRJNA951810_P_NODE_162941_length_247_cov_12.051724_g162596_i0	PRJNA951810	162941	247	12.051724	29.76775828	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	154	5.95e-33	NTclustered	gi\|2893358418\|emb\|OZ220710.1\|	2202153	g162596	i0	80.769	2.61133603238866	208	30	82	9	8	210	3440437	3440639	MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1	blastn	645	154	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
937393	937393	PRJNA951810_P_NODE_44241_length_310_cov_7.742616_g43898_i0	PRJNA951810	44241	310	7.742616	24.0021096	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g43898	i0	94.444	0.703225806451613	36	2	12	0	228	263	1295476	1295511	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	218	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
1263354	1263354	PRJNA951810_P_NODE_17881_length_466_cov_3.539440_g17546_i0	PRJNA951810	17881	466	3.53944	16.4937904	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	2.08e-10	NTclustered	gi\|2108238081\|gb\|CP070694.1\|	2044940	g17546	i0	85.714	190.109442060086	77	9	32	1	85	159	4817908	4817984	MAG: Desulfobacterales bacterium isolate bin60 chromosome	blastn	88591	80.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
3814917	3814917	PRJNA951810_P_NODE_101383_length_292_cov_3.543379_g101039_i0	PRJNA951810	101383	292	3.543379	10.34666668	Pseudomonadati	3379134	Bacteria	Bacteria	141	5.61e-29	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g101039	i0	90.566	29.1301369863014	106	10	36	0	185	290	2138041	2138146	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	8506	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
10192718	10192718	PRJNA951810_P_NODE_54288_length_310_cov_4.561181_g53945_i0	PRJNA951810	54288	310	4.561181	14.1396611	Geomonas	2651583	Bacteria	Bacteria	147	1.29e-30	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g53945	i0	85.612	36.3709677419355	139	20	45	0	8	146	4286937	4286799	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	11275	148	0.993243243243243	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
11139112	11139112	PRJNA951810_P_NODE_107449_length_288_cov_5.530233_g107105_i0	PRJNA951810	107449	288	5.530233	15.92707104	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	172	1.96e-38	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g107105	i0	85.455	41.1979166666667	165	24	57	0	15	179	1868583	1868747	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	11865	172	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
16565841	16565841	PRJNA951810_P_NODE_15813_length_489_cov_0.983173_g15480_i0	PRJNA951810	15813	489	0.983173	4.80771597	Desulfurivibrio	427922	Bacteria	Bacteria	302	4.29e-77	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g15480	i0	78.427	115.359918200409	496	83	100	18	1	489	742	264	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	56411	302	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
17515253	17515253	PRJNA951810_P_NODE_29314_length_371_cov_1.271812_g28972_i0	PRJNA951810	29314	371	1.271812	4.71842252	Pelobacter propionicus	29543	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g28972	i0	92.308	0.105121293800539	39	2	10	1	20	57	3443467	3443505	Pelobacter propionicus DSM 2379, complete genome	blastn	39	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
18788357	18788357	PRJNA951810_P_NODE_174055_length_238_cov_8.115152_g173710_i0	PRJNA951810	174055	238	8.115152	19.31406176	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	65.8	2.75e-6	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g173710	i0	90	1.85714285714286	50	5	21	0	151	200	2798827	2798778	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	442	65.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
18789976	18789976	PRJNA951810_P_NODE_89455_length_297_cov_8.870536_g89111_i0	PRJNA951810	89455	297	8.870536	26.34549192	Geobacter sulfurreducens	35554	Bacteria	Bacteria	99	3.49e-16	NTclustered	gi\|1373812086\|dbj\|AP017912.1\|	35554	g89111	i0	96.61	18.9023569023569	59	2	20	0	181	239	2797432	2797490	Geobacter sulfurreducens DNA, complete genome	blastn	5614	99	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
18790000	18790000	PRJNA951810_P_NODE_90755_length_297_cov_3.794643_g90411_i0	PRJNA951810	90755	297	3.794643	11.27008971	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	198	3.3499999999999997e-46	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g90411	i0	80.147	105.585858585859	272	48	91	4	28	296	2270965	2271233	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	31359	198	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
20064475	20064475	PRJNA951810_P_NODE_64876_length_310_cov_2.860759_g64533_i0	PRJNA951810	64876	310	2.860759	8.8683529	Desulfoglaeba alkanexedens	361111	Bacteria	Bacteria	91.6	6.14e-14	NTclustered	gi\|1649181537\|gb\|CP040098.1\|	980445	g64533	i0	79.699	0.429032258064516	133	21	42	4	1	130	1418395	1418524	Desulfoglaeba alkanexedens ALDC chromosome, complete genome	blastn	133	91.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulfoglaeba	Desulfoglaeba alkanexedens
20389439	20389439	PRJNA951810_P_NODE_137096_length_268_cov_1.800000_g136751_i0	PRJNA951810	137096	268	1.8	4.824	Thermodesulfobacteriota	200940	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1208596715\|gb\|MF361871.1\|	885	g136751	i0	100	105.608208955224	268	0	100	0	1	268	20	287	Desulfovibrio sp. strain T2.22MG-35 16S ribosomal RNA gene, partial sequence	blastn	28303	496	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
21337780	21337780	PRJNA951810_P_NODE_12177_length_545_cov_4.904661_g11852_i0	PRJNA951810	12177	545	4.904661	26.73040245	Pelobacter propionicus	29543	Bacteria	Bacteria	215	6.46e-51	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g11852	i0	77.368	3.36697247706422	380	74	69	7	170	543	2564081	2564454	Pelobacter propionicus DSM 2379, complete genome	blastn	1835	215	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
21340265	21340265	PRJNA951810_P_NODE_88537_length_298_cov_3.195556_g88193_i0	PRJNA951810	88537	298	3.195556	9.52275688	uncultured Desulfobacter sp.	240139	Bacteria	Bacteria	134	9.61e-27	NTclustered	gi\|2621703974\|emb\|OY762929.1\|	240139	g88193	i0	81.818	12.0536912751678	165	24	55	6	130	292	4266162	4266002	MAG: uncultured Desulfobacter sp. isolate ab583996-6c72-41ec-a8bc-7a43732d896d genome assembly, chromosome: 1	blastn	3592	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	uncultured Desulfobacter sp.
23889279	23889279	PRJNA951810_P_NODE_193119_length_208_cov_11.696296_g192774_i0	PRJNA951810	193119	208	11.696296	24.32829568	Desulfobulbus oralis	1986146	Bacteria	Bacteria	193	1.03e-44	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g192774	i0	84.158	1.97115384615385	202	28	96	4	2	201	1421413	1421612	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	410	193	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis
25161718	25161718	PRJNA951810_P_NODE_117040_length_282_cov_2.760766_g116696_i0	PRJNA951810	117040	282	2.760766	7.78536012	Desulfobulbus oralis	1986146	Bacteria	Bacteria	510	3.57e-140	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g116696	i0	99.291	55.6950354609929	282	2	100	0	1	282	904493	904774	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	15706	510	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis

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