metadata: contig_metadata: 14 rows where bioproject = "PRJNA1123309", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA1123309", tax_kingdom = "Pseudomonadati" 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
2304335	2304335	PRJNA1123309_P_NODE_44342_length_259_cov_2.413978_g43962_i0	PRJNA1123309	44342	259	2.413978	6.25220302	Campylobacter	194	Bacteria	Bacteria	97.1	1.07e-15	NTclustered	gi\|2198378962\|gb\|CP059599.1\|	1660078	g43962	i0	96.552	4.3976833976834	58	2	22	0	169	226	62475	62532	Campylobacter sp. RM5004 chromosome, complete genome	blastn	1139	97.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM5004
7931158	7931158	PRJNA1123309_P_NODE_26787_length_312_cov_2.497908_g26407_i0	PRJNA1123309	26787	312	2.497908	7.79347296	Campylobacter gracilis	824	Bacteria	Bacteria	207	5.88e-49	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g26407	i0	91.892	0.958333333333333	148	12	47	0	4	151	1375119	1374972	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	299	207	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
8682138	8682138	PRJNA1123309_P_NODE_25607_length_318_cov_1.738776_g25227_i0	PRJNA1123309	25607	318	1.738776	5.52930768	root	1	Root_unresolved	Root_unresolved	62.1	4.95e-5	NTclustered	gi\|2523101058\|gb\|CP122954.1\|	210	g25227	i0	100	9.7861635220125809	33	0	10	0	118	150	1143547	1143579	Helicobacter pylori strain BS06 chromosome, complete genome	blastn	3112	62.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
8682246	8682246	PRJNA1123309_P_NODE_54067_length_249_cov_0.886364_g53687_i0	PRJNA1123309	54067	249	0.886364	2.20704636	Campylobacter	194	Bacteria	Bacteria	424	4.15e-114	NTclustered	gi\|2093921460\|gb\|CP082871.1\|	76517	g53687	i0	98.34	1.93574297188755	241	4	97	0	8	248	856603	856363	Campylobacter hominis strain FDAARGOS_1467 chromosome, complete genome	blastn	482	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
11757033	11757033	PRJNA1123309_P_NODE_5670_length_614_cov_2.892791_g5321_i0	PRJNA1123309	5670	614	2.892791	17.76173674	Campylobacter showae	204	Bacteria	Bacteria	1110	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g5321	i0	99.671	226.511400651466	607	2	99	0	8	614	389897	389291	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	139078	1110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
13032014	13032014	PRJNA1123309_P_NODE_40711_length_269_cov_1.188776_g40331_i0	PRJNA1123309	40711	269	1.188776	3.19780744	Campylobacter rectus	203	Bacteria	Bacteria	418	2.1099999999999997e-112	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g40331	i0	96.443	253.219330855019	253	9	94	0	1	253	160513	160765	Campylobacter rectus strain ATCC 33238, complete genome	blastn	68116	418	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
13032119	13032119	PRJNA1123309_P_NODE_50971_length_251_cov_0.876404_g50591_i0	PRJNA1123309	50971	251	0.876404	2.19977404	Campylobacter rectus	203	Bacteria	Bacteria	379	9.189999999999998e-101	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g50591	i0	95.745	8.38645418326693	235	10	94	0	17	251	681900	682134	Campylobacter rectus strain ATCC 33238, complete genome	blastn	2105	379	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
15581338	15581338	PRJNA1123309_P_NODE_53453_length_249_cov_1.664773_g53073_i0	PRJNA1123309	53453	249	1.664773	4.14528477	Campylobacter gracilis	824	Bacteria	Bacteria	294	3.39e-75	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g53073	i0	88.75	1.92771084337349	240	27	96	0	5	244	2074817	2074578	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	480	294	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
16331431	16331431	PRJNA1123309_P_NODE_38833_length_273_cov_2.170000_g38453_i0	PRJNA1123309	38833	273	2.17	5.9241	root	1	Root_unresolved	Root_unresolved	455	1.6300000000000002e-123	NTclustered	gi\|2030387999\|gb\|CP068565.1\|	195	g38453	i0	97.736	319.142857142857	265	4	97	2	1	264	770781	770518	Campylobacter coli strain CC19DZ036 chromosome, complete genome	blastn	87126	455	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
16855671	16855671	PRJNA1123309_P_NODE_48734_length_252_cov_0.871508_g48354_i0	PRJNA1123309	48734	252	0.871508	2.19620016	Campylobacter gracilis	824	Bacteria	Bacteria	374	4.2899999999999985e-99	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g48354	i0	95.319	1.86507936507937	235	11	93	0	1	235	408977	409211	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	470	374	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
18880610	18880610	PRJNA1123309_P_NODE_41955_length_266_cov_1.015544_g41575_i0	PRJNA1123309	41955	266	1.015544	2.70134704	Campylobacter	194	Bacteria	Bacteria	449	7.38e-122	NTclustered	gi\|397310297\|gb\|JQ228546.1\|	204	g41575	i0	98.077	114.34962406015	260	1	96	2	11	266	1051	1310	Campylobacter showae strain WAL 18658 16S ribosomal RNA gene, partial sequence	blastn	30417	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23230453	23230453	PRJNA1123309_P_NODE_22479_length_336_cov_3.752852_g22100_i0	PRJNA1123309	22479	336	3.752852	12.60958272	Campylobacter showae	204	Bacteria	Bacteria	603	6.979999999999997e-168	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g22100	i0	99.398	225.279761904762	332	2	99	0	5	336	390423	390092	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	75694	603	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
24504180	24504180	PRJNA1123309_P_NODE_28560_length_303_cov_4.352174_g28180_i0	PRJNA1123309	28560	303	4.352174	13.18708722	Campylobacter showae	204	Bacteria	Bacteria	532	8.269999999999998e-147	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g28180	i0	100	236.23102310231	288	0	95	0	6	293	390519	390806	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	71578	532	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
28965142	28965142	PRJNA1123309_P_NODE_64588_length_243_cov_0.917647_g64208_i0	PRJNA1123309	64588	243	0.917647	2.22988221	Campylobacterota bacterium	2026809	Bacteria	Bacteria	43.9	0.0135	NR	MCL4431196.1	2026809	g64208	i0	41.2	0.62962962962963	51	30	63	0	71	223	2	52	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	153	43.9	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium

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