metadata: contig_metadata: 5 rows where bioproject = "PRJNA898105", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA898105", 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
8526660	8526660	PRJNA898105_P_NODE_6047_length_251_cov_1.634831_g5847_i0	PRJNA898105	6047	251	1.634831	4.10342581	Campylobacter ureolyticus	827	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g5847	i0	98.805	5	251	3	100	0	1	251	1689573	1689323	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	1255	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
16546717	16546717	PRJNA898105_P_NODE_1993_length_423_cov_1.834286_g1793_i0	PRJNA898105	1993	423	1.834286	7.75902978	Campylobacter	194	Bacteria	Bacteria	771	0	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g1793	i0	99.527	132.09219858156	423	2	100	0	1	423	1035437	1035015	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	55875	771	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
18725271	18725271	PRJNA898105_P_NODE_3255_length_324_cov_0.920319_g3055_i0	PRJNA898105	3255	324	0.920319	2.98183356	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	220	7.88e-53	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g3055	i0	90.23	65.8734567901235	174	9	53	7	3	174	177	10	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	21343	220	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
20370547	20370547	PRJNA898105_P_NODE_5176_length_269_cov_1.341837_g4976_i0	PRJNA898105	5176	269	1.341837	3.60954153	root	1	Root_unresolved	Root_unresolved	497	2.63e-136	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g4976	i0	100	106	269	0	100	0	1	269	1035868	1036136	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	28514	497	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
27845275	27845275	PRJNA898105_P_NODE_5144_length_270_cov_0.883249_g4944_i0	PRJNA898105	5144	270	0.883249	2.3847723	Helicobacter pylori	210	Bacteria	Bacteria	71.6	1.66e-14	NR	GAA8812112.1	210	g4944	i0	71.4	0.466666666666667	42	12	46.7	0	127	2	2	43	GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori]	diamond	126	71.6	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);;