metadata: contig_metadata: 12 rows where bioproject = "PRJNA1248424" and tax

12 rows where bioproject = "PRJNA1248424" 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
6730877	6730877	PRJNA1248424_P_NODE_66566_length_257_cov_5.385870_g60497_i0	PRJNA1248424	66566	257	5.38587	13.8416859	Bilophila	35832	Bacteria	Bacteria	146	4.81e-41	NR	WP_287546352.1	35832	g60497	i0	96.5	0.992217898832685	85	3	99.2	0	3	257	71	155	WP_287546352.1 MULTISPECIES: branched-chain amino acid ABC transporter permease [Bilophila]	diamond	255	146	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila
19479278	19479278	PRJNA1248424_P_NODE_71796_length_249_cov_0.875000_g65727_i0	PRJNA1248424	71796	249	0.875	2.17875	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	161	3.59e-35	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g65727	i0	81.771	13.3052208835341	192	35	77	0	1	192	65486	65677	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	3313	161	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
24579187	24579187	PRJNA1248424_P_NODE_51900_length_299_cov_2.871681_g45832_i0	PRJNA1248424	51900	299	2.871681	8.58632619	Taurinivorans muris	2787751	Bacteria	Bacteria	267	9.12e-67	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g45832	i0	98.667	1.00334448160535	150	2	100	0	150	299	1731439	1731588	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	300	267	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
27421517	27421517	PRJNA1248424_P_NODE_8963_length_1901_cov_3.346280_g6330_i0	PRJNA1248424	8963	1901	3.34628	63.6127828	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	52.4	9.4e-5	NR	MFO7876311.1	2821143	g6330	i0	96	0.0394529195160442	25	1	3.9	0	1299	1373	24	48	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	75	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
27547537	27547537	PRJNA1248424_P_NODE_47604_length_322_cov_2.634538_g41537_i0	PRJNA1248424	47604	322	2.634538	8.48321236	Bilophila wadsworthia	35833	Bacteria	Bacteria	100	2.96e-25	NR	MFR7889681.1	35833	g41537	i0	100	2.28260869565217	49	0	45.7	0	149	3	5	53	MFR7889681.1 HD-GYP domain-containing protein [Bilophila wadsworthia]	diamond	735	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27610789	27610789	PRJNA1248424_P_NODE_38524_length_387_cov_1.993631_g32465_i0	PRJNA1248424	38524	387	1.993631	7.71535197	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	44.7	0.00346	NR	MFO7876311.1	2821143	g32465	i0	77.8	0.209302325581395	27	6	20.9	0	286	206	24	50	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	81	44.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
28021350	28021350	PRJNA1248424_P_NODE_80785_length_239_cov_2.204819_g74716_i0	PRJNA1248424	80785	239	2.204819	5.26951741	Desulfobacteraceae bacterium IS3	1934248	Bacteria	Bacteria	41.6	0.0143	NR	OQX21802.1	1934248	g74716	i0	42.2	0.564853556485356	45	26	56.5	0	82	216	2	46	OQX21802.1 MAG: hypothetical protein BWK80_32210 [Desulfobacteraceae bacterium IS3]	diamond	135	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium IS3
28273630	28273630	PRJNA1248424_P_NODE_65386_length_261_cov_1.180851_g59317_i0	PRJNA1248424	65386	261	1.180851	3.08202111	Desulfocapsa sp.	2066021	Bacteria	Bacteria	53.5	7.47e-6	NR	RUM41879.1	2066021	g59317	i0	36.4	3.82758620689655	88	53	98.9	2	1	258	470	556	RUM41879.1 MAG: hypothetical protein DSY80_08180 [Desulfocapsa sp.]	diamond	999	53.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sp.
28684397	28684397	PRJNA1248424_P_NODE_65427_length_261_cov_0.978723_g59358_i0	PRJNA1248424	65427	261	0.978723	2.55446703	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	43.5	0.0249	NR	MBQ7608481.1	2049043	g59358	i0	34.4	0.735632183908046	64	42	73.6	0	235	44	167	230	MBQ7608481.1 isoleucine--tRNA ligase [Desulfovibrionaceae bacterium]	diamond	192	43.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
29757617	29757617	PRJNA1248424_P_NODE_75611_length_245_cov_0.895349_g69542_i0	PRJNA1248424	75611	245	0.895349	2.19360505	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	43.5	0.0207	NR	MDD3952243.1	2044940	g69542	i0	41.4	0.710204081632653	58	33	69.8	1	215	45	37	94	MDD3952243.1 type I restriction endonuclease [Desulfobacterales bacterium]	diamond	174	43.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30421524	30421524	PRJNA1248424_P_NODE_31173_length_489_cov_1.182692_g25130_i0	PRJNA1248424	31173	489	1.182692	5.78336388	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	50.1	6.26e-5	NR	MFO7876311.1	2821143	g25130	i0	64.3	0.257668711656442	42	11	25.8	1	193	68	24	61	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	126	50.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
31812041	31812041	PRJNA1248424_P_NODE_57737_length_281_cov_1.850962_g51669_i0	PRJNA1248424	57737	281	1.850962	5.20120322	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	52	1.84e-6	NR	MFO7876311.1	2821143	g51669	i0	96	0.266903914590747	25	1	26.7	0	160	86	24	48	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	75	52	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.

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