metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax_phylum = "Elusimicrobiota"

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_species
3218018	3218018	PRJNA688655_P_NODE_14563_length_243_cov_0.905882_g14498_i0	PRJNA688655	14563	243	0.905882	2.20129326	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	344	3.23e-90	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g14498	i0	92.181	21.7119341563786	243	19	100	0	1	243	1126524	1126282	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	5276	344	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
4495036	4495036	PRJNA688655_P_NODE_10404_length_248_cov_0.880000_g10339_i0	PRJNA688655	10404	248	0.88	2.1824	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g10339	i0	86.8	1.00806451612903	250	29	100	4	1	248	1676249	1676496	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	250	276	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
4495082	4495082	PRJNA688655_P_NODE_13344_length_244_cov_1.801170_g13279_i0	PRJNA688655	13344	244	1.80117	4.3948548	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	305	1.53e-78	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g13279	i0	89.873	0.971311475409836	237	24	97	0	1	237	1622729	1622493	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	237	305	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
4495186	4495186	PRJNA688655_P_NODE_6164_length_274_cov_1.149254_g6099_i0	PRJNA688655	6164	274	1.149254	3.14895596	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	257	4.97e-64	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g6099	i0	83.636	1.0036496350365	275	43	100	2	1	274	1235405	1235678	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	275	257	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
5770807	5770807	PRJNA688655_P_NODE_5045_length_294_cov_1.393665_g4980_i0	PRJNA688655	5045	294	1.393665	4.0973751	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	217	9.14e-52	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g4980	i0	80.783	0.95578231292517	281	51	95	3	4	282	995763	995484	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	281	217	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
10871179	10871179	PRJNA688655_P_NODE_14829_length_243_cov_0.905882_g14764_i0	PRJNA688655	14829	243	0.905882	2.20129326	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g14764	i0	100	41.0411522633745	243	0	100	0	1	243	128672	128430	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	9973	449	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
10871216	10871216	PRJNA688655_P_NODE_2129_length_390_cov_0.971609_g2064_i0	PRJNA688655	2129	390	0.971609	3.7892751	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	518	3.06e-142	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g2064	i0	91.049	9.36410256410256	391	24	100	4	1	390	1345027	1344647	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	3652	518	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
10871226	10871226	PRJNA688655_P_NODE_3009_length_347_cov_0.872263_g2944_i0	PRJNA688655	3009	347	0.872263	3.02675261	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	327	4.869999999999999e-85	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g2944	i0	89.015	0.760806916426513	264	29	76	0	82	345	585249	584986	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	264	327	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
12146508	12146508	PRJNA688655_P_NODE_14810_length_243_cov_0.905882_g14745_i0	PRJNA688655	14810	243	0.905882	2.20129326	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g14745	i0	96.708	1	243	8	100	0	1	243	1226160	1226402	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	243	405	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
13421178	13421178	PRJNA688655_P_NODE_8451_length_250_cov_0.870056_g8386_i0	PRJNA688655	8451	250	0.870056	2.17514	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g8386	i0	86.4	1	250	34	100	0	1	250	1206608	1206359	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	250	274	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
15969915	15969915	PRJNA688655_P_NODE_5533_length_285_cov_1.452830_g5468_i0	PRJNA688655	5533	285	1.45283	4.1405655	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	449	7.99e-122	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g5468	i0	95.088	1	285	14	100	0	1	285	1105521	1105805	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	285	449	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
17245064	17245064	PRJNA688655_P_NODE_13434_length_244_cov_0.900585_g13369_i0	PRJNA688655	13434	244	0.900585	2.1974274	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g13369	i0	94.239	34.2950819672131	243	14	99	0	1	243	117767	118009	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	8368	372	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
22344394	22344394	PRJNA688655_P_NODE_10578_length_248_cov_0.880000_g10513_i0	PRJNA688655	10578	248	0.88	2.1824	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	65.8	2.88e-6	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g10513	i0	97.368	0.286290322580645	38	1	15	0	1	38	256829	256792	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	71	65.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
22344606	22344606	PRJNA688655_P_NODE_9778_length_249_cov_0.875000_g9713_i0	PRJNA688655	9778	249	0.875	2.17875	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	139	1.68e-28	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g9713	i0	79.208	0.811244979919679	202	40	81	2	41	241	721234	721034	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	202	139	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
23619946	23619946	PRJNA688655_P_NODE_13179_length_245_cov_0.895349_g13114_i0	PRJNA688655	13179	245	0.895349	2.19360505	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	375	1.16e-99	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g13114	i0	94.286	1	245	14	100	0	1	245	223827	224071	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	245	375	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
23620082	23620082	PRJNA688655_P_NODE_7859_length_251_cov_0.865169_g7794_i0	PRJNA688655	7859	251	0.865169	2.17157419	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	294	3.4200000000000003e-75	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g7794	i0	88.211	0.9800796812749	246	29	98	0	1	246	956997	957242	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	246	294	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae bacterium
23620083	23620083	PRJNA688655_P_NODE_7979_length_251_cov_0.865169_g7914_i0	PRJNA688655	7979	251	0.865169	2.17157419	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	143	1.31e-29	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g7914	i0	81.319	0.725099601593626	182	28	71	4	52	230	1657416	1657594	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	182	143	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobiaceae 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);;