metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
507162	507162	PRJNA533623_P_NODE_67941_length_226_cov_6.369697_g66160_i0	PRJNA533623	67941	226	6.369697	14.39551522	Campylobacter ureolyticus	827	Bacteria	Bacteria	357	3.81e-94	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g66160	i0	98.515	3.57522123893805	202	3	89	0	5	206	465331	465532	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	808	357	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
3057826	3057826	PRJNA533623_P_NODE_58523_length_259_cov_10.166667_g56743_i0	PRJNA533623	58523	259	10.166667	26.33166753	Helicobacter typhlonius	76936	Bacteria	Bacteria	451	1.99e-122	NTclustered	gi\|953940668\|emb\|LN907858.1\|	76936	g56743	i0	99.2	0.965250965250965	250	2	97	0	1	250	1089063	1088814	Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I	blastn	250	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter typhlonius
9435482	9435482	PRJNA533623_P_NODE_70568_length_218_cov_2.783439_g68787_i0	PRJNA533623	70568	218	2.783439	6.06789702	Campylobacter showae	204	Bacteria	Bacteria	289	1.3499999999999998e-73	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g68787	i0	93.333	15.7614678899083	195	13	89	0	1	195	120928	120734	Campylobacter showae genome assembly, chromosome: I	blastn	3436	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
15809231	15809231	PRJNA533623_P_NODE_41793_length_334_cov_13.637363_g40019_i0	PRJNA533623	41793	334	13.637363	45.54879242	Helicobacter typhlonius	76936	Bacteria	Bacteria	553	7.079999999999998e-153	NTclustered	gi\|953940668\|emb\|LN907858.1\|	76936	g40019	i0	99.669	0.904191616766467	302	1	90	0	24	325	1129829	1130130	Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I	blastn	302	553	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter typhlonius
15809653	15809653	PRJNA533623_P_NODE_59993_length_254_cov_1.979275_g58213_i0	PRJNA533623	59993	254	1.979275	5.0273585	Arcobacter suis	1278212	Bacteria	Bacteria	126	1.3399999999999999e-24	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g58213	i0	89.109	3.63779527559055	101	11	40	0	21	121	2487412	2487512	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	924	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
17695726	17695726	PRJNA533623_P_NODE_26374_length_447_cov_14.018135_g24605_i0	PRJNA533623	26374	447	14.018135	62.66106345	Pseudomonadati	3379134	Bacteria	Bacteria	743	0	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g24605	i0	100	89.9328859060403	402	0	90	0	23	424	701325	701726	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	40200	743	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
17695994	17695994	PRJNA533623_P_NODE_58434_length_260_cov_1.306533_g56654_i0	PRJNA533623	58434	260	1.306533	3.3969858	Pseudomonadati	3379134	Bacteria	Bacteria	429	9.37e-116	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g56654	i0	100	89.2307692307692	232	0	89	0	13	244	701840	702071	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	23200	429	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
18969463	18969463	PRJNA533623_P_NODE_46295_length_311_cov_26.204000_g44517_i0	PRJNA533623	46295	311	26.204	81.49444	Campylobacter	194	Bacteria	Bacteria	484	2.4199999999999994e-132	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g44517	i0	98.897	193.543408360129	272	1	87	1	22	291	1582	1853	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	60192	484	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19632953	19632953	PRJNA533623_P_NODE_56056_length_269_cov_1.875000_g54276_i0	PRJNA533623	56056	269	1.875	5.04375	Campylobacter ureolyticus	827	Bacteria	Bacteria	470	5.74e-128	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g54276	i0	99.231	1.93308550185874	260	2	97	0	10	269	1361060	1361319	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	520	470	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
20909366	20909366	PRJNA533623_P_NODE_80017_length_185_cov_5.177419_g78236_i0	PRJNA533623	80017	185	5.177419	9.57822515	Helicobacter hepaticus	32025	Bacteria	Bacteria	302	1.42e-77	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g78236	i0	98.256	2.57297297297297	172	3	93	0	1	172	660896	661067	Helicobacter hepaticus ATCC 51449, complete genome	blastn	476	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
21519985	21519985	PRJNA533623_P_NODE_44637_length_320_cov_1.606178_g42863_i0	PRJNA533623	44637	320	1.606178	5.1397696	root	1	Root_unresolved	Root_unresolved	279	1.26e-70	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g42863	i0	94.054	58.96875	185	10	58	1	1	185	699760	699577	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	18870	279	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
21520213	21520213	PRJNA533623_P_NODE_75397_length_206_cov_0.958621_g73616_i0	PRJNA533623	75397	206	0.958621	1.97475926	root	1	Root_unresolved	Root_unresolved	204	4.7e-48	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g73616	i0	84.466	101.601941747573	206	32	100	0	1	206	699491	699696	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	20930	204	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
24731986	24731986	PRJNA533623_P_NODE_21520_length_501_cov_5.134091_g19771_i0	PRJNA533623	21520	501	5.134091	25.72179591	Candidatus Campylobacter infans	2561898	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1870124224\|gb\|CP049075.1\|	2561898	g19771	i0	92.5	0.0798403193612774	40	3	8	0	302	341	579436	579397	Candidatus Campylobacter infans strain 19S00001 chromosome, complete genome	blastn	40	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Candidatus Campylobacter infans

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