metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Campylobacterota"

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
364535	364535	PRJNA168635_P_NODE_29961_length_164_cov_0.904348_g29545_i0	PRJNA168635	29961	164	0.904348	1.48313072	Sulfurospirillum diekertiae	1854492	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|1905313802\|gb\|CP045453.2\|	1854492	g29545	i0	96.341	4.9390243902439	164	6	100	0	1	164	18013	18176	Sulfurospirillum diekertiae strain ACSTCE chromosome, complete genome	blastn	810	270	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum diekertiae
1639169	1639169	PRJNA168635_P_NODE_15282_length_205_cov_4.076923_g14866_i0	PRJNA168635	15282	205	4.076923	8.35769215	Campylobacter ureolyticus	827	Bacteria	Bacteria	292	9.69e-75	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g14866	i0	100	166.048780487805	158	0	100	0	48	205	203235	203392	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	34040	292	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
2329673	2329673	PRJNA168635_P_NODE_7542_length_307_cov_99.542636_g7130_i0	PRJNA168635	7542	307	99.542636	305.59589252	Sulfurospirillum	57665	Bacteria	Bacteria	534	2.33e-147	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g7130	i0	98.046	362.078175895765	307	6	100	0	1	307	1637	1943	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	111158	534	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
4191387	4191387	PRJNA168635_P_NODE_11724_length_239_cov_2.010526_g11308_i0	PRJNA168635	11724	239	2.010526	4.80515714	Campylobacter showae	204	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|1483583511\|emb\|LT631435.1\|	204	g11308	i0	99.582	232.543933054393	239	1	100	0	1	239	10409	10647	Campylobacter showae genome assembly, plasmid: XI	blastn	55578	436	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
4191733	4191733	PRJNA168635_P_NODE_32724_length_160_cov_4.882883_g32308_i0	PRJNA168635	32724	160	4.882883	7.8126128	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	270	3.3699999999999993e-68	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g32308	i0	97.484	141.0625	159	3	99	1	1	159	644746	644589	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	22570	270	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
4882173	4882173	PRJNA168635_P_NODE_18264_length_188_cov_3.920863_g17848_i0	PRJNA168635	18264	188	3.920863	7.37122244	Campylobacter	194	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g17848	i0	100	275.984042553192	188	0	100	0	1	188	30550	30737	Campylobacter showae genome assembly, plasmid: V	blastn	51885	348	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
4882192	4882192	PRJNA168635_P_NODE_2084_length_559_cov_8.741176_g1712_i0	PRJNA168635	2084	559	8.741176	48.86317384	Sulfuricurvum	286130	Bacteria	Bacteria	896	0	NTclustered	gi\|470487282\|ref\|NR_076811.1\|	148813	g1712	i0	96.33	313.270125223614	545	20	97	0	15	559	547	3	Sulfuricurvum kujiense strain YK-1 23S ribosomal RNA gene, complete sequence	blastn	175118	896	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum kujiense
6157146	6157146	PRJNA168635_P_NODE_9325_length_273_cov_9.227679_g8910_i0	PRJNA168635	9325	273	9.227679	25.19156367	Aliarcobacter	2321111	Bacteria	Bacteria	488	1.6099999999999996e-133	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g8910	i0	99.259	376.758241758242	270	2	99	0	4	273	1319	1050	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	102855	488	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
6742352	6742352	PRJNA168635_P_NODE_35466_length_151_cov_5.088235_g35050_i0	PRJNA168635	35466	151	5.088235	7.68323485	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	213	5.34e-51	NTclustered	gi\|346681549\|gb\|JF740663.1\|	120858	g35050	i0	92.617	120.596026490066	149	10	98	1	1	148	53	201	Uncultured epsilon proteobacterium clone 23S_S3M_206 23S ribosomal RNA gene, partial sequence	blastn	18210	213	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
6742420	6742420	PRJNA168635_P_NODE_6566_length_330_cov_15.088968_g6155_i0	PRJNA168635	6566	330	15.088968	49.7935944	Candidatus Thiovulum stygium	2951083	Bacteria	Bacteria	523	5.479999999999998e-144	NTclustered	gi\|2182967327\|gb\|CP091137.1\|	2951083	g6155	i0	95.427	169.781818181818	328	15	99	0	1	328	566135	566462	MAG: Candidatus Thiovulum stygium isolate 07-Movile_MetG_Ill chromosome, complete genome	blastn	56028	523	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiovulum	Candidatus Thiovulum stygium
8018134	8018134	PRJNA168635_P_NODE_9987_length_262_cov_8.488263_g9572_i0	PRJNA168635	9987	262	8.488263	22.23924906	Campylobacter sp. GTC17093	3382266	Bacteria	Bacteria	446	9.379999999999998e-121	NTclustered	gi\|2866683719\|dbj\|AP038832.1\|	3382266	g9572	i0	97.328	255.889312977099	262	7	100	0	1	262	47402	47663	Campylobacter sp. GTC17093 DNA, complete genome	blastn	67043	446	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. GTC17093
10568494	10568494	PRJNA168635_P_NODE_19609_length_183_cov_20.985075_g19193_i0	PRJNA168635	19609	183	20.985075	38.40268725	Halarcobacter bivalviorum	663364	Bacteria	Bacteria	143	8.989999999999998e-30	NTclustered	gi\|1435902972\|gb\|CP031217.1\|	663364	g19193	i0	92.157	81.2513661202186	102	6	84	2	1	101	343877	343777	Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome	blastn	14869	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter bivalviorum
11257594	11257594	PRJNA168635_P_NODE_35369_length_152_cov_2.009709_g34953_i0	PRJNA168635	35369	152	2.009709	3.05475768	Sulfurospirillum	57665	Bacteria	Bacteria	248	1.48e-61	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g34953	i0	96.644	12.8421052631579	149	5	98	0	2	150	773323	773175	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	1952	248	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
11257624	11257624	PRJNA168635_P_NODE_6609_length_329_cov_50.857143_g6198_i0	PRJNA168635	6609	329	50.857143	167.32000047	Sulfurospirillum	57665	Bacteria	Bacteria	464	3.3599999999999995e-126	NTclustered	gi\|757804896\|dbj\|AP014724.1\|	366522	g6198	i0	92.145	125.480243161094	331	23	100	3	1	329	49337	49666	Sulfurospirillum cavolei DNA, complete genome	blastn	41283	464	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum cavolei
12532853	12532853	PRJNA168635_P_NODE_20210_length_181_cov_5.878788_g19794_i0	PRJNA168635	20210	181	5.878788	10.64060628	Arcobacteraceae	2808963	Bacteria	Bacteria	326	8.2e-85	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g19794	i0	98.907	270.28729281768	183	0	100	2	1	181	847636	847454	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	48922	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
13118224	13118224	PRJNA168635_P_NODE_19671_length_183_cov_3.626866_g19255_i0	PRJNA168635	19671	183	3.626866	6.63716478	Desulfurella acetivorans	33002	Bacteria	Bacteria	126	9.05e-25	NTclustered	gi\|662020107\|ref\|NR_121994.1\|	33002	g19255	i0	91.304	65.9016393442623	92	8	50	0	64	155	264	173	Desulfurella acetivorans strain A63 23S ribosomal RNA, complete sequence	blastn	12060	126	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales	Desulfurellaceae	Desulfurella	Desulfurella acetivorans
13118407	13118407	PRJNA168635_P_NODE_3131_length_470_cov_38.828979_g2735_i0	PRJNA168635	3131	470	38.828979	182.4962013	Helicobacter sp.	218	Bacteria	Bacteria	261	6.97e-65	NTclustered	gi\|1917981504\|gb\|MW147610.1\|	218	g2735	i0	80.833	81.231914893617	360	46	74	16	1	349	845	1192	Helicobacter sp. strain MIT 16-1345 16S ribosomal RNA gene, partial sequence	blastn	38179	261	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
14393491	14393491	PRJNA168635_P_NODE_15892_length_201_cov_1.368421_g15476_i0	PRJNA168635	15892	201	1.368421	2.75052621	Sulfurospirillum halorespirans	194424	Bacteria	Bacteria	333	5.569999999999999e-87	NTclustered	gi\|1063807422\|gb\|CP017111.1\|	1193502	g15476	i0	96.517	13.5124378109453	201	7	100	0	1	201	478215	478415	Sulfurospirillum halorespirans DSM 13726 chromosome, complete genome	blastn	2716	333	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum halorespirans
15081773	15081773	PRJNA168635_P_NODE_1772_length_601_cov_85.836957_g1414_i0	PRJNA168635	1772	601	85.836957	515.88011157	Sulfuricurvum	286130	Bacteria	Bacteria	839	0	NTclustered	gi\|470487282\|ref\|NR_076811.1\|	148813	g1414	i0	91.914	278.534109816972	606	40	100	9	1	601	1950	1349	Sulfuricurvum kujiense strain YK-1 23S ribosomal RNA gene, complete sequence	blastn	167399	845	0.992899408284024	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum kujiense
15667222	15667222	PRJNA168635_P_NODE_17413_length_192_cov_1.300699_g16997_i0	PRJNA168635	17413	192	1.300699	2.49734208	Campylobacter showae	204	Bacteria	Bacteria	350	5.24e-92	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g16997	i0	99.479	229.026041666667	192	1	100	0	1	192	390725	390534	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	43973	350	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
20766091	20766091	PRJNA168635_P_NODE_26737_length_167_cov_2.838983_g26321_i0	PRJNA168635	26737	167	2.838983	4.74110161	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	182	1.71e-41	NTclustered	gi\|2621786048\|emb\|OY782506.1\|	2808971	g26321	i0	86.391	255.203592814371	169	19	100	4	1	167	786372	786538	MAG: Arcobacteraceae bacterium isolate 46883acb-a361-43ba-a1df-3f0e2b68257b genome assembly, chromosome: 1	blastn	42619	182	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
21456037	21456037	PRJNA168635_P_NODE_21797_length_177_cov_1.390625_g21381_i0	PRJNA168635	21797	177	1.390625	2.46140625	Campylobacter	194	Bacteria	Bacteria	226	8.329999999999998e-55	NTclustered	gi\|1590155399\|gb\|CP037747.1\|	28898	g21381	i0	89.944	264.966101694915	179	13	100	4	1	177	534586	534761	Campylobacter helveticus strain 2013D-9613 chromosome, complete genome	blastn	46899	226	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter helveticus
21456056	21456056	PRJNA168635_P_NODE_23477_length_172_cov_9.081301_g23061_i0	PRJNA168635	23477	172	9.081301	15.61983772	Arcobacteraceae	2808963	Bacteria	Bacteria	313	5.989999999999998e-81	NTclustered	gi\|1847324382\|gb\|CP053840.1\|	1054033	g23061	i0	99.419	396.52325581395303	172	1	100	0	1	172	2091786	2091615	Arcobacter venerupis strain LMG 26156 chromosome, complete genome	blastn	68202	313	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter venerupis
21456069	21456069	PRJNA168635_P_NODE_25357_length_169_cov_0.866667_g24941_i0	PRJNA168635	25357	169	0.866667	1.46466723	Campylobacter	194	Bacteria	Bacteria	108	2.97e-19	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g24941	i0	90.244	140.988165680473	82	8	49	0	11	92	28511	28430	Campylobacter showae genome assembly, plasmid: V	blastn	23827	108	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
21456155	21456155	PRJNA168635_P_NODE_4317_length_405_cov_3.129213_g3915_i0	PRJNA168635	4317	405	3.129213	12.67331265	Campylobacter	194	Bacteria	Bacteria	113	1.76e-20	NTclustered	gi\|1861380260\|gb\|CP053831.1\|	202	g3915	i0	80.69	54.6	145	28	36	0	47	191	608303	608447	Campylobacter mucosalis strain ATCC 43264 chromosome, complete genome	blastn	22113	113	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter mucosalis
21456192	21456192	PRJNA168635_P_NODE_7917_length_300_cov_18.370518_g7504_i0	PRJNA168635	7917	300	18.370518	55.111554	Arcobacteraceae	2808963	Bacteria	Bacteria	532	8.18e-147	NTclustered	gi\|1847339566\|gb\|CP053833.1\|	1054034	g7504	i0	99.658	336.256666666667	292	0	98	1	1	292	919214	919504	Arcobacter cloacae strain LMG 26153 chromosome, complete genome	blastn	100877	532	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter cloacae
22040996	22040996	PRJNA168635_P_NODE_16178_length_199_cov_1.533333_g15762_i0	PRJNA168635	16178	199	1.533333	3.05133267	Sulfurospirillum halorespirans	194424	Bacteria	Bacteria	237	4.44e-58	NTclustered	gi\|1063807422\|gb\|CP017111.1\|	1193502	g15762	i0	88.384	39.0201005025126	198	22	99	1	3	199	685170	684973	Sulfurospirillum halorespirans DSM 13726 chromosome, complete genome	blastn	7765	237	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum halorespirans
22731020	22731020	PRJNA168635_P_NODE_21518_length_177_cov_16.000000_g21102_i0	PRJNA168635	21518	177	16	28.32	Campylobacter	194	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g21102	i0	100	268.180790960452	177	0	100	0	1	177	31153	31329	Campylobacter showae genome assembly, plasmid: V	blastn	47468	327	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
24006282	24006282	PRJNA168635_P_NODE_32539_length_161_cov_3.383929_g32123_i0	PRJNA168635	32539	161	3.383929	5.44812569	Arcobacteraceae	2808963	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|34868921\|gb\|AY314755.1\|	28198	g32123	i0	100	123.496894409938	161	0	100	0	1	161	302	142	Arcobacter cryaerophilus isolate CCUG 17802 16S ribosomal RNA gene, partial sequence	blastn	19883	298	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
25280473	25280473	PRJNA168635_P_NODE_9500_length_270_cov_12.597285_g9085_i0	PRJNA168635	9500	270	12.597285	34.0126695	Arcobacteraceae	2808963	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g9085	i0	100	422.82962962963	270	0	100	0	1	270	1011502	1011233	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	114164	499	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii

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