metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA358009" 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
1073121	1073121	PRJNA358009_P_NODE_9501_length_185_cov_8.029412_g9432_i0	PRJNA358009	9501	185	8.029412	14.8544122	Gracilinema	2951106	Bacteria	Bacteria	228	2.4499999999999995e-55	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g9432	i0	89.503	115.183783783784	181	18	97	1	4	183	389	209	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	21309	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
2348464	2348464	PRJNA358009_P_NODE_9422_length_186_cov_2.751825_g9353_i0	PRJNA358009	9422	186	2.751825	5.1183945	Treponema	157	Bacteria	Bacteria	291	3.1e-74	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g9353	i0	94.709	172.360215053763	189	6	100	3	1	186	1687	1874	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	32059	291	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
2948937	2948937	PRJNA358009_P_NODE_7123_length_277_cov_16.421053_g7056_i0	PRJNA358009	7123	277	16.421053	45.48631681	Treponema sp.	166	Bacteria	Bacteria	141	5.29e-29	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g7056	i0	80.526	128.353790613718	190	32	69	5	87	276	1476607	1476423	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	35554	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
4900919	4900919	PRJNA358009_P_NODE_1964_length_330_cov_11.384342_g1901_i0	PRJNA358009	1964	330	11.384342	37.5683286	Treponema	157	Bacteria	Bacteria	147	1.39e-30	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g1901	i0	86.567	11.7121212121212	134	17	40	1	190	322	324741	324608	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	3865	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
8725628	8725628	PRJNA358009_P_NODE_17107_length_157_cov_13.379630_g17038_i0	PRJNA358009	17107	157	13.37963	21.0060191	Gracilinema	2951106	Bacteria	Bacteria	230	5.58e-56	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g17038	i0	94.595	144.229299363057	148	8	94	0	2	149	2912	2765	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	22644	230	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
8725700	8725700	PRJNA358009_P_NODE_5947_length_327_cov_1.589928_g5884_i0	PRJNA358009	5947	327	1.589928	5.19906456	Treponema	157	Bacteria	Bacteria	172	2.26e-38	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g5884	i0	100	79.4403669724771	93	0	59	0	228	320	1013963	1013871	Treponema medium strain T19 chromosome, complete genome	blastn	25977	172	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
10602090	10602090	PRJNA358009_P_NODE_7029_length_291_cov_28.115702_g6962_i0	PRJNA358009	7029	291	28.115702	81.81669282	Breznakiella homolactica	2798577	Bacteria	Bacteria	368	2.36e-97	NTclustered	gi\|2093987262\|gb\|CP067089.2\|	2798577	g6962	i0	91.45	163.584192439863	269	21	92	2	24	291	9298	9031	Breznakiella homolactica strain RmG30 chromosome, complete genome	blastn	47603	368	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Breznakiella	Breznakiella homolactica
11877007	11877007	PRJNA358009_P_NODE_7790_length_221_cov_6.005814_g7721_i0	PRJNA358009	7790	221	6.005814	13.27284894	Sphaerochaeta pleomorpha	1131707	Bacteria	Bacteria	379	7.909999999999998e-101	NTclustered	gi\|359350094\|gb\|CP003155.1\|	158190	g7721	i0	98.598	241.366515837104	214	3	97	0	8	221	2305363	2305576	Sphaerochaeta pleomorpha str. Grapes, complete genome	blastn	53342	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta pleomorpha
12551434	12551434	PRJNA358009_P_NODE_1050_length_370_cov_19.040498_g989_i0	PRJNA358009	1050	370	19.040498	70.4498426	Gracilinema	2951106	Bacteria	Bacteria	409	1.81e-109	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g989	i0	87.088	200.210810810811	364	44	98	2	1	363	2504	2143	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	74078	409	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
12551448	12551448	PRJNA358009_P_NODE_11410_length_174_cov_3.456000_g11341_i0	PRJNA358009	11410	174	3.456	6.01344	Gracilinema	2951106	Bacteria	Bacteria	211	2.28e-50	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g11341	i0	89.759	3.81609195402299	166	16	95	1	7	172	699	863	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	664	211	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium

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