metadata: contig_metadata: 21 rows where bioproject = "PRJNA763243", tax_kingdom = "Pseudomonadati" and tax

21 rows where bioproject = "PRJNA763243", 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
3756847	3756847	PRJNA763243_P_NODE_10943_length_456_cov_1.741514_g10600_i0	PRJNA763243	10943	456	1.741514	7.94130384	Bacteria	2	Bacteria	Bacteria	230	1.9e-55	NTclustered	gi\|1919195970\|gb\|CP063088.1\|	201	g10600	i0	81.818	60.2565789473684	275	48	60	2	183	456	750867	750594	Campylobacter lari strain 2014D-0218 chromosome, complete genome	blastn	27477	230	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
5846553	5846553	PRJNA763243_P_NODE_28205_length_310_cov_10.734177_g27859_i0	PRJNA763243	28205	310	10.734177	33.2759487	Campylobacter concisus	199	Bacteria	Bacteria	466	8.73e-127	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g27859	i0	93.16	39.1451612903226	307	18	98	1	4	307	1444250	1443944	Campylobacter concisus strain RMIT-O23 chromosome	blastn	12135	466	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
7122385	7122385	PRJNA763243_P_NODE_57566_length_246_cov_0.890173_g57220_i0	PRJNA763243	57566	246	0.890173	2.18982558	Wolinella succinogenes	844	Bacteria	Bacteria	420	5.29e-113	NTclustered	gi\|34482172\|emb\|BX571657.1\|	844	g57220	i0	97.942	1.97560975609756	243	4	99	1	1	243	128475	128234	Wolinella succinogenes, complete genome; segment 1/7	blastn	486	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
8397068	8397068	PRJNA763243_P_NODE_62907_length_241_cov_13.666667_g62561_i0	PRJNA763243	62907	241	13.666667	32.93666747	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g62561	i0	91.845	2.7800829875518702	233	19	97	0	5	237	323076	323308	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	670	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
11409000	11409000	PRJNA763243_P_NODE_34689_length_291_cov_7.674312_g34343_i0	PRJNA763243	34689	291	7.674312	22.33224792	Campylobacter	194	Bacteria	Bacteria	209	1.51e-49	NTclustered	gi\|2305955962\|gb\|CP012549.1\|	1660063	g34343	i0	90.968	7.17525773195876	155	14	53	0	137	291	723730	723884	Campylobacter sp. RM16187, complete genome	blastn	2088	209	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM16187
12223132	12223132	PRJNA763243_P_NODE_48390_length_257_cov_14.581522_g48044_i0	PRJNA763243	48390	257	14.581522	37.47451154	Campylobacter sp. GTC17093	3382266	Bacteria	Bacteria	446	9.179999999999998e-121	NTclustered	gi\|2866683719\|dbj\|AP038832.1\|	3382266	g48044	i0	98.425	260.988326848249	254	2	98	2	5	257	47701	47449	Campylobacter sp. GTC17093 DNA, complete genome	blastn	67074	446	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. GTC17093
14772792	14772792	PRJNA763243_P_NODE_64912_length_238_cov_3.866667_g64566_i0	PRJNA763243	64912	238	3.866667	9.20266746	Wolinella succinogenes	844	Bacteria	Bacteria	416	6.579999999999998e-112	NTclustered	gi\|34483865\|emb\|BX571662.1\|	844	g64566	i0	98.718	1.96638655462185	234	3	98	0	2	235	191580	191813	Wolinella succinogenes, complete genome; segment 6/7	blastn	468	416	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
16046520	16046520	PRJNA763243_P_NODE_65793_length_235_cov_8.456790_g65447_i0	PRJNA763243	65793	235	8.45679	19.8734565	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	387	5.08e-103	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g65447	i0	97.38	234.612765957447	229	3	97	1	4	229	84699	84927	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	55134	387	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
16508166	16508166	PRJNA763243_P_NODE_55793_length_247_cov_3.643678_g55447_i0	PRJNA763243	55793	247	3.643678	8.99988466	Sulfurospirillum	57665	Bacteria	Bacteria	180	9.82e-41	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g55447	i0	80.498	36.2267206477733	241	42	96	5	7	244	1333	1095	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	8948	180	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
17321020	17321020	PRJNA763243_P_NODE_1494_length_1023_cov_933.589474_g1296_i0	PRJNA763243	1494	1023	933.589474	9550.62031902	Helicobacter pylori	210	Bacteria	Bacteria	143	5.99e-29	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g1296	i0	91.429	11.8035190615836	105	8	19	1	1	105	1292677	1292574	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	12075	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
17782992	17782992	PRJNA763243_P_NODE_73954_length_202_cov_9.232558_g73608_i0	PRJNA763243	73954	202	9.232558	18.64976716	Helicobacter	209	Bacteria	Bacteria	363	7.149999999999999e-96	NTclustered	gi\|2157108461\|dbj\|AP025204.1\|	213	g73608	i0	99.497	133.30198019802	199	1	99	0	1	199	128390	128192	Helicobacter cinaedi 94105 DNA, complete genome	blastn	26927	363	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cinaedi
20331501	20331501	PRJNA763243_P_NODE_10136_length_471_cov_15.597990_g9793_i0	PRJNA763243	10136	471	15.59799	73.4665329	Campylobacter	194	Bacteria	Bacteria	854	0	NTclustered	gi\|373279146\|gb\|JN713167.1\|	203	g9793	i0	99.574	112.422505307856	469	1	99	1	4	471	442	910	Campylobacter rectus canine oral taxon 010 clone OB004 16S ribosomal RNA gene, partial sequence	blastn	52951	854	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
23695588	23695588	PRJNA763243_P_NODE_13299_length_418_cov_2551.530435_g12954_i0	PRJNA763243	13299	418	2551.530435	10665.3972183	Helicobacter pylori	210	Bacteria	Bacteria	141	8.34e-29	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g12954	i0	93.617	14.4043062200957	94	6	22	0	325	418	1292584	1292677	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	6021	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
24156985	24156985	PRJNA763243_P_NODE_48819_length_257_cov_0.896739_g48473_i0	PRJNA763243	48819	257	0.896739	2.30461923	Helicobacter	209	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|3023090\|gb\|AF054578.1\|AF054578	75047	g48473	i0	99.611	109.003891050584	257	1	100	0	1	257	629	885	Helicobacter sp. UNSW1.7sp 16S ribosomal RNA gene, partial sequence	blastn	28014	470	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. UNSW1.7sp
24970632	24970632	PRJNA763243_P_NODE_71620_length_212_cov_32.294964_g71274_i0	PRJNA763243	71620	212	32.294964	68.46532368	Campylobacter sp. RM16187	1660063	Bacteria	Bacteria	377	2.71e-100	NTclustered	gi\|2305955962\|gb\|CP012549.1\|	1660063	g71274	i0	99.517	257.77358490566	207	1	98	0	4	210	818262	818468	Campylobacter sp. RM16187, complete genome	blastn	54648	377	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM16187
25432041	25432041	PRJNA763243_P_NODE_9720_length_479_cov_18.583744_g9377_i0	PRJNA763243	9720	479	18.583744	89.01613376	Campylobacter	194	Bacteria	Bacteria	863	0	NTclustered	gi\|1622749546\|gb\|CP012545.1\|	1032243	g9377	i0	99.37	244.713987473904	476	3	99	0	4	479	727345	727820	Campylobacter californiensis strain RM6914, complete genome	blastn	117218	869	0.993095512082854	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter californiensis
27021585	27021585	PRJNA763243_P_NODE_66802_length_232_cov_3.377358_g66456_i0	PRJNA763243	66802	232	3.377358	7.83547056	Desulfurellales bacterium	2482794	Bacteria	Bacteria	53.5	4.14e-6	NR	TXH54326.1	2482794	g66456	i0	48.3	1.51293103448276	58	30	75	0	48	221	174	231	TXH54326.1 MAG: hypothetical protein E6Q97_11250 [Desulfurellales bacterium]	diamond	351	53.5	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
27084836	27084836	PRJNA763243_P_NODE_59362_length_244_cov_2.087719_g59016_i0	PRJNA763243	59362	244	2.087719	5.09403436	Sulfurimonas sp.	2022749	Bacteria	Bacteria	42.4	0.0383	NR	MDQ7043078.1	2022749	g59016	i0	44.9	0.602459016393443	49	24	56.6	1	100	237	63	111	MDQ7043078.1 hypothetical protein [Sulfurimonas sp.]	diamond	147	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
28127159	28127159	PRJNA763243_P_NODE_66725_length_232_cov_7.911950_g66379_i0	PRJNA763243	66725	232	7.91195	18.355724	Sulfurimonadaceae bacterium	2771476	Bacteria	Bacteria	48.5	1.82e-4	NR	MCW8838973.1	2771476	g66379	i0	44.6	0.724137931034483	56	30	71.1	1	65	229	2	57	MCW8838973.1 hypothetical protein [Sulfurimonadaceae bacterium]	diamond	168	48.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae		Sulfurimonadaceae bacterium
28632426	28632426	PRJNA763243_P_NODE_30987_length_305_cov_5.086207_g30641_i0	PRJNA763243	30987	305	5.086207	15.51293135	Helicobacter pylori	210	Bacteria	Bacteria	103	1.04e-25	NR	GAA8854299.1	210	g30641	i0	96	0.491803278688525	50	2	49.2	0	1	150	35	84	GAA8854299.1 hypothetical protein DUHN55_46680 [Helicobacter pylori]	diamond	150	103	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30242857	30242857	PRJNA763243_P_NODE_55792_length_247_cov_3.718391_g55446_i0	PRJNA763243	55792	247	3.718391	9.18442577	Helicobacter pylori	210	Bacteria	Bacteria	52	1.3e-6	NR	GAA9176533.1	210	g55446	i0	55.4	0.680161943319838	56	24	68	1	10	177	1	55	GAA9176533.1 hypothetical protein Kyoto193A_0850 [Helicobacter pylori]	diamond	168	52	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);;