metadata: contig_metadata: 12 rows where bioproject = "PRJNA492280" and tax

12 rows where bioproject = "PRJNA492280" 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
3650009	3650009	PRJNA492280_P_NODE_21563_length_164_cov_3.047244_g21456_i0	PRJNA492280	21563	164	3.047244	4.99748016	Campylobacter	194	Bacteria	Bacteria	233	4.56e-57	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g21456	i0	90.123	257.329268292683	162	15	98	1	1	161	29792	29953	Campylobacter showae genome assembly, plasmid: V	blastn	42202	233	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6202184	6202184	PRJNA492280_P_NODE_33365_length_150_cov_4.079646_g33258_i0	PRJNA492280	33365	150	4.079646	6.119469	Arcobacteraceae	2808963	Bacteria	Bacteria	267	4.009999999999999e-67	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g33258	i0	99.32	334.02	147	1	98	0	4	150	1772	1918	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	50103	267	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
6202217	6202217	PRJNA492280_P_NODE_3805_length_253_cov_2.324074_g3698_i0	PRJNA492280	3805	253	2.324074	5.87990722	Campylobacter	194	Bacteria	Bacteria	137	6.16e-28	NTclustered	gi\|1883582428\|gb\|CP059437.1\|	196	g3698	i0	100	148.873517786561	74	0	60	0	92	165	136542	136469	Campylobacter fetus strain CFViADRI545 chromosome, complete genome	blastn	37665	137	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
7477149	7477149	PRJNA492280_P_NODE_8346_length_183_cov_10.554795_g8239_i0	PRJNA492280	8346	183	10.554795	19.31527485	Campylobacter	194	Bacteria	Bacteria	60.2	9.31e-5	NTclustered	gi\|1721134170\|emb\|LR698972.1\|	200	g8239	i0	83.333	1.48633879781421	66	9	36	2	11	75	831984	831920	Campylobacter curvus isolate MGYG-HGUT-01706 genome assembly, chromosome: 1	blastn	272	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter curvus
10027253	10027253	PRJNA492280_P_NODE_26448_length_163_cov_7.984127_g26341_i0	PRJNA492280	26448	163	7.984127	13.01412701	Campylobacter	194	Bacteria	Bacteria	134	4.72e-27	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g26341	i0	100	211.521472392638	72	0	87	0	3	74	42517	42588	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	34478	134	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
15754494	15754494	PRJNA492280_P_NODE_14153_length_164_cov_4.968504_g14046_i0	PRJNA492280	14153	164	4.968504	8.14834656	Sulfurospirillum diekertiae	1854492	Bacteria	Bacteria	113	6.1900000000000006e-21	NTclustered	gi\|1905313802\|gb\|CP045453.2\|	1854492	g14046	i0	98.438	75.0182926829268	64	1	39	0	8	71	1848760	1848697	Sulfurospirillum diekertiae strain ACSTCE chromosome, complete genome	blastn	12303	113	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum diekertiae
15754788	15754788	PRJNA492280_P_NODE_9073_length_177_cov_5.014286_g8966_i0	PRJNA492280	9073	177	5.014286	8.87528622	Helicobacter enhydrae	222136	Bacteria	Bacteria	100	5.27e-17	NTclustered	gi\|1046578886\|gb\|CP016503.1\|	222136	g8966	i0	96.667	42.774011299435	60	2	36	0	112	171	558441	558382	Helicobacter enhydrae strain MIT 01-6242 chromosome, complete genome	blastn	7571	100	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter enhydrae
18950357	18950357	PRJNA492280_P_NODE_14755_length_164_cov_4.685039_g14648_i0	PRJNA492280	14755	164	4.685039	7.68346396	Pseudomonadati	3379134	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g14648	i0	100	91.4634146341463	76	0	91	0	1	76	700977	701052	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	15000	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
19577657	19577657	PRJNA492280_P_NODE_10136_length_169_cov_3.325758_g10029_i0	PRJNA492280	10136	169	3.325758	5.62053102	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	145	2.26e-30	NTclustered	gi\|334724810\|gb\|JF795907.1\|	218934	g10029	i0	98.78	92.5147928994083	82	0	86	1	89	169	152	233	Uncultured Campylobacter sp. clone 2UC22S 1 16S ribosomal RNA gene, partial sequence	blastn	15635	145	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
25325208	25325208	PRJNA492280_P_NODE_32740_length_150_cov_5.159292_g32633_i0	PRJNA492280	32740	150	5.159292	7.738938	Campylobacter	194	Bacteria	Bacteria	119	1.19e-22	NTclustered	gi\|1483583496\|emb\|LT631420.1\|	204	g32633	i0	95.89	3.78	73	3	95	0	78	150	18821	18749	Campylobacter showae genome assembly, chromosome: I	blastn	567	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
28055389	28055389	PRJNA492280_P_NODE_31325_length_151_cov_3.236842_g31218_i0	PRJNA492280	31325	151	3.236842	4.88763142	Desulfurellales bacterium	2482794	Bacteria	Bacteria	56.2	1.77e-7	NR	TXH53030.1	2482794	g31218	i0	70.8	0.95364238410596	48	13	93.4	1	6	146	151	198	TXH53030.1 MAG: hypothetical protein E6Q97_14060 [Desulfurellales bacterium]	diamond	144	56.2	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
30692639	30692639	PRJNA492280_P_NODE_15533_length_164_cov_4.401575_g15426_i0	PRJNA492280	15533	164	4.401575	7.218583	Bacteria	2	Bacteria	Bacteria	58.2	1.31e-8	NR	PUB99708.1	210	g15426	i0	100	1.82926829268293	25	0	45.7	0	75	1	127	151	PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori]	diamond	300	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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