metadata: contig_metadata: 16 rows where bioproject = "PRJNA631796" and tax

16 rows where bioproject = "PRJNA631796" 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
4431141	4431141	PRJNA631796_P_NODE_9304_length_225_cov_1.560976_g9026_i0	PRJNA631796	9304	225	1.560976	3.512196	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	128	3.23e-25	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g9026	i0	87.611	67.6577777777778	113	10	49	3	1	111	116	6	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	15223	128	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
6255705	6255705	PRJNA631796_P_NODE_6645_length_265_cov_2.063725_g6367_i0	PRJNA631796	6645	265	2.063725	5.46887125	Helicobacter	209	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|50957175\|gb\|AY596260.1\|	213	g6367	i0	100	120.796226415094	265	0	100	0	1	265	1629	1365	Helicobacter cinaedi strain CCUG 33804 23S ribosomal RNA gene, partial sequence	blastn	32011	490	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cinaedi
15180424	15180424	PRJNA631796_P_NODE_7952_length_240_cov_4.167598_g7674_i0	PRJNA631796	7952	240	4.167598	10.0022352	Campylobacter	194	Bacteria	Bacteria	401	1.8599999999999994e-107	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g7674	i0	99.545	204.3125	220	1	92	0	21	240	1869	1650	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	49035	401	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15906196	15906196	PRJNA631796_P_NODE_11713_length_206_cov_1.324138_g11435_i0	PRJNA631796	11713	206	1.324138	2.72772428	Campylobacter sp. CCS1377	3158229	Bacteria	Bacteria	167	6.159999999999999e-37	NTclustered	gi\|2738339955\|gb\|CP155620.1\|	3158229	g11435	i0	85.185	95.4563106796116	162	24	79	0	4	165	119648	119809	Campylobacter sp. CCS1377 chromosome, complete genome	blastn	19664	167	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCS1377
15906235	15906235	PRJNA631796_P_NODE_4473_length_327_cov_3.424812_g4195_i0	PRJNA631796	4473	327	3.424812	11.19913524	Helicobacter pylori	210	Bacteria	Bacteria	71.3	8.49e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g4195	i0	100	13.1162079510703	38	0	12	0	290	327	1292723	1292686	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4289	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
21005783	21005783	PRJNA631796_P_NODE_14417_length_169_cov_4.351852_g14139_i0	PRJNA631796	14417	169	4.351852	7.35462988	Campylobacter gracilis	824	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g14139	i0	99.408	254.639053254438	169	1	100	0	1	169	500657	500489	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	43034	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
22829454	22829454	PRJNA631796_P_NODE_13618_length_194_cov_4.255639_g13340_i0	PRJNA631796	13618	194	4.255639	8.25593966	Campylobacter	194	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g13340	i0	99.485	231.365979381443	194	1	100	0	1	194	704	897	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	44885	353	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22829461	22829461	PRJNA631796_P_NODE_2938_length_410_cov_6.673352_g2661_i0	PRJNA631796	2938	410	6.673352	27.3607432	Campylobacter	194	Bacteria	Bacteria	752	0	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g2661	i0	99.756	236.407317073171	410	1	100	0	1	410	1033143	1032734	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	96927	752	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
27219661	27219661	PRJNA631796_S_NODE_64922_length_220_cov_1.496855_g64755_i0	PRJNA631796	64922	220	1.496855	3.293081	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	1.01e-9	NR	GAA9176259.1	210	g64755	i0	49.3	1.81363636363636	67	9	90	2	213	16	7	49	GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori]	diamond	399	59.3	0.993254637436762	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27725645	27725645	PRJNA631796_S_NODE_74404_length_214_cov_1.516340_g74237_i0	PRJNA631796	74404	214	1.51634	3.2449676	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	5.71e-7	NR	GAA6835236.1	210	g74237	i0	84.6	2.94392523364486	26	4	36.4	0	208	131	5	30	GAA6835236.1 hypothetical protein Kyoto200A_4550 [Helicobacter pylori]	diamond	630	52.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28249290	28249290	PRJNA631796_S_NODE_67706_length_218_cov_1.796178_g67539_i0	PRJNA631796	67706	218	1.796178	3.91566804	Helicobacter pylori	210	Bacteria	Bacteria	68.2	2.04e-13	NR	GAA8812112.1	210	g67539	i0	78.4	0.509174311926605	37	8	50.9	0	39	149	1	37	GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori]	diamond	111	68.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28293484	28293484	PRJNA631796_S_NODE_100186_length_206_cov_1.262069_g100019_i0	PRJNA631796	100186	206	1.262069	2.59986214	Pseudomonadati	3379134	Bacteria	Bacteria	61.6	5.68e-11	NR	GAA9037979.1	210	g100019	i0	71.1	1.63106796116505	38	11	55.3	0	195	82	2	39	GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori]	diamond	336	62	0.993548387096774	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28817489	28817489	PRJNA631796_S_NODE_40068_length_240_cov_1.474860_g39901_i0	PRJNA631796	40068	240	1.47486	3.539664	Helicobacter pylori	210	Bacteria	Bacteria	60.8	1.92e-10	NR	GAA6795286.1	210	g39901	i0	82.9	0.4375	35	5	42.5	1	236	135	6	40	GAA6795286.1 hypothetical protein Kyoto200A_0270 [Helicobacter pylori]	diamond	105	60.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30270746	30270746	PRJNA631796_S_NODE_49092_length_232_cov_1.134503_g48925_i0	PRJNA631796	49092	232	1.134503	2.63204696	Helicobacter pylori	210	Bacteria	Bacteria	56.2	1.23e-8	NR	GAA8950290.1	210	g48925	i0	92.3	0.336206896551724	26	2	33.6	0	9	86	1	26	GAA8950290.1 hypothetical protein Kyoto181A_1480 [Helicobacter pylori]	diamond	78	56.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31895103	31895103	PRJNA631796_S_NODE_134577_length_188_cov_2.133858_g134410_i0	PRJNA631796	134577	188	2.133858	4.01165304	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	2.42e-7	NR	GAA9036680.1	210	g134410	i0	72.7	1.45212765957447	33	9	52.7	0	176	78	5	37	GAA9036680.1 hypothetical protein Kyoto181A_9030 [Helicobacter pylori]	diamond	273	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32199062	32199062	PRJNA631796_S_NODE_16198_length_275_cov_1.247664_g16031_i0	PRJNA631796	16198	275	1.247664	3.431076	Helicobacter pylori	210	Bacteria	Bacteria	54.7	1.44e-7	NR	GAA6835236.1	210	g16031	i0	82.8	1.50545454545455	29	5	31.6	0	224	138	4	32	GAA6835236.1 hypothetical protein Kyoto200A_4550 [Helicobacter pylori]	diamond	414	54.7	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);;