metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA597223" 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
2416057	2416057	PRJNA597223_P_NODE_41242_length_222_cov_1.727273_g39396_i0	PRJNA597223	41242	222	1.727273	3.83454606	root	1	Root_unresolved	Root_unresolved	405	1.31e-108	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g39396	i0	99.55	100	222	1	100	0	1	222	698714	698493	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	22200	405	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
4396704	4396704	PRJNA597223_P_NODE_40344_length_225_cov_2.000000_g38498_i0	PRJNA597223	40344	225	2	4.5	Arcobacter iocasae	2906515	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g38498	i0	100	0.133333333333333	30	0	13	0	49	78	2410718	2410747	Arcobacter sp. KX21116 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
5673155	5673155	PRJNA597223_P_NODE_67305_length_175_cov_1.621429_g65459_i0	PRJNA597223	67305	175	1.621429	2.83750075	Arcobacter ellisii	913109	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g65459	i0	98.701	2.98285714285714	154	2	88	0	1	154	2261989	2262142	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	522	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
6947075	6947075	PRJNA597223_P_NODE_16746_length_405_cov_2.651351_g14938_i0	PRJNA597223	16746	405	2.651351	10.73797155	Campylobacter concisus	199	Bacteria	Bacteria	697	0	NTclustered	gi\|1938726479\|gb\|CP049270.1\|	199	g14938	i0	97.772	236.140740740741	404	9	99	0	2	405	1056100	1056503	Campylobacter concisus strain P26UCO-S2 chromosome, complete genome	blastn	95637	697	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10069251	10069251	PRJNA597223_P_NODE_24168_length_319_cov_6.940141_g22324_i0	PRJNA597223	24168	319	6.940141	22.13904979	Campylobacter	194	Bacteria	Bacteria	540	5.24e-149	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g22324	i0	97.179	239	319	9	100	0	1	319	779	1097	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	76241	545	0.990825688073395	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10773189	10773189	PRJNA597223_P_NODE_20209_length_359_cov_4.379630_g18375_i0	PRJNA597223	20209	359	4.37963	15.7228717	Arcobacter ellisii	913109	Bacteria	Bacteria	643	4.409999999999999e-180	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g18375	i0	99.16	401.554317548746	357	3	99	0	3	359	954070	953714	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	144158	643	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
12619725	12619725	PRJNA597223_P_NODE_28190_length_287_cov_19.075397_g26344_i0	PRJNA597223	28190	287	19.075397	54.74638939	root	1	Root_unresolved	Root_unresolved	477	3.6899999999999996e-130	NTclustered	gi\|285182751\|gb\|GU418883.1\|	824	g26344	i0	96.853	103.648083623693	286	7	99	2	1	284	290	5	Campylobacter gracilis clone OCQ007 16S ribosomal RNA gene, partial sequence	blastn	29747	477	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
15871966	15871966	PRJNA597223_P_NODE_57053_length_187_cov_2.125000_g55207_i0	PRJNA597223	57053	187	2.125	3.97375	Campylobacter showae	204	Bacteria	Bacteria	121	4.3299999999999996e-23	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g55207	i0	95.946	4.56149732620321	74	3	77	0	2	75	3195	3268	Campylobacter showae genome assembly, chromosome: I	blastn	853	121	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
15872163	15872163	PRJNA597223_P_NODE_76133_length_162_cov_2.307087_g74287_i0	PRJNA597223	76133	162	2.307087	3.73748094	Campylobacter gracilis	824	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g74287	i0	100	249.975308641975	162	0	100	0	1	162	502424	502263	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	40496	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
15872280	15872280	PRJNA597223_P_NODE_86733_length_151_cov_2.612069_g84887_i0	PRJNA597223	86733	151	2.612069	3.94422419	Sulfurovum sp. NBC37-1	387093	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|151423458\|dbj\|AP009179.1\|	387093	g84887	i0	92.308	1.97350993377483	39	3	26	0	110	148	695779	695817	Sulfurovum sp. NBC37-1 DNA, complete genome	blastn	298	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp. NBC37-1
18992186	18992186	PRJNA597223_P_NODE_69735_length_171_cov_1.764706_g67889_i0	PRJNA597223	69735	171	1.764706	3.01764726	Bacteria	2	Bacteria	Bacteria	99	1.81e-16	NTclustered	gi\|2621785505\|emb\|OY781963.1\|	2808971	g67889	i0	82.5	41.7426900584795	120	14	71	6	53	168	1221885	1221769	MAG: Arcobacteraceae bacterium isolate 71d67385-9353-412f-8d24-32561d467f9a genome assembly, chromosome: 1	blastn	7138	100	0.99	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
20267279	20267279	PRJNA597223_P_NODE_71556_length_168_cov_2.278195_g69710_i0	PRJNA597223	71556	168	2.278195	3.8273676	Bacteria	2	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g69710	i0	99.405	371.47619047619	168	1	100	0	1	168	554369	554202	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	62408	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
21542522	21542522	PRJNA597223_P_NODE_23057_length_329_cov_957.588435_g21214_i0	PRJNA597223	23057	329	957.588435	3150.46595115	root	1	Root_unresolved	Root_unresolved	597	3.169999999999999e-166	NTclustered	gi\|285196821\|gb\|GU427148.1\|	204	g21214	i0	99.694	106.77811550152	327	0	99	1	1	326	331	5	Campylobacter showae clone ATC_T20_13 16S ribosomal RNA gene, partial sequence	blastn	35130	597	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23521601	23521601	PRJNA597223_P_NODE_56119_length_188_cov_2.274510_g54273_i0	PRJNA597223	56119	188	2.27451	4.2760788	Campylobacter concisus	199	Bacteria	Bacteria	130	7.24e-26	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g54273	i0	98.63	5.43617021276596	73	1	78	0	5	77	561690	561762	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	1022	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23521744	23521744	PRJNA597223_P_NODE_71539_length_168_cov_2.345865_g69693_i0	PRJNA597223	71539	168	2.345865	3.9410532	Helicobacter cetorum	138563	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|384554969\|gb\|CP003479.1\|	182217	g69693	i0	100	0.166666666666667	28	0	17	0	105	132	1228805	1228832	Helicobacter cetorum MIT 00-7128, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cetorum
24092612	24092612	PRJNA597223_P_NODE_24739_length_314_cov_370.555556_g22895_i0	PRJNA597223	24739	314	370.555556	1163.54444584	root	1	Root_unresolved	Root_unresolved	457	5.33e-124	NTclustered	gi\|1969424192\|gb\|MW548691.1\|	199	g22895	i0	98.833	83.484076433121	257	1	82	2	59	314	425	680	Campylobacter concisus strain KCOM 3603 (=ChDC ETd4) 16S ribosomal RNA gene, partial sequence	blastn	26214	457	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24795010	24795010	PRJNA597223_P_NODE_25260_length_310_cov_3.130909_g23416_i0	PRJNA597223	25260	310	3.130909	9.7058179	Campylobacter gracilis	824	Bacteria	Bacteria	479	1.1199999999999996e-130	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g23416	i0	94.805	248.722580645161	308	14	99	2	1	307	500138	499832	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	77104	479	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
25366989	25366989	PRJNA597223_P_NODE_29500_length_278_cov_1140.279835_g27654_i0	PRJNA597223	29500	278	1140.279835	3169.9779413	Campylobacter	194	Bacteria	Bacteria	457	4.639999999999999e-124	NTclustered	gi\|285177073\|gb\|GU415929.1\|	199	g27654	i0	96.727	110.125899280576	275	8	99	1	5	278	56	330	Campylobacter concisus clone NW049 16S ribosomal RNA gene, partial sequence	blastn	30615	457	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus

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