metadata: contig_metadata: 25 rows where bioproject = "PRJNA493828" and tax

25 rows where bioproject = "PRJNA493828" 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
1106423	1106423	PRJNA493828_P_NODE_26581_length_265_cov_7.583333_g26162_i0	PRJNA493828	26581	265	7.583333	20.09583245	Sulfurimonadaceae	2771471	Bacteria	Bacteria	340	4.62e-89	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g26162	i0	89.811	303.230188679245	265	27	100	0	1	265	1882175	1881911	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	80356	340	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
1106469	1106469	PRJNA493828_P_NODE_31321_length_252_cov_3.614525_g30902_i0	PRJNA493828	31321	252	3.614525	9.108603	Sulfurospirillum	57665	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|757804896\|dbj\|AP014724.1\|	366522	g30902	i0	100	199.313492063492	252	0	100	0	1	252	750059	750310	Sulfurospirillum cavolei DNA, complete genome	blastn	50227	466	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum cavolei
6852572	6852572	PRJNA493828_P_NODE_44006_length_226_cov_4.117647_g43587_i0	PRJNA493828	44006	226	4.117647	9.30588222	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|2581878167\|gb\|CP134854.1\|	2933791	g43587	i0	99.558	28.9070796460177	226	1	100	0	1	226	1971621	1971396	Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 52 chromosome, complete genome	blastn	6533	412	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
7484767	7484767	PRJNA493828_P_NODE_46946_length_205_cov_4.598485_g46527_i0	PRJNA493828	46946	205	4.598485	9.42689425	Sulfurospirillum	57665	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|757804896\|dbj\|AP014724.1\|	366522	g46527	i0	100	268.785365853659	205	0	100	0	1	205	53107	52903	Sulfurospirillum cavolei DNA, complete genome	blastn	55101	379	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum cavolei
7484774	7484774	PRJNA493828_P_NODE_47526_length_202_cov_4.465116_g47107_i0	PRJNA493828	47526	202	4.465116	9.01953432	Arcobacter	28196	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g47107	i0	100	352.113861386139	202	0	100	0	1	202	1733143	1733344	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	71127	374	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
8759437	8759437	PRJNA493828_P_NODE_24047_length_273_cov_5.740000_g23628_i0	PRJNA493828	24047	273	5.74	15.6702	Aliarcobacter	2321111	Bacteria	Bacteria	486	5.8e-133	NTclustered	gi\|1817415496\|gb\|CP026656.1\|	28198	g23628	i0	100	374.340659340659	263	0	96	0	8	270	57070	56808	Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome	blastn	102195	486	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
9402744	9402744	PRJNA493828_P_NODE_32768_length_250_cov_0.870056_g32349_i0	PRJNA493828	32768	250	0.870056	2.17514	Helicobacter pylori	210	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1725898549\|gb\|CP032025.1\|	210	g32349	i0	96.875	0.268	32	0	12	1	185	215	260787	260756	Helicobacter pylori strain C-Mx-2011-152 chromosome	blastn	67	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
13860125	13860125	PRJNA493828_P_NODE_25611_length_268_cov_7.051282_g25192_i0	PRJNA493828	25611	268	7.051282	18.89743576	Sulfurospirillum	57665	Bacteria	Bacteria	468	2.06e-127	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g25192	i0	98.491	282.89552238806	265	4	99	0	1	265	1132	1396	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	75816	472	0.991525423728814	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
15134428	15134428	PRJNA493828_P_NODE_14172_length_312_cov_1.841004_g13753_i0	PRJNA493828	14172	312	1.841004	5.74393248	root	1	Root_unresolved	Root_unresolved	577	3.89e-160	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g13753	i0	100	100	312	0	100	0	1	312	698843	698532	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	31200	577	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
15134798	15134798	PRJNA493828_P_NODE_5752_length_460_cov_1.844961_g5360_i0	PRJNA493828	5752	460	1.844961	8.4868206	Thiomicrolovo	3451667	Bacteria	Bacteria	95.3	7.31e-15	NTclustered	gi\|2732788113\|gb\|CP147914.1\|	3131933	g5360	i0	89.474	13.3739130434783	76	6	16	2	251	325	1279847	1279773	Sulfurimonas sp. HSL1-2 chromosome, complete genome	blastn	6152	95.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo zhangzhouensis
15777439	15777439	PRJNA493828_P_NODE_3753_length_558_cov_3.096907_g3376_i0	PRJNA493828	3753	558	3.096907	17.28074106	Campylobacter sp. 19-13652	2840180	Bacteria	Bacteria	65.8	7.06e-6	NTclustered	gi\|2052158881\|dbj\|AP024713.1\|	2840180	g3376	i0	82.667	0.403225806451613	75	11	13	2	380	452	1151708	1151782	Campylobacter sp. 19-13652 DNA, complete genome	blastn	225	65.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. 19-13652
18326420	18326420	PRJNA493828_P_NODE_34055_length_248_cov_1.811429_g33636_i0	PRJNA493828	34055	248	1.811429	4.49234392	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g33636	i0	100	356.75	248	0	100	0	1	248	382	629	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	88474	459	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
18958319	18958319	PRJNA493828_P_NODE_5575_length_466_cov_3.145038_g5183_i0	PRJNA493828	5575	466	3.145038	14.65587708	Arcobacteraceae	2808963	Bacteria	Bacteria	822	0	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g5183	i0	98.498	416.442060085837	466	7	100	0	1	466	954078	953613	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	194062	822	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
19600765	19600765	PRJNA493828_P_NODE_39276_length_241_cov_2.839286_g38857_i0	PRJNA493828	39276	241	2.839286	6.84267926	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2581873871\|gb\|CP134842.1\|	2933791	g38857	i0	99.17	29.9253112033195	241	2	100	0	1	241	60961	61201	Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 65 chromosome, complete genome	blastn	7212	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
21508448	21508448	PRJNA493828_P_NODE_22437_length_279_cov_1.402913_g22018_i0	PRJNA493828	22437	279	1.402913	3.91412727	Campylobacter	194	Bacteria	Bacteria	508	1.27e-139	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g22018	i0	99.64	247.756272401434	278	1	99	0	2	279	158296	158019	Campylobacter rectus strain ATCC 33238, complete genome	blastn	69124	508	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
22783822	22783822	PRJNA493828_P_NODE_48738_length_196_cov_4.731707_g48319_i0	PRJNA493828	48738	196	4.731707	9.27414572	Aliarcobacter	2321111	Bacteria	Bacteria	363	6.899999999999998e-96	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g48319	i0	100	377.75	196	0	100	0	1	196	314	119	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	74039	363	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
23427447	23427447	PRJNA493828_P_NODE_6119_length_446_cov_9.474531_g5721_i0	PRJNA493828	6119	446	9.474531	42.25640826	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	741	0	NTclustered	gi\|219880899\|gb\|FJ535176.1\|	120858	g5721	i0	97.045	96.1614349775785	440	13	99	0	7	446	1385	946	Uncultured epsilon proteobacterium clone ATB-LH-5995 16S ribosomal RNA gene, partial sequence	blastn	42888	741	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
23427480	23427480	PRJNA493828_P_NODE_8379_length_389_cov_2.623418_g7964_i0	PRJNA493828	8379	389	2.623418	10.20509602	Candidatus Thiovulum stygium	2951083	Bacteria	Bacteria	87.9	1.02e-12	NTclustered	gi\|2182967327\|gb\|CP091137.1\|	2951083	g7964	i0	87.179	0.701799485861183	78	8	20	2	187	263	1035282	1035206	MAG: Candidatus Thiovulum stygium isolate 07-Movile_MetG_Ill chromosome, complete genome	blastn	273	87.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiovulum	Candidatus Thiovulum stygium
25332885	25332885	PRJNA493828_P_NODE_28300_length_260_cov_4.636364_g27881_i0	PRJNA493828	28300	260	4.636364	12.0545464	Aliarcobacter	2321111	Bacteria	Bacteria	448	2.5899999999999996e-121	NTclustered	gi\|1817415263\|gb\|CP026655.1\|	28198	g27881	i0	99.592	338.673076923077	245	1	94	0	14	258	62971	62727	Aliarcobacter cryaerophilus strain G13RTA chromosome, complete genome	blastn	88055	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
26918721	26918721	PRJNA493828_P_NODE_21522_length_282_cov_1.641148_g21103_i0	PRJNA493828	21522	282	1.641148	4.62803736	Campylobacterales bacterium	2268180	Bacteria	Bacteria	117	3.43e-29	NR	MFP4332947.1	2268180	g21103	i0	58.5	1	94	39	100	0	282	1	165	258	MFP4332947.1 hypothetical protein [Campylobacterales bacterium]	diamond	282	117	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
29098063	29098063	PRJNA493828_P_NODE_40248_length_239_cov_7.078313_g39829_i0	PRJNA493828	40248	239	7.078313	16.91716807	Campylobacterales bacterium	2268180	Bacteria	Bacteria	108	5.64e-27	NR	HOI83097.1	2268180	g39829	i0	100	0.690376569037657	55	0	69	0	73	237	1	55	HOI83097.1 SLAC1 anion channel family protein [Campylobacterales bacterium]	diamond	165	108	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
29255596	29255596	PRJNA493828_P_NODE_24529_length_272_cov_2.065327_g24110_i0	PRJNA493828	24529	272	2.065327	5.61768944	Helicobacter pylori	210	Bacteria	Bacteria	60.5	3.69e-10	NR	GAA9037979.1	210	g24110	i0	69.4	0.705882352941177	36	11	39.7	0	270	163	4	39	GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori]	diamond	192	60.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29839743	29839743	PRJNA493828_P_NODE_12251_length_332_cov_0.872587_g11832_i0	PRJNA493828	12251	332	0.872587	2.89698884	Pseudomonadati	3379134	Bacteria	Bacteria	47	0.00318	NR	WP_127681565.1	2579250	g11832	i0	46.8	4.12048192771084	47	24	42.5	1	141	1	1	46	WP_127681565.1 DNA repair protein RadA [Nautilia sp. PV-1]	diamond	1368	47.4	0.991561181434599	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Nautilia	Nautilia sp. PV-1
30361708	30361708	PRJNA493828_P_NODE_36272_length_245_cov_1.982558_g35853_i0	PRJNA493828	36272	245	1.982558	4.8572671	Helicobacter pylori	210	Bacteria	Bacteria	87	3.09e-19	NR	GAA9040163.1	210	g35853	i0	64.4	1.78775510204082	73	26	89.4	0	27	245	95	167	GAA9040163.1 hypothetical protein Kyoto184A_01960 [Helicobacter pylori]	diamond	438	87	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31293126	31293126	PRJNA493828_P_NODE_9875_length_362_cov_7.152249_g9457_i0	PRJNA493828	9875	362	7.152249	25.89114138	Pseudomonadati	3379134	Bacteria	Bacteria	107	4.06e-28	NR	GAA9180441.1	210	g9457	i0	100	1.74033149171271	47	0	39	0	51	191	1	47	GAA9180441.1 hypothetical protein Kyoto193A_2360 [Helicobacter pylori]	diamond	630	107	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);;