metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA498309" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA498309" 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
1756194	1756194	PRJNA498309_P_NODE_66442_length_299_cov_8.839695_g64294_i0	PRJNA498309	66442	299	8.839695	26.43068805	Campylobacter ureolyticus	827	Bacteria	Bacteria	503	6.389999999999998e-138	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g64294	i0	99.281	3.7190635451505	278	2	93	0	1	278	180960	181237	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	1112	503	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
2384948	2384948	PRJNA498309_S_NODE_17862_length_507_cov_14.218220_g15805_i0	PRJNA498309	17862	507	14.21822	72.0863754	Campylobacter	194	Bacteria	Bacteria	872	0	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g15805	i0	99.582	247.130177514793	479	1	94	1	7	484	29365	29843	Campylobacter showae genome assembly, plasmid: V	blastn	125295	872	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
3659640	3659640	PRJNA498309_P_NODE_116643_length_160_cov_3.365854_g114494_i0	PRJNA498309	116643	160	3.365854	5.3853664	Campylobacter	194	Bacteria	Bacteria	294	2e-75	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g114494	i0	100	236.875	159	0	99	0	1	159	43224	43382	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	37900	296	0.993243243243243	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
6211759	6211759	PRJNA498309_P_NODE_102605_length_188_cov_1.629139_g100456_i0	PRJNA498309	102605	188	1.629139	3.06278132	Pseudomonadati	3379134	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g100456	i0	100	100	188	0	100	0	1	188	701086	701273	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	18800	348	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
7486437	7486437	PRJNA498309_P_NODE_109726_length_173_cov_2.176471_g107577_i0	PRJNA498309	109726	173	2.176471	3.76529483	root	1	Root_unresolved	Root_unresolved	73.1	1.12e-8	NTclustered	gi\|1721134175\|emb\|LR698977.1\|	198	g107577	i0	100	40.6011560693642	39	0	23	0	135	173	496360	496322	Campylobacter hyointestinalis isolate MGYG-HGUT-02307 genome assembly, chromosome: 1	blastn	7024	73.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hyointestinalis
8761850	8761850	PRJNA498309_P_NODE_46007_length_399_cov_3.613260_g43873_i0	PRJNA498309	46007	399	3.61326	14.4169074	Bacteria	2	Bacteria	Bacteria	665	0	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g43873	i0	100	18.0401002506266	360	0	90	0	23	382	5256	4897	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	7198	665	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
10683595	10683595	PRJNA498309_P_NODE_100029_length_194_cov_1.636943_g97880_i0	PRJNA498309	100029	194	1.636943	3.17566942	Campylobacter showae	204	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g97880	i0	100	263.010309278351	194	0	100	0	1	194	390358	390551	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	51024	359	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11960045	11960045	PRJNA498309_P_NODE_74830_length_268_cov_2.662338_g72681_i0	PRJNA498309	74830	268	2.662338	7.13506584	Helicobacter canis	29419	Bacteria	Bacteria	457	4.45e-124	NTclustered	gi\|50957149\|gb\|AY596234.1\|	29419	g72681	i0	100	126.276119402985	247	0	92	0	22	268	799	1045	Helicobacter canis strain ATCC 51401 23S ribosomal RNA gene, partial sequence	blastn	33842	457	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
12587965	12587965	PRJNA498309_P_NODE_64530_length_307_cov_8.203704_g62382_i0	PRJNA498309	64530	307	8.203704	25.18537128	root	1	Root_unresolved	Root_unresolved	514	3.04e-141	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g62382	i0	99.298	106.413680781759	285	0	92	1	25	307	315681	315965	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	32669	514	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
14509861	14509861	PRJNA498309_P_NODE_59692_length_329_cov_2.630137_g57544_i0	PRJNA498309	59692	329	2.630137	8.65315073	Arcobacter cloacae	1054034	Bacteria	Bacteria	523	5.459999999999998e-144	NTclustered	gi\|1847339566\|gb\|CP053833.1\|	1054034	g57544	i0	97.394	7.09726443768997	307	8	93	0	1	307	1938482	1938788	Arcobacter cloacae strain LMG 26153 chromosome, complete genome	blastn	2335	523	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter cloacae
15136423	15136423	PRJNA498309_P_NODE_102152_length_189_cov_1.723684_g100003_i0	PRJNA498309	102152	189	1.723684	3.25776276	Pseudomonadati	3379134	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g100003	i0	100	100	189	0	100	0	1	189	701270	701458	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	18900	350	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
15136828	15136828	PRJNA498309_P_NODE_37852_length_452_cov_5.655422_g35782_i0	PRJNA498309	37852	452	5.655422	25.56250744	Campylobacter	194	Bacteria	Bacteria	736	0	NTclustered	gi\|470482328\|ref\|NR_076526.1\|	76517	g35782	i0	96.026	257.464601769911	453	17	100	1	1	452	1664	1212	Campylobacter hominis strain CH001A 23S ribosomal RNA gene, complete sequence	blastn	116374	736	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
16411598	16411598	PRJNA498309_P_NODE_52733_length_362_cov_2.784615_g50585_i0	PRJNA498309	52733	362	2.784615	10.0803063	Campylobacter	194	Bacteria	Bacteria	669	0	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g50585	i0	100	243.370165745856	362	0	100	0	1	362	29498	29859	Campylobacter showae genome assembly, plasmid: V	blastn	88100	669	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
17686631	17686631	PRJNA498309_P_NODE_45934_length_399_cov_49.049724_g43800_i0	PRJNA498309	45934	399	49.049724	195.70839876	Helicobacter	209	Bacteria	Bacteria	691	0	NTclustered	gi\|50957150\|gb\|AY596235.1\|	29419	g43800	i0	100	128.71679197995	374	0	94	0	1	374	1028	1401	Helicobacter canis strain ATCC 51402 23S ribosomal RNA gene, partial sequence	blastn	51358	691	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis

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