metadata: contig_metadata: 28 rows where bioproject = "PRJNA358009" and tax

28 rows where bioproject = "PRJNA358009" 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
4900824	4900824	PRJNA358009_P_NODE_10184_length_181_cov_3.977273_g10115_i0	PRJNA358009	10184	181	3.977273	7.19886413	Campylobacter	194	Bacteria	Bacteria	278	2.33e-70	NTclustered	gi\|1733425738\|gb\|CP043427.1\|	32024	g10115	i0	97.531	233.14364640884	162	4	90	0	20	181	613332	613171	Campylobacter sputorum subsp. sputorum strain LMG 7795 chromosome, complete genome	blastn	42199	278	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sputorum
5501956	5501956	PRJNA358009_P_NODE_7105_length_280_cov_12.580087_g7038_i0	PRJNA358009	7105	280	12.580087	35.2242436	Wolinella succinogenes	844	Bacteria	Bacteria	396	1.03e-105	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g7038	i0	93.796	148.635714285714	274	0	98	3	8	280	336172	335915	Wolinella succinogenes, complete genome; segment 4/7	blastn	41618	396	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
6175965	6175965	PRJNA358009_P_NODE_16525_length_160_cov_7.684685_g16456_i0	PRJNA358009	16525	160	7.684685	12.295496	Campylobacter	194	Bacteria	Bacteria	248	1.5799999999999998e-61	NTclustered	gi\|2427060812\|gb\|CP115607.1\|	2983836	g16456	i0	95.541	239.00625	157	3	97	4	6	160	469226	469380	Campylobacter sp. VBCF_01 NA2 chromosome	blastn	38241	248	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. VBCF_01 NA2
7450990	7450990	PRJNA358009_P_NODE_786_length_411_cov_17.737569_g728_i0	PRJNA358009	786	411	17.737569	72.90140859	Campylobacter	194	Bacteria	Bacteria	420	9.399999999999997e-113	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g728	i0	92.256	227.009732360097	297	21	96	2	1	296	1279	984	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	93301	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9326360	9326360	PRJNA358009_P_NODE_17628_length_155_cov_4.754717_g17559_i0	PRJNA358009	17628	155	4.754717	7.36981135	Wolinella succinogenes	844	Bacteria	Bacteria	255	9.05e-64	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g17559	i0	97.333	171.754838709677	150	4	97	0	1	150	334733	334882	Wolinella succinogenes, complete genome; segment 4/7	blastn	26622	255	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
10001234	10001234	PRJNA358009_P_NODE_7528_length_236_cov_13.866310_g7460_i0	PRJNA358009	7528	236	13.86631	32.7244916	Campylobacter	194	Bacteria	Bacteria	398	2.36e-106	NTclustered	gi\|1861373391\|gb\|CP053826.1\|	200	g7460	i0	97.425	224.415254237288	233	6	99	0	4	236	840672	840440	Campylobacter curvus strain ATCC 35224 chromosome, complete genome	blastn	52962	398	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter curvus
10602064	10602064	PRJNA358009_P_NODE_509_length_485_cov_5.665138_g459_i0	PRJNA358009	509	485	5.665138	27.4759193	Campylobacter gracilis	824	Bacteria	Bacteria	435	4.02e-117	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g459	i0	89.802	186.261855670103	353	17	69	6	7	342	501458	501808	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	90337	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
10602108	10602108	PRJNA358009_P_NODE_8389_length_198_cov_7.335570_g8320_i0	PRJNA358009	8389	198	7.33557	14.5244286	Campylobacter gracilis	824	Bacteria	Bacteria	351	1.51e-92	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g8320	i0	98.98	256.429292929293	196	2	99	0	1	196	499840	499645	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	50773	351	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
11276261	11276261	PRJNA358009_P_NODE_2609_length_327_cov_3.535971_g2546_i0	PRJNA358009	2609	327	3.535971	11.56262517	Arcobacter	28196	Bacteria	Bacteria	185	2.91e-42	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g2546	i0	100	156.498470948012	100	0	59	0	1	100	1734299	1734398	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	51175	185	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
11876890	11876890	PRJNA358009_P_NODE_15390_length_162_cov_9.805310_g15321_i0	PRJNA358009	15390	162	9.80531	15.8846022	Campylobacter rectus	203	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g15321	i0	100	225.074074074074	156	0	96	0	7	162	158899	159054	Campylobacter rectus strain ATCC 33238, complete genome	blastn	36462	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
12551555	12551555	PRJNA358009_P_NODE_50_length_1004_cov_19.295288_g28_i0	PRJNA358009	50	1004	19.295288	193.72469152	Campylobacter	194	Bacteria	Bacteria	420	2.4199999999999993e-112	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g28	i0	92.256	130.762948207171	297	21	62	2	691	986	1279	984	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	131286	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12551573	12551573	PRJNA358009_P_NODE_630_length_447_cov_15.726131_g573_i0	PRJNA358009	630	447	15.726131	70.29580557	Campylobacter	194	Bacteria	Bacteria	420	1.0299999999999997e-112	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g573	i0	92.256	161.131991051454	297	21	66	2	152	447	984	1279	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	72026	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
13826434	13826434	PRJNA358009_P_NODE_631_length_447_cov_4.359296_g574_i0	PRJNA358009	631	447	4.359296	19.48605312	Campylobacter	194	Bacteria	Bacteria	189	3.16e-43	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g574	i0	99.048	157.892617449664	105	1	66	0	116	220	470	366	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	70578	189	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15100850	15100850	PRJNA358009_P_NODE_8292_length_201_cov_7.605263_g8223_i0	PRJNA358009	8292	201	7.605263	15.28657863	Arcobacter	28196	Bacteria	Bacteria	361	2.5599999999999998e-95	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g8223	i0	100	352.338308457711	195	0	97	0	1	195	1010222	1010028	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	70820	361	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
15700990	15700990	PRJNA358009_P_NODE_6493_length_326_cov_4.931408_g6430_i0	PRJNA358009	6493	326	4.931408	16.07639008	Campylobacter sp. RM12651	1660079	Bacteria	Bacteria	75	6.54e-9	NTclustered	gi\|2198381838\|gb\|CP059600.1\|	1660079	g6430	i0	84.416	6.23006134969325	77	11	25	1	7	83	46934	47009	Campylobacter sp. RM12651 chromosome, complete genome	blastn	2031	75	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM12651
15701003	15701003	PRJNA358009_P_NODE_73_length_903_cov_12.322014_g47_i0	PRJNA358009	73	903	12.322014	111.26778642	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	468	7.64e-127	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g47	i0	92.661	175.954595791805	327	21	58	3	228	552	86070	85745	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	158887	468	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
16375400	16375400	PRJNA358009_P_NODE_11733_length_172_cov_7.414634_g11664_i0	PRJNA358009	11733	172	7.414634	12.75317048	Campylobacter	194	Bacteria	Bacteria	241	2.87e-59	NTclustered	gi\|1883582428\|gb\|CP059437.1\|	196	g11664	i0	94.839	213.593023255814	155	6	90	2	15	168	138146	138299	Campylobacter fetus strain CFViADRI545 chromosome, complete genome	blastn	36738	241	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
20198984	20198984	PRJNA358009_P_NODE_1036_length_372_cov_4.520124_g975_i0	PRJNA358009	1036	372	4.520124	16.81486128	Campylobacter	194	Bacteria	Bacteria	318	3.159999999999999e-82	NTclustered	gi\|240265822\|gb\|GQ167659.1\|	76517	g975	i0	99.429	124.317204301075	175	1	98	0	1	175	1258	1084	Campylobacter hominis strain UNSWCD 16S ribosomal RNA gene, partial sequence	blastn	46246	318	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
20198995	20198995	PRJNA358009_P_NODE_11396_length_174_cov_3.944000_g11327_i0	PRJNA358009	11396	174	3.944	6.86256	Campylobacter	194	Bacteria	Bacteria	309	7.87e-80	NTclustered	gi\|1885696378\|gb\|CP059682.1\|	28080	g11327	i0	100	220.408045977011	167	0	96	0	1	167	341771	341605	Campylobacter upsaliensis strain FDAARGOS_736 chromosome, complete genome	blastn	38351	309	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter upsaliensis
20199049	20199049	PRJNA358009_P_NODE_16776_length_159_cov_4.945455_g16707_i0	PRJNA358009	16776	159	4.945455	7.86327345	Sulfurimonadaceae	2771471	Bacteria	Bacteria	176	7.49e-40	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g16707	i0	87.097	125.968553459119	155	20	97	0	1	155	1881930	1882084	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	20029	176	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
21474640	21474640	PRJNA358009_P_NODE_16677_length_160_cov_2.387387_g16608_i0	PRJNA358009	16677	160	2.387387	3.8198192	root	1	Root_unresolved	Root_unresolved	283	4.32e-72	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g16608	i0	100	96.58125	153	0	96	0	1	153	698881	699033	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	15453	283	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
21474682	21474682	PRJNA358009_P_NODE_3477_length_327_cov_2.629496_g3414_i0	PRJNA358009	3477	327	2.629496	8.59845192	Campylobacter	194	Bacteria	Bacteria	187	8.08e-43	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g3414	i0	100	144.675840978593	101	0	59	0	227	327	86	186	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	47309	187	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21474719	21474719	PRJNA358009_P_NODE_637_length_445_cov_15.853535_g579_i0	PRJNA358009	637	445	15.853535	70.54823075	Campylobacter	194	Bacteria	Bacteria	420	1.0199999999999997e-112	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g579	i0	92.256	161.856179775281	297	21	67	2	1	296	1279	984	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	72026	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22749903	22749903	PRJNA358009_P_NODE_778_length_413_cov_17.967033_g720_i0	PRJNA358009	778	413	17.967033	74.20384629	Campylobacter	194	Bacteria	Bacteria	420	9.45e-113	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g720	i0	92.256	209.433414043584	297	21	94	2	1	296	1279	984	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	86496	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22749906	22749906	PRJNA358009_P_NODE_78_length_894_cov_12.828402_g51_i0	PRJNA358009	78	894	12.828402	114.68591388	Pseudomonadati	3379134	Bacteria	Bacteria	420	2.15e-112	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g51	i0	92.256	110.662192393736	297	21	72	2	19	314	984	1279	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	98932	424	0.990566037735849	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24024686	24024686	PRJNA358009_P_NODE_14879_length_163_cov_6.543860_g14810_i0	PRJNA358009	14879	163	6.54386	10.6664918	Campylobacter	194	Bacteria	Bacteria	276	7.41e-70	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g14810	i0	98.718	216.226993865031	156	1	95	1	2	156	1032145	1032300	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	35245	276	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24024788	24024788	PRJNA358009_P_NODE_559_length_469_cov_5.100000_g505_i0	PRJNA358009	559	469	5.1	23.919	root	1	Root_unresolved	Root_unresolved	268	4.16e-67	NTclustered	gi\|1969424192\|gb\|MW548691.1\|	199	g505	i0	88.511	77.8230277185501	235	5	75	6	1	235	836	624	Campylobacter concisus strain KCOM 3603 (=ChDC ETd4) 16S ribosomal RNA gene, partial sequence	blastn	36499	268	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
28085461	28085461	PRJNA358009_P_NODE_8725_length_190_cov_4.390071_g8656_i0	PRJNA358009	8725	190	4.390071	8.3411349	Sulfurovum sp.	1969726	Bacteria	Bacteria	129	4.32e-33	NR	MDD3500783.1	1969726	g8656	i0	96.7	0.947368421052632	60	2	94.7	0	9	188	399	458	MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.]	diamond	180	129	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum 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);;