metadata: contig_metadata: 7 rows where bioproject = "PRJNA541476" and tax

7 rows where bioproject = "PRJNA541476" 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
15812024	15812024	PRJNA541476_P_NODE_4533_length_537_cov_2.295259_g4334_i0	PRJNA541476	4533	537	2.295259	12.32554083	Pseudomonadati	3379134	Bacteria	Bacteria	166	1.8e-44	NR	PLX72999.1	892	g4334	i0	53.1	11.9720670391061	179	65	99.4	6	2	535	399	559	PLX72999.1 MAG: SAM-dependent methyltransferase [Desulfuromonas sp.]	diamond	6429	167	0.994011976047904	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp.
27250737	27250737	PRJNA541476_P_NODE_18243_length_290_cov_1.926267_g18037_i0	PRJNA541476	18243	290	1.926267	5.5861743	Pseudomonadati	3379134	Bacteria	Bacteria	95.9	1.25e-20	NR	WP_020589162.1	2290	g18037	i0	48.5	4.01379310344828	97	48	98.3	2	287	3	322	418	WP_020589162.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Desulfobacter curvatus]	diamond	1164	96.7	0.991726990692865	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter curvatus
30140671	30140671	PRJNA541476_P_NODE_9372_length_371_cov_3.382550_g9166_i0	PRJNA541476	9372	371	3.38255	12.5492605	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	96.7	2.01e-20	NR	WP_015947357.1	218208	g9166	i0	42.6	4.35849056603774	115	57	89.8	4	334	2	491	600	WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans]	diamond	1617	96.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
30535034	30535034	PRJNA541476_P_NODE_8833_length_382_cov_1.058252_g8629_i0	PRJNA541476	8833	382	1.058252	4.04252264	Pseudomonadati	3379134	Bacteria	Bacteria	133	2.81e-33	NR	WP_200802460.1	231440	g8629	i0	55.1	12.9031413612565	127	57	99.7	0	2	382	664	790	WP_200802460.1 cation-transporting P-type ATPase [Desulfopila aestuarii]	diamond	4929	133	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila aestuarii
30836158	30836158	PRJNA541476_P_NODE_27214_length_255_cov_3.340659_g27008_i0	PRJNA541476	27214	255	3.340659	8.51868045	Desulfofustis sp. PB-SRB1	1385624	Bacteria	Bacteria	82	2.87e-16	NR	MBL0381487.1	1385624	g27008	i0	67.7	1.58823529411765	65	20	76.5	1	18	212	222	285	MBL0381487.1 malate dehydrogenase [Desulfofustis sp. PB-SRB1]	diamond	405	82	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfofustis	Desulfofustis sp. PB-SRB1
31405254	31405254	PRJNA541476_P_NODE_32156_length_249_cov_0.875000_g31950_i0	PRJNA541476	32156	249	0.875	2.17875	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	60.1	3.11e-8	NR	MEF8824479.1	2683721	g31950	i0	87.5	0.385542168674699	32	4	38.6	0	96	1	170	201	MEF8824479.1 aminopeptidase [Desulfohalobiaceae bacterium]	diamond	96	60.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
31531778	31531778	PRJNA541476_P_NODE_35336_length_246_cov_0.895954_g35130_i0	PRJNA541476	35336	246	0.895954	2.20404684	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	158	3.19e-44	NR	MCF8085868.1	2683721	g35130	i0	91.5	1	82	7	100	0	1	246	116	197	MCF8085868.1 YeiH family protein [Desulfohalobiaceae bacterium]	diamond	246	158	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae 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);;