metadata: contig_metadata: 11 rows where bioproject = "PRJNA725806", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA725806", 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
1194271	1194271	PRJNA725806_P_NODE_103721_length_194_cov_10.439490_g103419_i0	PRJNA725806	103721	194	10.43949	20.2526106	Campylobacter	194	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|744815412\|gb\|CP007774.1\|	580033	g103419	i0	94.444	0.556701030927835	36	2	19	0	158	193	897878	897843	Campylobacter volucris LMG 24379 chromosome, complete genome	blastn	108	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter volucris
1987931	1987931	PRJNA725806_P_NODE_4802_length_446_cov_2.865526_g4526_i0	PRJNA725806	4802	446	2.865526	12.78024596	Helicobacter pylori	210	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2641956183\|gb\|CP078386.1\|	210	g4526	i0	100	0.269058295964126	30	0	7	0	100	129	1106279	1106308	Helicobacter pylori strain HpGP-RUS-006 chromosome, complete genome	blastn	120	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
7090721	7090721	PRJNA725806_P_NODE_69886_length_223_cov_5.193548_g69585_i0	PRJNA725806	69886	223	5.193548	11.58161204	Helicobacter pylori	210	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2642635232\|gb\|CP079397.1\|	210	g69585	i0	97.059	0.152466367713004	34	0	15	1	23	56	147667	147699	Helicobacter pylori strain HpGP-LIT-013 chromosome, complete genome	blastn	34	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
12191209	12191209	PRJNA725806_P_NODE_30230_length_286_cov_6.184739_g29933_i0	PRJNA725806	30230	286	6.184739	17.68835354	Caminibacter mediatlanticus	291048	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1666442357\|gb\|CP040463.1\|	391592	g29933	i0	96.875	0.111888111888112	32	1	11	0	65	96	721257	721288	Caminibacter mediatlanticus TB-2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Caminibacter	Caminibacter mediatlanticus
12191343	12191343	PRJNA725806_P_NODE_82630_length_211_cov_3.304598_g82329_i0	PRJNA725806	82630	211	3.304598	6.97270178	Campylobacter lari	201	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1540241471\|emb\|LR134508.1\|	201	g82329	i0	90.698	0.611374407582938	43	2	20	2	112	153	27223	27182	Campylobacter lari strain NCTC11937 genome assembly, chromosome: 1	blastn	129	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
19838665	19838665	PRJNA725806_P_NODE_119616_length_184_cov_5.897959_g119314_i0	PRJNA725806	119616	184	5.897959	10.85224456	Malaciobacter pacificus	1080223	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1576839153\|gb\|CP035928.1\|	1080223	g119314	i0	96.875	0.173913043478261	32	1	17	0	134	165	2538045	2538014	Malaciobacter pacificus strain LMG 26638 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter pacificus
21114303	21114303	PRJNA725806_P_NODE_12417_length_356_cov_6.263323_g12128_i0	PRJNA725806	12417	356	6.263323	22.29742988	Campylobacter jejuni	197	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2076403051\|gb\|CP059375.1\|	197	g12128	i0	100	0.0786516853932584	28	0	8	0	329	356	733911	733884	Campylobacter jejuni strain 2012D-9520 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
21596606	21596606	PRJNA725806_P_NODE_174257_length_158_cov_2.413223_g173955_i0	PRJNA725806	174257	158	2.413223	3.81289234	Bacteria	2	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g173955	i0	100	366.037974683544	158	0	100	0	1	158	554384	554227	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	57834	292	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
22389474	22389474	PRJNA725806_P_NODE_898_length_734_cov_6.469154_g728_i0	PRJNA725806	898	734	6.469154	47.48359036	Campylobacter showae	204	Bacteria	Bacteria	1303	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g728	i0	99.306	230.310626702997	720	5	98	0	15	734	389363	390082	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	169048	1303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
24938427	24938427	PRJNA725806_P_NODE_62120_length_232_cov_5.794872_g61822_i0	PRJNA725806	62120	232	5.794872	13.44410304	uncultured Aliarcobacter sp.	2321118	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621785459\|emb\|OY781917.1\|	2321118	g61822	i0	96.875	0.137931034482759	32	1	14	0	193	224	1602110	1602079	MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2	blastn	32	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	uncultured Aliarcobacter sp.
28568098	28568098	PRJNA725806_P_NODE_44507_length_257_cov_6.040909_g44210_i0	PRJNA725806	44507	257	6.040909	15.52513613	Helicobacter turcicus	2867412	Bacteria	Bacteria	46.2	0.00242	NR	WP_221531207.1	2867412	g44210	i0	32.9	0.817120622568093	70	47	81.7	0	2	211	171	240	WP_221531207.1 bifunctional riboflavin kinase/FAD synthetase [Helicobacter turcicus]	diamond	210	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter turcicus

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