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

5 rows where bioproject = "PRJNA1226487", 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
5438329	5438329	PRJNA1226487_P_NODE_81825_length_226_cov_2.013072_g81723_i0	PRJNA1226487	81825	226	2.013072	4.54954272	Campylobacter geochelonis	1780362	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1847322497\|gb\|CP053844.1\|	1780362	g81723	i0	92.308	0.172566371681416	39	1	17	2	91	129	2096805	2096841	Campylobacter geochelonis strain LMG 29375 chromosome, complete genome	blastn	39	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter geochelonis
7988463	7988463	PRJNA1226487_P_NODE_74587_length_244_cov_0.900585_g74485_i0	PRJNA1226487	74587	244	0.900585	2.1974274	Campylobacter rectus	203	Bacteria	Bacteria	368	1.92e-97	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g74485	i0	93.852	12.7131147540984	244	15	100	0	1	244	1668880	1669123	Campylobacter rectus strain ATCC 33238, complete genome	blastn	3102	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
20736550	20736550	PRJNA1226487_P_NODE_82057_length_224_cov_4.437086_g81955_i0	PRJNA1226487	82057	224	4.437086	9.93907264	Campylobacter ureolyticus	827	Bacteria	Bacteria	407	3.69e-109	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g81955	i0	100	3.92857142857143	220	0	98	0	1	220	1341984	1341765	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	880	407	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
27786637	27786637	PRJNA1226487_P_NODE_76544_length_242_cov_1.822485_g76442_i0	PRJNA1226487	76544	242	1.822485	4.4104137	Pseudomonadati	3379134	Bacteria	Bacteria	59.3	2.31e-8	NR	MCB4773506.1	1969726	g76442	i0	39.4	8.81404958677686	71	43	88	0	10	222	52	122	MCB4773506.1 DUF1891 domain-containing protein [Sulfurovum sp.]	diamond	2133	59.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
30249739	30249739	PRJNA1226487_P_NODE_7232_length_494_cov_3.807601_g7135_i0	PRJNA1226487	7232	494	3.807601	18.80954894	Pseudomonadati	3379134	Bacteria	Bacteria	123	1e-31	NR	GMT39229.1	56877	g7135	i0	45.5	7.63967611336032	156	74	94.7	4	474	7	68	212	GMT39229.1 glutathione S-transferase family protein [Helicobacter bizzozeronii]	diamond	3774	124	0.991935483870968	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter bizzozeronii

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