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

13 rows where analysis = "blastn", bioproject = "PRJNA643700" 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
3168967	3168967	PRJNA643700_P_NODE_299543_length_210_cov_1.291925_g297987_i0	PRJNA643700	299543	210	1.291925	2.7130425	Arcobacter venerupis	1054033	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1847324382\|gb\|CP053840.1\|	1054033	g297987	i0	100	0.133333333333333	28	0	13	0	88	115	2761702	2761729	Arcobacter venerupis strain LMG 26156 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter venerupis
5721561	5721561	PRJNA643700_P_NODE_106945_length_402_cov_4.804533_g105391_i0	PRJNA643700	106945	402	4.804533	19.31422266	Arcobacter iocasae	2906515	Bacteria	Bacteria	58.4	8.28e-4	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g105391	i0	100	0.0771144278606965	31	0	8	0	363	393	686366	686336	Arcobacter sp. KX21116 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
5721595	5721595	PRJNA643700_P_NODE_153465_length_328_cov_2.354839_g151910_i0	PRJNA643700	153465	328	2.354839	7.72387192	Aliarcobacter butzleri	28197	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|526271239\|gb\|CP006615.1\|	1036172	g151910	i0	100	0.341463414634146	28	0	9	0	179	206	114736	114763	Arcobacter butzleri 7h1h, complete genome	blastn	112	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
8271463	8271463	PRJNA643700_P_NODE_332767_length_193_cov_2.027778_g331211_i0	PRJNA643700	332767	193	2.027778	3.9136115400000002	Helicobacter pylori	210	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2642300512\|gb\|CP078412.1\|	210	g331211	i0	100	0.290155440414508	28	0	15	0	68	95	191396	191423	Helicobacter pylori strain HpGP-POR-102 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
10822254	10822254	PRJNA643700_P_NODE_102809_length_411_cov_2.174033_g101255_i0	PRJNA643700	102809	411	2.174033	8.93527563	Candidatus Thiovulum stygium	2951083	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|2182967327\|gb\|CP091137.1\|	2951083	g101255	i0	100	0.0681265206812652	28	0	7	0	297	324	1233022	1232995	MAG: Candidatus Thiovulum stygium isolate 07-Movile_MetG_Ill chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiovulum	Candidatus Thiovulum stygium
10822258	10822258	PRJNA643700_P_NODE_109629_length_397_cov_2.402299_g108075_i0	PRJNA643700	109629	397	2.402299	9.53712703	Helicobacter pylori	210	Bacteria	Bacteria	58.4	8.17e-4	NTclustered	gi\|2642415116\|gb\|CP079341.1\|	210	g108075	i0	78.723	0.236775818639798	94	15	23	4	189	281	1097908	1097819	Helicobacter pylori strain HpGP-PER-020 chromosome, complete genome	blastn	94	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
15920954	15920954	PRJNA643700_P_NODE_220193_length_261_cov_2.207547_g218637_i0	PRJNA643700	220193	261	2.207547	5.76169767	Malaciobacter canalis	1912871	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1724553138\|gb\|CP042812.1\|	1912871	g218637	i0	100	0.10727969348659	28	0	11	0	224	251	1135613	1135640	Malaciobacter canalis strain LMG 29148 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter canalis
15921069	15921069	PRJNA643700_P_NODE_356073_length_182_cov_2.736842_g354517_i0	PRJNA643700	356073	182	2.736842	4.98105244	Campylobacter canadensis	449520	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1845963639\|gb\|CP035946.1\|	449520	g354517	i0	100	0.153846153846154	28	0	15	0	44	71	549840	549813	Campylobacter canadensis strain LMG 24001 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter canadensis
15921167	15921167	PRJNA643700_P_NODE_425713_length_162_cov_0.920354_g424157_i0	PRJNA643700	425713	162	0.920354	1.49097348	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2581873871\|gb\|CP134842.1\|	2933791	g424157	i0	100	0.537037037037037	29	0	18	0	122	150	1750831	1750859	Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 65 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
19744937	19744937	PRJNA643700_P_NODE_195676_length_282_cov_2.596567_g194120_i0	PRJNA643700	195676	282	2.596567	7.32231894	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621701254\|emb\|OY759974.1\|	2808971	g194120	i0	100	0.198581560283688	28	0	10	0	163	190	112319	112346	MAG: Arcobacteraceae bacterium isolate 2f960911-6b7a-430b-8fcb-36b605e4e712 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
20285094	20285094	PRJNA643700_P_NODE_357836_length_182_cov_1.052632_g356280_i0	PRJNA643700	357836	182	1.052632	1.91579024	Campylobacter	194	Bacteria	Bacteria	211	2.41e-50	NTclustered	gi\|2524016160\|dbj\|AP028392.1\|	197	g356280	i0	88.108	248.351648351648	185	12	100	7	1	182	809432	809609	Campylobacter jejuni BCH-11447 DNA, complete genome	blastn	45200	211	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
21020555	21020555	PRJNA643700_P_NODE_283437_length_219_cov_1.141176_g281881_i0	PRJNA643700	283437	219	1.141176	2.49917544	Halarcobacter mediterraneus	2023153	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2621784616\|emb\|OY781074.1\|	2023153	g281881	i0	100	0.127853881278539	28	0	13	0	149	176	344552	344525	MAG: Halarcobacter mediterraneus isolate a5fc0a89-db13-449e-aec2-f9d0956b3340 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter mediterraneus
22295220	22295220	PRJNA643700_P_NODE_268718_length_227_cov_2.629213_g267162_i0	PRJNA643700	268718	227	2.629213	5.96831351	Campylobacter sp. RM12651	1660079	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2198381838\|gb\|CP059600.1\|	1660079	g267162	i0	100	0.123348017621145	28	0	12	0	141	168	1740102	1740075	Campylobacter sp. RM12651 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM12651

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