metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
2928217	2928217	PRJNA312107_P_NODE_20963_length_167_cov_0.881356_g20797_i0	PRJNA312107	20963	167	0.881356	1.47186452	Campylobacter ureolyticus	827	Bacteria	Bacteria	300	4.53e-77	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g20797	i0	98.817	3.03592814371257	169	0	100	1	1	167	849175	849343	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	507	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
7441562	7441562	PRJNA312107_P_NODE_17406_length_175_cov_1.238095_g17240_i0	PRJNA312107	17406	175	1.238095	2.16666625	Campylobacter	194	Bacteria	Bacteria	311	2.2e-80	NTclustered	gi\|1861376917\|gb\|CP053828.1\|	91353	g17240	i0	98.851	237.965714285714	174	2	99	0	2	175	360504	360331	Campylobacter hyointestinalis subsp. lawsonii strain CHY5 chromosome, complete genome	blastn	41644	311	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hyointestinalis
13131366	13131366	PRJNA312107_P_NODE_22231_length_166_cov_0.888889_g22065_i0	PRJNA312107	22231	166	0.888889	1.47555574	Campylobacter ureolyticus	827	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g22065	i0	100	3	166	0	100	0	1	166	1311987	1312152	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	498	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
13817033	13817033	PRJNA312107_P_NODE_23371_length_164_cov_1.678261_g23205_i0	PRJNA312107	23371	164	1.678261	2.75234804	Aliarcobacter	2321111	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g23205	i0	100	370.94512195122	164	0	100	0	1	164	141	304	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	60835	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
16366094	16366094	PRJNA312107_P_NODE_17093_length_177_cov_0.765625_g16927_i0	PRJNA312107	17093	177	0.765625	1.35515625	Campylobacter	194	Bacteria	Bacteria	316	4.799999999999999e-82	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g16927	i0	98.87	249.045197740113	177	2	100	0	1	177	1034197	1034373	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	44081	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17641271	17641271	PRJNA312107_P_NODE_16374_length_181_cov_1.181818_g16208_i0	PRJNA312107	16374	181	1.181818	2.13909058	Campylobacterales	213849	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|434932\|emb\|X67760.1\|	202	g16208	i0	100	365.795580110497	181	0	100	0	1	181	583	403	C.mucosalis 23S rRNA gene	blastn	66209	335	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter mucosalis
21465359	21465359	PRJNA312107_P_NODE_25637_length_162_cov_0.920354_g25471_i0	PRJNA312107	25637	162	0.920354	1.49097348	Arcobacteraceae	2808963	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g25471	i0	98.765	399.339506172839	162	2	100	0	1	162	1733648	1733487	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	64693	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
24015467	24015467	PRJNA312107_P_NODE_19079_length_169_cov_0.866667_g18913_i0	PRJNA312107	19079	169	0.866667	1.46466723	Campylobacter	194	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g18913	i0	97.006	2.96449704142012	167	5	99	0	1	167	1233773	1233607	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	501	281	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
24603659	24603659	PRJNA312107_P_NODE_21700_length_166_cov_0.888889_g21534_i0	PRJNA312107	21700	166	0.888889	1.47555574	Campylobacter ureolyticus	827	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g21534	i0	97.59	4	166	4	100	0	1	166	804484	804319	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	664	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus

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