metadata: contig_metadata: 18 rows where bioproject = "PRJNA700095" and tax

18 rows where bioproject = "PRJNA700095" 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
18535172	18535172	PRJNA700095_P_NODE_65015_length_241_cov_1.464286_g63751_i0	PRJNA700095	65015	241	1.464286	3.52892926	Campylobacter rectus	203	Bacteria	Bacteria	442	1.0999999999999999e-119	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g63751	i0	100	256.261410788382	239	0	99	0	1	239	160423	160661	Campylobacter rectus strain ATCC 33238, complete genome	blastn	61759	442	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
26893135	26893135	PRJNA700095_P_NODE_29061_length_315_cov_2.425620_g27797_i0	PRJNA700095	29061	315	2.42562	7.640703	Campylobacter jejuni	197	Bacteria	Bacteria	52.8	7.11e-6	NR	WP_323470850.1	197	g27797	i0	33.3	0.742857142857143	78	48	71.4	2	310	86	68	144	WP_323470850.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	234	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
27556474	27556474	PRJNA700095_P_NODE_4984_length_883_cov_2.804938_g4007_i0	PRJNA700095	4984	883	2.804938	24.76760254	Campylobacterota bacterium	2026809	Bacteria	Bacteria	74.3	3.45e-11	NR	MCL4431196.1	2026809	g4007	i0	28.2	0.530011325028313	156	97	48.6	3	687	259	4	157	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	468	74.3	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
27651547	27651547	PRJNA700095_P_NODE_25644_length_339_cov_1.710526_g24380_i0	PRJNA700095	25644	339	1.710526	5.79868314	Helicobacter pylori	210	Bacteria	Bacteria	50.8	4.55e-6	NR	GAA9037979.1	210	g24380	i0	62.2	1.24778761061947	37	14	32.7	0	63	173	3	39	GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori]	diamond	423	50.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27746336	27746336	PRJNA700095_P_NODE_10624_length_594_cov_1.907869_g9384_i0	PRJNA700095	10624	594	1.907869	11.33274186	Campylobacterota bacterium	2026809	Bacteria	Bacteria	52.8	2.24e-4	NR	MCL4431196.1	2026809	g9384	i0	53.2	0.237373737373737	47	22	23.7	0	159	19	4	50	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	141	52.8	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
27840664	27840664	PRJNA700095_P_NODE_62804_length_243_cov_0.900000_g61540_i0	PRJNA700095	62804	243	0.9	2.187	Helicobacter pylori	210	Bacteria	Bacteria	54.3	7.53e-8	NR	GAA8733143.1	210	g61540	i0	70.6	0.419753086419753	34	10	42	0	104	3	2	35	GAA8733143.1 hypothetical protein Kyoto147A_1090 [Helicobacter pylori]	diamond	102	54.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28724935	28724935	PRJNA700095_P_NODE_20347_length_391_cov_2.009434_g19084_i0	PRJNA700095	20347	391	2.009434	7.85688694	Campylobacter jejuni	197	Bacteria	Bacteria	100	5.16e-24	NR	WP_323470850.1	197	g19084	i0	90.6	0.406649616368286	53	5	40.7	0	389	231	103	155	WP_323470850.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	159	100	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
29577160	29577160	PRJNA700095_P_NODE_12250_length_546_cov_1.194503_g11000_i0	PRJNA700095	12250	546	1.194503	6.52198638	Campylobacterota bacterium	2026809	Bacteria	Bacteria	180	1.37e-52	NR	MCL4431196.1	2026809	g11000	i0	54.6	1.01648351648352	185	67	100	2	546	1	8	178	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	555	180	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29640234	29640234	PRJNA700095_P_NODE_59030_length_245_cov_1.412791_g57766_i0	PRJNA700095	59030	245	1.412791	3.46133795	Campylobacterota bacterium	2026809	Bacteria	Bacteria	94.7	3.33e-21	NR	MCL4431196.1	2026809	g57766	i0	56.5	1.04081632653061	85	30	95.5	2	236	3	205	289	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	255	94.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
30378678	30378678	PRJNA700095_P_NODE_32132_length_301_cov_1.872807_g30868_i0	PRJNA700095	32132	301	1.8728070000000001	5.63714907	Nitratiruptor	269258	Bacteria	Bacteria	84	2.59e-16	NR	WP_201334422.1	2724897	g30868	i0	62.5	1.27574750830565	64	23	62.8	1	14	202	1766	1829	WP_201334422.1 beta strand repeat-containing protein [Nitratiruptor sp. YY08-10]	diamond	384	84	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitratiruptor	Nitratiruptor sp. YY08-10
30378680	30378680	PRJNA700095_P_NODE_53752_length_249_cov_0.875000_g52488_i0	PRJNA700095	53752	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	51.6	2.09e-6	NR	GAA9176824.1	210	g52488	i0	77.8	2.25301204819277	27	6	32.5	0	37	117	1	27	GAA9176824.1 hypothetical protein Kyoto193A_1160 [Helicobacter pylori]	diamond	561	52	0.992307692307692	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30777900	30777900	PRJNA700095_P_NODE_34114_length_292_cov_2.027397_g32850_i0	PRJNA700095	34114	292	2.027397	5.91999924	Helicobacter pylori	210	Bacteria	Bacteria	58.9	1.04e-8	NR	GAA9176272.1	210	g32850	i0	80.6	0.955479452054795	31	6	31.8	0	58	150	1	31	GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori]	diamond	279	58.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30967575	30967575	PRJNA700095_P_NODE_54474_length_248_cov_1.925714_g53210_i0	PRJNA700095	54474	248	1.925714	4.77577072	Helicobacter pylori	210	Bacteria	Bacteria	43.5	0.00439	NR	GAA9038095.1	210	g53210	i0	39.3	2.34677419354839	61	12	73.8	1	202	20	3	38	GAA9038095.1 hypothetical protein Kyoto184A_00980 [Helicobacter pylori]	diamond	582	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31125016	31125016	PRJNA700095_P_NODE_41395_length_272_cov_1.994975_g40131_i0	PRJNA700095	41395	272	1.994975	5.426332	Helicobacter pylori	210	Bacteria	Bacteria	52.4	6.52e-7	NR	GAA8906355.1	210	g40131	i0	70.6	1.13602941176471	34	9	37.5	1	270	169	14	46	GAA8906355.1 hypothetical protein Kyoto166A_0340 [Helicobacter pylori]	diamond	309	52.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31631323	31631323	PRJNA700095_P_NODE_51116_length_251_cov_1.606742_g49852_i0	PRJNA700095	51116	251	1.606742	4.03292242	Campylobacter jejuni	197	Bacteria	Bacteria	56.6	1.18e-7	NR	WP_323470850.1	197	g49852	i0	34.1	1.01593625498008	85	54	99.2	1	3	251	56	140	WP_323470850.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	255	56.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32390732	32390732	PRJNA700095_P_NODE_6499_length_778_cov_2.548936_g5414_i0	PRJNA700095	6499	778	2.548936	19.83072208	Campylobacterota bacterium	2026809	Bacteria	Bacteria	67.4	5.4e-9	NR	MCL4431196.1	2026809	g5414	i0	30.3	0.508997429305913	132	77	45.9	3	320	676	2	131	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	396	67.4	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
32454219	32454219	PRJNA700095_P_NODE_47299_length_259_cov_1.338710_g46035_i0	PRJNA700095	47299	259	1.33871	3.4672589	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	42.7	0.043	NR	WP_105939929.1	28198	g46035	i0	41.9	0.498069498069498	43	25	49.8	0	225	97	193	235	WP_105939929.1 phage replisome organizer N-terminal domain-containing protein [Aliarcobacter cryaerophilus]	diamond	129	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
32863828	32863828	PRJNA700095_P_NODE_65060_length_241_cov_1.375000_g63796_i0	PRJNA700095	65060	241	1.375	3.31375	Helicobacter pylori	210	Bacteria	Bacteria	52.4	4.09e-7	NR	GAA6858477.1	210	g63796	i0	66.7	0.746887966804979	30	10	37.3	0	29	118	6	35	GAA6858477.1 hypothetical protein Kyoto206A_0230 [Helicobacter pylori]	diamond	180	52.4	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);;