metadata: contig_metadata: 15 rows where bioproject = "PRJNA1005695", tax_phylum = "Spirochaetota" and tax

15 rows where bioproject = "PRJNA1005695", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
1001092	1001092	PRJNA1005695_P_NODE_30141_length_272_cov_1.457286_g29289_i0	PRJNA1005695	30141	272	1.457286	3.96381792	Turneriella	338321	Bacteria	Bacteria	475	1.2499999999999999e-129	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g29289	i0	98.162	65.5220588235294	272	5	100	0	1	272	306	35	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	17822	475	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
2276164	2276164	PRJNA1005695_P_NODE_1422_length_1322_cov_2.765412_g1031_i0	PRJNA1005695	1422	1322	2.765412	36.55874664	root	1	Root_unresolved	Root_unresolved	2431	0	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g1031	i0	99.849	126.68532526475	1322	2	100	0	1	1322	2037566	2036245	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	167478	2436	0.997947454844007	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
6531797	6531797	PRJNA1005695_P_NODE_39586_length_243_cov_0.917647_g38734_i0	PRJNA1005695	39586	243	0.917647	2.22988221	Borrelia sp. BU AG58	2887345	Bacteria	Bacteria	209	1.23e-49	NTclustered	gi\|2550531245\|gb\|CP086555.2\|	2887345	g38734	i0	82.591	164.094650205761	247	33	100	10	1	243	434367	434127	Borrelia sp. BU AG58 chromosome, complete genome	blastn	39875	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia sp. BU AG58
7806198	7806198	PRJNA1005695_P_NODE_40487_length_239_cov_2.777108_g39635_i0	PRJNA1005695	40487	239	2.777108	6.63728812	Leptospira tipperaryensis	2564040	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|1066933105\|gb\|CP015217.1\|	2564040	g39635	i0	100	189.02510460251	239	0	100	0	1	239	802286	802524	Leptospira tipperaryensis strain GWTS #1 chromosome 1, complete sequence	blastn	45177	442	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira tipperaryensis
9929213	9929213	PRJNA1005695_P_NODE_7408_length_577_cov_1.486111_g6576_i0	PRJNA1005695	7408	577	1.486111	8.57486047	Turneriella	338321	Bacteria	Bacteria	1005	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g6576	i0	98.094	301.707105719237	577	11	100	0	1	577	523	1099	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	174085	1005	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
10356597	10356597	PRJNA1005695_P_NODE_19209_length_344_cov_3.778598_g18357_i0	PRJNA1005695	19209	344	3.778598	12.99837712	Thermospira aquatica	2828656	Bacteria	Bacteria	255	2.31e-63	NTclustered	gi\|2242711866\|gb\|CP073355.1\|	2828656	g18357	i0	82.653	213.593023255814	294	45	85	4	32	322	943985	943695	Thermospira aquatica strain F1F22 chromosome, complete genome	blastn	73476	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales	Thermospiraceae	Thermospira	Thermospira aquatica
18005333	18005333	PRJNA1005695_P_NODE_34535_length_253_cov_1.388889_g33683_i0	PRJNA1005695	34535	253	1.388889	3.51388917	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	143	1.32e-29	NTclustered	gi\|2621705858\|emb\|OY763920.1\|	2791017	g33683	i0	80.628	70.798418972332	191	31	74	5	9	196	645902	646089	MAG: Sphaerochaetaceae bacterium isolate d5506382-6fb0-4ee2-9b9e-b33663e62a62 genome assembly, chromosome: 1	blastn	17912	143	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
19279163	19279163	PRJNA1005695_P_NODE_37236_length_248_cov_0.862857_g36384_i0	PRJNA1005695	37236	248	0.862857	2.13988536	Treponema socranskii	53419	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g36384	i0	100	197.564516129032	248	0	100	0	1	248	907423	907670	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	48996	459	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
20127597	20127597	PRJNA1005695_P_NODE_34436_length_253_cov_2.083333_g33584_i0	PRJNA1005695	34436	253	2.083333	5.27083249	Spirochaeta	146	Bacteria	Bacteria	396	9.209999999999997e-106	NTclustered	gi\|339759270\|emb\|HE566016.1\|	174390	g33584	i0	94.862	97.9367588932806	253	13	100	0	1	253	826	574	Uncultured Spirochaeta sp. partial 16S rRNA gene, clone F63_02	blastn	24778	396	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	uncultured Spirochaeta sp.
21830280	21830280	PRJNA1005695_P_NODE_24538_length_303_cov_1.604348_g23686_i0	PRJNA1005695	24538	303	1.604348	4.86117444	Leptospira cinconiae	3235173	Bacteria	Bacteria	555	1.7599999999999995e-153	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g23686	i0	99.67	191.70297029703	303	1	100	0	1	303	753715	754017	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	58086	555	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
24379408	24379408	PRJNA1005695_P_NODE_10520_length_478_cov_3.597531_g9668_i0	PRJNA1005695	10520	478	3.597531	17.19619818	uncultured Spirochaetia bacterium	2563800	Bacteria	Bacteria	684	0	NTclustered	gi\|2213050919\|gb\|ON086745.1\|	2563800	g9668	i0	94.977	83.2196652719665	438	19	91	2	44	478	1	438	Uncultured Spirochaetia bacterium clone AC_BRV01 16S ribosomal RNA gene, partial sequence	blastn	39779	684	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				uncultured Spirochaetia bacterium
27350834	27350834	PRJNA1005695_P_NODE_38703_length_245_cov_0.906977_g37851_i0	PRJNA1005695	38703	245	0.906977	2.22209365	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	92.4	5.480000000000001e-21	NR	MDC7127142.1	1898206	g37851	i0	46.9	0.991836734693878	81	43	99.2	0	3	245	70	150	MDC7127142.1 HAD hydrolase-like protein [Spirochaetaceae bacterium]	diamond	243	92.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30982509	30982509	PRJNA1005695_P_NODE_30754_length_269_cov_1.591837_g29902_i0	PRJNA1005695	30754	269	1.591837	4.28204153	Treponemataceae bacterium	2854022	Bacteria	Bacteria	45.8	0.00401	NR	MEL3908691.1	2854022	g29902	i0	58.6	0.323420074349442	29	12	32.3	0	121	35	372	400	MEL3908691.1 SPFH domain-containing protein [Treponemataceae bacterium]	diamond	87	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
32215884	32215884	PRJNA1005695_P_NODE_29558_length_275_cov_1.232673_g28706_i0	PRJNA1005695	29558	275	1.232673	3.38985075	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	44.3	0.012	NR	MBL8967346.1	1898206	g28706	i0	39	0.84	77	45	81.8	1	262	38	82	158	MBL8967346.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Spirochaetaceae bacterium]	diamond	231	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
32588117	32588117	PRJNA1005695_P_NODE_9739_length_498_cov_1.762353_g8888_i0	PRJNA1005695	9739	498	1.762353	8.77651794	Bacteria	2	Bacteria	Bacteria	135	4.5799999999999995e-37	NR	PKL26378.1	2013835	g8888	i0	45.5	4.68674698795181	156	70	93.4	5	33	497	8	149	PKL26378.1 MAG: hypothetical protein CVV47_00140 [Spirochaetae bacterium HGW-Spirochaetae-3]	diamond	2334	135	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-3

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