metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Ignavibacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_species
25653242	25653242	PRJEB20058_P_NODE_206714_length_251_cov_11.852632_g203890_i0	PRJEB20058	206714	251	11.852632	29.75010632	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	191	4.62e-44	NTclustered	gi\|1850839647\|gb\|CP053446.1\|	2026749	g203890	i0	81.739	3.79282868525896	230	40	91	2	23	251	36558	36330	Ignavibacteriae bacterium isolate IGN2 chromosome	blastn	952	191	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
25653572	25653572	PRJEB20058_P_NODE_214282_length_246_cov_4.335135_g211458_i0	PRJEB20058	214282	246	4.335135	10.6644321	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	185	2.1e-42	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g211458	i0	87.578	0.654471544715447	161	18	65	2	1	160	2822541	2822382	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	161	185	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
25653888	25653888	PRJEB20058_P_NODE_221818_length_241_cov_3.566667_g218993_i0	PRJEB20058	221818	241	3.566667	8.59566747	uncultured Ignavibacteriales bacterium	1191687	Bacteria	Bacteria	148	2.69e-31	NTclustered	gi\|2874253946\|emb\|OY970271.1\|	1191687	g218993	i0	80.203	0.817427385892116	197	39	82	0	3	199	811753	811949	MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1	blastn	197	148	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	uncultured Ignavibacteriales bacterium
25790812	25790812	PRJEB20058_P_NODE_245547_length_203_cov_38.535211_g242722_i0	PRJEB20058	245547	203	38.535211	78.22647833	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	180	7.78e-41	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g242722	i0	84.916	0.881773399014778	179	26	88	1	26	203	1245625	1245803	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	179	180	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26058276	26058276	PRJEB20058_P_NODE_129885_length_346_cov_2.631579_g127066_i0	PRJEB20058	129885	346	2.631579	9.10526334	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	329	1.35e-85	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g127066	i0	84.273	6.83815028901734	337	53	97	0	10	346	2698888	2698552	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	2366	329	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26058919	26058919	PRJEB20058_P_NODE_144109_length_322_cov_10.249042_g141288_i0	PRJEB20058	144109	322	10.249042	33.00191524	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	355	2.06e-93	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g141288	i0	88.255	0.925465838509317	298	34	93	1	24	321	2822266	2822562	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	298	355	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26062687	26062687	PRJEB20058_P_NODE_235245_length_225_cov_10.957317_g232420_i0	PRJEB20058	235245	225	10.957317	24.65396325	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	231	2.39e-56	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g232420	i0	87.192	2.70666666666667	203	26	90	0	22	224	166396	166598	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	609	231	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26064875	26064875	PRJEB20058_P_NODE_55629_length_563_cov_3.938247_g52880_i0	PRJEB20058	55629	563	3.938247	22.17233061	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	667	0	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g52880	i0	88.427	2.95204262877442	553	64	98	0	2	554	3558934	3559486	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	1662	667	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26195484	26195484	PRJEB20058_P_NODE_14878_length_1075_cov_29.080868_g13083_i0	PRJEB20058	14878	1075	29.080868	312.619331	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	821	0	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g13083	i0	80.962	1.6176744186046501	1040	194	96	4	21	1057	1049026	1050064	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	1739	821	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26195609	26195609	PRJEB20058_P_NODE_151638_length_311_cov_3.856000_g148815_i0	PRJEB20058	151638	311	3.856	11.99216	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	307	5.62e-79	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g148815	i0	86.861	0.881028938906752	274	36	88	0	2	275	3718016	3718289	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	274	307	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26196017	26196017	PRJEB20058_P_NODE_160942_length_298_cov_33.848101_g158119_i0	PRJEB20058	160942	298	33.848101	100.86734098	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	224	5.549999999999998e-54	NTclustered	gi\|1958088527\|gb\|CP065001.1\|	2049428	g158119	i0	81.387	5.77852348993289	274	51	92	0	22	295	3032395	3032668	Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome	blastn	1722	224	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriales bacterium
26333860	26333860	PRJEB20058_P_NODE_211279_length_248_cov_4.032086_g208455_i0	PRJEB20058	211279	248	4.032086	9.99957328	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	202	2.0999999999999998e-47	NTclustered	gi\|2874253742\|emb\|OY969585.1\|	2026749	g208455	i0	84.729	163.612903225806	203	30	82	1	1	203	459974	460175	MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1	blastn	40576	202	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26333987	26333987	PRJEB20058_P_NODE_214055_length_246_cov_11.200000_g211231_i0	PRJEB20058	214055	246	11.2	27.552	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	191	4.51e-44	NTclustered	gi\|1958088527\|gb\|CP065001.1\|	2049428	g211231	i0	83.028	55.739837398374	218	30	86	6	23	234	607369	607585	Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome	blastn	13712	191	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriales bacterium
26338145	26338145	PRJEB20058_P_NODE_77663_length_470_cov_46.738386_g74883_i0	PRJEB20058	77663	470	46.738386	219.6704142	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	331	5.24e-86	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g74883	i0	81.03	0.908510638297872	427	72	90	8	37	458	1937491	1937913	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	427	331	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26471293	26471293	PRJEB20058_P_NODE_243144_length_208_cov_38.979592_g240319_i0	PRJEB20058	243144	208	38.979592	81.07755136	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	159	1.04e-34	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g240319	i0	82.418	0.875	182	32	88	0	2	183	689082	688901	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	182	159	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
26473416	26473416	PRJEB20058_P_NODE_58576_length_547_cov_66.681070_g55821_i0	PRJEB20058	58576	547	66.68107	364.7454529	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	863	0	NTclustered	gi\|1850842921\|gb\|CP053447.1\|	2026749	g55821	i0	96.718	230.842778793419	518	17	95	0	9	526	429407	428890	Ignavibacteriae bacterium isolate IGN3 chromosome	blastn	126271	863	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium

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