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

10 rows where bioproject = "PRJNA674308", 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
4994859	4994859	PRJNA674308_P_NODE_29804_length_185_cov_1.147059_g29569_i0	PRJNA674308	29804	185	1.147059	2.12205915	Pseudomonadati	3379134	Bacteria	Bacteria	224	3.16e-54	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g29569	i0	88.649	131.935135135135	185	20	99	1	2	185	1712793	1712609	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	24408	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
8297900	8297900	PRJNA674308_P_NODE_11447_length_282_cov_1.918455_g11212_i0	PRJNA674308	11447	282	1.918455	5.4100431	Desulfarculia bacterium	3065862	Bacteria	Bacteria	291	5.06e-74	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g11212	i0	86.517	149.219858156028	267	33	95	3	16	282	335716	335453	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	42080	291	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
26923641	26923641	PRJNA674308_P_NODE_15982_length_242_cov_2.284974_g15747_i0	PRJNA674308	15982	242	2.284974	5.52963708	Geotalea uraniireducens	351604	Bacteria	Bacteria	42.7	0.0357	NR	WP_348835281.1	351604	g15747	i0	41.7	0.743801652892562	60	33	74.4	1	27	206	313	370	WP_348835281.1 30S ribosomal protein S1 [Geotalea uraniireducens]	diamond	180	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
27124938	27124938	PRJNA674308_P_NODE_48222_length_164_cov_0.904348_g47987_i0	PRJNA674308	48222	164	0.904348	1.48313072	Bacteria	2	Bacteria	Bacteria	54.3	1.06e-6	NR	PIP40895.1	1973983	g47987	i0	54.7	3.89634146341463	53	24	97	0	5	163	656	708	PIP40895.1 MAG: hypothetical protein COX19_04720, partial [Desulfobacterales bacterium CG23_combo_of_CG06-09_8_20_14_all_51_8]	diamond	639	54.7	0.992687385740402	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium CG23_combo_of_CG06-09_8_20_14_all_51_8
27207994	27207994	PRJNA674308_P_NODE_30182_length_184_cov_1.155556_g29947_i0	PRJNA674308	30182	184	1.155556	2.12622304	Candidatus Magnetomorum sp. HK-1	1509431	Bacteria	Bacteria	77	1.41e-14	NR	KPA11669.1	1509431	g29947	i0	60	1.95652173913043	60	21	97.8	1	180	1	423	479	KPA11669.1 FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetomorum sp. HK-1]	diamond	360	77	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
27334816	27334816	PRJNA674308_P_NODE_46183_length_165_cov_0.896552_g45948_i0	PRJNA674308	46183	165	0.896552	1.4793108	Desulfobacterales bacterium RIFOXYA12_FULL_46_15	1797914	Bacteria	Bacteria	54.3	9.69e-7	NR	OGR25613.1	1797914	g45948	i0	58.5	0.963636363636364	53	20	96.4	2	6	164	48	98	OGR25613.1 MAG: short-chain dehydrogenase [Desulfobacterales bacterium RIFOXYA12_FULL_46_15]	diamond	159	54.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium RIFOXYA12_FULL_46_15
28167639	28167639	PRJNA674308_P_NODE_32685_length_177_cov_1.531250_g32450_i0	PRJNA674308	32685	177	1.53125	2.7103125	Pseudomonadati	3379134	Bacteria	Bacteria	55.5	3.69e-7	NR	MBC2694805.1	2049433	g32450	i0	47.3	3.6271186440678	55	28	91.5	1	168	7	25	79	MBC2694805.1 5'-methylthioadenosine nucleosidase [Desulfobacteraceae bacterium]	diamond	642	55.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
28945262	28945262	PRJNA674308_P_NODE_42828_length_166_cov_0.888889_g42593_i0	PRJNA674308	42828	166	0.888889	1.47555574	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	116	6.57e-30	NR	NIP31130.1	2080303	g42593	i0	94.4	5.85542168674699	54	3	97.6	0	3	164	146	199	NIP31130.1 recombinase [Candidatus Dadabacteria bacterium]	diamond	972	116	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
30093492	30093492	PRJNA674308_P_NODE_552_length_1311_cov_2.203645_g462_i0	PRJNA674308	552	1311	2.203645	28.88978595	root	1	Root_unresolved	Root_unresolved	356	2.04e-114	NR	WP_020589162.1	2290	g462	i0	47	24.8810068649886	404	211	91.8	3	2	1204	127	530	WP_020589162.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Desulfobacter curvatus]	diamond	32619	358	0.994413407821229	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter curvatus
31420917	31420917	PRJNA674308_P_NODE_48436_length_164_cov_0.904348_g48201_i0	PRJNA674308	48436	164	0.904348	1.48313072	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	1.61e-4	NR	KPA13394.1	1509431	g48201	i0	62.9	4.99390243902439	35	13	64	0	106	2	2226	2260	KPA13394.1 Concanavalin A-like lectin/glucanase [Candidatus Magnetomorum sp. HK-1]	diamond	819	48.5	0.991752577319588	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1

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