metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
3599964	3599964	PRJNA1237347_P_NODE_524883_length_245_cov_0.860465_g518310_i0	PRJNA1237347	524883	245	0.860465	2.10813925	Bacteria	2	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621700913\|emb\|OY759747.1\|	2053615	g518310	i0	100	0.228571428571429	28	0	11	0	4	31	4932748	4932721	MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
4168404	4168404	PRJNA1237347_P_NODE_339984_length_309_cov_1.254237_g333411_i0	PRJNA1237347	339984	309	1.254237	3.87559233	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	76.8	1.71e-9	NTclustered	gi\|2907625910\|emb\|OZ223470.1\|	2791017	g333411	i0	88.71	0.601941747572815	62	7	20	0	116	177	787019	786958	MAG: Sphaerochaetaceae bacterium isolate cd985c71-0469-48ce-9ce8-6ec3774ccd9a genome assembly, chromosome: 1	blastn	186	76.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
5441973	5441973	PRJNA1237347_P_NODE_206905_length_424_cov_1.358974_g200333_i0	PRJNA1237347	206905	424	1.358974	5.76204976	Spirochaetia bacterium	2053615	Bacteria	Bacteria	99	5.17e-16	NTclustered	gi\|2621706436\|emb\|OY764216.1\|	2053615	g200333	i0	78.528	8.85849056603774	163	25	87	8	90	246	4857011	4856853	MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1	blastn	3756	99	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
7998700	7998700	PRJNA1237347_P_NODE_557767_length_241_cov_0.880952_g551194_i0	PRJNA1237347	557767	241	0.880952	2.12309432	Treponema vincentii	69710	Bacteria	Bacteria	198	2.63e-46	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g551194	i0	95.2	3.76763485477178	125	6	52	0	1	125	1523449	1523325	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	908	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7999054	7999054	PRJNA1237347_P_NODE_62367_length_920_cov_3.463991_g56809_i0	PRJNA1237347	62367	920	3.463991	31.8687172	Sediminispirochaeta smaragdinae	55206	Bacteria	Bacteria	654	0	NTclustered	gi\|301633733\|gb\|CP002116.1\|	573413	g56809	i0	80.149	155.302173913043	937	137	99	38	1	919	3456335	3455430	Sediminispirochaeta smaragdinae DSM 11293 chromosome, complete genome	blastn	142878	654	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Sediminispirochaeta	Sediminispirochaeta smaragdinae
9270404	9270404	PRJNA1237347_P_NODE_389268_length_284_cov_1.459716_g382695_i0	PRJNA1237347	389268	284	1.459716	4.14559344	Spirochaetia bacterium	2053615	Bacteria	Bacteria	73.1	2.01e-8	NTclustered	gi\|2621706436\|emb\|OY764216.1\|	2053615	g382695	i0	75.148	0.595070422535211	169	35	59	7	71	237	4856818	4856655	MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1	blastn	169	73.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
9976367	9976367	PRJNA1237347_P_NODE_307688_length_329_cov_1.093750_g301115_i0	PRJNA1237347	307688	329	1.09375	3.5984375	Leptospira	171	Bacteria	Bacteria	62.1	5.14e-5	NTclustered	gi\|2040565569\|gb\|CP072628.1\|	174	g301115	i0	84.058	5.27963525835866	69	6	20	5	203	269	2127190	2127255	Leptospira borgpetersenii strain FMAS_AP3 chromosome 1, complete sequence	blastn	1737	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira borgpetersenii
14372546	14372546	PRJNA1237347_P_NODE_454172_length_257_cov_2.717391_g447599_i0	PRJNA1237347	454172	257	2.717391	6.98369487	uncultured Treponema sp.	162155	Bacteria	Bacteria	111	3.8e-20	NTclustered	gi\|2215077807\|gb\|ON138401.1\|	162155	g447599	i0	83.898	4.83268482490272	118	17	46	1	136	253	611	726	Uncultured Treponema sp. clone DT22 23S ribosomal RNA gene, partial sequence	blastn	1242	111	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
15639664	15639664	PRJNA1237347_P_NODE_120573_length_604_cov_2.259887_g114063_i0	PRJNA1237347	120573	604	2.259887	13.64971748	Spirochaeta aurantia	147	Bacteria	Bacteria	726	0	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g114063	i0	88.468	182.32119205298	607	62	99	8	1	603	2845	3447	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	110122	726	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
16917410	16917410	PRJNA1237347_P_NODE_289014_length_342_cov_1.144981_g282441_i0	PRJNA1237347	289014	342	1.144981	3.91583502	Thermospira aquatica	2828656	Bacteria	Bacteria	257	6.38e-64	NTclustered	gi\|2242711866\|gb\|CP073355.1\|	2828656	g282441	i0	80.692	359.836257309942	347	54	100	6	1	342	943641	943979	Thermospira aquatica strain F1F22 chromosome, complete genome	blastn	123064	257	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Thermospiraceae	Thermospira	Thermospira aquatica
16919410	16919410	PRJNA1237347_P_NODE_389214_length_284_cov_1.483412_g382641_i0	PRJNA1237347	389214	284	1.483412	4.21289008	Spirochaetia bacterium	2053615	Bacteria	Bacteria	156	1.94e-33	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g382641	i0	78.125	64.5880281690141	256	48	89	8	8	259	3667592	3667843	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	18343	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
16922146	16922146	PRJNA1237347_P_NODE_534354_length_243_cov_1.711765_g527781_i0	PRJNA1237347	534354	243	1.711765	4.15958895	Spirochaetia bacterium	2053615	Bacteria	Bacteria	86.1	2.16e-12	NTclustered	gi\|2621706436\|emb\|OY764216.1\|	2053615	g527781	i0	82.828	1.81893004115226	99	14	42	3	104	200	4855890	4855793	MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1	blastn	442	86.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
20739657	20739657	PRJNA1237347_P_NODE_18717_length_1830_cov_3.834377_g16315_i0	PRJNA1237347	18717	1830	3.834377	70.1690991	Leptospira cinconiae	3235173	Bacteria	Bacteria	3319	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g16315	i0	99.399	188.86393442623	1830	11	100	0	1	1830	753237	755066	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	345621	3319	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
22724979	22724979	PRJNA1237347_P_NODE_271758_length_355_cov_2.219858_g265185_i0	PRJNA1237347	271758	355	2.219858	7.8804959	Spirochaetia	203692	Bacteria	Bacteria	556	5.84e-154	NTclustered	gi\|559795264\|ref\|NR_104855.1\|	34097	g265185	i0	94.93	95.7352112676056	355	18	100	0	1	355	160	514	Brevinema andersonii strain CT11616 16S ribosomal RNA, partial sequence	blastn	33986	556	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Brevinemataceae	Brevinema	Brevinema andersonii
23296263	23296263	PRJNA1237347_P_NODE_473039_length_251_cov_0.865169_g466466_i0	PRJNA1237347	473039	251	0.865169	2.17157419	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g466466	i0	91.235	3.34661354581673	251	22	100	0	1	251	210443	210193	Leptospira sp. severe_002 chromosome 1	blastn	840	342	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
24562575	24562575	PRJNA1237347_P_NODE_106060_length_656_cov_2.770154_g99621_i0	PRJNA1237347	106060	656	2.770154	18.17221024	Leptospira sp. 'Mane'	3387407	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2889308543\|gb\|CP177134.1\|	3387407	g99621	i0	100	0.0442073170731707	29	0	4	0	463	491	2387392	2387420	Leptospira sp. 'Mane' chromosome 1, complete sequence	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. 'Mane'

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