metadata: contig_metadata: 10 rows where bioproject = "PRJNA906294", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA906294", 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
888143	888143	PRJNA906294_P_NODE_223741_length_243_cov_1.600000_g219625_i0	PRJNA906294	223741	243	1.6	3.888	Thermosulfurimonas marina	2047767	Bacteria	Bacteria	183	7.44e-42	NTclustered	gi\|1831559056\|gb\|CP042909.1\|	2047767	g219625	i0	80.591	15.0946502057613	237	46	98	0	3	239	484038	483802	Thermosulfurimonas marina strain SU872 chromosome, complete genome	blastn	3668	183	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermosulfurimonas	Thermosulfurimonas marina
3438870	3438870	PRJNA906294_P_NODE_22283_length_1227_cov_7.052860_g19515_i0	PRJNA906294	22283	1227	7.05286	86.5385922	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	215	1.51e-50	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g19515	i0	85.167	5.08068459657702	209	31	17	0	219	427	22924	23132	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	6234	215	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
22566579	22566579	PRJNA906294_P_NODE_73638_length_525_cov_2.287611_g69533_i0	PRJNA906294	73638	525	2.287611	12.00995775	uncultured Desulfobacter sp.	240139	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|2814788332\|emb\|OY762228.2\|	240139	g69533	i0	100	0.0552380952380952	29	0	6	0	280	308	604126	604154	MAG: uncultured Desulfobacter sp. isolate cd87f30c-30a5-471b-81aa-180dc00a34f5 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	uncultured Desulfobacter sp.
26802685	26802685	PRJNA906294_P_NODE_191221_length_264_cov_1.340314_g187105_i0	PRJNA906294	191221	264	1.340314	3.53842896	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	43.1	0.035	NR	HHL34124.1	2053307	g187105	i0	35.7	0.636363636363636	56	36	63.6	0	18	185	545	600	HHL34124.1 response regulator [Desulfobulbaceae bacterium]	diamond	168	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
26866358	26866358	PRJNA906294_P_NODE_163841_length_293_cov_2.236364_g159725_i0	PRJNA906294	163841	293	2.236364	6.55254652	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	78.2	7.37e-16	NR	MDX1707214.1	2044940	g159725	i0	50	4.3617747440273	82	39	84	2	249	4	42	121	MDX1707214.1 Hsp20/alpha crystallin family protein [Desulfobacterales bacterium]	diamond	1278	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28161541	28161541	PRJNA906294_P_NODE_121805_length_359_cov_4.230769_g117689_i0	PRJNA906294	121805	359	4.230769	15.18846071	Smithellaceae bacterium	2964540	Bacteria	Bacteria	58.2	4.83e-7	NR	HPD56940.1	2964540	g117689	i0	41	1.38718662952646	83	36	69.4	3	250	2	239	308	HPD56940.1 RHS repeat-associated core domain-containing protein [Smithellaceae bacterium]	diamond	498	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
28168906	28168906	PRJNA906294_P_NODE_51805_length_686_cov_2.381729_g47811_i0	PRJNA906294	51805	686	2.381729	16.33866094	Pseudomonadati	3379134	Bacteria	Bacteria	205	5.4e-63	NR	HEY9161896.1	3041274	g47811	i0	60.5	5.37026239067055	172	68	75.2	0	666	151	30	201	HEY9161896.1 NAD(P)H:quinone oxidoreductase [Desulfomonilia bacterium]	diamond	3684	207	0.990338164251208	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia				Desulfomonilia bacterium
28508767	28508767	PRJNA906294_P_NODE_50867_length_695_cov_4.654341_g46888_i0	PRJNA906294	50867	695	4.654341	32.34766995	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	149	2.49e-40	NR	MCP4692921.1	2044940	g46888	i0	39.5	4.5021582733813	223	125	93.2	4	674	27	30	249	MCP4692921.1 DUF4197 domain-containing protein [Desulfobacterales bacterium]	diamond	3129	149	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
31762624	31762624	PRJNA906294_P_NODE_120457_length_362_cov_1.937716_g116342_i0	PRJNA906294	120457	362	1.937716	7.01453192	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.9	0.0483	NR	HMK65614.1	2202153	g116342	i0	35.4	0.538674033149171	65	42	53.9	0	35	229	46	110	HMK65614.1 CoA-transferase [Thermodesulfobacteriota bacterium]	diamond	195	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32371530	32371530	PRJNA906294_P_NODE_210779_length_248_cov_0.868571_g206663_i0	PRJNA906294	210779	248	0.868571	2.15405608	Desulfobacteria	3024418	Bacteria	Bacteria	119	3e-29	NR	MDH3567976.1	2049433	g206663	i0	68.9	17.1895161290323	74	23	89.5	0	227	6	381	454	MDH3567976.1 acyl-CoA synthetase [Desulfobacteraceae bacterium]	diamond	4263	120	0.991666666666667	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae 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);;