metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_species
2041231	2041231	PRJNA784298_P_NODE_19702_length_278_cov_2.195122_g19501_i0	PRJNA784298	19702	278	2.195122	6.10243916	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	217	8.569999999999999e-52	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g19501	i0	85.238	18.9424460431655	210	31	76	0	11	220	927095	927304	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	5266	217	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
2041279	2041279	PRJNA784298_P_NODE_2422_length_817_cov_10.111559_g2240_i0	PRJNA784298	2422	817	10.111559	82.61143703	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	418	7.029999999999999e-112	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g2240	i0	78.209	1.88984088127295	670	134	82	11	7	673	640846	641506	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	1544	418	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
3316513	3316513	PRJNA784298_P_NODE_12723_length_350_cov_1.942238_g12522_i0	PRJNA784298	12723	350	1.942238	6.797833	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	315	3.8199999999999998e-81	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g12522	i0	82.997	1.12857142857143	347	59	99	0	3	349	1127607	1127953	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	395	315	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
3316629	3316629	PRJNA784298_P_NODE_22863_length_256_cov_1.612022_g22662_i0	PRJNA784298	22863	256	1.612022	4.12677632	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	206	1.69e-48	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g22662	i0	81.395	14.25	258	42	99	6	2	256	886986	887240	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	3648	206	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
7143759	7143759	PRJNA784298_P_NODE_16926_length_301_cov_2.337719_g16725_i0	PRJNA784298	16926	301	2.337719	7.03653419	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	130	1.26e-25	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g16725	i0	94.118	20.6511627906977	85	5	28	0	7	91	769564	769480	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	6216	130	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
7143764	7143764	PRJNA784298_P_NODE_17306_length_298_cov_1.844444_g17105_i0	PRJNA784298	17306	298	1.844444	5.49644312	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	265	3.2699999999999997e-66	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g17105	i0	82.935	15.3926174496644	293	50	98	0	1	293	30651	30943	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	4587	265	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
7143880	7143880	PRJNA784298_P_NODE_28166_length_223_cov_9.253333_g27965_i0	PRJNA784298	28166	223	9.253333	20.63493259	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	119	1.92e-22	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g27965	i0	95.89	2.74887892376682	73	3	33	0	3	75	704048	703976	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	613	119	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
8418552	8418552	PRJNA784298_P_NODE_347_length_2190_cov_4.691072_g286_i0	PRJNA784298	347	2190	4.691072	102.7344768	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1384	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g286	i0	78.665	35.8529680365297	2217	375	99	70	1	2166	531114	533283	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	78518	1384	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
9693684	9693684	PRJNA784298_P_NODE_20008_length_276_cov_1.566502_g19807_i0	PRJNA784298	20008	276	1.566502	4.32354552	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	206	1.84e-48	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g19807	i0	88.636	33.7644927536232	176	10	63	6	99	273	1254201	1254367	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	9319	206	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
9693797	9693797	PRJNA784298_P_NODE_3928_length_642_cov_2.667838_g3731_i0	PRJNA784298	3928	642	2.667838	17.12751996	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	623	1.08e-173	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g3731	i0	85.289	69.9221183800623	605	87	94	2	39	642	677599	676996	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	44890	623	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
9693817	9693817	PRJNA784298_P_NODE_568_length_1718_cov_19.317933_g483_i0	PRJNA784298	568	1718	19.317933	331.88208894	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1214	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g483	i0	84.084	65.0325960419092	1288	173	74	23	442	1709	466044	464769	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	111726	1214	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
12244809	12244809	PRJNA784298_P_NODE_10590_length_385_cov_2.753205_g10389_i0	PRJNA784298	10590	385	2.753205	10.59983925	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	237	9.45e-58	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g10389	i0	79.939	0.854545454545454	329	60	85	6	1	326	814436	814111	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	329	237	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
12244971	12244971	PRJNA784298_P_NODE_24950_length_247_cov_0.885057_g24749_i0	PRJNA784298	24950	247	0.885057	2.18609079	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	335	1.9799999999999992e-87	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g24749	i0	91.165	174.396761133603	249	18	100	4	1	247	907739	907985	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	43076	335	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		TM7 phylum sp. oral taxon 349
13518998	13518998	PRJNA784298_P_NODE_10431_length_388_cov_5.933333_g10230_i0	PRJNA784298	10431	388	5.933333	23.02133204	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	195	5.819999999999999e-45	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g10230	i0	78.431	0.86340206185567	306	60	78	6	1	303	70330	70028	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	335	195	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
14794082	14794082	PRJNA784298_P_NODE_7552_length_458_cov_172.451948_g7351_i0	PRJNA784298	7552	458	172.451948	789.82992184	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	113	2.01e-20	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g7351	i0	82.222	0.294759825327511	135	20	29	2	34	167	938528	938659	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	135	113	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
16067728	16067728	PRJNA784298_P_NODE_113_length_3494_cov_9.998831_g91_i0	PRJNA784298	113	3494	9.998831	349.35915514	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	832	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g91	i0	80.14	4.35489410417859	1143	204	32	21	122	1254	797675	798804	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	15216	832	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
17343455	17343455	PRJNA784298_P_NODE_10474_length_387_cov_13.738854_g10273_i0	PRJNA784298	10474	387	13.738854	53.16936498	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	307	7.140000000000001e-79	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g10273	i0	83.382	6.86304909560724	343	46	87	10	3	338	308677	308339	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	2656	307	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
17343664	17343664	PRJNA784298_P_NODE_34_length_5720_cov_11.325128_g31_i0	PRJNA784298	34	5720	11.325128	647.7973216	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1611	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g31	i0	74.891	4.44527972027972	3895	801	67	127	548	4400	611521	615280	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	25427	1611	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
19892071	19892071	PRJNA784298_P_NODE_11916_length_362_cov_5.062284_g11715_i0	PRJNA784298	11916	362	5.062284	18.32546808	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	207	6.92e-49	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g11715	i0	80.071	0.776243093922652	281	55	78	1	82	362	6653	6932	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	281	207	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
19892099	19892099	PRJNA784298_P_NODE_1456_length_1072_cov_13.342342_g1306_i0	PRJNA784298	1456	1072	13.342342	143.02990624	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	316	3.5000000000000003e-81	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g1306	i0	75.61	13.9067164179104	697	138	64	25	389	1069	1294084	1294764	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	14908	316	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
19892311	19892311	PRJNA784298_P_NODE_7716_length_453_cov_4.097368_g7515_i0	PRJNA784298	7716	453	4.097368	18.56107704	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	243	2.43e-59	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g7515	i0	76.674	1.37306843267108	463	93	99	13	2	453	583760	583302	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	622	243	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
21167847	21167847	PRJNA784298_P_NODE_17_length_7627_cov_9.959624_g15_i0	PRJNA784298	17	7627	9.959624	759.62052248	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	1646	0	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g15	i0	76.242	1.85092434771208	3321	663	43	101	1993	5241	861545	858279	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	14117	1646	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
22442591	22442591	PRJNA784298_P_NODE_15758_length_313_cov_1.825000_g15557_i0	PRJNA784298	15758	313	1.825	5.71225	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	302	2.63e-77	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g15557	i0	85.374	28.4696485623003	294	39	93	3	2	293	893935	893644	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	8911	302	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
23718262	23718262	PRJNA784298_P_NODE_3799_length_653_cov_1.575862_g3602_i0	PRJNA784298	3799	653	1.575862	10.29037886	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	403	1.5599999999999994e-107	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g3602	i0	78.067	9.97702909647779	652	133	99	10	7	653	1209559	1208913	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	6515	403	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
24991785	24991785	PRJNA784298_P_NODE_21440_length_265_cov_3.739583_g21239_i0	PRJNA784298	21440	265	3.739583	9.90989495	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	182	2.96e-41	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g21239	i0	82.524	3.40754716981132	206	36	78	0	14	219	237884	237679	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	903	182	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria 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);;