metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
7143965	7143965	PRJNA784298_P_NODE_8626_length_429_cov_2.303371_g8425_i0	PRJNA784298	8626	429	2.303371	9.88146159	Campylobacterales bacterium	2268180	Bacteria	Bacteria	184	1.9799999999999997e-57	NR	MBY0540711.1	2268180	g8425	i0	82.7	0.769230769230769	110	19	76.9	0	100	429	1	110	MBY0540711.1 response regulator [Campylobacterales bacterium]	diamond	330	184	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
26800399	26800399	PRJNA784298_P_NODE_15221_length_319_cov_1.313008_g15020_i0	PRJNA784298	15221	319	1.313008	4.18849552	Campylobacterales bacterium	2268180	Bacteria	Bacteria	123	7.12e-31	NR	MBY0540714.1	2268180	g15020	i0	68.4	0.74294670846395	79	16	67.7	2	103	318	1	77	MBY0540714.1 toprim domain-containing protein [Campylobacterales bacterium]	diamond	237	123	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
27179820	27179820	PRJNA784298_P_NODE_22362_length_259_cov_2.666667_g22161_i0	PRJNA784298	22362	259	2.666667	6.90666753	Campylobacterota bacterium	2026809	Bacteria	Bacteria	97.4	8.23e-24	NR	MDQ1326211.1	2026809	g22161	i0	59	0.961389961389961	83	33	96.1	1	252	4	1	82	MDQ1326211.1 hypothetical protein [Campylobacterota bacterium]	diamond	249	97.4	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
27874860	27874860	PRJNA784298_P_NODE_4545_length_597_cov_2.618321_g4347_i0	PRJNA784298	4545	597	2.618321	15.63137637	Campylobacterales bacterium	2268180	Bacteria	Bacteria	397	9.19e-136	NR	MBY0540714.1	2268180	g4347	i0	94.4	0.994974874371859	198	11	99.5	0	596	3	224	421	MBY0540714.1 toprim domain-containing protein [Campylobacterales bacterium]	diamond	594	397	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
28159319	28159319	PRJNA784298_P_NODE_5365_length_546_cov_3.668076_g5166_i0	PRJNA784298	5365	546	3.668076	20.02769496	Arcobacter roscoffensis	2961520	Bacteria	Bacteria	93.6	1.93e-20	NR	WP_254577520.1	2961520	g5166	i0	59.3	1.29120879120879	118	48	64.8	0	6	359	43	160	WP_254577520.1 acyltransferase [Arcobacter roscoffensis]	diamond	705	93.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter roscoffensis
28632891	28632891	PRJNA784298_P_NODE_11807_length_364_cov_2.268041_g11606_i0	PRJNA784298	11807	364	2.268041	8.25566924	Desulfurella sp.	1962857	Bacteria	Bacteria	50.1	2.91e-4	NR	WP_291490181.1	1962857	g11606	i0	54.5	1.64835164835165	44	20	36.3	0	269	138	169	212	WP_291490181.1 ankyrin repeat domain-containing protein, partial [Desulfurella sp.]	diamond	600	50.1	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales	Desulfurellaceae	Desulfurella	Desulfurella sp.
28632910	28632910	PRJNA784298_P_NODE_27_length_6605_cov_9.623546_g24_i0	PRJNA784298	27	6605	9.623546	635.6352133	Campylobacterales bacterium	2268180	Bacteria	Bacteria	122	1.78e-25	NR	HIM94542.1	2268180	g24	i0	29.7	0.87887963663891	320	181	14.5	8	2499	3458	3	278	HIM94542.1 transposase [Campylobacterales bacterium]	diamond	5805	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
29453267	29453267	PRJNA784298_P_NODE_16450_length_306_cov_1.540773_g16249_i0	PRJNA784298	16450	306	1.540773	4.71476538	Helicobacter japonicus	425400	Bacteria	Bacteria	47	3.44e-4	NR	WP_034362923.1	425400	g16249	i0	30.6	0.833333333333333	85	58	82.4	1	255	4	8	92	WP_034362923.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatC [Helicobacter japonicus]	diamond	255	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter japonicus
29548147	29548147	PRJNA784298_P_NODE_23610_length_251_cov_1.730337_g23409_i0	PRJNA784298	23610	251	1.730337	4.34314587	Helicobacteraceae bacterium	2212472	Bacteria	Bacteria	82.4	8.48e-17	NR	NOQ30227.1	2212472	g23409	i0	46.3	0.9800796812749	82	35	98	1	4	249	128	200	NOQ30227.1 hypothetical protein [Helicobacteraceae bacterium]	diamond	246	82.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae		Helicobacteraceae bacterium
29895784	29895784	PRJNA784298_P_NODE_26091_length_243_cov_1.358824_g25890_i0	PRJNA784298	26091	243	1.358824	3.30194232	Campylobacterales bacterium	2268180	Bacteria	Bacteria	155	3.22e-47	NR	MBY0540712.1	2268180	g25890	i0	91.3	0.987654320987654	80	7	98.8	0	2	241	13	92	MBY0540712.1 response regulator [Campylobacterales bacterium]	diamond	240	155	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
30653807	30653807	PRJNA784298_P_NODE_24093_length_250_cov_0.870056_g23892_i0	PRJNA784298	24093	250	0.870056	2.17514	Helicobacter pylori	210	Bacteria	Bacteria	68.9	3.02e-13	NR	GAA9246723.1	210	g23892	i0	71.8	0.468	39	11	46.8	0	90	206	10	48	GAA9246723.1 hypothetical protein Kyoto199A_0690 [Helicobacter pylori]	diamond	117	68.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31127516	31127516	PRJNA784298_P_NODE_28555_length_203_cov_5.261538_g28354_i0	PRJNA784298	28555	203	5.261538	10.68092214	Campylobacterales bacterium	2268180	Bacteria	Bacteria	81.3	6.38e-18	NR	MBY0540712.1	2268180	g28354	i0	95.1	0.605911330049261	41	2	60.6	0	79	201	1	41	MBY0540712.1 response regulator [Campylobacterales bacterium]	diamond	123	81.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
31199933	31199933	PRJNA784298_P_NODE_1895_length_924_cov_2.293772_g1727_i0	PRJNA784298	1895	924	2.293772	21.19445328	Campylobacterales	213849	Bacteria	Bacteria	198	9.889999999999998e-55	NR	WP_024954704.1	57666	g1727	i0	42.5	5.62987012987013	247	141	80.2	1	179	919	1	246	WP_024954704.1 FIST N-terminal domain-containing protein [Sulfurospirillum arcachonense]	diamond	5202	200	0.99	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum arcachonense
32212706	32212706	PRJNA784298_P_NODE_14858_length_323_cov_1.948000_g14657_i0	PRJNA784298	14858	323	1.948	6.29204	Bacteria	2	Bacteria	Bacteria	87.8	6.55e-20	NR	MDN2860585.1	197	g14657	i0	45.7	4.36532507739938	94	51	87.3	0	302	21	3	96	MDN2860585.1 hypothetical protein [Campylobacter jejuni]	diamond	1410	87.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32551659	32551659	PRJNA784298_P_NODE_18919_length_284_cov_2.156398_g18718_i0	PRJNA784298	18919	284	2.156398	6.12417032	Campylobacter sp.	205	Bacteria	Bacteria	110	1.11e-26	NR	WP_287722146.1	205	g18718	i0	58.5	0.992957746478873	94	39	99.3	0	3	284	103	196	WP_287722146.1 DNA adenine methylase [Campylobacter sp.]	diamond	282	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp.
32654842	32654842	PRJNA784298_P_NODE_12920_length_347_cov_1.945255_g12719_i0	PRJNA784298	12920	347	1.945255	6.75003485	Arcobacter	28196	Bacteria	Bacteria	58.9	2.62e-7	NR	OUR71149.1	1856277	g12719	i0	32.4	1.86743515850144	108	57	88.2	3	314	9	581	678	OUR71149.1 hypothetical protein A9Q76_06050 [Arcobacter sp. 31_11_sub10_T18]	diamond	648	58.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 31_11_sub10_T18
32843993	32843993	PRJNA784298_P_NODE_25460_length_245_cov_1.331395_g25259_i0	PRJNA784298	25460	245	1.331395	3.26191775	Campylobacterales	213849	Bacteria	Bacteria	47.8	6.28e-4	NR	NLN00010.1	2268179	g25259	i0	54.8	1.02857142857143	42	19	51.4	0	119	244	21	62	NLN00010.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	252	48.1	0.993762993762994	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium

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