metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
1407904	1407904	PRJEB66218_P_NODE_39942_length_555_cov_2.344130_g37544_i0	PRJEB66218	39942	555	2.34413	13.0099215	Spirochaetota bacterium	2202144	Bacteria	Bacteria	534	4.4499999999999997e-147	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g37544	i0	84.192	116.354954954955	563	75	99	11	1	554	73264	72707	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	64577	534	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
4822347	4822347	PRJEB66218_P_NODE_153304_length_239_cov_1.460674_g150875_i0	PRJEB66218	153304	239	1.460674	3.49101086	Treponema	157	Bacteria	Bacteria	86.1	2.12e-12	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g150875	i0	97.959	2.02092050209205	49	1	21	0	7	55	2342390	2342438	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	483	86.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
5235378	5235378	PRJEB66218_P_NODE_240425_length_202_cov_0.921986_g237994_i0	PRJEB66218	240425	202	0.921986	1.86241172	Treponema sp. OMZ 906	2563662	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2265130757\|gb\|CP051196.1\|	2563662	g237994	i0	100	6.01980198019802	202	0	100	0	1	202	716318	716519	Treponema sp. OMZ 906 chromosome, complete genome	blastn	1216	374	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
6510043	6510043	PRJEB66218_P_NODE_1766_length_3456_cov_54.156112_g1449_i0	PRJEB66218	1766	3456	54.156112	1871.63523072	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	2.08e-28	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g1449	i0	81.461	4.53211805555556	178	30	5	3	998	1173	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15663	143	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
15433370	15433370	PRJEB66218_P_NODE_128533_length_264_cov_0.960591_g126104_i0	PRJEB66218	128533	264	0.960591	2.53596024	Treponema parvum	138851	Bacteria	Bacteria	379	9.739999999999998e-101	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g126104	i0	93.05	190.613636363636	259	18	98	0	1	259	1517188	1517446	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	50322	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
15434562	15434562	PRJEB66218_P_NODE_19013_length_909_cov_3.337264_g16990_i0	PRJEB66218	19013	909	3.337264	30.33572976	Spirochaetota bacterium	2202144	Bacteria	Bacteria	484	7.639999999999997e-132	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g16990	i0	77.007	179.698569856986	922	164	99	35	1	905	73543	74433	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	163346	484	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
21807687	21807687	PRJEB66218_P_NODE_128798_length_263_cov_2.108911_g126369_i0	PRJEB66218	128798	263	2.108911	5.54643593	Spirochaetota bacterium	2202144	Bacteria	Bacteria	272	1.69e-68	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g126369	i0	85.714	425.699619771863	266	29	99	8	2	263	74663	74403	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	111959	272	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium

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