metadata: contig_metadata: 22 rows where bioproject = "PRJNA565778", tax_phylum = "Campylobacterota" and tax

22 rows where bioproject = "PRJNA565778", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
4963829	4963829	PRJNA565778_S_NODE_19864_length_248_cov_113.345972_g19568_i0	PRJNA565778	19864	248	113.345972	281.09801056	Arcobacter	28196	Bacteria	Bacteria	313	9.32e-81	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g19568	i0	93.365	15.241935483871	211	14	85	0	38	248	2146608	2146398	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	3780	313	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
4963925	4963925	PRJNA565778_S_NODE_40364_length_163_cov_2.309524_g40068_i0	PRJNA565778	40364	163	2.309524	3.76452412	Campylobacter	194	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|470482328\|ref\|NR_076526.1\|	76517	g40068	i0	100	239.901840490798	163	0	100	0	1	163	116	278	Campylobacter hominis strain CH001A 23S ribosomal RNA gene, complete sequence	blastn	39104	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
10064346	10064346	PRJNA565778_S_NODE_4748_length_473_cov_3.167431_g4518_i0	PRJNA565778	4748	473	3.167431	14.98194863	Bacteria	2	Bacteria	Bacteria	857	0	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g4518	i0	99.366	45.9090909090909	473	3	100	0	1	473	1544339	1544811	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	21715	857	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
14586969	14586969	PRJNA565778_S_NODE_19072_length_254_cov_2.156682_g18776_i0	PRJNA565778	19072	254	2.156682	5.47797228	Campylobacterales bacterium	2268180	Bacteria	Bacteria	123	4.32e-34	NR	MBY0540711.1	2268180	g18776	i0	82.2	0.862204724409449	73	13	86.2	0	226	8	1	73	MBY0540711.1 response regulator [Campylobacterales bacterium]	diamond	219	123	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
15860946	15860946	PRJNA565778_S_NODE_29993_length_200_cov_315.447853_g29697_i0	PRJNA565778	29993	200	315.447853	630.895706	Bacteria	2	Bacteria	Bacteria	107	4.88e-25	NR	MBM18277.1	2026809	g29697	i0	96.4	26.61	56	2	84	0	32	199	179	234	MBM18277.1 hypothetical protein [Campylobacterota bacterium]	diamond	5322	107	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
20960548	20960548	PRJNA565778_S_NODE_34857_length_184_cov_237.517007_g34561_i0	PRJNA565778	34857	184	237.517007	437.03129288	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	255	1.11e-63	NTclustered	gi\|1817415496\|gb\|CP026656.1\|	28198	g34561	i0	97.959	0.967391304347826	147	3	80	0	1	147	1398342	1398488	Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome	blastn	178	255	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
22235135	22235135	PRJNA565778_S_NODE_11378_length_324_cov_4.216028_g11082_i0	PRJNA565778	11378	324	4.216028	13.65993072	Aliarcobacter trophiarum	708186	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1442793352\|gb\|CP031367.1\|	1032241	g11082	i0	100	0.0864197530864197	28	0	9	0	286	313	1484222	1484249	Aliarcobacter trophiarum LMG 25534 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter trophiarum
26808402	26808402	PRJNA565778_S_NODE_22981_length_231_cov_2.613402_g22685_i0	PRJNA565778	22981	231	2.613402	6.03695862	Pseudomonadati	3379134	Bacteria	Bacteria	104	8.92e-25	NR	WP_260950376.1	28198	g22685	i0	68.1	4.46753246753247	72	21	93.5	1	2	217	100	169	WP_260950376.1 glycosyltransferase family 4 protein [Aliarcobacter cryaerophilus]	diamond	1032	105	0.990476190476191	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
28184663	28184663	PRJNA565778_S_NODE_21426_length_239_cov_11.024752_g21130_i0	PRJNA565778	21426	239	11.024752	26.34915728	Helicobacter pylori	210	Bacteria	Bacteria	45.4	0.00342	NR	GAA8854026.1	210	g21130	i0	77.4	0.778242677824268	31	7	38.9	0	208	116	207	237	GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori]	diamond	186	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28942987	28942987	PRJNA565778_S_NODE_41548_length_157_cov_1.808333_g41252_i0	PRJNA565778	41548	157	1.808333	2.83908281	Campylobacterales bacterium	2268180	Bacteria	Bacteria	79.7	5.71e-17	NR	MBY0540710.1	2268180	g41252	i0	75	0.993630573248408	52	13	99.4	0	156	1	19	70	MBY0540710.1 hypothetical protein [Campylobacterales bacterium]	diamond	156	79.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
29289947	29289947	PRJNA565778_S_NODE_27869_length_209_cov_3.174419_g27573_i0	PRJNA565778	27869	209	3.174419	6.63453571	Helicobacter cappadocius	3063998	Bacteria	Bacteria	87.4	2.25e-18	NR	WP_370690938.1	3063998	g27573	i0	62.1	1.63636363636364	58	22	83.3	0	34	207	230	287	WP_370690938.1 Eco57I restriction-modification methylase domain-containing protein [Helicobacter cappadocius]	diamond	342	87.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cappadocius
30047714	30047714	PRJNA565778_S_NODE_7191_length_397_cov_334.011111_g6907_i0	PRJNA565778	7191	397	334.011111	1326.02411067	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	52.8	1.89e-5	NR	HRN00570.1	28198	g6907	i0	56.9	0.385390428211587	51	19	38.5	1	358	206	32	79	HRN00570.1 zinc ribbon domain-containing protein [Aliarcobacter cryaerophilus]	diamond	153	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
30269329	30269329	PRJNA565778_S_NODE_22232_length_235_cov_2.116162_g21936_i0	PRJNA565778	22232	235	2.116162	4.9729807	Campylobacterales bacterium	2268180	Bacteria	Bacteria	150	2.2e-43	NR	MBY0540713.1	2268180	g21936	i0	88.7	0.906382978723404	71	8	90.6	0	215	3	1	71	MBY0540713.1 hypothetical protein [Campylobacterales bacterium]	diamond	213	150	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
30427478	30427478	PRJNA565778_S_NODE_18913_length_255_cov_2.119266_g18617_i0	PRJNA565778	18913	255	2.119266	5.4041283	Campylobacterales bacterium	2268180	Bacteria	Bacteria	65.5	4.03e-10	NR	MBY0540714.1	2268180	g18617	i0	61.7	0.552941176470588	47	9	47.1	2	122	3	1	45	MBY0540714.1 toprim domain-containing protein [Campylobacterales bacterium]	diamond	141	65.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
30584845	30584845	PRJNA565778_S_NODE_37413_length_177_cov_1.392857_g37117_i0	PRJNA565778	37413	177	1.392857	2.46535689	Campylobacterales bacterium	2268180	Bacteria	Bacteria	86.7	4.25e-20	NR	MBY0540711.1	2268180	g37117	i0	97.6	0.694915254237288	41	1	69.5	0	177	55	83	123	MBY0540711.1 response regulator [Campylobacterales bacterium]	diamond	123	86.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
30679581	30679581	PRJNA565778_S_NODE_15353_length_281_cov_324.450820_g15057_i0	PRJNA565778	15353	281	324.45082	911.7068042	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	43.5	0.00929	NR	HRN00571.1	28198	g15057	i0	39.2	0.843416370106762	79	40	80.1	4	38	262	13	87	HRN00571.1 hypothetical protein [Aliarcobacter cryaerophilus]	diamond	237	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
30756635	30756635	PRJNA565778_S_NODE_22934_length_231_cov_5.159794_g22638_i0	PRJNA565778	22934	231	5.159794	11.91912414	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	8.92e-6	NR	GAA8930966.1	210	g22638	i0	76.9	0.688311688311688	26	6	33.8	0	230	153	21	46	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	159	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30964310	30964310	PRJNA565778_S_NODE_23634_length_227_cov_47.573684_g23338_i0	PRJNA565778	23634	227	47.573684	107.99226268	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	41.2	0.0396	NR	HRN00571.1	28198	g23338	i0	37.9	0.766519823788546	58	32	71.4	1	181	20	30	87	HRN00571.1 hypothetical protein [Aliarcobacter cryaerophilus]	diamond	174	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
31691342	31691342	PRJNA565778_S_NODE_18677_length_256_cov_32.538813_g18381_i0	PRJNA565778	18677	256	32.538813	83.29936128	Campylobacterota bacterium	2026809	Bacteria	Bacteria	144	6.699999999999999e-38	NR	NCD13088.1	2026809	g18381	i0	94.6	0.8671875	74	4	86.7	0	35	256	538	611	NCD13088.1 site-specific DNA-methyltransferase [Campylobacterota bacterium]	diamond	222	144	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
32070989	32070989	PRJNA565778_S_NODE_16098_length_275_cov_100.529412_g15802_i0	PRJNA565778	16098	275	100.529412	276.45588299999997	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	109	5.55e-28	NR	HRN00570.1	28198	g15802	i0	98.1	0.567272727272727	52	1	56.7	0	238	83	115	166	HRN00570.1 zinc ribbon domain-containing protein [Aliarcobacter cryaerophilus]	diamond	156	109	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
32450968	32450968	PRJNA565778_S_NODE_36839_length_178_cov_170.836879_g36543_i0	PRJNA565778	36839	178	170.836879	304.08964462	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	72.4	3.6e-13	NR	NQY20328.1	2268179	g36543	i0	70.2	3.1685393258427	47	14	79.2	0	142	2	18	64	NQY20328.1 tRNA lysidine(34) synthetase TilS [Campylobacteraceae bacterium]	diamond	564	72.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
32639919	32639919	PRJNA565778_S_NODE_30980_length_197_cov_7.168750_g30684_i0	PRJNA565778	30980	197	7.16875	14.1224375	Sulfuricurvum sp.	2025608	Bacteria	Bacteria	50.1	5.25e-5	NR	MFA6145682.1	2025608	g30684	i0	45.1	0.776649746192893	51	28	77.7	0	5	157	171	221	MFA6145682.1 type I secretion system permease/ATPase [Sulfuricurvum sp.]	diamond	153	50.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp.

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