metadata: contig_metadata: 13 rows where bioproject = "PRJNA917598" and tax

13 rows where bioproject = "PRJNA917598" 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
5999719	5999719	PRJNA917598_P_NODE_61925_length_287_cov_1.785047_g60981_i0	PRJNA917598	61925	287	1.785047	5.12308489	Arcobacter sp. FWKO B	2593672	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1913474794\|gb\|CP041403.1\|	2593672	g60981	i0	100	0.0975609756097561	28	0	10	0	15	42	1137597	1137570	Arcobacter sp. FWKO B chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. FWKO B
9825034	9825034	PRJNA917598_P_NODE_93708_length_242_cov_0.911243_g92764_i0	PRJNA917598	93708	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	131	4.91e-36	NR	MDR3346663.1	2268179	g92764	i0	91.3	2.51652892561983	69	6	85.5	0	240	34	161	229	MDR3346663.1 RelA/SpoT domain-containing protein [Campylobacteraceae bacterium]	diamond	609	132	0.992424242424242	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
15279240	15279240	PRJNA917598_P_NODE_36852_length_378_cov_1.514754_g35908_i0	PRJNA917598	36852	378	1.514754	5.72577012	Pseudomonadati	3379134	Bacteria	Bacteria	101	1.02e-22	NR	KIM09966.1	1539064	g35908	i0	56.4	1.88095238095238	78	34	61.9	0	235	2	2	79	KIM09966.1 MAG: aminotransferase [Sulfurovum sp. FS06-10]	diamond	711	102	0.990196078431373	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp. FS06-10
26644538	26644538	PRJNA917598_P_NODE_5421_length_1051_cov_2.012270_g4716_i0	PRJNA917598	5421	1051	2.01227	21.1489577	Campylobacterales bacterium	2268180	Bacteria	Bacteria	88.6	1.57e-15	NR	HIP02110.1	2268180	g4716	i0	57.3	0.214081826831589	75	32	21.4	0	225	1	1	75	HIP02110.1 DNA alkylation repair protein [Campylobacterales bacterium]	diamond	225	88.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
28453286	28453286	PRJNA917598_P_NODE_65286_length_281_cov_1.480769_g64342_i0	PRJNA917598	65286	281	1.480769	4.16096089	Pseudomonadati	3379134	Bacteria	Bacteria	139	1.75e-39	NR	WP_301346947.1	28197	g64342	i0	69.6	5.90391459074733	92	25	98.2	1	1	276	86	174	WP_301346947.1 acyltransferase [Aliarcobacter butzleri]	diamond	1659	140	0.992857142857143	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
29014490	29014490	PRJNA917598_P_NODE_48908_length_328_cov_1.207843_g47964_i0	PRJNA917598	48908	328	1.207843	3.96172504	Sulfurospirillum sp. UCH	2053622	Bacteria	Bacteria	160	2.2199999999999996e-47	NR	WP_067178248.1	1581011	g47964	i0	81.5	7.91158536585366	108	20	98.8	0	324	1	1	108	WP_067178248.1 TMEM165/GDT1 family protein [Sulfurospirillum sp. UCH001]	diamond	2595	160	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. UCH001
30150809	30150809	PRJNA917598_P_NODE_84712_length_248_cov_0.880000_g83768_i0	PRJNA917598	84712	248	0.88	2.1824	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	67	3.12e-11	NR	MCD4757232.1	2808971	g83768	i0	51.5	1.81451612903226	68	30	79.8	2	2	199	96	162	MCD4757232.1 TIGR02646 family protein [Arcobacteraceae bacterium]	diamond	450	67	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
30348418	30348418	PRJNA917598_P_NODE_34672_length_390_cov_1.447950_g33728_i0	PRJNA917598	34672	390	1.44795	5.647005	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	4e-5	NR	WP_208350301.1	210	g33728	i0	32.4	2	68	46	52.3	0	204	1	22	89	WP_208350301.1 hypothetical protein, partial [Helicobacter pylori]	diamond	780	50.8	0.992125984251969	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30537479	30537479	PRJNA917598_P_NODE_96453_length_238_cov_2.333333_g95509_i0	PRJNA917598	96453	238	2.333333	5.55333254	Bacteria	2	Bacteria	Bacteria	56.6	4.38e-7	NR	WP_273404694.1	522485	g95509	i0	57.8	2.47058823529412	45	19	56.7	0	236	102	525	569	WP_273404694.1 EcoAI/FtnUII family type I restriction enzme subunit R [Campylobacter avium]	diamond	588	56.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter avium
31668035	31668035	PRJNA917598_P_NODE_69137_length_274_cov_1.149254_g68193_i0	PRJNA917598	69137	274	1.149254	3.14895596	Sulfurimonas sp.	2022749	Bacteria	Bacteria	68.6	9.96e-13	NR	WP_321779451.1	2022749	g68193	i0	54.5	0.722627737226277	66	30	72.3	0	5	202	31	96	WP_321779451.1 DUF1778 domain-containing protein [Sulfurimonas sp.]	diamond	198	68.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
31857795	31857795	PRJNA917598_P_NODE_7397_length_885_cov_4.996305_g6593_i0	PRJNA917598	7397	885	4.996305	44.21729925	Halarcobacter sp.	2321133	Bacteria	Bacteria	110	9.98e-25	NR	WP_320035457.1	2321133	g6593	i0	33.3	2.59661016949153	276	161	91.2	11	50	856	10	269	WP_320035457.1 phosphodiester glycosidase family protein [Halarcobacter sp.]	diamond	2298	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter sp.
32308463	32308463	PRJNA917598_P_NODE_6979_length_914_cov_1.969084_g6197_i0	PRJNA917598	6979	914	1.969084	17.99742776	Pseudomonadati	3379134	Bacteria	Bacteria	79	3.31e-12	NR	WP_072680222.1	1898176	g6197	i0	27.4	3.99124726477024	219	157	71.2	2	656	6	357	575	WP_072680222.1 EAL domain-containing protein [Arcobacter sp. LA11]	diamond	3648	79	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. LA11
32837331	32837331	PRJNA917598_P_NODE_50940_length_321_cov_1.201613_g49996_i0	PRJNA917598	50940	321	1.201613	3.85717773	Sulfurovum sp.	1969726	Bacteria	Bacteria	87	1.72e-19	NR	MDD3500781.1	1969726	g49996	i0	55.1	0.831775700934579	89	27	83.2	1	43	309	24	99	MDD3500781.1 hypothetical protein [Sulfurovum sp.]	diamond	267	87	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.

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