metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax

24 rows where analysis = "blastn", bioproject = "PRJEB10140" 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
11689	11689	PRJEB10140_P_NODE_146061_length_253_cov_1.803922_g128753_i0	PRJEB10140	146061	253	1.803922	4.56392266	Helicobacter pylori	210	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2642226168\|gb\|CP078255.1\|	210	g128753	i0	100	1.6600790513834	28	0	11	0	44	71	712499	712472	Helicobacter pylori strain HpGP-TUR-021 chromosome, complete genome	blastn	420	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
1286351	1286351	PRJEB10140_P_NODE_20322_length_1493_cov_13.840028_g2275_i3	PRJEB10140	20322	1493	13.840028	206.63161804	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	58.4	0.003	NTclustered	gi\|2922095445\|gb\|CP182877.1\|	1355374	g2275	i3	97.059	0.0455458807769591	34	1	2	0	1169	1202	1942805	1942772	Aliarcobacter lanthieri strain BNI-4365 chromosome, complete genome	blastn	68	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
5114338	5114338	PRJEB10140_P_NODE_193925_length_200_cov_1.377483_g176616_i0	PRJEB10140	193925	200	1.377483	2.754966	Campylobacter sp. GTC17093	3382266	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2866683719\|dbj\|AP038832.1\|	3382266	g176616	i0	100	0.14	28	0	14	0	2	29	622936	622909	Campylobacter sp. GTC17093 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. GTC17093
7664434	7664434	PRJEB10140_P_NODE_222347_length_181_cov_1.575758_g205038_i0	PRJEB10140	222347	181	1.575758	2.85212198	Malaciobacter halophilus	197482	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1435905597\|gb\|CP031218.1\|	197482	g205038	i0	100	0.154696132596685	28	0	15	0	124	151	2158003	2158030	Malaciobacter halophilus strain CCUG 53805 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter halophilus
7665337	7665337	PRJEB10140_P_NODE_33787_length_1027_cov_2.851738_g21038_i0	PRJEB10140	33787	1027	2.851738	29.28734926	Arcobacter aquimarinus	1315211	Bacteria	Bacteria	56.5	0.008	NTclustered	gi\|1845961186\|gb\|CP030944.1\|	1315211	g21038	i0	97.059	0.0331061343719572	34	0	3	1	927	959	2122335	2122302	Arcobacter aquimarinus strain W63 chromosome, complete genome	blastn	34	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter aquimarinus
8938515	8938515	PRJEB10140_P_NODE_127688_length_287_cov_1.735294_g110381_i0	PRJEB10140	127688	287	1.735294	4.98029378	Arcobacter sp. 15-2	3374109	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2862971141\|dbj\|AP038804.1\|	3374109	g110381	i0	96.875	0.111498257839721	32	0	11	1	160	191	431608	431638	Arcobacter sp. 15-2 DNA, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 15-2
10215829	10215829	PRJEB10140_P_NODE_30849_length_1106_cov_22.406812_g4982_i2	PRJEB10140	30849	1106	22.406812	247.81934072	Campylobacter hepaticus	1813019	Bacteria	Bacteria	54.7	0.031	NTclustered	gi\|1940031893\|gb\|CP065357.1\|	1813019	g4982	i2	96.875	0.173598553345389	32	1	3	0	932	963	1417250	1417281	Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome	blastn	192	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hepaticus
11185294	11185294	PRJEB10140_P_NODE_122749_length_298_cov_2.060241_g105442_i0	PRJEB10140	122749	298	2.060241	6.13951818	root	1	Root_unresolved	Root_unresolved	130	1.24e-25	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g105442	i0	89.32	34.5637583892617	103	11	35	0	1	103	699328	699430	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	10300	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
11489650	11489650	PRJEB10140_P_NODE_14510_length_1833_cov_13.179933_g2275_i2	PRJEB10140	14510	1833	13.179933	241.58817189	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	58.4	0.004	NTclustered	gi\|2922095445\|gb\|CP182877.1\|	1355374	g2275	i2	97.059	0.0370976541189307	34	1	2	0	889	922	1942772	1942805	Aliarcobacter lanthieri strain BNI-4365 chromosome, complete genome	blastn	68	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
12765205	12765205	PRJEB10140_P_NODE_14391_length_1841_cov_12.474888_g2275_i1	PRJEB10140	14391	1841	12.474888	229.66268808	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	58.4	0.004	NTclustered	gi\|2922095445\|gb\|CP182877.1\|	1355374	g2275	i1	97.059	0.0369364475828354	34	1	2	0	897	930	1942772	1942805	Aliarcobacter lanthieri strain BNI-4365 chromosome, complete genome	blastn	68	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
14040449	14040449	PRJEB10140_P_NODE_247392_length_169_cov_0.866667_g230083_i0	PRJEB10140	247392	169	0.866667	1.46466723	Campylobacter concisus	199	Bacteria	Bacteria	291	2.75e-74	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g230083	i0	97.633	10.7988165680473	169	4	100	0	1	169	338438	338606	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	1825	291	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15009925	15009925	PRJEB10140_P_NODE_152132_length_244_cov_1.805128_g134824_i0	PRJEB10140	152132	244	1.805128	4.40451232	Aliarcobacter	2321111	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2305706618\|gb\|CP104378.1\|	28197	g134824	i0	100	0.229508196721311	28	0	11	0	121	148	1961647	1961674	Aliarcobacter butzleri strain P1100 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
15010286	15010286	PRJEB10140_P_NODE_97092_length_377_cov_1.704268_g79796_i0	PRJEB10140	97092	377	1.704268	6.4250903599999996	Campylobacter	194	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1540241471\|emb\|LR134508.1\|	201	g79796	i0	100	0.238726790450928	30	0	8	0	342	371	1457747	1457718	Campylobacter lari strain NCTC11937 genome assembly, chromosome: 1	blastn	90	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
15314246	15314246	PRJEB10140_P_NODE_207613_length_190_cov_1.432624_g190304_i0	PRJEB10140	207613	190	1.432624	2.7219856	Campylobacter vicugnae	1660076	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2678412531\|gb\|CP144916.1\|	1660076	g190304	i0	100	0.457894736842105	29	0	15	0	51	79	876482	876510	Campylobacter vicugnae strain RM9261 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
15315641	15315641	PRJEB10140_P_NODE_90453_length_404_cov_5.335211_g73164_i0	PRJEB10140	90453	404	5.335211	21.55425244	Campylobacter corcagiensis	1448857	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1847320813\|gb\|CP053842.1\|	1448857	g73164	i0	100	0.138613861386139	28	0	7	0	371	398	1131223	1131250	Campylobacter corcagiensis strain LMG 27932 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter corcagiensis
16589553	16589553	PRJEB10140_P_NODE_265514_length_166_cov_0.880342_g248205_i0	PRJEB10140	265514	166	0.880342	1.46136772	Malaciobacter canalis	1912871	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|1724553138\|gb\|CP042812.1\|	1912871	g248205	i0	99.398	3.96987951807229	166	1	100	0	1	166	661934	661769	Malaciobacter canalis strain LMG 29148 chromosome, complete genome	blastn	659	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter canalis
17863762	17863762	PRJEB10140_P_NODE_192095_length_201_cov_3.157895_g174786_i0	PRJEB10140	192095	201	3.157895	6.34736895	Arcobacter acticola	1849015	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1845963640\|gb\|CP042652.1\|	1849015	g174786	i0	100	0.144278606965174	29	0	14	0	36	64	355072	355100	Arcobacter acticola strain KCTC 52212 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter acticola
19137538	19137538	PRJEB10140_P_NODE_20396_length_1489_cov_6.439583_g11845_i0	PRJEB10140	20396	1489	6.439583	95.88539087	Campylobacter lari	201	Bacteria	Bacteria	54.7	0.043	NTclustered	gi\|2878709609\|gb\|CP176434.1\|	201	g11845	i0	96.875	0.0214909335124244	32	1	2	0	437	468	137932	137901	Campylobacter lari strain 3439-36 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
19137558	19137558	PRJEB10140_P_NODE_206216_length_191_cov_1.302817_g188907_i0	PRJEB10140	206216	191	1.302817	2.48838047	Sulfurospirillaceae bacterium ADMFC2	3385206	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2835534110\|dbj\|AP038756.1\|	3385206	g188907	i0	100	0.146596858638743	28	0	15	0	5	32	526910	526937	Sulfurospirillaceae bacterium ADMFC2 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae		Sulfurospirillaceae bacterium ADMFC2
20413412	20413412	PRJEB10140_P_NODE_272537_length_165_cov_0.879310_g255228_i0	PRJEB10140	272537	165	0.87931	1.4508615	Campylobacter devanensis	3161138	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g255228	i0	99.383	5.76969696969697	162	1	98	0	4	165	1302861	1303022	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	952	294	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
22659203	22659203	PRJEB10140_P_NODE_228118_length_178_cov_1.302326_g210809_i0	PRJEB10140	228118	178	1.302326	2.31814028	Campylobacter	194	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g210809	i0	100	15.7303370786517	28	0	16	0	139	166	1349767	1349794	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	2800	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
22963794	22963794	PRJEB10140_P_NODE_18379_length_1593_cov_10.448187_g5960_i2	PRJEB10140	18379	1593	10.448187	166.43961891	Campylobacter sp. CCS1377	3158229	Bacteria	Bacteria	54.7	0.046	NTclustered	gi\|2738339955\|gb\|CP155620.1\|	3158229	g5960	i2	100	0.0182046453232894	29	0	2	0	647	675	734437	734465	Campylobacter sp. CCS1377 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCS1377
23934466	23934466	PRJEB10140_P_NODE_151139_length_245_cov_247868.510204_g133831_i0	PRJEB10140	151139	245	247868.510204	607277.8499998	root	1	Root_unresolved	Root_unresolved	215	2.67e-51	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g133831	i0	99.16	77.8408163265306	119	1	71	0	1	119	699456	699338	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	19071	215	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
23934646	23934646	PRJEB10140_P_NODE_240779_length_171_cov_1.278689_g223470_i0	PRJEB10140	240779	171	1.278689	2.18655819	root	1	Root_unresolved	Root_unresolved	316	4.6e-82	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g223470	i0	100	101	171	0	100	0	1	171	1303170	1303000	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	17271	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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