metadata: contig_metadata: 5 rows where bioproject = "PRJNA640350" and tax

5 rows where bioproject = "PRJNA640350" 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
17188371	17188371	PRJNA640350_P_NODE_25794_length_187_cov_1.563291_g25633_i0	PRJNA640350	25794	187	1.563291	2.92335417	Campylobacter showae	204	Bacteria	Bacteria	257	3.1600000000000004e-64	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g25633	i0	91.444	6.95187165775401	187	16	100	0	1	187	1051296	1051110	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	1300	257	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
28988497	28988497	PRJNA640350_P_NODE_24288_length_193_cov_28.902439_g24127_i0	PRJNA640350	24288	193	28.902439	55.78170727	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.00157	NR	GAA9176272.1	210	g24127	i0	73.9	2.39378238341969	23	6	35.8	0	193	125	7	29	GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori]	diamond	462	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29606906	29606906	PRJNA640350_P_NODE_37410_length_156_cov_2.173228_g37249_i0	PRJNA640350	37410	156	2.173228	3.39023568	Campylobacter jejuni	197	Bacteria	Bacteria	41.6	0.00759	NR	WP_215425550.1	197	g37249	i0	84.2	0.769230769230769	19	3	36.5	0	58	114	1	19	WP_215425550.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	120	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
29904041	29904041	PRJNA640350_P_NODE_31311_length_169_cov_1.935714_g31150_i0	PRJNA640350	31311	169	1.935714	3.27135666	Campylobacter	194	Bacteria	Bacteria	106	1.1e-25	NR	WP_304346457.1	204	g31150	i0	98.2	1.98816568047337	56	1	99.4	0	169	2	136	191	WP_304346457.1 type VI secretion system domain-containing protein, partial [Campylobacter showae]	diamond	336	107	0.990654205607477	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
30523321	30523321	PRJNA640350_P_NODE_93_length_1658_cov_4.082259_g72_i0	PRJNA640350	93	1658	4.082259	67.68385422	Campylobacter jejuni	197	Bacteria	Bacteria	481	1.4499999999999999e-164	NR	ECO5635035.1	197	g72	i0	73.8	0.627864897466827	347	85	62.1	5	167	1195	1	345	ECO5635035.1 tyrosine-type recombinase/integrase [Campylobacter jejuni]	diamond	1041	481	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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