metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
1172430	1172430	PRJNA682078_P_NODE_181441_length_274_cov_1.149254_g179664_i0	PRJNA682078	181441	274	1.149254	3.14895596	root	1	Root_unresolved	Root_unresolved	507	4.47e-139	NTclustered	gi\|1145145120\|gb\|KX686749.1\|	195	g179664	i0	100	101	274	0	100	0	1	274	46367	46640	Campylobacter coli strain Tx40 plasmid unnamed, complete sequence	blastn	27674	507	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
1938083	1938083	PRJNA682078_P_NODE_283022_length_242_cov_0.911243_g281245_i0	PRJNA682078	283022	242	0.911243	2.20520806	Helicobacter hepaticus	32025	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g281245	i0	98.347	1	242	4	100	0	1	242	596925	596684	Helicobacter hepaticus ATCC 51449, complete genome	blastn	242	425	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
2448558	2448558	PRJNA682078_P_NODE_263622_length_245_cov_0.895349_g261845_i0	PRJNA682078	263622	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g261845	i0	99.184	100.836734693878	245	2	100	0	1	245	556300	556056	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	24705	442	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
3213110	3213110	PRJNA682078_P_NODE_291343_length_241_cov_0.916667_g289566_i0	PRJNA682078	291343	241	0.916667	2.20916747	Helicobacter mastomyrinus	287948	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2727596528\|gb\|CP145316.1\|	287948	g289566	i0	99.585	1	241	1	100	0	1	241	416681	416921	Helicobacter mastomyrinus strain Hm-17 chromosome, complete genome	blastn	241	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter mastomyrinus
4490896	4490896	PRJNA682078_P_NODE_51484_length_478_cov_0.760494_g49714_i0	PRJNA682078	51484	478	0.760494	3.63516132	Helicobacter himalayensis	1591088	Bacteria	Bacteria	292	2.52e-74	NTclustered	gi\|1012282722\|gb\|CP014991.1\|	1591088	g49714	i0	80.25	21.6799163179916	400	70	83	7	82	478	1145841	1146234	Helicobacter himalayensis strain YS1, complete genome	blastn	10363	292	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter himalayensis
6276134	6276134	PRJNA682078_P_NODE_158125_length_288_cov_1.432558_g156348_i0	PRJNA682078	158125	288	1.432558	4.12576704	Campylobacter	194	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2151052516\|gb\|CP086657.1\|	195	g156348	i0	100	101	288	0	100	0	1	288	196252	196539	Campylobacter coli strain P4581 chromosome, complete genome	blastn	29088	532	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
6276900	6276900	PRJNA682078_P_NODE_228005_length_250_cov_1.322034_g226228_i0	PRJNA682078	228005	250	1.322034	3.305085	Aliarcobacter	2321111	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g226228	i0	98.8	39.844	250	3	100	0	1	250	345607	345358	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	9961	446	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
7551839	7551839	PRJNA682078_P_NODE_54886_length_463_cov_1.074359_g53115_i0	PRJNA682078	54886	463	1.074359	4.97428217	root	1	Root_unresolved	Root_unresolved	856	0	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g53115	i0	100	101.937365010799	463	0	100	0	1	463	1303958	1303496	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	47197	856	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
12140326	12140326	PRJNA682078_P_NODE_236290_length_249_cov_0.875000_g234513_i0	PRJNA682078	236290	249	0.875	2.17875	Helicobacter hepaticus	32025	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g234513	i0	100	1.8714859437751	249	0	100	0	1	249	568298	568050	Helicobacter hepaticus ATCC 51449, complete genome	blastn	466	460	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
12140868	12140868	PRJNA682078_P_NODE_258350_length_246_cov_0.890173_g256573_i0	PRJNA682078	258350	246	0.890173	2.18982558	Helicobacter hepaticus	32025	Bacteria	Bacteria	255	1.58e-63	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g256573	i0	87.783	1.85772357723577	221	23	89	4	28	246	1451469	1451251	Helicobacter hepaticus ATCC 51449, complete genome	blastn	457	255	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
13927474	13927474	PRJNA682078_P_NODE_284351_length_242_cov_0.911243_g282574_i0	PRJNA682078	284351	242	0.911243	2.20520806	Campylobacter	194	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2703256232\|gb\|CP148214.1\|	197	g282574	i0	100	100	242	0	100	0	1	242	1092330	1092089	Campylobacter jejuni strain Z1323CCJ0059 chromosome, complete genome	blastn	24200	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
14691112	14691112	PRJNA682078_P_NODE_284152_length_242_cov_0.911243_g282375_i0	PRJNA682078	284152	242	0.911243	2.20520806	Helicobacter hepaticus	32025	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g282375	i0	100	1	242	0	100	0	1	242	1200099	1199858	Helicobacter hepaticus ATCC 51449, complete genome	blastn	242	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
15202061	15202061	PRJNA682078_P_NODE_279072_length_243_cov_0.905882_g277295_i0	PRJNA682078	279072	243	0.905882	2.20129326	Campylobacter	194	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1100599896\|gb\|CP017859.1\|	197	g277295	i0	100	100	243	0	100	0	1	243	181244	181002	Campylobacter jejuni strain YQ2210, complete genome	blastn	24300	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
15962956	15962956	PRJNA682078_P_NODE_206213_length_259_cov_1.655914_g204436_i0	PRJNA682078	206213	259	1.655914	4.28881726	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|2620255116\|gb\|CP129949.1\|	2933791	g204436	i0	99.614	29.976833976834	259	1	100	0	1	259	823945	823687	Arcobacter cryaerophilus gv. pseudocryaerophilus strain DSM 115956 chromosome, complete genome	blastn	7764	473	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
18513857	18513857	PRJNA682078_P_NODE_270875_length_244_cov_0.900585_g269098_i0	PRJNA682078	270875	244	0.900585	2.1974274	Helicobacter hepaticus	32025	Bacteria	Bacteria	449	6.68e-122	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g269098	i0	100	2.23770491803279	243	0	99	0	1	243	792104	792346	Helicobacter hepaticus ATCC 51449, complete genome	blastn	546	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
20299293	20299293	PRJNA682078_P_NODE_223456_length_251_cov_0.865169_g221679_i0	PRJNA682078	223456	251	0.865169	2.17157419	Aliarcobacter	2321111	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g221679	i0	99.203	3	251	2	100	0	1	251	1809793	1810043	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	753	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
21060565	21060565	PRJNA682078_P_NODE_120317_length_325_cov_1.222222_g118540_i0	PRJNA682078	120317	325	1.222222	3.9722215	Helicobacter mastomyrinus	287948	Bacteria	Bacteria	601	2.4199999999999993e-167	NTclustered	gi\|2727596528\|gb\|CP145316.1\|	287948	g118540	i0	100	48.8369230769231	325	0	100	0	1	325	1130002	1129678	Helicobacter mastomyrinus strain Hm-17 chromosome, complete genome	blastn	15872	601	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter mastomyrinus
24123508	24123508	PRJNA682078_P_NODE_113039_length_334_cov_1.099617_g111262_i0	PRJNA682078	113039	334	1.099617	3.67272078	Bacteria	2	Bacteria	Bacteria	612	1.15e-170	NTclustered	gi\|2290299522\|gb\|CP103055.1\|	195	g111262	i0	99.701	100.74251497006	334	1	100	0	1	334	741451	741118	Campylobacter coli strain YC3-24 chromosome, complete genome	blastn	33648	612	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
24125401	24125401	PRJNA682078_P_NODE_283019_length_242_cov_0.911243_g281242_i0	PRJNA682078	283019	242	0.911243	2.20520806	Campylobacter	194	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2452071706\|gb\|CP118900.1\|	197	g281242	i0	100	100	242	0	100	0	1	242	1198555	1198796	Campylobacter jejuni strain BDS5 chromosome, complete genome	blastn	24200	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25398222	25398222	PRJNA682078_P_NODE_126400_length_318_cov_1.257143_g124623_i0	PRJNA682078	126400	318	1.257143	3.99771474	Bacteria	2	Bacteria	Bacteria	588	1.84e-163	NTclustered	gi\|2290299522\|gb\|CP103055.1\|	195	g124623	i0	100	101.694968553459	318	0	100	0	1	318	741784	741467	Campylobacter coli strain YC3-24 chromosome, complete genome	blastn	32339	588	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli

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