metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
4736154	4736154	PRJNA929922_P_NODE_97084_length_260_cov_1.235294_g96544_i0	PRJNA929922	97084	260	1.235294	3.2117644	Helicobacter pylori	210	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2641857346\|gb\|CP078338.1\|	210	g96544	i0	100	0.326923076923077	29	0	11	0	208	236	231162	231190	Helicobacter pylori strain HpGP-SPA-304 chromosome, complete genome	blastn	85	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
4736343	4736343	PRJNA929922_S_NODE_18324_length_360_cov_10.543554_g18100_i0	PRJNA929922	18324	360	10.543554	37.9567944	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g18100	i0	100	0.0777777777777778	28	0	8	0	234	261	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
6357742	6357742	PRJNA929922_P_NODE_34825_length_359_cov_3.101399_g34285_i0	PRJNA929922	34825	359	3.101399	11.13402241	root	1	Root_unresolved	Root_unresolved	660	0	NTclustered	gi\|1969424192\|gb\|MW548691.1\|	199	g34285	i0	100	101.437325905292	357	0	99	0	3	359	281	637	Campylobacter concisus strain KCOM 3603 (=ChDC ETd4) 16S ribosomal RNA gene, partial sequence	blastn	36416	664	0.993975903614458	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8906305	8906305	PRJNA929922_P_NODE_119207_length_249_cov_0.875000_g118667_i0	PRJNA929922	119207	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	460	3.16e-125	NTclustered	gi\|2523961402\|dbj\|AP028347.1\|	197	g118667	i0	100	41.6787148594378	249	0	100	0	1	249	3765	3517	Campylobacter jejuni BCH-10335 plasmid pTet_BCH-10335 DNA, complete sequence	blastn	10378	460	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
12387744	12387744	PRJNA929922_S_NODE_60470_length_252_cov_1.290503_g60246_i0	PRJNA929922	60470	252	1.290503	3.25206756	Campylobacter sp. RM16192	1660080	Bacteria	Bacteria	440	4.1699999999999984e-119	NTclustered	gi\|1622751281\|gb\|CP012552.1\|	1660080	g60246	i0	100	7.43650793650794	238	0	94	0	15	252	1597455	1597692	Campylobacter sp. RM16192 chromosome, complete genome	blastn	1874	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM16192
16556089	16556089	PRJNA929922_P_NODE_143433_length_244_cov_1.350877_g142893_i0	PRJNA929922	143433	244	1.350877	3.29613988	root	1	Root_unresolved	Root_unresolved	451	1.86e-122	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g142893	i0	100	116.233606557377	244	0	100	0	1	244	318867	319110	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	28361	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
17831146	17831146	PRJNA929922_P_NODE_20934_length_416_cov_2.848397_g20399_i0	PRJNA929922	20934	416	2.848397	11.84933152	Campylobacter	194	Bacteria	Bacteria	763	0	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g20399	i0	99.76	237.117788461538	416	1	100	0	1	416	1691	1276	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	98641	763	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19105096	19105096	PRJNA929922_P_NODE_166735_length_207_cov_4.313433_g166195_i0	PRJNA929922	166735	207	4.313433	8.92880631	Campylobacter	194	Bacteria	Bacteria	344	2.67e-90	NTclustered	gi\|1207769203\|gb\|MF351716.1\|	199	g166195	i0	96.618	244.734299516908	207	7	100	0	1	207	460	254	Campylobacter concisus strain H9O-S1 23S ribosomal RNA gene, partial sequence	blastn	50660	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19105120	19105120	PRJNA929922_P_NODE_24695_length_397_cov_1.546296_g24157_i0	PRJNA929922	24695	397	1.546296	6.13879512	Campylobacter	194	Bacteria	Bacteria	689	0	NTclustered	gi\|1938721720\|gb\|CP049266.1\|	199	g24157	i0	97.985	231.2040302267	397	8	100	0	1	397	1060129	1059733	Campylobacter concisus strain P1CDO3 chromosome, complete genome	blastn	91788	689	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21309339	21309339	PRJNA929922_P_NODE_62417_length_302_cov_1.777293_g61877_i0	PRJNA929922	62417	302	1.777293	5.36742486	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g61877	i0	100	0.0927152317880795	28	0	9	0	104	131	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
22931250	22931250	PRJNA929922_P_NODE_106418_length_251_cov_0.865169_g105878_i0	PRJNA929922	106418	251	0.865169	2.17157419	Sulfurimonadaceae	2771471	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g105878	i0	100	0.462151394422311	29	0	12	0	126	154	2169958	2169930	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
25480258	25480258	PRJNA929922_P_NODE_40340_length_344_cov_3.036900_g39800_i0	PRJNA929922	40340	344	3.0369	10.446936000000001	Campylobacter	194	Bacteria	Bacteria	636	7.059999999999998e-178	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g39800	i0	100	250.5	344	0	100	0	1	344	408	751	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	86172	636	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
25480374	25480374	PRJNA929922_P_NODE_76300_length_283_cov_1.828571_g75760_i0	PRJNA929922	76300	283	1.828571	5.17485593	Campylobacter	194	Bacteria	Bacteria	438	1.7199999999999995e-118	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g75760	i0	94.718	229.703180212014	284	12	99	3	1	282	394	112	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	65006	438	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus

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