metadata: contig_metadata: 19 rows where bioproject = "PRJNA438687" and tax

19 rows where bioproject = "PRJNA438687" 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
1091132	1091132	PRJNA438687_S_NODE_1601_length_328_cov_79.907850_g1511_i0	PRJNA438687	1601	328	79.90785	262.097748	Arcobacteraceae	2808963	Bacteria	Bacteria	601	2.4399999999999998e-167	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g1511	i0	99.695	389.033536585366	328	1	100	0	1	328	1733666	1733993	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	127603	601	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
1091180	1091180	PRJNA438687_S_NODE_4281_length_214_cov_41.396648_g4191_i0	PRJNA438687	4281	214	41.396648	88.58882672	Pseudomonadati	3379134	Bacteria	Bacteria	388	1.26e-103	NTclustered	gi\|1898123824\|gb\|CP060693.1\|	28198	g4191	i0	99.531	263.677570093458	213	1	99	0	2	214	67894	67682	Aliarcobacter cryaerophilus strain 16CS1285-4 chromosome, complete genome	blastn	56427	388	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
1091219	1091219	PRJNA438687_S_NODE_6281_length_175_cov_1.728571_g6191_i0	PRJNA438687	6281	175	1.728571	3.02499925	Campylobacter	194	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|240265854\|gb\|GQ167691.1\|	827	g6191	i0	100	258.337142857143	175	0	100	0	1	175	2082	2256	Bacteroides ureolyticus strain UNSWE 23S ribosomal RNA gene, partial sequence	blastn	45209	324	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
2986028	2986028	PRJNA438687_S_NODE_5863_length_182_cov_2.755102_g5773_i0	PRJNA438687	5863	182	2.755102	5.01428564	Campylobacter showae	204	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g5773	i0	100	232.010989010989	182	0	100	0	1	182	389676	389857	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	42226	337	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
4262307	4262307	PRJNA438687_S_NODE_3864_length_226_cov_4.753927_g3774_i0	PRJNA438687	3864	226	4.753927	10.74387502	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	379	8.119999999999998e-101	NTclustered	gi\|346681541\|gb\|JF740655.1\|	120858	g3774	i0	96.903	324.663716814159	226	7	100	0	1	226	34	259	Uncultured epsilon proteobacterium clone 23S_S3M_218 23S ribosomal RNA gene, partial sequence	blastn	73374	379	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
8744189	8744189	PRJNA438687_S_NODE_5827_length_183_cov_1.729730_g5737_i0	PRJNA438687	5827	183	1.72973	3.1654059	Sulfurimonas	202746	Bacteria	Bacteria	244	2.4e-60	NTclustered	gi\|2621701203\|emb\|OY759725.1\|	291845	g5737	i0	90.811	341.72131147541	185	13	100	4	1	183	682669	682487	MAG: uncultured Sulfurimonas sp. isolate a78221b3-3849-449b-b167-7d88721915ac genome assembly, chromosome: 1	blastn	62535	244	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	uncultured Sulfurimonas sp.
9363401	9363401	PRJNA438687_S_NODE_8008_length_152_cov_3.837607_g7918_i0	PRJNA438687	8008	152	3.837607	5.83316264	Campylobacter gracilis	824	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g7918	i0	100	250	152	0	100	0	1	152	502596	502445	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	38000	281	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
11294305	11294305	PRJNA438687_S_NODE_3409_length_241_cov_4.325243_g3319_i0	PRJNA438687	3409	241	4.325243	10.42383563	Sulfurospirillum	57665	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g3319	i0	97.51	270.195020746888	241	6	100	0	1	241	2245021	2244781	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	65117	412	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
13188988	13188988	PRJNA438687_S_NODE_3911_length_225_cov_2.289474_g3821_i0	PRJNA438687	3911	225	2.289474	5.1513165	Campylobacter showae	204	Bacteria	Bacteria	416	6.159999999999998e-112	NTclustered	gi\|1483583511\|emb\|LT631435.1\|	204	g3821	i0	100	248.937777777778	225	0	100	0	1	225	11150	10926	Campylobacter showae genome assembly, plasmid: XI	blastn	56011	416	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
13844804	13844804	PRJNA438687_S_NODE_7531_length_157_cov_377.213115_g7441_i0	PRJNA438687	7531	157	377.213115	592.22459055	root	1	Root_unresolved	Root_unresolved	285	1.17e-72	NTclustered	gi\|34868921\|gb\|AY314755.1\|	28198	g7441	i0	99.363	174.987261146497	157	1	100	0	1	157	724	880	Arcobacter cryaerophilus isolate CCUG 17802 16S ribosomal RNA gene, partial sequence	blastn	27473	287	0.993031358885017	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
15737940	15737940	PRJNA438687_S_NODE_293_length_542_cov_43.848126_g219_i0	PRJNA438687	293	542	43.848126	237.65684292	Arcobacter suis	1278212	Bacteria	Bacteria	913	0	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g219	i0	97.053	398.505535055351	543	15	100	1	1	542	1734262	1734804	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	215990	913	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
16393734	16393734	PRJNA438687_S_NODE_3193_length_250_cov_7.646512_g3103_i0	PRJNA438687	3193	250	7.646512	19.11628	Sulfurimonas	202746	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|470486842\|ref\|NR_076783.1\|	202747	g3103	i0	90.763	271.972	249	19	98	4	5	250	242	489	Sulfurimonas autotrophica strain DSM 16294 23S ribosomal RNA gene, complete sequence	blastn	67993	331	0.993957703927492	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas autotrophica
17012713	17012713	PRJNA438687_S_NODE_7774_length_155_cov_1.750000_g7684_i0	PRJNA438687	7774	155	1.75	2.7125	Sulfurimonas sp. CS5	3391145	Bacteria	Bacteria	207	2.57e-49	NTclustered	gi\|2908503039\|gb\|CP180409.1\|	3391145	g7684	i0	92.414	101.303225806452	145	11	97	0	1	145	590468	590612	Sulfurimonas sp. CS5 chromosome, complete genome	blastn	15702	207	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp. CS5
24043050	24043050	PRJNA438687_S_NODE_4739_length_204_cov_1.319527_g4649_i0	PRJNA438687	4739	204	1.319527	2.69183508	Campylobacter	194	Bacteria	Bacteria	209	9.98e-50	NTclustered	gi\|2427057555\|gb\|CP115609.1\|	2984142	g4649	i0	87.845	229.441176470588	181	19	88	3	25	204	989623	989801	Campylobacter sp. CS_NA3 strain Cs NA3 chromosome	blastn	46806	209	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CS_NA3
24043053	24043053	PRJNA438687_S_NODE_4879_length_201_cov_8.692771_g4789_i0	PRJNA438687	4879	201	8.692771	17.47246971	root	1	Root_unresolved	Root_unresolved	361	2.5599999999999998e-95	NTclustered	gi\|1255532737\|gb\|MG195893.1\|	28198	g4789	i0	99.005	133.701492537313	201	2	100	0	1	201	93	293	Aliarcobacter cryaerophilus strain LMG 24291 16S ribosomal RNA gene, partial sequence	blastn	26874	361	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
25317342	25317342	PRJNA438687_S_NODE_1560_length_330_cov_29.271186_g1470_i0	PRJNA438687	1560	330	29.271186	96.5949138	Sulfurospirillum	57665	Bacteria	Bacteria	385	2.6999999999999992e-102	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g1470	i0	87.952	271.245454545455	332	33	100	5	1	330	2245246	2245572	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	89511	385	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
25317354	25317354	PRJNA438687_S_NODE_2380_length_287_cov_83.273810_g2290_i0	PRJNA438687	2380	287	83.27381	238.9958347	Arcobacteraceae	2808963	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g2290	i0	100	398.313588850174	287	0	100	0	1	287	1733409	1733695	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	114316	531	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
27549840	27549840	PRJNA438687_S_NODE_5824_length_183_cov_1.810811_g5734_i0	PRJNA438687	5824	183	1.810811	3.31378413	Helicobacter pylori	210	Bacteria	Bacteria	39.3	0.037	NR	GAA6796013.1	210	g5734	i0	100	0.278688524590164	17	0	27.9	0	181	131	4	20	GAA6796013.1 hypothetical protein Kyoto200A_0760 [Helicobacter pylori]	diamond	51	39.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32888444	32888444	PRJNA438687_S_NODE_6000_length_179_cov_5.638889_g5910_i0	PRJNA438687	6000	179	5.638889	10.09361131	Helicobacter pylori	210	Bacteria	Bacteria	48.9	4.93e-5	NR	GAA9037156.1	210	g5910	i0	85.4	0.804469273743017	48	3	73.7	1	155	24	1	48	GAA9037156.1 hypothetical protein Kyoto184A_00230 [Helicobacter pylori]	diamond	144	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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