metadata: contig_metadata: 15 rows where bioproject = "PRJNA193544", tax_phylum = "Campylobacterota" and tax

15 rows where bioproject = "PRJNA193544", tax_phylum = "Campylobacterota" 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
1055261	1055261	PRJNA193544_S_NODE_21_length_661_cov_14.985759_g9_i3	PRJNA193544	21	661	14.985759	99.05586699	Sulfurospirillum	57665	Bacteria	Bacteria	1007	0	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g9	i3	98.097	287.063540090772	578	11	87	0	80	657	1265	1842	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	189749	1007	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
3605687	3605687	PRJNA193544_S_NODE_1123_length_240_cov_18628.341232_g1108_i0	PRJNA193544	1123	240	18628.341232	44708.0189568	Sulfurospirillum	57665	Bacteria	Bacteria	372	1.4599999999999997e-98	NTclustered	gi\|470485421\|ref\|NR_076700.1\|	65553	g1108	i0	99.034	318.570833333333	207	2	86	0	34	240	1279	1073	Sulfurospirillum deleyianum strain 'Spirillum' 5175 23S ribosomal RNA gene, complete sequence	blastn	76457	372	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum deleyianum
4192960	4192960	PRJNA193544_S_NODE_1184_length_234_cov_19687.443902_g1169_i0	PRJNA193544	1184	234	19687.443902	46068.61873068	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	285	1.9e-72	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g1169	i0	97.041	216.397435897436	169	5	72	0	66	234	289	121	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	50637	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
5469202	5469202	PRJNA193544_S_NODE_1365_length_221_cov_7.208333_g1350_i0	PRJNA193544	1365	221	7.208333	15.93041593	Helicobacter pametensis	95149	Bacteria	Bacteria	156	1.45e-33	NTclustered	gi\|50957145\|gb\|AY596230.1\|	95149	g1350	i0	80.488	189.62443438914	205	39	93	1	11	215	320	117	Helicobacter pametensis strain ATCC 51478 23S ribosomal RNA gene, partial sequence	blastn	41907	156	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pametensis
6157946	6157946	PRJNA193544_S_NODE_1185_length_234_cov_17797.839024_g1170_i0	PRJNA193544	1185	234	17797.839024	41646.94331616	Sulfurimonadaceae	2771471	Bacteria	Bacteria	233	6.97e-57	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g1170	i0	87.879	130.632478632479	198	24	85	0	37	234	1881910	1882107	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	30568	233	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
6157982	6157982	PRJNA193544_S_NODE_585_length_302_cov_80.538462_g570_i0	PRJNA193544	585	302	80.538462	243.22615524	Sulfurospirillum	57665	Bacteria	Bacteria	460	3.94e-125	NTclustered	gi\|470485421\|ref\|NR_076700.1\|	65553	g570	i0	94.098	240.82119205298	305	14	100	4	1	302	772	469	Sulfurospirillum deleyianum strain 'Spirillum' 5175 23S ribosomal RNA gene, complete sequence	blastn	72728	460	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum deleyianum
9293962	9293962	PRJNA193544_S_NODE_1568_length_210_cov_8.955801_g1553_i0	PRJNA193544	1568	210	8.955801	18.8071821	Arcobacter sp. FWKO B	2593672	Bacteria	Bacteria	265	2.17e-66	NTclustered	gi\|1913474794\|gb\|CP041403.1\|	2593672	g1553	i0	90.594	371.328571428571	202	15	95	3	1	200	655696	655895	Arcobacter sp. FWKO B chromosome	blastn	77979	265	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. FWKO B
12533863	12533863	PRJNA193544_S_NODE_10_length_767_cov_21.822493_g9_i0	PRJNA193544	10	767	21.822493	167.37852131	Sulfurospirillum	57665	Bacteria	Bacteria	1083	0	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g9	i0	92.228	305.358539765319	772	49	99	10	1	763	1073	1842	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	234210	1083	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
15082782	15082782	PRJNA193544_S_NODE_2792_length_165_cov_13.066176_g2777_i0	PRJNA193544	2792	165	13.066176	21.5591904	Sulfurospirillum	57665	Bacteria	Bacteria	276	7.52e-70	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g2777	i0	98.71	231.442424242424	155	2	94	0	1	155	2246194	2246348	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	38188	276	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
18217605	18217605	PRJNA193544_S_NODE_455_length_325_cov_366.594595_g440_i0	PRJNA193544	455	325	366.594595	1191.43243375	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	348	3.4800000000000005e-91	NTclustered	gi\|346681537\|gb\|JF740651.1\|	120858	g440	i0	95.434	135.781538461538	219	9	67	1	1	219	262	479	Uncultured epsilon proteobacterium clone 23S_S3M_212 23S ribosomal RNA gene, partial sequence	blastn	44129	348	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
20767445	20767445	PRJNA193544_S_NODE_797_length_273_cov_25.852459_g782_i0	PRJNA193544	797	273	25.852459	70.57721307	Sulfurospirillum diekertiae	1854492	Bacteria	Bacteria	449	7.61e-122	NTclustered	gi\|1209483714\|gb\|CP021979.1\|	1854492	g782	i0	96.35	307.157509157509	274	8	100	2	1	273	2076234	2076506	Sulfurospirillum sp. SL2-2 genome	blastn	83854	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum diekertiae
21457019	21457019	PRJNA193544_S_NODE_637_length_296_cov_13.295880_g622_i0	PRJNA193544	637	296	13.29588	39.3558048	Sulfurospirillum	57665	Bacteria	Bacteria	418	2.3499999999999998e-112	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g622	i0	99.563	210.851351351351	229	1	77	0	2	230	2305	2077	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	62412	418	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
24007214	24007214	PRJNA193544_S_NODE_19_length_670_cov_23.728549_g9_i1	PRJNA193544	19	670	23.728549	158.9812783	Sulfurospirillum	57665	Bacteria	Bacteria	1014	0	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g9	i1	97.635	304.682089552239	592	13	88	1	5	596	1842	1252	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	204137	1014	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
25281312	25281312	PRJNA193544_S_NODE_1620_length_207_cov_13.028090_g1605_i0	PRJNA193544	1620	207	13.02809	26.9681463	Sulfurospirillum	57665	Bacteria	Bacteria	311	2.71e-80	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g1605	i0	96.296	237.115942028986	189	7	91	0	1	189	769	957	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	49083	311	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
25281317	25281317	PRJNA193544_S_NODE_20_length_669_cov_14.959375_g9_i2	PRJNA193544	20	669	14.959375	100.07821875	Sulfurospirillum	57665	Bacteria	Bacteria	1022	0	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g9	i2	95.356	325.772795216741	646	24	96	5	23	665	1200	1842	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	217942	1022	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii

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