metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
669543	669543	PRJNA690124_P_NODE_45401_length_251_cov_0.876404_g45035_i0	PRJNA690124	45401	251	0.876404	2.19977404	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g45035	i0	88.446	28.8326693227092	251	29	100	0	1	251	340747	340997	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	7237	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
669760	669760	PRJNA690124_P_NODE_54941_length_243_cov_0.917647_g54575_i0	PRJNA690124	54941	243	0.917647	2.22988221	Arcobacter ellisii	913109	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g54575	i0	99.588	17.7283950617284	243	1	100	0	1	243	1523923	1524165	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	4308	444	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
1178678	1178678	PRJNA690124_P_NODE_49301_length_248_cov_0.891429_g48935_i0	PRJNA690124	49301	248	0.891429	2.21074392	Sulfurospirillum	57665	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g48935	i0	84.264	28.8427419354839	197	31	79	0	43	239	378748	378552	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	7153	193	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
1945303	1945303	PRJNA690124_P_NODE_33482_length_287_cov_1.116822_g33116_i0	PRJNA690124	33482	287	1.116822	3.20527914	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	226	1.48e-54	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g33116	i0	80.836	1	287	55	100	0	1	287	1619602	1619888	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	287	226	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
3220457	3220457	PRJNA690124_P_NODE_48063_length_249_cov_0.886364_g47697_i0	PRJNA690124	48063	249	0.886364	2.20704636	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g47697	i0	92.369	2	249	19	100	0	1	249	1649850	1650098	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	498	355	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
3730015	3730015	PRJNA690124_P_NODE_10743_length_490_cov_2.410072_g10378_i0	PRJNA690124	10743	490	2.410072	11.8093528	Sulfuricurvum	286130	Bacteria	Bacteria	761	0	NTclustered	gi\|470487282\|ref\|NR_076811.1\|	148813	g10378	i0	94.694	325.340816326531	490	26	100	0	1	490	514	25	Sulfuricurvum kujiense strain YK-1 23S ribosomal RNA gene, complete sequence	blastn	159417	761	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum kujiense
5773191	5773191	PRJNA690124_P_NODE_48985_length_248_cov_0.891429_g48619_i0	PRJNA690124	48985	248	0.891429	2.21074392	Sulfurospirillum sp. 'SP'	3023479	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|2591886793\|gb\|CP118374.1\|	3023479	g48619	i0	90.612	0.987903225806452	245	23	99	0	1	245	146723	146967	Sulfurospirillum sp. 'SP' plasmid pSulSP, complete sequence	blastn	245	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. 'SP'
8322403	8322403	PRJNA690124_P_NODE_34247_length_284_cov_1.109005_g33881_i0	PRJNA690124	34247	284	1.109005	3.1495742	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	172	1.93e-38	NTclustered	gi\|1679706893\|gb\|CP021072.1\|	1032070	g33881	i0	86.164	1.11971830985915	159	22	56	0	118	276	634380	634222	Arcobacter cryaerophilus ATCC 43158 strain LMG 9904 genome	blastn	318	172	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
11381876	11381876	PRJNA690124_P_NODE_27469_length_314_cov_1.941909_g27103_i0	PRJNA690124	27469	314	1.941909	6.09759426	Aliarcobacter	2321111	Bacteria	Bacteria	370	7.14e-98	NTclustered	gi\|1847318617\|gb\|CP053839.1\|	1355374	g27103	i0	87.975	230.471337579618	316	35	100	3	1	314	802067	801753	Aliarcobacter lanthieri strain LMG 28516 chromosome, complete genome	blastn	72368	370	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
12148588	12148588	PRJNA690124_P_NODE_35490_length_279_cov_1.310680_g35124_i0	PRJNA690124	35490	279	1.31068	3.6567972	Arcobacter venerupis	1054033	Bacteria	Bacteria	246	1.1e-60	NTclustered	gi\|1847324382\|gb\|CP053840.1\|	1054033	g35124	i0	82.671	22.2222222222222	277	48	99	0	3	279	1105763	1106039	Arcobacter venerupis strain LMG 26156 chromosome, complete genome	blastn	6200	246	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter venerupis
13423355	13423355	PRJNA690124_P_NODE_43711_length_253_cov_0.866667_g43345_i0	PRJNA690124	43711	253	0.866667	2.19266751	Arcobacter ellisii	913109	Bacteria	Bacteria	196	1e-45	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g43345	i0	81.328	0.952569169960474	241	45	95	0	13	253	960333	960093	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	241	196	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
13932723	13932723	PRJNA690124_P_NODE_55711_length_242_cov_0.923077_g55345_i0	PRJNA690124	55711	242	0.923077	2.23384634	Arcobacteraceae	2808963	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2317589584\|gb\|CP099557.1\|	28198	g55345	i0	100	8	242	0	100	0	1	242	92943	93184	Aliarcobacter cryaerophilus strain ICDCAC48 plasmid pCNAC48, complete sequence	blastn	1936	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
14697971	14697971	PRJNA690124_P_NODE_22792_length_342_cov_1.159851_g22426_i0	PRJNA690124	22792	342	1.159851	3.96669042	Arcobacter acticola	1849015	Bacteria	Bacteria	627	4.22e-175	NTclustered	gi\|1845963640\|gb\|CP042652.1\|	1849015	g22426	i0	99.708	22.9473684210526	342	1	100	0	1	342	1152892	1153233	Arcobacter acticola strain KCTC 52212 chromosome, complete genome	blastn	7848	627	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter acticola
14698437	14698437	PRJNA690124_P_NODE_44412_length_252_cov_0.871508_g44046_i0	PRJNA690124	44412	252	0.871508	2.19620016	Arcobacter suis	1278212	Bacteria	Bacteria	252	2.1e-62	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g44046	i0	87.907	1.84920634920635	215	25	85	1	38	252	201964	202177	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	466	252	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
15972264	15972264	PRJNA690124_P_NODE_46613_length_250_cov_0.881356_g46247_i0	PRJNA690124	46613	250	0.881356	2.20339	Arcobacter cloacae	1054034	Bacteria	Bacteria	206	1.6399999999999998e-48	NTclustered	gi\|1847339566\|gb\|CP053833.1\|	1054034	g46247	i0	84.541	0.828	207	32	83	0	39	245	2362270	2362476	Arcobacter cloacae strain LMG 26153 chromosome, complete genome	blastn	207	206	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter cloacae
15972346	15972346	PRJNA690124_P_NODE_50153_length_247_cov_0.896552_g49787_i0	PRJNA690124	50153	247	0.896552	2.21448344	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	246	9.54e-61	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g49787	i0	84.677	2.0080971659919	248	37	100	1	1	247	2299311	2299064	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	496	246	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
17247448	17247448	PRJNA690124_P_NODE_46814_length_250_cov_0.881356_g46448_i0	PRJNA690124	46814	250	0.881356	2.20339	Arcobacter ellisii	913109	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g46448	i0	100	7.92	250	0	100	0	1	250	2423821	2424070	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	1980	462	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
18521149	18521149	PRJNA690124_P_NODE_25895_length_323_cov_1.364000_g25529_i0	PRJNA690124	25895	323	1.364	4.40572	Wolinella succinogenes	844	Bacteria	Bacteria	593	4.0199999999999986e-165	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g25529	i0	100	168.981424148607	321	0	99	0	3	323	335676	335996	Wolinella succinogenes, complete genome; segment 4/7	blastn	54581	593	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
18521576	18521576	PRJNA690124_P_NODE_45615_length_251_cov_0.876404_g45249_i0	PRJNA690124	45615	251	0.876404	2.19977404	Sulfuricurvum kujiense	148813	Bacteria	Bacteria	165	2.8e-36	NTclustered	gi\|313153990\|gb\|CP002355.1\|	709032	g45249	i0	78.824	1.01593625498008	255	47	100	7	1	251	1839286	1839537	Sulfuricurvum kujiense DSM 16994 chromosome, complete genome	blastn	255	165	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum kujiense
19030367	19030367	PRJNA690124_P_NODE_48015_length_249_cov_0.886364_g47649_i0	PRJNA690124	48015	249	0.886364	2.20704636	Arcobacteraceae	2808963	Bacteria	Bacteria	287	5.670000000000001e-73	NTclustered	gi\|1861369602\|gb\|CP054051.1\|	255507	g47649	i0	87.55	98.1847389558233	249	29	99	2	2	249	579129	579376	Aliarcobacter cibarius strain LMG 21996 chromosome, complete genome	blastn	24448	289	0.993079584775087	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cibarius
19796572	19796572	PRJNA690124_P_NODE_50936_length_246_cov_0.901734_g50570_i0	PRJNA690124	50936	246	0.901734	2.21826564	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	78.7	3.67e-10	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g50570	i0	84.81	0.321138211382114	79	10	32	2	169	246	92279	92202	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	79	78.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
21072004	21072004	PRJNA690124_P_NODE_47077_length_250_cov_0.881356_g46711_i0	PRJNA690124	47077	250	0.881356	2.20339	Candidatus Sulfurimonas marisnigri	2740405	Bacteria	Bacteria	209	1.27e-49	NTclustered	gi\|1929274859\|gb\|CP054493.1\|	2740405	g46711	i0	82.906	0.936	234	38	93	2	3	235	731442	731674	Candidatus Sulfurimonas marisnigri strain SoZ1 chromosome, complete genome	blastn	234	209	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Candidatus Sulfurimonas marisnigri
23621934	23621934	PRJNA690124_P_NODE_24379_length_332_cov_1.204633_g24013_i0	PRJNA690124	24379	332	1.204633	3.99938156	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	128	5.0499999999999995e-25	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g24013	i0	80.723	0.5	166	30	50	2	165	329	1220758	1220922	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	166	128	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
23622512	23622512	PRJNA690124_P_NODE_51099_length_246_cov_0.901734_g50733_i0	PRJNA690124	51099	246	0.901734	2.21826564	Candidatus Sulfuricurvum sp. RIFRC-1	1249480	Bacteria	Bacteria	167	7.61e-37	NTclustered	gi\|410994849\|gb\|CP003920.1\|	1249480	g50733	i0	79.184	0.995934959349594	245	47	99	4	3	245	2176193	2175951	Candidatus Sulfuricurvum sp. RIFRC-1, complete genome	blastn	245	167	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Candidatus Sulfuricurvum sp. RIFRC-1
24895589	24895589	PRJNA690124_P_NODE_39060_length_266_cov_1.222798_g38694_i0	PRJNA690124	39060	266	1.222798	3.25264268	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|346681545\|gb\|JF740659.1\|	120858	g38694	i0	97.744	302.466165413534	266	6	100	0	1	266	369	104	Uncultured epsilon proteobacterium clone 23S_S3M_192 23S ribosomal RNA gene, partial sequence	blastn	80456	459	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium

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