metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA446034" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA446034" 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
4265116	4265116	PRJNA446034_S_NODE_28504_length_209_cov_1.837209_g28467_i0	PRJNA446034	28504	209	1.837209	3.83976681	Campylobacter concisus	199	Bacteria	Bacteria	339	1.26e-88	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g28467	i0	96.135	15.799043062201	207	8	99	0	3	209	983581	983375	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	3302	339	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6815953	6815953	PRJNA446034_S_NODE_48306_length_185_cov_2.621622_g48269_i0	PRJNA446034	48306	185	2.621622	4.8500007	Campylobacter avium	522485	Bacteria	Bacteria	307	3.05e-79	NTclustered	gi\|1226875038\|gb\|CP022347.1\|	522484	g48269	i0	96.774	3.14054054054054	186	2	99	3	1	184	1230445	1230262	Campylobacter avium LMG 24591 chromosome, complete genome	blastn	581	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter avium
7469963	7469963	PRJNA446034_S_NODE_55146_length_179_cov_4.436620_g55109_i0	PRJNA446034	55146	179	4.43662	7.9415498	Campylobacter	194	Bacteria	Bacteria	326	8.09e-85	NTclustered	gi\|1733425738\|gb\|CP043427.1\|	32024	g55109	i0	99.441	4.98324022346369	179	1	100	0	1	179	1693599	1693421	Campylobacter sputorum subsp. sputorum strain LMG 7795 chromosome, complete genome	blastn	892	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sputorum
8091372	8091372	PRJNA446034_S_NODE_4087_length_322_cov_1.950877_g4050_i0	PRJNA446034	4087	322	1.950877	6.28182394	Campylobacter concisus	199	Bacteria	Bacteria	427	4.299999999999999e-115	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g4050	i0	91.429	15.6086956521739	315	22	98	5	6	319	367488	367798	Campylobacter concisus strain RMIT-O23 chromosome	blastn	5026	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8744938	8744938	PRJNA446034_S_NODE_30307_length_206_cov_2.207101_g30270_i0	PRJNA446034	30307	206	2.207101	4.54662806	Bacteria	2	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g30270	i0	100	379.946601941748	206	0	100	0	1	206	554361	554156	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	78269	381	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
13191650	13191650	PRJNA446034_S_NODE_113991_length_150_cov_5.637168_g113954_i0	PRJNA446034	113991	150	5.637168	8.455752	Campylobacter concisus	199	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g113954	i0	100	1	150	0	100	0	1	150	118086	117937	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	150	278	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17015375	17015375	PRJNA446034_S_NODE_113954_length_150_cov_5.805310_g113917_i0	PRJNA446034	113954	150	5.80531	8.707965	Arcobacter suis	1278212	Bacteria	Bacteria	206	8.86e-49	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g113917	i0	91.333	3.78666666666667	150	13	100	0	1	150	761367	761218	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	568	206	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
19564261	19564261	PRJNA446034_S_NODE_96216_length_157_cov_1.275000_g96179_i0	PRJNA446034	96216	157	1.275	2.00175	Campylobacter concisus	199	Bacteria	Bacteria	211	2.02e-50	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g96179	i0	93.056	2.7515923566879	144	10	92	0	4	147	674703	674846	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	432	211	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20839694	20839694	PRJNA446034_S_NODE_15097_length_240_cov_2.187192_g15060_i0	PRJNA446034	15097	240	2.187192	5.2492608	Campylobacter rectus	203	Bacteria	Bacteria	111	3.51e-20	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g15060	i0	85.321	0.908333333333333	109	14	45	2	127	233	1753551	1753659	Campylobacter rectus strain ATCC 33238, complete genome	blastn	218	111	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
20839802	20839802	PRJNA446034_S_NODE_33037_length_202_cov_3.139394_g33000_i0	PRJNA446034	33037	202	3.139394	6.34157588	Aliarcobacter thereius	544718	Bacteria	Bacteria	291	3.42e-74	NTclustered	gi\|1576840368\|gb\|CP035926.1\|	1032240	g33000	i0	92.574	1	202	15	100	0	1	202	1195468	1195669	Aliarcobacter thereius LMG 24486 chromosome, complete genome	blastn	202	291	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter thereius
21493802	21493802	PRJNA446034_S_NODE_5077_length_306_cov_6.211896_g5040_i0	PRJNA446034	5077	306	6.211896	19.00840176	Campylobacter	194	Bacteria	Bacteria	459	1.4399999999999999e-124	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g5040	i0	94.04	3.94444444444444	302	18	99	0	1	302	1108054	1108355	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	1207	460	0.997826086956522	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
21493848	21493848	PRJNA446034_S_NODE_71417_length_168_cov_9.557252_g71380_i0	PRJNA446034	71417	168	9.557252	16.05618336	Arcobacter	28196	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g71380	i0	95.181	7.46428571428571	166	8	99	0	1	166	980998	981163	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	1254	265	0.992452830188679	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis

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