metadata: contig_metadata: 9 rows where bioproject = "PRJNA1120771", tax_phylum = "Campylobacterota" and tax

9 rows where bioproject = "PRJNA1120771", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
10480208	10480208	PRJNA1120771_S_NODE_20909_length_256_cov_27.305164_g20509_i0	PRJNA1120771	20909	256	27.305164	69.90121984	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g20509	i0	100	0.109375	28	0	11	0	95	122	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
16853917	16853917	PRJNA1120771_S_NODE_32994_length_213_cov_2.558824_g32594_i0	PRJNA1120771	32994	213	2.558824	5.45029512	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	73.1	1.44e-8	NTclustered	gi\|2621701254\|emb\|OY759974.1\|	2808971	g32594	i0	92.157	3.18779342723005	51	4	24	0	132	182	846658	846708	MAG: Arcobacteraceae bacterium isolate 2f960911-6b7a-430b-8fcb-36b605e4e712 genome assembly, chromosome: 1	blastn	679	73.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
27375779	27375779	PRJNA1120771_S_NODE_35483_length_206_cov_2.134969_g35083_i0	PRJNA1120771	35483	206	2.134969	4.39803614	root	1	Root_unresolved	Root_unresolved	44.7	3.56e-4	NR	GAA8856488.1	210	g35083	i0	51.4	1.73300970873786	35	17	51	0	109	5	1	35	GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori]	diamond	357	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28522969	28522969	PRJNA1120771_S_NODE_33347_length_212_cov_2.402367_g32947_i0	PRJNA1120771	33347	212	2.402367	5.09301804	Campylobacterota bacterium	2026809	Bacteria	Bacteria	42.7	0.0246	NR	NPA11277.1	2026809	g32947	i0	51.4	0.919811320754717	35	17	49.5	0	89	193	51	85	NPA11277.1 (Fe-S)-binding protein [Campylobacterota bacterium]	diamond	195	42.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29143884	29143884	PRJNA1120771_S_NODE_33789_length_211_cov_1.553571_g33389_i0	PRJNA1120771	33789	211	1.553571	3.27803481	root	1	Root_unresolved	Root_unresolved	48.5	1.48e-5	NR	GAA9111179.1	210	g33389	i0	39.6	6.96682464454976	48	29	68.2	0	46	189	2	49	GAA9111179.1 hypothetical protein Kyoto184A_09850 [Helicobacter pylori]	diamond	1470	48.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30786031	30786031	PRJNA1120771_S_NODE_29554_length_223_cov_2.611111_g29154_i0	PRJNA1120771	29554	223	2.611111	5.82277753	root	1	Root_unresolved	Root_unresolved	41.2	0.00943	NR	GAA8748121.1	210	g29154	i0	48.6	0.995515695067265	37	19	49.8	0	183	73	8	44	GAA8748121.1 hypothetical protein Kyoto147A_3030 [Helicobacter pylori]	diamond	222	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31175652	31175652	PRJNA1120771_S_NODE_16195_length_283_cov_1.812500_g15795_i0	PRJNA1120771	16195	283	1.8125	5.129375	Helicobacter pylori	210	Bacteria	Bacteria	43.5	0.003	NR	GAA8969655.1	210	g15795	i0	53.5	0.45583038869258	43	20	45.6	0	229	101	7	49	GAA8969655.1 hypothetical protein Kyoto181A_4370 [Helicobacter pylori]	diamond	129	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32693715	32693715	PRJNA1120771_S_NODE_26300_length_234_cov_1.863874_g25900_i0	PRJNA1120771	26300	234	1.863874	4.36146516	Helicobacter pylori	210	Bacteria	Bacteria	42.7	0.00333	NR	GAA9254308.1	210	g25900	i0	67.9	0.358974358974359	28	9	35.9	0	233	150	21	48	GAA9254308.1 hypothetical protein Kyoto199A_3000 [Helicobacter pylori]	diamond	84	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32693719	32693719	PRJNA1120771_S_NODE_33480_length_212_cov_1.029586_g33080_i0	PRJNA1120771	33480	212	1.029586	2.18272232	Helicobacter pylori	210	Bacteria	Bacteria	45.8	1.21e-4	NR	GAA8973712.1	210	g33080	i0	58.5	0.580188679245283	41	16	58	1	170	48	4	43	GAA8973712.1 hypothetical protein Kyoto181A_4710 [Helicobacter pylori]	diamond	123	45.8	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);;