metadata: contig_metadata: 19 rows where bioproject = "PRJDB9741", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJDB9741", 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
10831	10831	PRJDB9741_P_NODE_13741_length_189_cov_1.285714_g13424_i0	PRJDB9741	13741	189	1.285714	2.42999946	Campylobacter showae	204	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g13424	i0	99.471	10.968253968254	189	1	100	0	1	189	1113146	1112958	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2073	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6389296	6389296	PRJDB9741_P_NODE_7326_length_231_cov_3.346154_g7009_i0	PRJDB9741	7326	231	3.346154	7.72961574	Wolinella succinogenes	844	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g7009	i0	100	140.926406926407	231	0	100	0	1	231	335287	335517	Wolinella succinogenes, complete genome; segment 4/7	blastn	32554	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
9909927	9909927	PRJDB9741_P_NODE_10028_length_208_cov_1.283019_g9711_i0	PRJDB9741	10028	208	1.283019	2.66867952	Campylobacter	194	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g9711	i0	100	224.932692307692	208	0	100	0	1	208	1579	1786	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	46786	385	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10213855	10213855	PRJDB9741_P_NODE_7989_length_222_cov_3.872832_g7672_i0	PRJDB9741	7989	222	3.872832	8.59768704	Wolinella succinogenes	844	Bacteria	Bacteria	411	2.8199999999999996e-110	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g7672	i0	100	194.936936936937	222	0	100	0	1	222	335165	334944	Wolinella succinogenes, complete genome; segment 4/7	blastn	43276	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
13735315	13735315	PRJDB9741_P_NODE_34691_length_163_cov_3.245614_g34374_i0	PRJDB9741	34691	163	3.2456140000000002	5.29035082	Campylobacterales	213849	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g34374	i0	96.319	239.006134969325	163	6	100	0	1	163	43417	43255	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	38958	268	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
15313116	15313116	PRJDB9741_P_NODE_2773_length_428_cov_3.039578_g2458_i0	PRJDB9741	2773	428	3.039578	13.00939384	Wolinella succinogenes	844	Bacteria	Bacteria	780	0	NTclustered	gi\|34482172\|emb\|BX571657.1\|	844	g2458	i0	99.533	176.016355140187	428	2	100	0	1	428	140087	139660	Wolinella succinogenes, complete genome; segment 1/7	blastn	75335	780	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
15313273	15313273	PRJDB9741_P_NODE_7073_length_236_cov_1.165775_g6756_i0	PRJDB9741	7073	236	1.165775	2.751229	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	178	3.35e-40	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g6756	i0	90.58	84.2542372881356	138	8	58	4	101	236	6	140	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	19884	178	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
16587673	16587673	PRJDB9741_P_NODE_10714_length_201_cov_3.138158_g10397_i0	PRJDB9741	10714	201	3.138158	6.30769758	Arcobacter roscoffensis	2961520	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2270258285\|gb\|CP100595.1\|	2961520	g10397	i0	100	359.89552238806	201	0	100	0	1	201	276320	276120	Arcobacter roscoffensis strain ARW1-2F2 chromosome, complete genome	blastn	72339	372	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter roscoffensis
20411498	20411498	PRJDB9741_P_NODE_19557_length_178_cov_4.837209_g19240_i0	PRJDB9741	19557	178	4.837209	8.61023202	Wolinella succinogenes	844	Bacteria	Bacteria	302	1.35e-77	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g19240	i0	97.191	135.662921348315	178	5	100	0	1	178	334088	334265	Wolinella succinogenes, complete genome; segment 4/7	blastn	24148	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
22962973	22962973	PRJDB9741_P_NODE_959_length_881_cov_2.996394_g731_i0	PRJDB9741	959	881	2.996394	26.39823114	Wolinella succinogenes	844	Bacteria	Bacteria	1605	0	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g731	i0	99.546	150	881	4	100	0	1	881	336374	335494	Wolinella succinogenes, complete genome; segment 4/7	blastn	132150	1605	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
26684187	26684187	PRJDB9741_P_NODE_10841_length_200_cov_2.344371_g10524_i0	PRJDB9741	10841	200	2.344371	4.688742	Helicobacter pylori	210	Bacteria	Bacteria	57.4	6.05e-9	NR	GAA6953508.1	210	g10524	i0	75	0.48	32	8	48	0	146	51	1	32	GAA6953508.1 hypothetical protein Kyoto211A_0720 [Helicobacter pylori]	diamond	96	57.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27121066	27121066	PRJDB9741_P_NODE_19102_length_179_cov_2.307692_g18785_i0	PRJDB9741	19102	179	2.307692	4.13076868	Pseudomonadati	3379134	Bacteria	Bacteria	102	3.81e-26	NR	WP_175055342.1	197	g18785	i0	100	5.93296089385475	59	0	98.9	0	179	3	59	117	WP_175055342.1 GAF domain-containing protein, partial [Campylobacter jejuni]	diamond	1062	102	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
27342866	27342866	PRJDB9741_P_NODE_27803_length_167_cov_0.864407_g27486_i0	PRJDB9741	27803	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	42	0.00203	NR	GAA8912035.1	210	g27486	i0	61.5	0.844311377245509	26	10	46.7	0	2	79	12	37	GAA8912035.1 hypothetical protein Kyoto166A_2340 [Helicobacter pylori]	diamond	141	42.4	0.990566037735849	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27474897	27474897	PRJDB9741_P_NODE_19543_length_179_cov_0.915385_g19226_i0	PRJDB9741	19543	179	0.915385	1.63853915	Helicobacter pylori	210	Bacteria	Bacteria	69.7	8.21e-14	NR	GAA6859872.1	210	g19226	i0	90.6	0.536312849162011	32	3	53.6	0	82	177	4	35	GAA6859872.1 hypothetical protein Kyoto206A_1100 [Helicobacter pylori]	diamond	96	69.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28226478	28226478	PRJDB9741_P_NODE_36846_length_162_cov_2.159292_g36529_i0	PRJDB9741	36846	162	2.159292	3.49805304	Bacteria	2	Bacteria	Bacteria	110	2.64e-30	NR	WP_240369625.1	195	g36529	i0	98.1	1.96296296296296	53	1	98.1	0	3	161	15	67	WP_240369625.1 hypothetical protein, partial [Campylobacter coli]	diamond	318	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29747986	29747986	PRJDB9741_P_NODE_12091_length_194_cov_2.034483_g11774_i0	PRJDB9741	12091	194	2.034483	3.94689702	Helicobacter pylori	210	Bacteria	Bacteria	57.4	8.2e-9	NR	GAA8686254.1	210	g11774	i0	100	0.479381443298969	31	0	47.9	0	103	11	1	31	GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori]	diamond	93	57.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31517967	31517967	PRJDB9741_P_NODE_19556_length_178_cov_5.286822_g19239_i0	PRJDB9741	19556	178	5.286822	9.41054316	Helicobacter pylori	210	Bacteria	Bacteria	61.2	6.08e-11	NR	GAA8948601.1	210	g19239	i0	68.9	1.51685393258427	45	13	75.8	1	176	42	2	45	GAA8948601.1 hypothetical protein Kyoto181A_0400 [Helicobacter pylori]	diamond	270	61.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32024083	32024083	PRJDB9741_P_NODE_5678_length_264_cov_1.841860_g5362_i0	PRJDB9741	5678	264	1.84186	4.8625104	Helicobacter pylori	210	Bacteria	Bacteria	79	4.45e-17	NR	GAA8734169.1	210	g5362	i0	77	0.840909090909091	74	17	84.1	0	10	231	6	79	GAA8734169.1 hypothetical protein Kyoto147A_1540 [Helicobacter pylori]	diamond	222	79	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32055559	32055559	PRJDB9741_P_NODE_20438_length_177_cov_1.593750_g20121_i0	PRJDB9741	20438	177	1.59375	2.8209375	Helicobacter pylori	210	Bacteria	Bacteria	55.5	1.11e-8	NR	GAA9221949.1	210	g20121	i0	83.9	1.52542372881356	31	4	50.8	1	137	48	6	36	GAA9221949.1 hypothetical protein Kyoto198A_3800 [Helicobacter pylori]	diamond	270	55.5	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);;