metadata: contig_metadata: 7 rows where bioproject = "PRJNA1198392", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1198392", 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
324479	324479	PRJNA1198392_P_NODE_13961_length_262_cov_1.275132_g13820_i0	PRJNA1198392	13961	262	1.275132	3.34084584	Campylobacter concisus	199	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1063302220\|gb\|CP000792.2\|	360104	g13820	i0	99.618	17.3206106870229	262	1	100	0	1	262	747493	747754	Campylobacter concisus 13826 chromosome, complete genome	blastn	4538	479	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
324594	324594	PRJNA1198392_P_NODE_19741_length_244_cov_0.900585_g19600_i0	PRJNA1198392	19741	244	0.900585	2.1974274	Arcobacter roscoffensis	2961520	Bacteria	Bacteria	235	2.0399999999999997e-57	NTclustered	gi\|2270258285\|gb\|CP100595.1\|	2961520	g19600	i0	84.362	2.01639344262295	243	34	99	4	4	244	2907094	2907334	Arcobacter roscoffensis strain ARW1-2F2 chromosome, complete genome	blastn	492	235	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter roscoffensis
7977852	7977852	PRJNA1198392_P_NODE_13347_length_265_cov_2.229167_g13206_i0	PRJNA1198392	13347	265	2.229167	5.90729255	Campylobacter rectus	203	Bacteria	Bacteria	440	4.419999999999998e-119	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g13206	i0	96.604	9.73584905660377	265	9	100	0	1	265	218983	218719	Campylobacter rectus strain ATCC 33238, complete genome	blastn	2580	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
16901597	16901597	PRJNA1198392_P_NODE_12094_length_272_cov_1.326633_g11953_i0	PRJNA1198392	12094	272	1.326633	3.60844176	Campylobacter concisus	199	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|157101564\|gb\|CP000793.1\|	360104	g11953	i0	100	1.20955882352941	272	0	100	0	1	272	20758	20487	Campylobacter concisus 13826 plasmid pCCON31, complete sequence	blastn	329	503	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
26692632	26692632	PRJNA1198392_P_NODE_21941_length_217_cov_3.784722_g21800_i0	PRJNA1198392	21941	217	3.784722	8.21284674	Helicobacter pylori	210	Bacteria	Bacteria	39.7	0.0378	NR	WP_316480680.1	210	g21800	i0	88.9	0.248847926267281	18	2	24.9	0	1	54	7	24	WP_316480680.1 hypothetical protein [Helicobacter pylori]	diamond	54	39.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29598496	29598496	PRJNA1198392_P_NODE_19230_length_245_cov_0.895349_g19089_i0	PRJNA1198392	19230	245	0.895349	2.19360505	Helicobacter pylori	210	Bacteria	Bacteria	58.2	2.45e-9	NR	GAA8692375.1	210	g19089	i0	49.1	0.673469387755102	55	13	67.3	1	232	68	2	41	GAA8692375.1 hypothetical protein Kyoto145A_2350 [Helicobacter pylori]	diamond	165	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30641087	30641087	PRJNA1198392_P_NODE_9133_length_286_cov_1.610329_g8992_i0	PRJNA1198392	9133	286	1.610329	4.60554094	Helicobacter pylori	210	Bacteria	Bacteria	72.4	6.32e-14	NR	GAA6955717.1	210	g8992	i0	44.9	1.02797202797203	98	19	67.1	2	1	192	6	102	GAA6955717.1 hypothetical protein Kyoto211A_1670 [Helicobacter pylori]	diamond	294	72.4	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);;