metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
402597	402597	PRJNA382357_P_NODE_120041_length_223_cov_1.574074_g119302_i0	PRJNA382357	120041	223	1.574074	3.51018502	Campylobacter jejuni	197	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1444880815\|gb\|CP012212.1\|	197	g119302	i0	90.476	0.188340807174888	42	3	19	1	28	69	914425	914465	Campylobacter jejuni strain CJ017CCUA, complete genome	blastn	42	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
1678233	1678233	PRJNA382357_P_NODE_20462_length_488_cov_1.430913_g19728_i0	PRJNA382357	20462	488	1.430913	6.98285544	Campylobacter gracilis	824	Bacteria	Bacteria	531	5.01e-146	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g19728	i0	90.338	1.87704918032787	414	26	93	9	77	488	1838497	1838898	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	916	531	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
1678987	1678987	PRJNA382357_P_NODE_642_length_1962_cov_74.433456_g0_i102	PRJNA382357	642	1962	74.433456	1460.38440672	Hippea maritima	84405	Bacteria	Bacteria	97.1	9.22e-15	NTclustered	gi\|327180802\|gb\|CP002606.1\|	760142	g0	i102	88.75	3.12130479102956	80	7	8	1	1133	1212	1102298	1102375	Hippea maritima DSM 10411, complete genome	blastn	6124	97.1	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales	Hippeaceae	Hippea	Hippea maritima
3626040	3626040	PRJNA382357_P_NODE_58343_length_306_cov_24.714286_g57604_i0	PRJNA382357	58343	306	24.714286	75.62571516	root	1	Root_unresolved	Root_unresolved	399	8.849999999999999e-107	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g57604	i0	100	119.343137254902	216	0	100	0	91	306	33292	33507	Campylobacter showae genome assembly, plasmid: V	blastn	36519	399	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
5506224	5506224	PRJNA382357_P_NODE_11605_length_619_cov_3.698925_g10892_i0	PRJNA382357	11605	619	3.698925	22.89634575	Campylobacter gracilis	824	Bacteria	Bacteria	612	2.2499999999999993e-170	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g10892	i0	100	302.722132471729	331	0	100	0	289	619	500683	501013	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	187385	612	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
6178099	6178099	PRJNA382357_P_NODE_40125_length_362_cov_1.295681_g39386_i0	PRJNA382357	40125	362	1.295681	4.69036522	Pseudomonadati	3379134	Bacteria	Bacteria	669	0	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g39386	i0	100	100	362	0	100	0	1	362	701818	702179	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	36200	669	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
7452712	7452712	PRJNA382357_P_NODE_156226_length_202_cov_0.921986_g155487_i0	PRJNA382357	156226	202	0.921986	1.86241172	Campylobacter	194	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2198377002\|gb\|CP059597.1\|	1032242	g155487	i0	100	0.97029702970297	28	0	14	0	35	62	629840	629813	Campylobacter molothri strain RM10537 chromosome, complete genome	blastn	196	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter molothri
8057818	8057818	PRJNA382357_P_NODE_87887_length_256_cov_1.876923_g87148_i0	PRJNA382357	87887	256	1.876923	4.80492288	Wolinella succinogenes	844	Bacteria	Bacteria	305	1.62e-78	NTclustered	gi\|34482500\|emb\|BX571658.1\|	844	g87148	i0	97.222	2.09375	180	5	100	0	77	256	20007	20186	Wolinella succinogenes, complete genome; segment 2/7	blastn	536	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
9331437	9331437	PRJNA382357_P_NODE_170528_length_170_cov_20.532110_g169789_i0	PRJNA382357	170528	170	20.53211	34.904587	Campylobacter gracilis	824	Bacteria	Bacteria	148	1.7599999999999998e-31	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g169789	i0	95.652	1.78823529411765	92	4	81	0	15	106	119790	119699	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	304	148	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
10003289	10003289	PRJNA382357_P_NODE_38988_length_366_cov_14.786885_g38249_i0	PRJNA382357	38988	366	14.786885	54.1199991	Campylobacter	194	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1483583498\|emb\|LT631422.1\|	204	g38249	i0	100	0.158469945355191	29	0	8	0	229	257	16689	16661	Campylobacter showae genome assembly, chromosome: I	blastn	58	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11277724	11277724	PRJNA382357_P_NODE_128449_length_215_cov_15.298701_g127710_i0	PRJNA382357	128449	215	15.298701	32.89220715	Sulfurospirillum	57665	Bacteria	Bacteria	243	1.05e-59	NTclustered	gi\|507148369\|ref\|NR_103172.1\|	44674	g127710	i0	99.254	178.316279069767	134	1	100	0	82	215	2470	2337	Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence	blastn	38338	243	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum barnesii
12553322	12553322	PRJNA382357_P_NODE_15190_length_553_cov_7.760163_g14467_i0	PRJNA382357	15190	553	7.760163	42.91370139	Campylobacter	194	Bacteria	Bacteria	496	2.0899999999999998e-135	NTclustered	gi\|1721134170\|emb\|LR698972.1\|	200	g14467	i0	98.571	235.609403254973	280	4	92	0	199	478	832232	831953	Campylobacter curvus isolate MGYG-HGUT-01706 genome assembly, chromosome: 1	blastn	130292	501	0.99001996007984	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter curvus
13157205	13157205	PRJNA382357_P_NODE_22331_length_470_cov_1.117359_g21595_i0	PRJNA382357	22331	470	1.117359	5.2515873	Campylobacter concisus	199	Bacteria	Bacteria	717	0	NTclustered	gi\|1935891962\|gb\|CP049237.1\|	199	g21595	i0	94.783	17.2765957446809	460	24	98	0	1	460	1844608	1844149	Campylobacter concisus strain H1O1 chromosome, complete genome	blastn	8120	717	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
13828601	13828601	PRJNA382357_P_NODE_3651_length_998_cov_17.614728_g3095_i0	PRJNA382357	3651	998	17.614728	175.79498544	Campylobacter	194	Bacteria	Bacteria	963	0	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g3095	i0	100	233.286573146293	521	0	100	0	1	521	724515	723995	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	232820	963	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
14431454	14431454	PRJNA382357_P_NODE_12552_length_599_cov_1.429368_g11834_i0	PRJNA382357	12552	599	1.429368	8.56191432	Campylobacter vicugnae	1660076	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|2678412531\|gb\|CP144916.1\|	1660076	g11834	i0	100	0.0484140233722871	29	0	5	0	491	519	1210659	1210687	Campylobacter vicugnae strain RM9261 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
15103427	15103427	PRJNA382357_P_NODE_94092_length_249_cov_0.994681_g93353_i0	PRJNA382357	94092	249	0.994681	2.47675569	Campylobacter	194	Bacteria	Bacteria	403	5.3999999999999986e-108	NTclustered	gi\|1483583555\|emb\|LT631479.1\|	204	g93353	i0	98.261	4.61847389558233	230	4	92	0	20	249	1684545	1684774	Campylobacter showae strain B91_TPP genome assembly, chromosome: I	blastn	1150	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
17652073	17652073	PRJNA382357_P_NODE_123474_length_220_cov_1.484277_g122735_i0	PRJNA382357	123474	220	1.484277	3.2654094	Campylobacter	194	Bacteria	Bacteria	267	6.39e-67	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g122735	i0	96.855	18.6590909090909	159	5	99	0	62	220	338092	337934	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	4105	267	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17652243	17652243	PRJNA382357_P_NODE_143134_length_207_cov_1.678082_g142395_i0	PRJNA382357	143134	207	1.678082	3.47362974	Campylobacter	194	Bacteria	Bacteria	239	1.2999999999999999e-58	NTclustered	gi\|240265854\|gb\|GQ167691.1\|	827	g142395	i0	100	241.917874396135	129	0	92	0	1	129	1077	1205	Bacteroides ureolyticus strain UNSWE 23S ribosomal RNA gene, partial sequence	blastn	50077	239	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
19530090	19530090	PRJNA382357_P_NODE_69496_length_284_cov_1.336323_g68757_i0	PRJNA382357	69496	284	1.336323	3.79515732	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621701254\|emb\|OY759974.1\|	2808971	g68757	i0	100	0.197183098591549	28	0	10	0	229	256	194626	194599	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
23356786	23356786	PRJNA382357_P_NODE_94639_length_248_cov_1.390374_g93900_i0	PRJNA382357	94639	248	1.390374	3.44812752	Sulfurimonas sp.	2022749	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2452188818\|gb\|CP093397.1\|	2022749	g93900	i0	100	0.112903225806452	28	0	11	0	61	88	1110418	1110391	MAG: Sulfurimonas sp. isolate MAG-12 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
24026679	24026679	PRJNA382357_P_NODE_171639_length_167_cov_7.386792_g170900_i0	PRJNA382357	171639	167	7.386792	12.33594264	Campylobacter	194	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2678412531\|gb\|CP144916.1\|	1660076	g170900	i0	100	0.838323353293413	28	0	17	0	41	68	552188	552215	Campylobacter vicugnae strain RM9261 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
24630314	24630314	PRJNA382357_P_NODE_52160_length_322_cov_1.701149_g51421_i0	PRJNA382357	52160	322	1.701149	5.47769978	Campylobacter showae	204	Bacteria	Bacteria	283	9.85e-72	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g51421	i0	93.651	6.2888198757764	189	12	99	0	134	322	1465531	1465343	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	2025	283	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
25301002	25301002	PRJNA382357_P_NODE_160320_length_194_cov_14.473684_g159581_i0	PRJNA382357	160320	194	14.473684	28.07894696	Campylobacter	194	Bacteria	Bacteria	255	1.1900000000000001e-63	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g159581	i0	100	243.670103092784	138	0	100	0	57	194	1439	1302	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	47272	255	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);;