metadata: contig_metadata: 14 rows where bioproject = "PRJNA689790", tax_phylum = "Thermodesulfobacteriota" and tax

14 rows where bioproject = "PRJNA689790", 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
2453424	2453424	PRJNA689790_S_NODE_5462_length_257_cov_1.640909_g5347_i0	PRJNA689790	5462	257	1.640909	4.21713613	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	122	8.929999999999999e-31	NR	MBQ4133169.1	2049043	g5347	i0	68.2	16.7509727626459	85	27	99.2	0	3	257	50	134	MBQ4133169.1 F0F1 ATP synthase subunit beta [Desulfovibrionaceae bacterium]	diamond	4305	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
6282131	6282131	PRJNA689790_S_NODE_4605_length_283_cov_1.247967_g4490_i0	PRJNA689790	4605	283	1.247967	3.53174661	Lawsonia	41707	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g4490	i0	97.88	239.339222614841	283	6	100	0	1	283	655510	655228	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	67733	490	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
12148073	12148073	PRJNA689790_S_NODE_6730_length_229_cov_1.984375_g6615_i0	PRJNA689790	6730	229	1.984375	4.54421875	Desulfuromonadia	3031651	Bacteria	Bacteria	129	5.09e-33	NR	WP_088535434.1	1277350	g6615	i0	73.3	2.94759825327511	75	20	98.3	0	3	227	495	569	WP_088535434.1 phosphoenolpyruvate carboxykinase (GTP) [Geobacter sp. DSM 9736]	diamond	675	129	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. DSM 9736
21071199	21071199	PRJNA689790_S_NODE_8757_length_199_cov_4.919753_g8642_i0	PRJNA689790	8757	199	4.919753	9.79030847	Desulfobaccales bacterium	3064668	Bacteria	Bacteria	99	3e-22	NR	HEY9072800.1	3064668	g8642	i0	72.7	12.9346733668342	66	15	99.5	2	199	2	425	487	HEY9072800.1 hydroxylamine reductase [Desulfobaccales bacterium]	diamond	2574	99	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales			Desulfobaccales bacterium
24130032	24130032	PRJNA689790_S_NODE_14059_length_161_cov_1.556452_g13944_i0	PRJNA689790	14059	161	1.556452	2.50588772	Lawsonia	41707	Bacteria	Bacteria	261	2.04e-65	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g13944	i0	97.386	254.341614906832	153	4	99	0	1	153	653761	653913	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	40949	261	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
28104372	28104372	PRJNA689790_S_NODE_7485_length_216_cov_1.743017_g7370_i0	PRJNA689790	7485	216	1.743017	3.76491672	root	1	Root_unresolved	Root_unresolved	57.4	1.76e-7	NR	OQY11608.1	1971626	g7370	i0	38	1.93055555555556	71	39	98.6	1	215	3	542	607	OQY11608.1 MAG: acyl CoA:acetate/3-ketoacid CoA transferase [Desulfobacteraceae bacterium 4572_19]	diamond	417	57.8	0.993079584775087	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium 4572_19
28345590	28345590	PRJNA689790_S_NODE_10166_length_186_cov_1.570470_g10051_i0	PRJNA689790	10166	186	1.57047	2.9210742	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	60.5	5.02e-9	NR	MEM7008123.1	2202153	g10051	i0	47.5	1.96774193548387	61	32	98.4	0	2	184	93	153	MEM7008123.1 SDR family NAD(P)-dependent oxidoreductase [Thermodesulfobacteriota bacterium]	diamond	366	60.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29009029	29009029	PRJNA689790_S_NODE_10628_length_182_cov_1.613793_g10513_i0	PRJNA689790	10628	182	1.613793	2.93710326	Lawsonia intracellularis	29546	Bacteria	Bacteria	41.6	0.0427	NR	WP_258524466.1	29546	g10513	i0	35.7	0.923076923076923	56	33	87.4	1	1	159	514	569	WP_258524466.1 autotransporter outer membrane beta-barrel domain-containing protein [Lawsonia intracellularis]	diamond	168	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
29146837	29146837	PRJNA689790_S_NODE_9529_length_192_cov_1.258065_g9414_i0	PRJNA689790	9529	192	1.258065	2.4154848	Thermodesulfobacteriales	188710	Bacteria	Bacteria	66.6	6.94e-11	NR	WP_068541528.1	1795632	g9414	i0	55.2	3.4375	58	26	90.6	0	3	176	307	364	WP_068541528.1 hydroxylamine reductase [Thermodesulfatator autotrophicus]	diamond	660	66.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator autotrophicus
29987613	29987613	PRJNA689790_S_NODE_6951_length_225_cov_1.648936_g6836_i0	PRJNA689790	6951	225	1.648936	3.710106	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	71.2	1.86e-12	NR	HIC92180.1	2052184	g6836	i0	44.4	0.96	72	40	96	0	2	217	209	280	HIC92180.1 hypothetical protein [Syntrophaceae bacterium]	diamond	216	71.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
30240356	30240356	PRJNA689790_S_NODE_4032_length_305_cov_2.182836_g3917_i0	PRJNA689790	4032	305	2.182836	6.6576498	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	137	2.39e-35	NR	RNC66030.1	2099678	g3917	i0	79.2	3.81639344262295	77	15	75.7	1	304	74	532	607	RNC66030.1 MAG: phosphoenolpyruvate carboxykinase (GTP) [Desulfuromonadales bacterium]	diamond	1164	137	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
30757379	30757379	PRJNA689790_S_NODE_8554_length_202_cov_1.739394_g8439_i0	PRJNA689790	8554	202	1.739394	3.51357588	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	95.9	3.77e-21	NR	MFO7750321.1	2049433	g8439	i0	66.7	5.88118811881188	66	22	98	0	200	3	358	423	MFO7750321.1 PfaD family polyunsaturated fatty acid/polyketide biosynthesis protein [Desulfobacteraceae bacterium]	diamond	1188	96.7	0.991726990692865	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31199230	31199230	PRJNA689790_S_NODE_13655_length_163_cov_1.238095_g13540_i0	PRJNA689790	13655	163	1.238095	2.01809485	Desulfovibrionaceae	194924	Bacteria	Bacteria	94.4	4.3e-23	NR	WP_011526943.1	29546	g13540	i0	86.8	1.95092024539877	53	7	97.5	0	3	161	17	69	WP_011526943.1 flagellar basal body rod protein FlgB [Lawsonia intracellularis]	diamond	318	94.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
32737669	32737669	PRJNA689790_S_NODE_15160_length_156_cov_1.966387_g15045_i0	PRJNA689790	15160	156	1.966387	3.06756372	Desulfosalsimonas propionicica	332175	Bacteria	Bacteria	58.5	2.95e-8	NR	WP_181551675.1	332175	g15045	i0	54.3	2.57692307692308	46	21	88.5	0	2	139	119	164	WP_181551675.1 hydroxylamine reductase [Desulfosalsimonas propionicica]	diamond	402	58.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosalsimonadaceae	Desulfosalsimonas	Desulfosalsimonas propionicica

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