metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA681822" 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
656149	656149	PRJNA681822_P_NODE_479181_length_241_cov_0.916667_g477691_i0	PRJNA681822	479181	241	0.916667	2.20916747	Campylobacter concisus	199	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g477691	i0	98.34	17.9377593360996	241	4	100	0	1	241	556465	556705	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	4323	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
1930595	1930595	PRJNA681822_P_NODE_340522_length_263_cov_1.610526_g339033_i0	PRJNA681822	340522	263	1.610526	4.23568338	Nitratiruptor sp. YY09-18	2724901	Bacteria	Bacteria	78.7	3.96e-10	NTclustered	gi\|1941658040\|dbj\|AP023065.1\|	2724901	g339033	i0	87.879	0.250950570342205	66	8	25	0	5	70	769971	769906	Nitratiruptor sp. YY09-18 DNA, complete genome	blastn	66	78.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitratiruptor	Nitratiruptor sp. YY09-18
3205507	3205507	PRJNA681822_P_NODE_351663_length_260_cov_1.411765_g350174_i0	PRJNA681822	351663	260	1.411765	3.670589	Campylobacter concisus	199	Bacteria	Bacteria	451	1.9999999999999998e-122	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g350174	i0	98.077	12.3192307692308	260	3	100	1	1	260	748378	748121	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	3203	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
5759025	5759025	PRJNA681822_P_NODE_410465_length_248_cov_1.668571_g408976_i0	PRJNA681822	410465	248	1.668571	4.13805608	Campylobacter concisus	199	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g408976	i0	100	5	248	0	100	0	1	248	91683	91436	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	1240	459	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
5759191	5759191	PRJNA681822_P_NODE_423005_length_247_cov_0.885057_g421516_i0	PRJNA681822	423005	247	0.885057	2.18609079	Campylobacter concisus	199	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1938730527\|gb\|CP049274.1\|	199	g421516	i0	99.595	22.7570850202429	247	1	100	0	1	247	483741	483987	Campylobacter concisus strain P10CDO-S2 chromosome, complete genome	blastn	5621	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8309358	8309358	PRJNA681822_P_NODE_469807_length_242_cov_0.911243_g468317_i0	PRJNA681822	469807	242	0.911243	2.20520806	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2922053193\|gb\|CP182894.1\|	1355374	g468317	i0	100	0.231404958677686	28	0	12	0	193	220	651913	651886	Aliarcobacter lanthieri strain BNI-4366 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
10099614	10099614	PRJNA681822_P_NODE_452628_length_244_cov_0.900585_g451138_i0	PRJNA681822	452628	244	0.900585	2.1974274	Campylobacter	194	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1935893765\|gb\|CP049234.1\|	199	g451138	i0	98.77	17.8729508196721	244	3	100	0	1	244	704329	704086	Campylobacter concisus strain P15UCO-S2 chromosome, complete genome	blastn	4361	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12135639	12135639	PRJNA681822_P_NODE_474050_length_242_cov_0.911243_g472560_i0	PRJNA681822	474050	242	0.911243	2.20520806	Campylobacter showae	204	Bacteria	Bacteria	355	1.48e-93	NTclustered	gi\|1483583494\|emb\|LT631418.1\|	204	g472560	i0	94.017	5.80165289256198	234	14	97	0	1	234	36405	36172	Campylobacter showae genome assembly, chromosome: I	blastn	1404	355	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
13407957	13407957	PRJNA681822_P_NODE_296371_length_275_cov_1.460396_g294882_i0	PRJNA681822	296371	275	1.460396	4.016089	Campylobacter concisus	199	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|1063302220\|gb\|CP000792.2\|	360104	g294882	i0	99.273	15.6181818181818	275	2	100	0	1	275	802185	802459	Campylobacter concisus 13826 chromosome, complete genome	blastn	4295	497	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
13408874	13408874	PRJNA681822_P_NODE_373911_length_253_cov_1.711111_g372422_i0	PRJNA681822	373911	253	1.711111	4.32911083	Campylobacter rectus	203	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g372422	i0	98.024	13.2213438735178	253	5	100	0	1	253	976812	976560	Campylobacter rectus strain ATCC 33238, complete genome	blastn	3345	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
14682552	14682552	PRJNA681822_P_NODE_247412_length_287_cov_1.425234_g245923_i0	PRJNA681822	247412	287	1.425234	4.09042158	Helicobacter pylori	210	Bacteria	Bacteria	231	3.1799999999999997e-56	NTclustered	gi\|2814758776\|gb\|PQ423797.1\|	210	g245923	i0	90.805	72.1881533101045	174	15	60	1	111	283	18177	18004	Helicobacter pylori strain TER81 plasmid pTER81, complete sequence	blastn	20718	231	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
19780370	19780370	PRJNA681822_P_NODE_251916_length_286_cov_1.366197_g250427_i0	PRJNA681822	251916	286	1.366197	3.90732342	Campylobacter concisus	199	Bacteria	Bacteria	473	4.7599999999999997e-129	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g250427	i0	96.503	11.979020979021	286	10	100	0	1	286	194587	194872	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	3426	473	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22331498	22331498	PRJNA681822_P_NODE_301758_length_274_cov_1.039801_g300269_i0	PRJNA681822	301758	274	1.039801	2.84905474	Campylobacter concisus	199	Bacteria	Bacteria	424	4.63e-114	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g300269	i0	94.526	17.956204379562	274	15	100	0	1	274	1512881	1512608	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	4920	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22332027	22332027	PRJNA681822_P_NODE_348458_length_261_cov_1.313830_g346969_i0	PRJNA681822	348458	261	1.31383	3.4290963	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	444	3.36e-120	NTclustered	gi\|2620255116\|gb\|CP129949.1\|	2933791	g346969	i0	97.318	29.0229885057471	261	7	100	0	1	261	216887	217147	Arcobacter cryaerophilus gv. pseudocryaerophilus strain DSM 115956 chromosome, complete genome	blastn	7575	444	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
24881778	24881778	PRJNA681822_P_NODE_424860_length_247_cov_0.885057_g423371_i0	PRJNA681822	424860	247	0.885057	2.18609079	Campylobacter concisus	199	Bacteria	Bacteria	329	9.21e-86	NTclustered	gi\|1938728373\|gb\|CP049272.1\|	199	g423371	i0	90.688	10.080971659919	247	23	100	0	1	247	1505159	1504913	Campylobacter concisus strain P27CDO-S2 chromosome, complete genome	blastn	2490	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus

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