metadata: contig_metadata: 15 rows where bioproject = "PRJNA1078753", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJNA1078753", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

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
12946236	12946236	PRJNA1078753_P_NODE_18431_length_285_cov_1.415094_g18235_i0	PRJNA1078753	18431	285	1.415094	4.0330179	Spirochaetia bacterium	2053615	Bacteria	Bacteria	75	5.62e-9	NTclustered	gi\|2621704936\|emb\|OY762223.1\|	2053615	g18235	i0	95.745	2.83157894736842	47	1	16	1	200	245	2660790	2660836	MAG: Spirochaetia bacterium isolate 4d292051-824f-4208-a070-72fe4d4211c9 genome assembly, chromosome: 1	blastn	807	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
16769675	16769675	PRJNA1078753_P_NODE_4894_length_474_cov_1.496259_g4698_i0	PRJNA1078753	4894	474	1.496259	7.09226766	Spirochaetae bacterium HGW-Spirochaetae-6	2013838	Bacteria	Bacteria	252	1.68e-82	NR	PKL13565.1	2013838	g4698	i0	75	2.9620253164557	156	39	98.7	0	2	469	62	217	PKL13565.1 MAG: adenosylhomocysteinase, partial [Spirochaetae bacterium HGW-Spirochaetae-6]	diamond	1404	252	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-6
27604730	27604730	PRJNA1078753_P_NODE_20064_length_278_cov_1.409756_g19868_i0	PRJNA1078753	20064	278	1.409756	3.91912168	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	46.2	0.00305	NR	MBE6348771.1	1898206	g19868	i0	41.3	0.496402877697842	46	27	49.6	0	2	139	147	192	MBE6348771.1 MBL fold metallo-hydrolase [Spirochaetaceae bacterium]	diamond	138	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28015162	28015162	PRJNA1078753_P_NODE_16325_length_296_cov_2.008969_g16129_i0	PRJNA1078753	16325	296	2.008969	5.94654824	Treponema sp.	166	Bacteria	Bacteria	71.2	6.67e-12	NR	MCL2441771.1	166	g16129	i0	53.6	0.567567567567568	56	26	56.8	0	2	169	81	136	MCL2441771.1 hypothetical protein [Treponema sp.]	diamond	168	71.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28267438	28267438	PRJNA1078753_P_NODE_23666_length_264_cov_1.209424_g23470_i0	PRJNA1078753	23666	264	1.209424	3.19287936	Spirochaetales bacterium	2026792	Bacteria	Bacteria	65.9	2.37e-11	NR	MBN2443173.1	2026792	g23470	i0	48.8	1.85227272727273	80	39	88.6	2	8	241	21	100	MBN2443173.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium]	diamond	489	65.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28362254	28362254	PRJNA1078753_P_NODE_2526_length_625_cov_1.800725_g2335_i0	PRJNA1078753	2526	625	1.800725	11.25453125	Leptospira barantonii	2023184	Bacteria	Bacteria	79.7	1.75e-13	NR	WP_135670236.1	2023184	g2335	i0	34.7	1.6128	147	86	70.6	1	443	3	92	228	WP_135670236.1 circularly permuted ATPgrasp domain protein [Leptospira barantonii]	diamond	1008	79.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira barantonii
29404342	29404342	PRJNA1078753_P_NODE_37849_length_244_cov_0.900585_g37653_i0	PRJNA1078753	37849	244	0.900585	2.1974274	Treponema sp.	166	Bacteria	Bacteria	69.3	1.28e-11	NR	MBR6912347.1	166	g37653	i0	44.4	2.66803278688525	72	39	87.3	1	239	27	265	336	MBR6912347.1 DUF2135 domain-containing protein [Treponema sp.]	diamond	651	69.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29498938	29498938	PRJNA1078753_P_NODE_19550_length_280_cov_1.487923_g19354_i0	PRJNA1078753	19550	280	1.487923	4.1661844	Spirochaetota bacterium	2202144	Bacteria	Bacteria	70.5	9.71e-12	NR	MFH0975997.1	2202144	g19354	i0	42.4	1.54285714285714	92	45	98.6	2	278	3	215	298	MFH0975997.1 mucoidy inhibitor MuiA family protein [Spirochaetota bacterium]	diamond	432	70.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30121972	30121972	PRJNA1078753_P_NODE_35792_length_246_cov_0.890173_g35596_i0	PRJNA1078753	35792	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	63.5	8.68e-10	NR	MBN1501778.1	2202144	g35596	i0	47.4	1.81707317073171	76	31	90.2	4	2	223	107	175	MBN1501778.1 hypothetical protein [Spirochaetota bacterium]	diamond	447	63.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30162022	30162022	PRJNA1078753_P_NODE_43692_length_241_cov_0.916667_g43496_i0	PRJNA1078753	43692	241	0.916667	2.20916747	Treponema sp.	166	Bacteria	Bacteria	54.3	8.1e-7	NR	MDR2101306.1	166	g43496	i0	41.2	1.78008298755187	68	39	83.4	1	39	239	76	143	MDR2101306.1 Hsp20/alpha crystallin family protein [Treponema sp.]	diamond	429	54.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30794067	30794067	PRJNA1078753_P_NODE_31934_length_248_cov_0.880000_g31738_i0	PRJNA1078753	31934	248	0.88	2.1824	Spirochaetota bacterium	2202144	Bacteria	Bacteria	68.6	2.95e-11	NR	HOP64738.1	2202144	g31738	i0	40.7	4.69354838709677	81	47	98	1	245	3	241	320	HOP64738.1 cardiolipin synthase [Spirochaetota bacterium]	diamond	1164	68.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31670734	31670734	PRJNA1078753_P_NODE_11697_length_336_cov_1.395437_g11501_i0	PRJNA1078753	11697	336	1.395437	4.68866832	Pseudomonadati	3379134	Bacteria	Bacteria	129	3.05e-32	NR	MEA1912207.1	2202144	g11501	i0	57.4	8.8125	108	44	95.5	2	16	336	28	134	MEA1912207.1 glutamine synthetase III [Spirochaetota bacterium]	diamond	2961	130	0.992307692307692	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32113812	32113812	PRJNA1078753_P_NODE_15418_length_303_cov_1.339130_g15222_i0	PRJNA1078753	15418	303	1.33913	4.0575639	Pseudomonadati	3379134	Bacteria	Bacteria	102	5.1199999999999996e-23	NR	HQP48312.1	2202144	g15222	i0	52.6	3.84158415841584	97	44	96	1	301	11	408	502	HQP48312.1 translation elongation factor 4 [Spirochaetota bacterium]	diamond	1164	102	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32407105	32407105	PRJNA1078753_P_NODE_41779_length_242_cov_0.911243_g41583_i0	PRJNA1078753	41779	242	0.911243	2.20520806	Spirochaetales bacterium	2026792	Bacteria	Bacteria	62	3.04e-9	NR	MBN2628504.1	2026792	g41583	i0	43.1	1.41322314049587	58	33	71.9	0	180	7	15	72	MBN2628504.1 biotin--[acetyl-CoA-carboxylase] ligase [Spirochaetales bacterium]	diamond	342	62	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32839948	32839948	PRJNA1078753_P_NODE_28500_length_250_cov_1.305085_g28304_i0	PRJNA1078753	28500	250	1.305085	3.2627125	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	4.77e-4	NR	MBQ2315276.1	166	g28304	i0	52.5	1.896	40	19	48	0	248	129	77	116	MBQ2315276.1 sel1 repeat family protein [Treponema sp.]	diamond	474	48.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema 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);;