metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB39643" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB39643" 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
27633837	27633837	PRJEB39643_P_NODE_98564_length_262_cov_1.629630_g98371_i0	PRJEB39643	98564	262	1.62963	4.2696306	Sulfuricurvum sp.	2025608	Bacteria	Bacteria	69.7	1.48e-11	NR	WP_329657453.1	2025608	g98371	i0	51.3	0.893129770992366	78	36	89.3	1	256	23	406	481	WP_329657453.1 efflux transporter outer membrane subunit [Sulfuricurvum sp.]	diamond	234	69.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp.
28511159	28511159	PRJEB39643_P_NODE_159007_length_210_cov_5.503650_g158813_i0	PRJEB39643	159007	210	5.50365	11.557665	Sulfuricurvum	286130	Bacteria	Bacteria	119	3.61e-29	NR	WP_299938567.1	2025608	g158813	i0	78.3	1.97142857142857	69	15	98.6	0	208	2	48	116	WP_299938567.1 efflux RND transporter permease subunit [Sulfuricurvum sp.]	diamond	414	120	0.991666666666667	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp.
29111151	29111151	PRJEB39643_P_NODE_120008_length_252_cov_1.720670_g119815_i0	PRJEB39643	120008	252	1.72067	4.3360884	Bacteria	2	Bacteria	Bacteria	62.8	9.55e-11	NR	GAA8948737.1	210	g119815	i0	66	1.08333333333333	50	16	59.5	1	3	152	8	56	GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori]	diamond	273	63.2	0.993670886075949	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29489775	29489775	PRJEB39643_P_NODE_29410_length_339_cov_3.360902_g29217_i0	PRJEB39643	29410	339	3.360902	11.39345778	Pseudomonadati	3379134	Bacteria	Bacteria	179	5.619999999999999e-55	NR	MCH3765027.1	195	g29217	i0	90.2	2.97345132743363	112	8	99.1	2	3	338	37	145	MCH3765027.1 hypothetical protein [Campylobacter coli]	diamond	1008	179	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29685688	29685688	PRJEB39643_P_NODE_78450_length_271_cov_1.924242_g78257_i0	PRJEB39643	78450	271	1.924242	5.21469582	Helicobacter pylori	210	Bacteria	Bacteria	108	8.9e-29	NR	GAA9165282.1	210	g78257	i0	94.2	0.575645756457565	52	3	57.6	0	18	173	1	52	GAA9165282.1 hypothetical protein Kyoto190A_5390 [Helicobacter pylori]	diamond	156	108	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29812100	29812100	PRJEB39643_P_NODE_127671_length_249_cov_1.750000_g127478_i0	PRJEB39643	127671	249	1.75	4.3575	Campylobacter concisus	199	Bacteria	Bacteria	134	3.98e-35	NR	WP_181001734.1	199	g127478	i0	79.5	1	83	16	98.8	1	246	1	19	101	WP_181001734.1 mobilization protein [Campylobacter concisus]	diamond	249	134	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
30475826	30475826	PRJEB39643_P_NODE_133533_length_247_cov_1.770115_g133340_i0	PRJEB39643	133533	247	1.770115	4.37218405	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	146	7.479999999999997e-42	NR	WP_295141220.1	218934	g133340	i0	93.9	0.995951417004049	82	5	99.6	0	246	1	142	223	WP_295141220.1 hypothetical protein [uncultured Campylobacter sp.]	diamond	246	146	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
30570205	30570205	PRJEB39643_P_NODE_110753_length_256_cov_1.683060_g110560_i0	PRJEB39643	110753	256	1.68306	4.3086336	Campylobacter concisus	199	Bacteria	Bacteria	176	6.5999999999999986e-49	NR	MBS6287164.1	199	g110560	i0	95.3	0.99609375	85	4	99.6	0	256	2	712	796	MBS6287164.1 hypothetical protein [Campylobacter concisus]	diamond	255	176	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
31518832	31518832	PRJEB39643_P_NODE_133656_length_247_cov_1.770115_g133463_i0	PRJEB39643	133656	247	1.770115	4.37218405	Campylobacter concisus	199	Bacteria	Bacteria	107	5.15e-26	NR	MBF0928657.1	199	g133463	i0	98.2	1.33603238866397	55	1	66.8	0	1	165	272	326	MBF0928657.1 C4-dicarboxylate transporter DcuC [Campylobacter concisus]	diamond	330	107	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
31708476	31708476	PRJEB39643_P_NODE_15897_length_463_cov_2.479487_g15705_i0	PRJEB39643	15897	463	2.479487	11.48002481	Candidatus Sulfurimonas baltica	2740404	Bacteria	Bacteria	51.6	1.25e-4	NR	WP_194368918.1	2740404	g15705	i0	48.9	0.660907127429806	45	23	29.2	0	209	75	146	190	WP_194368918.1 tetratricopeptide repeat protein [Candidatus Sulfurimonas baltica]	diamond	306	51.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Candidatus Sulfurimonas baltica
32119932	32119932	PRJEB39643_P_NODE_2558_length_1237_cov_11.766323_g2467_i0	PRJEB39643	2558	1237	11.766323	145.54941551	Sulfuricurvum sp.	2025608	Bacteria	Bacteria	77.4	4.05e-12	NR	WP_299936147.1	2025608	g2467	i0	33.7	1.06709781729992	104	69	25.2	0	911	600	36	139	WP_299936147.1 class I SAM-dependent methyltransferase [Sulfuricurvum sp.]	diamond	1320	77.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp.
32303315	32303315	PRJEB39643_P_NODE_93099_length_264_cov_2.198953_g92906_i0	PRJEB39643	93099	264	2.198953	5.80523592	Bacteria	2	Bacteria	Bacteria	136	1.4e-39	NR	MCH3756027.1	195	g92906	i0	100	1.63636363636364	72	0	81.8	0	262	47	25	96	MCH3756027.1 MucR family transcriptional regulator [Campylobacter coli]	diamond	432	136	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
32341538	32341538	PRJEB39643_P_NODE_97739_length_262_cov_1.629630_g97546_i0	PRJEB39643	97739	262	1.62963	4.2696306	Helicobacter pylori	210	Bacteria	Bacteria	67	1.04e-12	NR	GAA6795254.1	210	g97546	i0	59.2	2.8969465648855	49	19	56.1	1	48	194	2	49	GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori]	diamond	759	67	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32398060	32398060	PRJEB39643_P_NODE_39439_length_299_cov_1.938053_g39246_i0	PRJEB39643	39439	299	1.938053	5.79477847	Pseudomonadati	3379134	Bacteria	Bacteria	148	1.27e-40	NR	WP_294892330.1	1537917	g39246	i0	71.7	8.91973244147157	99	28	99.3	0	3	299	44	142	WP_294892330.1 efflux RND transporter permease subunit, partial [Sulfuricurvum sp. MLSB]	diamond	2667	148	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum sp. MLSB
32720281	32720281	PRJEB39643_P_NODE_67500_length_277_cov_1.509804_g67307_i0	PRJEB39643	67500	277	1.509804	4.18215708	Campylobacter concisus	199	Bacteria	Bacteria	156	2.6e-44	NR	MBS6286247.1	199	g67307	i0	96	0.812274368231047	75	3	81.2	0	53	277	1	75	MBS6286247.1 LPXTG cell wall anchor domain-containing protein [Campylobacter concisus]	diamond	225	156	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus

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