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

12 rows where analysis = "blastn", bioproject = "PRJNA940501" 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
918776	918776	PRJNA940501_S_NODE_192081_length_195_cov_2.802632_g191263_i0	PRJNA940501	192081	195	2.802632	5.4651324	Campylobacter pinnipediorum	1965231	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1153133932\|gb\|CP012548.1\|	1660067	g191263	i0	100	0.733333333333333	29	0	15	0	22	50	1178076	1178104	Campylobacter pinnipediorum subsp. pinnipediorum strain RM17262 chromosome, complete genome	blastn	143	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter pinnipediorum
1258093	1258093	PRJNA940501_S_NODE_359441_length_156_cov_1.247788_g358623_i0	PRJNA940501	359441	156	1.247788	1.94654928	FCB group	1783270	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g358623	i0	100	105.923076923077	156	0	100	0	1	156	322346	322501	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	16524	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
6021789	6021789	PRJNA940501_S_NODE_170245_length_203_cov_1.762500_g169427_i0	PRJNA940501	170245	203	1.7625	3.577875	Halarcobacter sp.	2321133	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2907625964\|emb\|OZ223524.1\|	2321133	g169427	i0	96.774	0.152709359605911	31	1	15	0	150	180	1186489	1186519	MAG: Halarcobacter sp. isolate d3e0c030-8c1e-4ab3-9232-aa86cf828041 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter sp.
7297102	7297102	PRJNA940501_S_NODE_197146_length_194_cov_1.245033_g196328_i0	PRJNA940501	197146	194	1.245033	2.41536402	Aliarcobacter butzleri	28197	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2305706618\|gb\|CP104378.1\|	28197	g196328	i0	100	0.144329896907216	28	0	14	0	3	30	1113930	1113957	Aliarcobacter butzleri strain P1100 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
8572649	8572649	PRJNA940501_S_NODE_248787_length_179_cov_1.382353_g247969_i0	PRJNA940501	248787	179	1.382353	2.47441187	Poseidonibacter parvus	1850254	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1133382777\|gb\|CP019070.1\|	1850254	g247969	i0	100	0.156424581005587	28	0	16	0	45	72	353023	352996	Poseidonibacter parvus strain LPB0137 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter parvus
13675776	13675776	PRJNA940501_S_NODE_84631_length_249_cov_1.378641_g83813_i0	PRJNA940501	84631	249	1.378641	3.43281609	Aliarcobacter butzleri	28197	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2304736180\|gb\|CP104332.1\|	28197	g83813	i0	96.875	0.257028112449799	32	0	12	1	94	124	1360985	1361016	Aliarcobacter butzleri strain P1200 chromosome, complete genome	blastn	64	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
18769896	18769896	PRJNA940501_S_NODE_144455_length_214_cov_1.374269_g143637_i0	PRJNA940501	144455	214	1.374269	2.94093566	Sulfurospirillaceae bacterium ADMFC2	3385206	Bacteria	Bacteria	122	1.42e-23	NTclustered	gi\|2835534110\|dbj\|AP038756.1\|	3385206	g143637	i0	89.216	4.1588785046729	102	6	45	1	78	174	224572	224471	Sulfurospirillaceae bacterium ADMFC2 DNA, complete genome	blastn	890	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae		Sulfurospirillaceae bacterium ADMFC2
18770481	18770481	PRJNA940501_S_NODE_182655_length_199_cov_1.070513_g181837_i0	PRJNA940501	182655	199	1.070513	2.13032087	Sulfurospirillum sp. hDNRA2	3237298	Bacteria	Bacteria	69.4	1.71e-7	NTclustered	gi\|2755817859\|gb\|CP159800.1\|	3237298	g181837	i0	89.091	0.437185929648241	55	6	28	0	135	189	2308676	2308730	Sulfurospirillum sp. hDNRA2 strain DNRA8 chromosome, complete genome	blastn	87	69.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. hDNRA2
21321054	21321054	PRJNA940501_S_NODE_197377_length_194_cov_1.178808_g196559_i0	PRJNA940501	197377	194	1.178808	2.28688752	Helicobacter cholecystus	45498	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|40643949\|emb\|AJ558214.1\|	45498	g196559	i0	100	0.43298969072165	28	0	14	0	12	39	146	119	Helicobacter cholecystus partial hsp60 gene for heat shock protein 60, strain CCUG 38167	blastn	84	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cholecystus
22597490	22597490	PRJNA940501_S_NODE_316018_length_164_cov_1.322314_g315200_i0	PRJNA940501	316018	164	1.322314	2.16859496	Aliarcobacter cibarius	255507	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1755823616\|gb\|CP043857.1\|	255507	g315200	i0	100	0.353658536585366	29	0	18	0	16	44	1492621	1492649	Aliarcobacter cibarius strain H743 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cibarius
25146932	25146932	PRJNA940501_S_NODE_337220_length_160_cov_1.205128_g336402_i0	PRJNA940501	337220	160	1.205128	1.9282048	Wolinella succinogenes	844	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|34483511\|emb\|BX571661.1\|	844	g336402	i0	100	2	160	0	100	0	1	160	211911	212070	Wolinella succinogenes, complete genome; segment 5/7	blastn	320	296	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
25484652	25484652	PRJNA940501_S_NODE_326300_length_162_cov_1.184874_g325482_i0	PRJNA940501	326300	162	1.184874	1.91949588	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2329051131\|dbj\|AP026671.1\|	1069081	g325482	i0	100	0.691358024691358	28	0	17	0	71	98	182157	182130	Nitratiruptor tergarcus DSM 16512 DNA, complete sequence	blastn	112	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitratiruptor	Nitratiruptor tergarcus

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