metadata: contig_metadata: 10 rows where bioproject = "PRJNA1145276" and tax

10 rows where bioproject = "PRJNA1145276" 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
28081162	28081162	PRJNA1145276_P_NODE_14345_length_267_cov_0.902062_g14288_i0	PRJNA1145276	14345	267	0.902062	2.40850554	Helicobacter pylori	210	Bacteria	Bacteria	49.7	1.32e-5	NR	GAA8925633.1	210	g14288	i0	80.8	1.1685393258427	26	5	29.2	0	235	158	1	26	GAA8925633.1 hypothetical protein Kyoto166A_4000 [Helicobacter pylori]	diamond	312	49.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29155041	29155041	PRJNA1145276_P_NODE_15909_length_251_cov_0.865169_g15852_i0	PRJNA1145276	15909	251	0.865169	2.17157419	Helicobacter pylori	210	Bacteria	Bacteria	68.9	2.5e-12	NR	GAA6899338.1	210	g15852	i0	57.9	1.55378486055777	57	24	68.1	0	223	53	33	89	GAA6899338.1 hypothetical protein Kyoto207A_1020 [Helicobacter pylori]	diamond	390	68.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29659551	29659551	PRJNA1145276_P_NODE_19690_length_241_cov_0.869048_g19633_i0	PRJNA1145276	19690	241	0.869048	2.09440568	Helicobacter pylori	210	Bacteria	Bacteria	50.1	8.87e-6	NR	GAA8687257.1	210	g19633	i0	54.8	0.522821576763486	42	19	52.3	0	92	217	25	66	GAA8687257.1 hypothetical protein Kyoto145A_1670 [Helicobacter pylori]	diamond	126	50.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29912765	29912765	PRJNA1145276_P_NODE_19511_length_241_cov_0.916667_g19454_i0	PRJNA1145276	19511	241	0.916667	2.20916747	Helicobacter pylori	210	Bacteria	Bacteria	61.2	1.69e-9	NR	GAA9246114.1	210	g19454	i0	58	0.622406639004149	50	21	62.2	0	91	240	97	146	GAA9246114.1 hypothetical protein Kyoto199A_0250 [Helicobacter pylori]	diamond	150	61.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30355427	30355427	PRJNA1145276_P_NODE_15892_length_251_cov_0.865169_g15835_i0	PRJNA1145276	15892	251	0.865169	2.17157419	Helicobacter pylori	210	Bacteria	Bacteria	50.1	8.54e-5	NR	GAA8854026.1	210	g15835	i0	67.6	0.884462151394422	37	12	44.2	0	141	251	189	225	GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori]	diamond	222	50.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30702442	30702442	PRJNA1145276_P_NODE_18754_length_243_cov_0.905882_g18697_i0	PRJNA1145276	18754	243	0.905882	2.20129326	Helicobacter pylori	210	Bacteria	Bacteria	86.7	1.56e-19	NR	GAA9038605.1	210	g18697	i0	86.7	0.555555555555556	45	6	55.6	0	136	2	62	106	GAA9038605.1 hypothetical protein Kyoto184A_01310 [Helicobacter pylori]	diamond	135	86.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31018459	31018459	PRJNA1145276_P_NODE_13015_length_282_cov_0.961722_g12958_i0	PRJNA1145276	13015	282	0.961722	2.71205604	Helicobacter pylori	210	Bacteria	Bacteria	62.4	1.61e-10	NR	GAA7000764.1	210	g12958	i0	51.9	2.36170212765957	54	26	57.4	0	234	73	2	55	GAA7000764.1 hypothetical protein Kyoto211A_5690 [Helicobacter pylori]	diamond	666	62.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31081696	31081696	PRJNA1145276_P_NODE_13715_length_274_cov_1.034826_g13658_i0	PRJNA1145276	13715	274	1.034826	2.83542324	Helicobacter pylori	210	Bacteria	Bacteria	42	0.0071	NR	GAA6859173.1	210	g13658	i0	63.3	0.656934306569343	30	11	32.8	0	273	184	10	39	GAA6859173.1 hypothetical protein Kyoto206A_0790 [Helicobacter pylori]	diamond	180	42	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31271294	31271294	PRJNA1145276_P_NODE_19675_length_241_cov_0.892857_g19618_i0	PRJNA1145276	19675	241	0.892857	2.15178537	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.0241	NR	GAA9231934.1	210	g19618	i0	51.4	0.460580912863071	37	16	43.6	1	167	63	4	40	GAA9231934.1 hypothetical protein Kyoto198A_4860 [Helicobacter pylori]	diamond	111	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31492826	31492826	PRJNA1145276_P_NODE_6336_length_397_cov_1.848765_g6279_i0	PRJNA1145276	6336	397	1.848765	7.33959705	Helicobacter pylori	210	Bacteria	Bacteria	47.8	6.3e-4	NR	GAA6899797.1	210	g6279	i0	34.4	0.680100755667506	90	59	68	0	293	24	1	90	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	270	47.8	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);;