metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
552851	552851	PRJNA564013_P_NODE_80621_length_451_cov_11.289744_g77795_i0	PRJNA564013	80621	451	11.289744	50.91674544	Arcobacter sp. 15-2	3374109	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2862971141\|dbj\|AP038804.1\|	3374109	g77795	i0	100	0.0620842572062084	28	0	6	0	8	35	542135	542162	Arcobacter sp. 15-2 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 15-2
3099871	3099871	PRJNA564013_P_NODE_210383_length_296_cov_5.429787_g207532_i0	PRJNA564013	210383	296	5.429787	16.07216952	Campylobacter showae	204	Bacteria	Bacteria	425	1.41e-114	NTclustered	gi\|1483583525\|emb\|LT631449.1\|	204	g207532	i0	95.833	28.2364864864865	264	10	89	1	16	278	1882574	1882837	Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I	blastn	8358	425	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
3684426	3684426	PRJNA564013_P_NODE_52803_length_546_cov_7.051546_g50040_i0	PRJNA564013	52803	546	7.051546	38.50144116	Campylobacter	194	Bacteria	Bacteria	69.4	5.33e-7	NTclustered	gi\|2076393500\|gb\|CP059366.1\|	201	g50040	i0	92	1.23260073260073	50	3	9	1	490	538	203637	203588	Campylobacter lari strain 2015D-0005 chromosome, complete genome	blastn	673	69.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
4380169	4380169	PRJNA564013_P_NODE_72084_length_476_cov_5.207229_g69270_i0	PRJNA564013	72084	476	5.207229	24.78641004	Campylobacter concisus	199	Bacteria	Bacteria	782	0	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g69270	i0	99.08	56.8403361344538	435	4	91	0	24	458	1890443	1890877	Campylobacter concisus strain RMIT-O23 chromosome	blastn	27056	782	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6926069	6926069	PRJNA564013_P_NODE_167206_length_336_cov_5.029091_g164356_i0	PRJNA564013	167206	336	5.029091	16.89774576	Campylobacter showae	204	Bacteria	Bacteria	435	2.69e-117	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g164356	i0	94.056	7.68452380952381	286	17	85	0	26	311	191362	191647	Campylobacter showae genome assembly, chromosome: I	blastn	2582	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6930627	6930627	PRJNA564013_P_NODE_63766_length_503_cov_7.776018_g60965_i0	PRJNA564013	63766	503	7.776018	39.11337054	Campylobacter lari	201	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2878661658\|gb\|CP176590.1\|	201	g60965	i0	100	0.166998011928429	28	0	6	0	22	49	1431557	1431530	Campylobacter lari strain S4:11 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
7509815	7509815	PRJNA564013_P_NODE_192926_length_313_cov_1.936508_g190075_i0	PRJNA564013	192926	313	1.936508	6.06127004	Helicobacter	209	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2157106196\|dbj\|AP025196.1\|	213	g190075	i0	100	0.178913738019169	28	0	9	0	274	301	981819	981792	Helicobacter cinaedi T36 DNA, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cinaedi
8200254	8200254	PRJNA564013_P_NODE_14247_length_947_cov_5.782167_g12297_i0	PRJNA564013	14247	947	5.782167	54.75712149	Campylobacter gracilis	824	Bacteria	Bacteria	1498	0	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g12297	i0	96.571	1.90918690601901	904	31	95	0	22	925	1211678	1212581	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	1808	1498	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
8204326	8204326	PRJNA564013_P_NODE_334247_length_206_cov_9.641379_g331395_i0	PRJNA564013	334247	206	9.641379	19.86124074	Campylobacter rectus	203	Bacteria	Bacteria	329	7.43e-86	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g331395	i0	98.913	14.1165048543689	184	2	89	0	1	184	2090212	2090029	Campylobacter rectus strain ATCC 33238, complete genome	blastn	2908	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
8204468	8204468	PRJNA564013_P_NODE_341847_length_203_cov_2.450704_g338995_i0	PRJNA564013	341847	203	2.450704	4.97492912	Campylobacter concisus	199	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1938726479\|gb\|CP049270.1\|	199	g338995	i0	100	5.94088669950739	203	0	100	0	1	203	1478709	1478507	Campylobacter concisus strain P26UCO-S2 chromosome, complete genome	blastn	1206	375	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10060845	10060845	PRJNA564013_P_NODE_267588_length_247_cov_7.989247_g264736_i0	PRJNA564013	267588	247	7.989247	19.73344009	Arcobacteraceae	2808963	Bacteria	Bacteria	414	2.47e-111	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g264736	i0	97.531	2.94331983805668	243	5	98	1	6	247	1623907	1624149	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	727	414	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
11336515	11336515	PRJNA564013_P_NODE_97589_length_414_cov_5.354108_g94755_i0	PRJNA564013	97589	414	5.354108	22.16600712	root	1	Root_unresolved	Root_unresolved	688	0	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g94755	i0	99.733	90.5797101449275	375	1	91	0	23	397	1303456	1303082	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	37500	688	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
14580438	14580438	PRJNA564013_P_NODE_344912_length_202_cov_1.134752_g342060_i0	PRJNA564013	344912	202	1.134752	2.29219904	Campylobacter concisus	199	Bacteria	Bacteria	303	4.4e-78	NTclustered	gi\|1938721720\|gb\|CP049266.1\|	199	g342060	i0	96.703	12.4950495049505	182	6	90	0	6	187	308864	308683	Campylobacter concisus strain P1CDO3 chromosome, complete genome	blastn	2524	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15159511	15159511	PRJNA564013_P_NODE_119852_length_383_cov_2.903727_g117008_i0	PRJNA564013	119852	383	2.903727	11.12127441	Helicobacter	209	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2642764630\|gb\|CP078833.1\|	210	g117008	i0	100	0.477806788511749	29	0	8	0	342	370	56305	56277	Helicobacter pylori strain HpGP-JAP-102 chromosome, complete genome	blastn	183	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
15851854	15851854	PRJNA564013_P_NODE_213833_length_293_cov_3.965517_g210982_i0	PRJNA564013	213833	293	3.965517	11.61896481	Campylobacter showae	204	Bacteria	Bacteria	477	3.78e-130	NTclustered	gi\|1483583506\|emb\|LT631430.1\|	204	g210982	i0	98.519	4.60750853242321	270	4	92	0	24	293	32050	31781	Campylobacter showae genome assembly, plasmid: VI	blastn	1350	477	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
15854956	15854956	PRJNA564013_P_NODE_46253_length_577_cov_2.717054_g43509_i0	PRJNA564013	46253	577	2.717054	15.67740158	Campylobacter jejuni	197	Bacteria	Bacteria	553	1.2799999999999995e-152	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g43509	i0	84.854	94.9740034662045	548	83	95	0	30	577	699945	699398	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	54800	553	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
17709391	17709391	PRJNA564013_P_NODE_116554_length_387_cov_1.312883_g113710_i0	PRJNA564013	116554	387	1.312883	5.08085721	Arcobacteraceae	2808963	Bacteria	Bacteria	60.2	2.21e-4	NTclustered	gi\|1817415496\|gb\|CP026656.1\|	28198	g113710	i0	91.111	0.602067183462532	45	3	11	1	142	185	359527	359571	Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome	blastn	233	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
20952148	20952148	PRJNA564013_P_NODE_268317_length_247_cov_2.344086_g265465_i0	PRJNA564013	268317	247	2.344086	5.78989242	Campylobacter showae	204	Bacteria	Bacteria	388	1.5e-103	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g265465	i0	95.142	11.9595141700405	247	10	100	2	1	247	513632	513388	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2954	388	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
21535175	21535175	PRJNA564013_P_NODE_72137_length_476_cov_3.440964_g69323_i0	PRJNA564013	72137	476	3.440964	16.37898864	root	1	Root_unresolved	Root_unresolved	425	2.37e-114	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g69323	i0	82.773	100	476	82	100	0	1	476	699944	699469	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	47600	425	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
23502623	23502623	PRJNA564013_P_NODE_277019_length_241_cov_1.444444_g274167_i0	PRJNA564013	277019	241	1.444444	3.48111004	Campylobacter gracilis	824	Bacteria	Bacteria	363	8.819999999999997e-96	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g274167	i0	94.85	1.93360995850622	233	10	96	2	10	241	1794651	1794420	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	466	363	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
23504774	23504774	PRJNA564013_P_NODE_56039_length_532_cov_23.666667_g53261_i0	PRJNA564013	56039	532	23.666667	125.90666844	Campylobacter concisus	199	Bacteria	Bacteria	843	0	NTclustered	gi\|1938728373\|gb\|CP049272.1\|	199	g53261	i0	98.737	40.0845864661654	475	4	89	2	24	498	1540480	1540952	Campylobacter concisus strain P27CDO-S2 chromosome, complete genome	blastn	21325	843	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24085030	24085030	PRJNA564013_P_NODE_66479_length_494_cov_1.658199_g63674_i0	PRJNA564013	66479	494	1.658199	8.19150306	root	1	Root_unresolved	Root_unresolved	518	3.96e-142	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g63674	i0	85.832	98.6072874493927	487	69	99	0	4	490	699792	699306	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	48712	518	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
24772718	24772718	PRJNA564013_P_NODE_10400_length_1078_cov_17.085546_g8720_i0	PRJNA564013	10400	1078	17.085546	184.18218588	Campylobacter showae	204	Bacteria	Bacteria	1836	0	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g8720	i0	97.926	82.5315398886827	1061	21	98	1	2	1062	50592	51651	Campylobacter showae genome assembly, chromosome: I	blastn	88969	1836	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae

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