metadata: contig_metadata: 12 rows where bioproject = "PRJNA431371", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA431371", 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
2978869	2978869	PRJNA431371_P_NODE_23723_length_258_cov_1.389189_g23650_i0	PRJNA431371	23723	258	1.389189	3.58410762	Campylobacter rectus	203	Bacteria	Bacteria	416	7.229999999999998e-112	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g23650	i0	95.736	2	258	11	100	0	1	258	1939289	1939546	Campylobacter rectus strain ATCC 33238, complete genome	blastn	516	416	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
9356717	9356717	PRJNA431371_P_NODE_7868_length_440_cov_1.258856_g7795_i0	PRJNA431371	7868	440	1.258856	5.5389664	Bacteria	2	Bacteria	Bacteria	268	2.5199999999999993e-87	NR	MBM18008.1	2026809	g7795	i0	93.2	1.97727272727273	146	10	99.5	0	440	3	95	240	MBM18008.1 rod shape-determining protein [Campylobacterota bacterium]	diamond	870	268	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
19554179	19554179	PRJNA431371_P_NODE_27316_length_249_cov_0.875000_g27243_i0	PRJNA431371	27316	249	0.875	2.17875	Campylobacter showae	204	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|1483583493\|emb\|LT631417.1\|	204	g27243	i0	99.197	2	249	2	100	0	1	249	272009	271761	Campylobacter showae genome assembly, chromosome: I	blastn	498	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23380462	23380462	PRJNA431371_P_NODE_28919_length_248_cov_0.880000_g28846_i0	PRJNA431371	28919	248	0.88	2.1824	Caminibacter pacificus	1424653	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1690432421\|gb\|CP027432.2\|	1424653	g28846	i0	96.97	0.133064516129032	33	0	13	1	130	162	1556101	1556132	Caminibacter pacificus strain TB6 chromosome, complete genome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Caminibacter	Caminibacter pacificus
27423674	27423674	PRJNA431371_P_NODE_27063_length_249_cov_0.875000_g26990_i0	PRJNA431371	27063	249	0.875	2.17875	Helicobacter pylori	210	Bacteria	Bacteria	45.4	0.00261	NR	GAA9208890.1	210	g26990	i0	45.6	1.30120481927711	57	26	67.5	2	220	53	108	160	GAA9208890.1 hypothetical protein Kyoto198A_1340 [Helicobacter pylori]	diamond	324	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27865301	27865301	PRJNA431371_P_NODE_30405_length_246_cov_0.890173_g30332_i0	PRJNA431371	30405	246	0.890173	2.18982558	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	166	9.239999999999999e-48	NR	WP_177389253.1	218934	g30332	i0	100	1	82	0	100	0	1	246	27	108	WP_177389253.1 ArsS family sensor histidine kinase [uncultured Campylobacter sp.]	diamond	246	166	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
29917944	29917944	PRJNA431371_P_NODE_14571_length_334_cov_1.180077_g14498_i0	PRJNA431371	14571	334	1.180077	3.94145718	Campylobacterota bacterium	2026809	Bacteria	Bacteria	48.5	8.47e-4	NR	MCL4431196.1	2026809	g14498	i0	28.3	0.826347305389222	92	58	82.6	1	3	278	8	91	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	276	48.5	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
31655817	31655817	PRJNA431371_P_NODE_30897_length_246_cov_0.890173_g30824_i0	PRJNA431371	30897	246	0.890173	2.18982558	Aliarcobacter butzleri	28197	Bacteria	Bacteria	47.8	4.2e-5	NR	WP_305863257.1	28197	g30824	i0	60	0.426829268292683	35	14	42.7	0	230	126	10	44	WP_305863257.1 DUF1725 domain-containing protein, partial [Aliarcobacter butzleri]	diamond	105	47.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
31814179	31814179	PRJNA431371_P_NODE_6917_length_465_cov_1.551020_g6844_i0	PRJNA431371	6917	465	1.55102	7.212243	Campylobacterota bacterium	2026809	Bacteria	Bacteria	49.3	0.00184	NR	MEA3354675.1	2026809	g6844	i0	43.1	0.419354838709677	65	36	41.9	1	192	386	683	746	MEA3354675.1 adenylate/guanylate cyclase domain-containing protein [Campylobacterota bacterium]	diamond	195	49.3	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
31845698	31845698	PRJNA431371_P_NODE_35437_length_242_cov_0.911243_g35364_i0	PRJNA431371	35437	242	0.911243	2.20520806	Helicobacter pylori	210	Bacteria	Bacteria	52.4	1.68e-6	NR	GAA6955618.1	210	g35364	i0	75.9	0.359504132231405	29	7	36	0	241	155	53	81	GAA6955618.1 hypothetical protein Kyoto211A_1650 [Helicobacter pylori]	diamond	87	52.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32115535	32115535	PRJNA431371_P_NODE_30278_length_246_cov_0.890173_g30205_i0	PRJNA431371	30278	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	46.2	2.62e-4	NR	GAA9043861.1	210	g30205	i0	55.3	1.35365853658537	47	20	57.3	1	40	180	14	59	GAA9043861.1 hypothetical protein Kyoto184A_02700 [Helicobacter pylori]	diamond	333	46.6	0.991416309012876	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32888219	32888219	PRJNA431371_P_NODE_35040_length_242_cov_0.911243_g34967_i0	PRJNA431371	35040	242	0.911243	2.20520806	Helicobacter pylori	210	Bacteria	Bacteria	44.3	0.00139	NR	GAA8823266.1	210	g34967	i0	59.3	0.334710743801653	27	11	33.5	0	159	79	3	29	GAA8823266.1 hypothetical protein Kyoto149A_4100 [Helicobacter pylori]	diamond	81	44.3	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);;