metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA526367" 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
4323258	4323258	PRJNA526367_P_NODE_64464_length_152_cov_7.106796_g64254_i0	PRJNA526367	64464	152	7.106796	10.80232992	Campylobacter ureolyticus	827	Bacteria	Bacteria	241	2.47e-59	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g64254	i0	96.552	2.88157894736842	145	5	95	0	8	152	568752	568896	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	438	241	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
7491869	7491869	PRJNA526367_P_NODE_40886_length_181_cov_5.689394_g40676_i0	PRJNA526367	40886	181	5.689394	10.29780314	Campylobacter	194	Bacteria	Bacteria	316	4.939999999999999e-82	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g40676	i0	100	267.613259668508	171	0	94	0	8	178	28389	28559	Campylobacter showae genome assembly, plasmid: V	blastn	48438	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
8766709	8766709	PRJNA526367_P_NODE_37127_length_188_cov_2.935252_g36917_i0	PRJNA526367	37127	188	2.935252	5.51827376	root	1	Root_unresolved	Root_unresolved	329	6.65e-86	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g36917	i0	100	99.3617021276596	178	0	95	0	4	181	568503	568326	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	18680	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
11316714	11316714	PRJNA526367_P_NODE_26749_length_324_cov_1.847273_g26540_i0	PRJNA526367	26749	324	1.847273	5.98516452	Campylobacter	194	Bacteria	Bacteria	161	4.849999999999998e-35	NTclustered	gi\|1483583504\|emb\|LT631428.1\|	204	g26540	i0	97.849	3.07407407407407	93	2	59	0	8	100	26277	26369	Campylobacter showae genome assembly, plasmid: IV	blastn	996	161	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11974861	11974861	PRJNA526367_P_NODE_4890_length_332_cov_3.272085_g4681_i0	PRJNA526367	4890	332	3.272085	10.8633222	Campylobacter ureolyticus	827	Bacteria	Bacteria	239	2.24e-58	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g4681	i0	99.242	2.74698795180723	132	1	69	0	194	325	476882	477013	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	912	239	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
12592378	12592378	PRJNA526367_P_NODE_16570_length_324_cov_2.738182_g16361_i0	PRJNA526367	16570	324	2.738182	8.87170968	Campylobacter	194	Bacteria	Bacteria	183	1.03e-41	NTclustered	gi\|1483583501\|emb\|LT631425.1\|	204	g16361	i0	100	29.3734567901235	99	0	59	0	225	323	72844	72746	Campylobacter showae genome assembly, plasmid: I	blastn	9517	183	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
17691302	17691302	PRJNA526367_P_NODE_15774_length_324_cov_2.825455_g15565_i0	PRJNA526367	15774	324	2.825455	9.1544742	Campylobacter	194	Bacteria	Bacteria	180	1.34e-40	NTclustered	gi\|2093921460\|gb\|CP082871.1\|	76517	g15565	i0	100	2.73456790123457	97	0	59	0	4	100	79456	79360	Campylobacter hominis strain FDAARGOS_1467 chromosome, complete genome	blastn	886	180	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
22172806	22172806	PRJNA526367_P_NODE_4258_length_344_cov_2.210169_g4050_i0	PRJNA526367	4258	344	2.210169	7.60298136	Campylobacter fetus	196	Bacteria	Bacteria	172	2.39e-38	NTclustered	gi\|1043914323\|gb\|CP014570.1\|	32020	g4050	i0	98.969	0.552325581395349	97	0	55	1	4	100	20973	21068	Campylobacter fetus subsp. venerealis strain 01/165 plasmid mp2, complete sequence	blastn	190	172	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
22790866	22790866	PRJNA526367_P_NODE_3878_length_348_cov_4.588629_g3670_i0	PRJNA526367	3878	348	4.588629	15.96842892	Campylobacter	194	Bacteria	Bacteria	274	6.46e-69	NTclustered	gi\|2093923041\|gb\|CP082872.1\|	76517	g3670	i0	100	1.6551724137931	148	0	83	0	198	345	1771	1918	Campylobacter hominis strain FDAARGOS_1467 plasmid unnamed1, complete sequence	blastn	576	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis

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