metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
3649059	3649059	PRJNA488043_P_NODE_22363_length_151_cov_3.852459_g20121_i0	PRJNA488043	22363	151	3.852459	5.81721309	Campylobacter	194	Bacteria	Bacteria	209	6.91e-50	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g20121	i0	91.358	269.788079470199	162	1	99	1	3	151	571	732	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	40738	209	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
4926190	4926190	PRJNA488043_S_NODE_384_length_296_cov_4.655431_g373_i0	PRJNA488043	384	296	4.655431	13.78007576	Sulfurimonadaceae	2771471	Bacteria	Bacteria	122	2.07e-23	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g373	i0	79.348	32.2331081081081	184	31	60	6	18	196	1884696	1884515	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	9541	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
6200988	6200988	PRJNA488043_P_NODE_11965_length_283_cov_4.814961_g9724_i0	PRJNA488043	11965	283	4.814961	13.62633963	Campylobacter	194	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g9724	i0	100	235.265017667845	283	0	100	0	1	283	1113952	1113670	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	66580	523	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10653443	10653443	PRJNA488043_P_NODE_10909_length_311_cov_4.492908_g8668_i0	PRJNA488043	10909	311	4.492908	13.97294388	Campylobacter showae	204	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g8668	i0	100	235.263665594855	311	0	100	0	1	311	389474	389784	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	73167	575	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11301165	11301165	PRJNA488043_P_NODE_19629_length_175_cov_3.602740_g17387_i0	PRJNA488043	19629	175	3.60274	6.304795	Campylobacter	194	Bacteria	Bacteria	315	1.7000000000000002e-81	NTclustered	gi\|1938730527\|gb\|CP049274.1\|	199	g17387	i0	99.422	245.011428571429	173	1	99	0	3	175	1135849	1135677	Campylobacter concisus strain P10CDO-S2 chromosome, complete genome	blastn	42877	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12576794	12576794	PRJNA488043_P_NODE_10910_length_311_cov_4.432624_g8669_i0	PRJNA488043	10910	311	4.432624	13.78546064	Campylobacter	194	Bacteria	Bacteria	569	6.489999999999998e-158	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g8669	i0	99.678	235.845659163987	311	1	100	0	1	311	1113670	1113980	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	73348	569	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12577025	12577025	PRJNA488043_P_NODE_8930_length_376_cov_4.092219_g6710_i0	PRJNA488043	8930	376	4.092219	15.38674344	Campylobacter	194	Bacteria	Bacteria	608	1.689999999999999e-169	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g6710	i0	94.778	226.311170212766	383	13	100	1	1	376	1113670	1114052	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	85093	608	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20851665	20851665	PRJNA488043_S_NODE_1357_length_165_cov_9.551471_g1346_i0	PRJNA488043	1357	165	9.551471	15.75992715	Campylobacter hepaticus	1813019	Bacteria	Bacteria	100	4.86e-17	NTclustered	gi\|1940031893\|gb\|CP065357.1\|	1813019	g1346	i0	85.714	152.048484848485	98	11	59	3	1	97	21396	21491	Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome	blastn	25088	100	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hepaticus

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