metadata: contig_metadata: 13 rows where bioproject = "PRJNA982106" and tax

13 rows where bioproject = "PRJNA982106" 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
2546526	2546526	PRJNA982106_P_NODE_10902_length_318_cov_0.742857_g10662_i0	PRJNA982106	10902	318	0.742857	2.36228526	Bacteria	2	Bacteria	Bacteria	566	8.609999999999999e-157	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g10662	i0	98.742	101.006289308176	318	4	100	0	1	318	319489	319806	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	32120	566	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
6067407	6067407	PRJNA982106_P_NODE_8965_length_339_cov_0.812030_g8725_i0	PRJNA982106	8965	339	0.81203	2.7527817	Treponema sp. canine oral taxon 358	1151573	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|373279860\|gb\|JN713528.1\|	1151573	g8725	i0	99.705	99.3421828908555	339	1	100	0	1	339	919	581	Treponema sp. canine oral taxon 358 clone 1Z002 16S ribosomal RNA gene, partial sequence	blastn	33677	621	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. canine oral taxon 358
7649196	7649196	PRJNA982106_P_NODE_3286_length_486_cov_1.314770_g3047_i0	PRJNA982106	3286	486	1.31477	6.3897822	root	1	Root_unresolved	Root_unresolved	893	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g3047	i0	99.794	147.09670781893	486	1	100	0	1	486	312637	313122	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	71489	893	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
7649259	7649259	PRJNA982106_P_NODE_7646_length_356_cov_1.360424_g7406_i0	PRJNA982106	7646	356	1.360424	4.84310944	Treponema	157	Bacteria	Bacteria	501	2.779999999999999e-137	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g7406	i0	91.967	3.04213483146067	361	23	99	1	1	355	2643297	2643657	Treponema medium strain T19 chromosome, complete genome	blastn	1083	501	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
8923904	8923904	PRJNA982106_P_NODE_22587_length_249_cov_1.693182_g22347_i0	PRJNA982106	22587	249	1.693182	4.21602318	Treponema	157	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g22347	i0	96.8	197.473895582329	250	7	100	1	1	249	325255	325504	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	49171	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
12443044	12443044	PRJNA982106_P_NODE_26970_length_246_cov_0.890173_g26730_i0	PRJNA982106	26970	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	149	4.35e-44	NR	HKM06771.1	1972642	g26730	i0	86.6	12	82	11	100	0	1	246	80	161	HKM06771.1 ABC transporter ATP-binding protein [Sphaerochaeta sp.]	diamond	2952	149	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
16573457	16573457	PRJNA982106_P_NODE_13833_length_292_cov_1.406393_g13593_i0	PRJNA982106	13833	292	1.406393	4.10666756	Bacteria	2	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g13593	i0	100	68.4931506849315	292	0	100	0	1	292	319040	318749	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	20000	540	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17848620	17848620	PRJNA982106_P_NODE_20094_length_252_cov_1.564246_g19854_i0	PRJNA982106	20094	252	1.564246	3.94189992	Bacteria	2	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g19854	i0	99.603	115.861111111111	252	1	100	0	1	252	317982	317731	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	29197	460	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
19122208	19122208	PRJNA982106_P_NODE_11275_length_314_cov_0.950207_g11035_i0	PRJNA982106	11275	314	0.950207	2.98364998	Bacteria	2	Bacteria	Bacteria	534	2.39e-147	NTclustered	gi\|404429427\|emb\|HE793032.1\|	1161918	g11035	i0	98.361	147.324840764331	305	4	97	1	1	305	1131213	1130910	Brachyspira pilosicoli WesB complete genome	blastn	46260	534	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
22640802	22640802	PRJNA982106_P_NODE_16898_length_272_cov_1.195980_g16658_i0	PRJNA982106	16898	272	1.19598	3.2530656	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g16658	i0	97.81	192.242647058824	274	4	100	1	1	272	210654	210927	Treponema sp. OMZ 305 chromosome, complete genome	blastn	52290	472	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
22948766	22948766	PRJNA982106_P_NODE_19778_length_254_cov_2.464088_g19538_i0	PRJNA982106	19778	254	2.464088	6.25878352	root	1	Root_unresolved	Root_unresolved	470	5.37e-128	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g19538	i0	100	128.98031496063	254	0	100	0	1	254	2036855	2036602	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	32761	470	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
22948840	22948840	PRJNA982106_P_NODE_25458_length_247_cov_0.885057_g25218_i0	PRJNA982106	25458	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g25218	i0	100	81.6356275303644	247	0	100	0	1	247	321918	322164	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	20164	457	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25497344	25497344	PRJNA982106_P_NODE_13340_length_296_cov_1.269058_g13100_i0	PRJNA982106	13340	296	1.269058	3.75641168	Bacteria	2	Bacteria	Bacteria	542	1.34e-149	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g13100	i0	99.662	99.1452702702703	296	1	100	0	1	296	321845	321550	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	29347	542	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola

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