metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1068830" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
4842345	4842345	PRJNA1068830_P_NODE_69744_length_258_cov_1.589189_g69041_i0	PRJNA1068830	69744	258	1.589189	4.10010762	root	1	Root_unresolved	Root_unresolved	477	3.2699999999999985e-130	NTclustered	gi\|1377039872\|gb\|MF037584.1\|	195	g69041	i0	100	104.988372093023	258	0	100	0	1	258	1676	1933	Campylobacter coli strain SHP40 cfrC gene cluster, complete sequence	blastn	27087	477	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
7392046	7392046	PRJNA1068830_P_NODE_76226_length_250_cov_1.728814_g75523_i0	PRJNA1068830	76226	250	1.728814	4.322035	Helicobacter	209	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2642949270\|gb\|CP079480.1\|	210	g75523	i0	100	197	250	0	100	0	1	250	1018143	1017894	Helicobacter pylori strain HpGP-ITA-029 chromosome, complete genome	blastn	49250	462	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
7836227	7836227	PRJNA1068830_P_NODE_79067_length_248_cov_1.640000_g78364_i0	PRJNA1068830	79067	248	1.64	4.0672	Helicobacter apodemus	135569	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|1387666299\|gb\|CP021886.1\|	135569	g78364	i0	84.647	1.95564516129032	241	35	97	2	8	247	1387444	1387683	Helicobacter apodemus strain SCJK1 chromosome, complete genome	blastn	485	239	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter apodemus
10386907	10386907	PRJNA1068830_P_NODE_77049_length_250_cov_0.881356_g76346_i0	PRJNA1068830	77049	250	0.881356	2.20339	Wolinella succinogenes	844	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|34483511\|emb\|BX571661.1\|	844	g76346	i0	99.2	2	250	2	100	0	1	250	183387	183138	Wolinella succinogenes, complete genome; segment 5/7	blastn	500	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
16316712	16316712	PRJNA1068830_P_NODE_56093_length_291_cov_1.050459_g55390_i0	PRJNA1068830	56093	291	1.050459	3.05683569	Campylobacter	194	Bacteria	Bacteria	383	8.42e-102	NTclustered	gi\|2323242367\|gb\|CP109820.1\|	195	g55390	i0	91.166	97.6735395189003	283	23	97	2	7	288	12720	13001	Campylobacter coli strain CC21NB04a plasmid pCC21NB04-51K, complete sequence	blastn	28423	383	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
16316844	16316844	PRJNA1068830_P_NODE_82513_length_246_cov_0.901734_g81810_i0	PRJNA1068830	82513	246	0.901734	2.21826564	Helicobacter	209	Bacteria	Bacteria	248	2.6399999999999997e-61	NTclustered	gi\|2446988323\|gb\|CP063528.1\|	157268	g81810	i0	84.959	6	246	36	99	1	2	246	206833	207078	Helicobacter winghamensis strain DoED 19-02049 chromosome, complete genome	blastn	1476	248	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter winghamensis
18865787	18865787	PRJNA1068830_P_NODE_48795_length_314_cov_1.294606_g48092_i0	PRJNA1068830	48795	314	1.294606	4.06506284	Bacteria	2	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|2323242367\|gb\|CP109820.1\|	195	g48092	i0	100	105	314	0	100	0	1	314	50482	50169	Campylobacter coli strain CC21NB04a plasmid pCC21NB04-51K, complete sequence	blastn	32970	580	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
20584872	20584872	PRJNA1068830_P_NODE_84197_length_245_cov_0.906977_g83494_i0	PRJNA1068830	84197	245	0.906977	2.22209365	Helicobacter hepaticus	32025	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g83494	i0	100	1	245	0	100	0	1	245	1585167	1584923	Helicobacter hepaticus ATCC 51449, complete genome	blastn	245	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus

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