metadata: contig_metadata: 16 rows where bioproject = "PRJNA631119", tax_phylum = "Thermodesulfobacteriota" and tax

16 rows where bioproject = "PRJNA631119", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
2427173	2427173	PRJNA631119_P_NODE_34882_length_246_cov_0.890173_g34764_i0	PRJNA631119	34882	246	0.890173	2.18982558	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	73.9	2.76e-13	NR	MDK2955366.1	2448050	g34764	i0	57.1	2.64634146341463	70	28	84.1	2	232	26	190	258	MDK2955366.1 hypothetical protein [Desulfovibrionales bacterium]	diamond	651	73.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
4430836	4430836	PRJNA631119_P_NODE_10084_length_381_cov_2.698052_g9966_i0	PRJNA631119	10084	381	2.698052	10.27957812	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	176	2.6599999999999995e-54	NR	GJM17744.1	2202153	g9966	i0	72.6	0.921259842519685	117	32	92.1	0	377	27	11	127	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	351	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
9531757	9531757	PRJNA631119_P_NODE_32068_length_250_cov_0.870056_g31950_i0	PRJNA631119	32068	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	147	1.07e-39	NR	RUM37702.1	895	g31950	i0	83.1	58.284	83	14	99.6	0	250	2	161	243	RUM37702.1 MAG: energy-dependent translational throttle protein EttA [Desulfobulbus sp.]	diamond	14571	147	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp.
13357489	13357489	PRJNA631119_P_NODE_38991_length_241_cov_1.375000_g38873_i0	PRJNA631119	38991	241	1.375	3.31375	Pseudomonadati	3379134	Bacteria	Bacteria	120	2.25e-29	NR	WP_092054686.1	38815	g38873	i0	73.4	30.4979253112033	79	21	98.3	0	4	240	318	396	WP_092054686.1 pyruvate, phosphate dikinase [Desulfuromonas acetexigens]	diamond	7350	121	0.991735537190083	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Trichloromonadaceae	Trichloromonas	Trichloromonas acetexigens
22280337	22280337	PRJNA631119_P_NODE_28978_length_257_cov_1.673913_g28860_i0	PRJNA631119	28978	257	1.673913	4.30195641	Geotalea uraniireducens	351604	Bacteria	Bacteria	62.1	3.88e-5	NTclustered	gi\|146395585\|gb\|CP000698.1\|	351605	g28860	i0	88.679	4.76653696498054	53	3	21	3	1	53	625688	625737	Geobacter uraniireducens Rf4, complete genome	blastn	1225	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
26732342	26732342	PRJNA631119_P_NODE_37201_length_243_cov_1.711765_g37083_i0	PRJNA631119	37201	243	1.711765	4.15958895	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	70.9	4.23e-12	NR	MBN2141429.1	2049043	g37083	i0	62	0.617283950617284	50	19	61.7	0	154	5	30	79	MBN2141429.1 tyrosine--tRNA ligase [Desulfovibrionaceae bacterium]	diamond	150	70.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
27397096	27397096	PRJNA631119_P_NODE_21143_length_291_cov_1.408257_g21025_i0	PRJNA631119	21143	291	1.408257	4.09802787	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	58.2	2.61e-7	NR	RJP86588.1	2049433	g21025	i0	32.6	0.979381443298969	95	64	97.9	0	2	286	789	883	RJP86588.1 MAG: DUF11 domain-containing protein [Desulfobacteraceae bacterium]	diamond	285	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
27838829	27838829	PRJNA631119_P_NODE_36004_length_245_cov_0.895349_g35886_i0	PRJNA631119	36004	245	0.895349	2.19360505	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	58.9	7.84e-8	NR	MCP4349289.1	2044940	g35886	i0	43.1	0.881632653061225	72	41	88.2	0	217	2	5960	6031	MCP4349289.1 DUF4114 domain-containing protein [Desulfobacterales bacterium]	diamond	216	58.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29543832	29543832	PRJNA631119_P_NODE_15310_length_327_cov_2.129921_g15192_i0	PRJNA631119	15310	327	2.129921	6.96484167	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	92.4	3.74e-19	NR	MFQ6077535.1	2202153	g15192	i0	47.2	6.80733944954128	106	53	96.3	2	323	9	608	711	MFQ6077535.1 carboxypeptidase regulatory-like domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	2226	92.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29954561	29954561	PRJNA631119_P_NODE_39211_length_241_cov_0.916667_g39093_i0	PRJNA631119	39211	241	0.916667	2.20916747	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	114	2.42e-28	NR	RME57315.1	2080303	g39093	i0	72.3	1.03319502074689	83	20	99.6	1	240	1	162	244	RME57315.1 MAG: guanosine monophosphate reductase [Candidatus Dadabacteria bacterium]	diamond	249	114	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
30124819	30124819	PRJNA631119_P_NODE_21112_length_291_cov_1.412844_g20994_i0	PRJNA631119	21112	291	1.412844	4.11137604	Pseudomonadati	3379134	Bacteria	Bacteria	105	2.32e-24	NR	HHI97186.1	501497	g20994	i0	54.7	16.5051546391753	95	42	97.9	1	287	3	68	161	HHI97186.1 phosphoglycerate kinase [Thermodesulfatator atlanticus]	diamond	4803	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator atlanticus
30270703	30270703	PRJNA631119_P_NODE_1352_length_888_cov_1.573006_g1257_i0	PRJNA631119	1352	888	1.573006	13.96829328	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	156	6.77e-39	NR	RME61294.1	2080303	g1257	i0	36.8	6.59121621621622	272	142	91.9	4	23	838	488	729	RME61294.1 MAG: translation initiation factor IF-2 [Candidatus Dadabacteria bacterium]	diamond	5853	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
30965742	30965742	PRJNA631119_P_NODE_25774_length_270_cov_1.512690_g25656_i0	PRJNA631119	25774	270	1.51269	4.084263	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	61.6	6.05e-9	NR	MDD4197554.1	2660714	g25656	i0	50.9	0.611111111111111	55	27	61.1	0	246	82	148	202	MDD4197554.1 ankyrin repeat domain-containing protein [Syntrophorhabdaceae bacterium]	diamond	165	61.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
31724291	31724291	PRJNA631119_P_NODE_11397_length_364_cov_2.487973_g11279_i0	PRJNA631119	11397	364	2.487973	9.05622172	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	97.4	1e-20	NR	WP_015947357.1	218208	g11279	i0	42.4	3.59340659340659	118	59	94	4	13	354	488	600	WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans]	diamond	1308	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
32021731	32021731	PRJNA631119_P_NODE_5618_length_482_cov_4.012225_g5500_i0	PRJNA631119	5618	482	4.012225	19.3389245	Pseudomonadati	3379134	Bacteria	Bacteria	86.7	1.15e-17	NR	KRT63853.1	1640508	g5500	i0	36.2	3.37966804979253	149	88	92.1	4	32	475	19	161	KRT63853.1 MAG: hypothetical protein XU11_C0060G0007 [Candidatus Dadabacteria bacterium CSP1-2]	diamond	1629	86.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium CSP1-2
32230823	32230823	PRJNA631119_P_NODE_29518_length_255_cov_2.076923_g29400_i0	PRJNA631119	29518	255	2.076923	5.29615365	Desulfobacteraceae bacterium 4572_88	1972444	Bacteria	Bacteria	91.3	3.62e-19	NR	OQY57789.1	1972444	g29400	i0	51.2	3.75294117647059	86	35	92.9	2	238	2	145	230	OQY57789.1 MAG: hypothetical protein B6245_15245 [Desulfobacteraceae bacterium 4572_88]	diamond	957	91.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium 4572_88

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