metadata: contig_metadata: 15 rows where bioproject = "PRJNA1199330" and tax

15 rows where bioproject = "PRJNA1199330" 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
4151862	4151862	PRJNA1199330_P_NODE_106584_length_249_cov_0.886364_g105885_i0	PRJNA1199330	106584	249	0.886364	2.20704636	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	71.3	6.22e-8	NTclustered	gi\|2922053193\|gb\|CP182894.1\|	1355374	g105885	i0	82.143	1.01204819277108	84	13	33	2	167	249	879726	879644	Aliarcobacter lanthieri strain BNI-4366 chromosome, complete genome	blastn	252	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
5428167	5428167	PRJNA1199330_P_NODE_111805_length_245_cov_1.488372_g111106_i0	PRJNA1199330	111805	245	1.488372	3.6465114	Campylobacter rectus	203	Bacteria	Bacteria	337	5.45e-88	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g111106	i0	91.429	99.8489795918367	245	21	100	0	1	245	1916977	1917221	Campylobacter rectus strain ATCC 33238, complete genome	blastn	24463	337	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
8697260	8697260	PRJNA1199330_P_NODE_40387_length_325_cov_1.238095_g39688_i0	PRJNA1199330	40387	325	1.238095	4.02380875	Campylobacter	194	Bacteria	Bacteria	592	1.4599999999999996e-164	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g39688	i0	99.69	233.701538461538	323	1	99	0	1	323	594	916	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	75953	592	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10530093	10530093	PRJNA1199330_P_NODE_91369_length_262_cov_1.301587_g90670_i0	PRJNA1199330	91369	262	1.301587	3.41015794	Campylobacter rectus	203	Bacteria	Bacteria	368	2.09e-97	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g90670	i0	93.522	12.0496183206107	247	16	94	0	1	247	1373402	1373156	Campylobacter rectus strain ATCC 33238, complete genome	blastn	3157	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
15627618	15627618	PRJNA1199330_P_NODE_101473_length_252_cov_1.743017_g100774_i0	PRJNA1199330	101473	252	1.743017	4.39240284	Campylobacter showae	204	Bacteria	Bacteria	411	3.269999999999999e-110	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g100774	i0	96.032	38.6507936507937	252	10	100	0	1	252	1193715	1193464	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	9740	411	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
16902222	16902222	PRJNA1199330_P_NODE_118214_length_238_cov_2.145455_g117515_i0	PRJNA1199330	118214	238	2.145455	5.1061829	Campylobacter gracilis	824	Bacteria	Bacteria	355	1.45e-93	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g117515	i0	93.671	1.97899159663866	237	15	99	0	1	237	1708891	1708655	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	471	355	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
16902959	16902959	PRJNA1199330_P_NODE_58634_length_292_cov_0.821918_g57935_i0	PRJNA1199330	58634	292	0.821918	2.40000056	Helicobacter pullorum	35818	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|294795270\|gb\|GU902714.1\|	35818	g57935	i0	100	114	292	0	100	0	1	292	4	295	Helicobacter pullorum strain MIT 09-6635 16S ribosomal RNA gene, partial sequence	blastn	33288	540	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pullorum
17622185	17622185	PRJNA1199330_P_NODE_65134_length_286_cov_1.516432_g64435_i0	PRJNA1199330	65134	286	1.516432	4.33699552	Campylobacter	194	Bacteria	Bacteria	446	1.04e-120	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g64435	i0	95.053	23.7762237762238	283	14	99	0	4	286	2153269	2152987	Campylobacter rectus strain ATCC 33238, complete genome	blastn	6800	446	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
18895772	18895772	PRJNA1199330_P_NODE_38335_length_334_cov_1.793103_g37636_i0	PRJNA1199330	38335	334	1.793103	5.98896402	Campylobacter	194	Bacteria	Bacteria	617	2.48e-172	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g37636	i0	100	233.311377245509	334	0	100	0	1	334	1513	1180	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	77926	617	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19452234	19452234	PRJNA1199330_P_NODE_81896_length_271_cov_1.378788_g81197_i0	PRJNA1199330	81896	271	1.378788	3.73651548	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	116	4.21e-30	NR	WP_295143622.1	218934	g81197	i0	96.7	0.675276752767528	61	2	67.5	0	185	3	1	61	WP_295143622.1 pseudaminic acid cytidylyltransferase [uncultured Campylobacter sp.]	diamond	183	116	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
23277747	23277747	PRJNA1199330_P_NODE_37799_length_336_cov_3.357414_g37100_i0	PRJNA1199330	37799	336	3.357414	11.28091104	Campylobacter gracilis	824	Bacteria	Bacteria	193	1.7900000000000001e-44	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g37100	i0	84.536	1.1547619047619	194	30	58	0	143	336	559148	559341	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	388	193	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
27009173	27009173	PRJNA1199330_P_NODE_88722_length_264_cov_2.418848_g88023_i0	PRJNA1199330	88722	264	2.418848	6.38575872	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	137	2.5599999999999996e-35	NR	WP_298833284.1	218934	g88023	i0	79.5	1	88	17	98.9	1	262	2	878	965	WP_298833284.1 calcium-binding protein [uncultured Campylobacter sp.]	diamond	264	137	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
28809112	28809112	PRJNA1199330_P_NODE_108468_length_247_cov_2.511494_g107769_i0	PRJNA1199330	108468	247	2.511494	6.20339018	Helicobacter pylori	210	Bacteria	Bacteria	44.7	6.99e-4	NR	GAA8930966.1	210	g107769	i0	74.1	0.327935222672065	27	7	32.8	0	245	165	16	42	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	81	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29567118	29567118	PRJNA1199330_P_NODE_88530_length_264_cov_3.157068_g87831_i0	PRJNA1199330	88530	264	3.157068	8.33465952	Helicobacter pylori	210	Bacteria	Bacteria	58.2	1.27e-8	NR	GAA6860517.1	210	g87831	i0	56.7	1.10227272727273	67	17	62.5	1	255	91	1	67	GAA6860517.1 hypothetical protein Kyoto206A_1350 [Helicobacter pylori]	diamond	291	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32254262	32254262	PRJNA1199330_P_NODE_96118_length_257_cov_1.695652_g95419_i0	PRJNA1199330	96118	257	1.695652	4.35782564	Helicobacter pylori	210	Bacteria	Bacteria	60.5	3.08e-10	NR	GAA8757316.1	210	g95419	i0	66.7	0.852140077821012	36	12	42	0	67	174	4	39	GAA8757316.1 hypothetical protein Kyoto147A_3750 [Helicobacter pylori]	diamond	219	60.5	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);;