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

5 rows where bioproject = "PRJEB41113", 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
8986225	8986225	PRJEB41113_S_NODE_1528_length_240_cov_2.630542_g1519_i0	PRJEB41113	1528	240	2.630542	6.3133008	Campylobacter concisus	199	Bacteria	Bacteria	403	5.17e-108	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g1519	i0	97.071	17.9041666666667	239	7	99	0	2	240	485870	486108	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	4297	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17910704	17910704	PRJEB41113_S_NODE_5315_length_185_cov_4.074324_g5306_i0	PRJEB41113	5315	185	4.074324	7.5374994	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g5306	i0	100	0.151351351351351	28	0	15	0	85	112	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
26685135	26685135	PRJEB41113_S_NODE_2241_length_221_cov_5.722826_g2232_i0	PRJEB41113	2241	221	5.722826	12.64744546	Helicobacter pylori	210	Bacteria	Bacteria	42	0.00772	NR	GAA9192772.1	210	g2232	i0	85	0.271493212669683	20	3	27.1	0	69	128	2	21	GAA9192772.1 hypothetical protein Kyoto193A_3750 [Helicobacter pylori]	diamond	60	42	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30286655	30286655	PRJEB41113_S_NODE_5392_length_185_cov_1.148649_g5383_i0	PRJEB41113	5392	185	1.148649	2.12500065	Helicobacter pylori	210	Bacteria	Bacteria	57	1.39e-8	NR	GAA9128289.1	210	g5383	i0	75	0.583783783783784	36	9	58.4	0	165	58	53	88	GAA9128289.1 hypothetical protein Kyoto190A_1620 [Helicobacter pylori]	diamond	108	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32625688	32625688	PRJEB41113_S_NODE_9240_length_162_cov_35.472000_g9231_i0	PRJEB41113	9240	162	35.472	57.46464	Helicobacter pylori	210	Bacteria	Bacteria	44.7	3.67e-4	NR	GAA6820949.1	210	g9231	i0	48.8	0.759259259259259	41	14	63	1	162	61	2	42	GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori]	diamond	123	44.7	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);;