metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
947742	947742	PRJNA976345_P_NODE_121341_length_178_cov_2.412587_g119733_i0	PRJNA976345	121341	178	2.412587	4.29440486	Treponema denticola	158	Bacteria	Bacteria	139	1.1199999999999999e-28	NTclustered	gi\|2265166044\|gb\|CP051303.1\|	158	g119733	i0	100	9.17977528089888	75	0	84	0	1	75	1536483	1536557	Treponema denticola strain OT2B chromosome, complete genome	blastn	1634	139	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4776923	4776923	PRJNA976345_P_NODE_59544_length_230_cov_2.194872_g57936_i0	PRJNA976345	59544	230	2.194872	5.0482056	Treponema sp. OMZ 788	2563664	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2265141765\|gb\|CP051199.1\|	2563664	g57936	i0	100	0.121739130434783	28	0	12	0	62	89	2515017	2515044	Treponema sp. OMZ 788 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 788
7645245	7645245	PRJNA976345_P_NODE_199466_length_150_cov_1.373913_g197858_i0	PRJNA976345	199466	150	1.373913	2.0608695	Borrelia	138	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|576104362\|gb\|CP004146.1\|	1293576	g197858	i0	100	0.766666666666667	29	0	19	0	71	99	390147	390119	Borrelia hermsii YOR, complete genome	blastn	115	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia nietonii
8919852	8919852	PRJNA976345_P_NODE_134967_length_173_cov_1.630435_g133359_i0	PRJNA976345	134967	173	1.630435	2.82065255	Brachyspira	29521	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2021755399\|gb\|CP046930.1\|	159	g133359	i0	96.97	2.28901734104046	33	0	18	1	1	32	546839	546871	Brachyspira hyodysenteriae strain BHZ375 chromosome, complete genome	blastn	396	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
9875928	9875928	PRJNA976345_P_NODE_130208_length_175_cov_2.185714_g128600_i0	PRJNA976345	130208	175	2.185714	3.8249995	Brachyspira intermedia	84377	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g128600	i0	100	0.16	28	0	16	0	34	61	602231	602204	Brachyspira intermedia PWS/A, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
10195760	10195760	PRJNA976345_P_NODE_169268_length_159_cov_1.604839_g167660_i0	PRJNA976345	169268	159	1.604839	2.55169401	Borreliella	64895	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2592014987\|gb\|CP118292.1\|	29519	g167660	i0	96.774	1.34591194968553	31	1	19	0	28	58	11438	11468	Borreliella garinii strain 17-56Z1 plasmid lp17	blastn	214	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
10196133	10196133	PRJNA976345_P_NODE_79368_length_206_cov_2.707602_g77760_i0	PRJNA976345	79368	206	2.707602	5.57766012	Treponema	157	Bacteria	Bacteria	243	9.96e-60	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g77760	i0	87.864	12.6067961165049	206	25	100	0	1	206	1684343	1684548	Treponema sp. OMZ 838, complete genome	blastn	2597	243	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
15295078	15295078	PRJNA976345_P_NODE_178772_length_156_cov_1.322314_g177164_i0	PRJNA976345	178772	156	1.322314	2.06280984	Treponema	157	Bacteria	Bacteria	172	9.45e-39	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g177164	i0	86.538	4.94230769230769	156	21	100	0	1	156	1798600	1798445	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	771	172	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
16251509	16251509	PRJNA976345_P_NODE_53953_length_240_cov_1.390244_g52345_i0	PRJNA976345	53953	240	1.390244	3.3365856	Treponema brennaborense	81028	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g52345	i0	94.286	0.145833333333333	35	2	15	0	47	81	1851621	1851587	Treponema brennaborense DSM 12168, complete genome	blastn	35	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
18800615	18800615	PRJNA976345_P_NODE_79015_length_207_cov_1.366279_g77407_i0	PRJNA976345	79015	207	1.366279	2.82819753	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	287	4.56e-73	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g77407	i0	93.717	7.38164251207729	191	12	92	0	2	192	2675193	2675383	Treponema sp. OMZ 906 chromosome, complete genome	blastn	1528	287	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
23901242	23901242	PRJNA976345_P_NODE_6259_length_727_cov_8.170520_g4912_i0	PRJNA976345	6259	727	8.17052	59.3996804	Leptospira kirschneri	29507	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|2355083728\|gb\|CP112976.1\|	29507	g4912	i0	100	0.163686382393398	30	0	4	0	558	587	3816786	3816815	Leptospira kirschneri strain I-7 chromosome 1, complete sequence	blastn	119	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kirschneri

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