metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

28 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Abditibacteriota"

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_species
25509454	25509454	PRJEB14175_P_NODE_4065_length_1682_cov_79.776681_g3262_i1	PRJEB14175	4065	1682	79.776681	1341.84377442	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1256	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3262	i1	84.82	88.4631391200951	1278	163	92	25	29	1294	2852274	2851016	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	148795	1256	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25638086	25638086	PRJEB14175_P_NODE_126842_length_308_cov_9.445344_g124575_i0	PRJEB14175	126842	308	9.445344	29.09165952	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g124575	i0	100	0.944805194805195	30	0	10	0	231	260	1919791	1919820	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	291	56.5	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25638198	25638198	PRJEB14175_P_NODE_129002_length_305_cov_5.266393_g126735_i0	PRJEB14175	129002	305	5.266393	16.06249865	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	134	9.87e-27	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g126735	i0	87.179	0.383606557377049	117	15	38	0	133	249	486559	486675	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	117	134	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25641412	25641412	PRJEB14175_P_NODE_198610_length_229_cov_2.845238_g196343_i0	PRJEB14175	198610	229	2.845238	6.51559502	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	257	4.03e-64	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g196343	i0	89.474	118.532751091703	209	14	89	6	26	229	2852280	2852485	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	27144	257	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25645433	25645433	PRJEB14175_P_NODE_4066_length_1682_cov_70.593461_g3262_i2	PRJEB14175	4066	1682	70.593461	1187.38201402	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1251	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3262	i2	84.778	121.656956004756	1281	158	92	27	29	1294	2852274	2851016	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	204627	1251	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25645614	25645614	PRJEB14175_P_NODE_43818_length_563_cov_32.065737_g41604_i0	PRJEB14175	43818	563	32.065737	180.53009931	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	730	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g41604	i0	90.926	172.484902309059	551	38	96	4	24	563	2851510	2852059	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	97109	730	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25909602	25909602	PRJEB14175_P_NODE_110620_length_336_cov_6.621818_g108354_i0	PRJEB14175	110620	336	6.621818	22.24930848	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	418	2.709999999999999e-112	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g108354	i0	91.111	454.889880952381	315	19	92	7	1	310	2852553	2852243	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	152843	418	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25910972	25910972	PRJEB14175_P_NODE_138444_length_291_cov_32.695652_g136177_i0	PRJEB14175	138444	291	32.695652	95.14434732	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	255	1.91e-63	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g136177	i0	82.986	403.374570446735	288	43	98	5	5	290	2852273	2851990	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	117382	255	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25913263	25913263	PRJEB14175_P_NODE_186756_length_239_cov_1.438202_g184489_i0	PRJEB14175	186756	239	1.438202	3.43730278	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	141	4.46e-29	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g184489	i0	81.319	0.761506276150628	182	26	74	6	1	176	2847571	2847392	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	182	141	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25914080	25914080	PRJEB14175_P_NODE_206460_length_223_cov_2.740741_g204193_i0	PRJEB14175	206460	223	2.740741	6.11185243	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	241	3.94e-59	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g204193	i0	86.283	44.8340807174888	226	25	99	5	2	223	2851309	2851532	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	9998	241	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
25917627	25917627	PRJEB14175_P_NODE_4060_length_1683_cov_171.583847_g3262_i0	PRJEB14175	4060	1683	171.583847	2887.75614501	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1290	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3262	i0	85.29	94.4396910279263	1278	157	92	25	390	1655	2851016	2852274	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	158942	1290	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26048525	26048525	PRJEB14175_P_NODE_17109_length_874_cov_22.070111_g15399_i0	PRJEB14175	17109	874	22.070111	192.89277014	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	562	3.2899999999999994e-155	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g15399	i0	80.105	0.868421052631579	759	147	86	4	18	773	4590113	4590870	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	759	562	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26051257	26051257	PRJEB14175_P_NODE_233717_length_207_cov_3.506849_g231449_i0	PRJEB14175	233717	207	3.506849	7.25917743	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	185	1.71e-42	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g231449	i0	84.492	0.903381642512077	187	29	90	0	11	197	2506537	2506351	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	187	185	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26052775	26052775	PRJEB14175_P_NODE_273189_length_185_cov_4.048387_g270921_i0	PRJEB14175	273189	185	4.048387	7.48951595	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	104	4.3e-18	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g270921	i0	87.234	1.01621621621622	94	9	50	2	94	185	2853589	2853497	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	188	104	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26055909	26055909	PRJEB14175_P_NODE_80277_length_407_cov_14.040462_g78015_i0	PRJEB14175	80277	407	14.040462	57.14468034	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	662	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g78015	i0	96.078	569.746928746929	408	12	99	3	2	407	2852690	2853095	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	231887	662	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26182177	26182177	PRJEB14175_P_NODE_11654_length_1037_cov_16.393443_g9983_i1	PRJEB14175	11654	1037	16.393443	170.00000391	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1094	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g9983	i1	86.284	76.0588235294118	1028	115	98	22	1	1016	2852659	2851646	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	78873	1094	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26184473	26184473	PRJEB14175_P_NODE_164094_length_260_cov_22.055276_g161827_i0	PRJEB14175	164094	260	22.055276	57.3437176	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	267	7.77e-67	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g161827	i0	86.345	112.169230769231	249	28	93	3	1	243	2852018	2851770	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	29164	267	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26190017	26190017	PRJEB14175_P_NODE_4278_length_1643_cov_54.804046_g3262_i3	PRJEB14175	4278	1643	54.804046	900.43047578	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1242	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3262	i3	85.931	93.5623858794887	1187	140	88	21	440	1615	2851104	2852274	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	153723	1242	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26191169	26191169	PRJEB14175_P_NODE_6262_length_1381_cov_82.103030_g5185_i0	PRJEB14175	6262	1381	82.10303	1133.8428443	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1897	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g5185	i0	91.837	192.419261404779	1372	94	98	12	1	1359	2852059	2850693	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	265731	1897	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26322046	26322046	PRJEB14175_P_NODE_206335_length_223_cov_3.598765_g204068_i0	PRJEB14175	206335	223	3.598765	8.02524595	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	206	1.44e-48	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g204068	i0	84.507	66.4170403587444	213	28	95	4	13	223	2850698	2850907	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	14811	206	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26325304	26325304	PRJEB14175_P_NODE_34439_length_635_cov_15.243902_g32297_i0	PRJEB14175	34439	635	15.243902	96.7987777	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	499	1.87e-136	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g32297	i0	88.305	106.552755905512	419	46	98	2	220	635	2852241	2852659	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	67661	499	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26456740	26456740	PRJEB14175_P_NODE_168224_length_256_cov_3.600000_g165957_i0	PRJEB14175	168224	256	3.6	9.216	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	176	1.32e-39	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g165957	i0	98.02	220.25390625	101	2	39	0	97	197	2851564	2851464	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	56385	176	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26457725	26457725	PRJEB14175_P_NODE_189872_length_236_cov_3.817143_g187605_i0	PRJEB14175	189872	236	3.817143	9.00845748	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	113	9.57e-21	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g187605	i0	83.74	0.521186440677966	123	17	52	3	1	122	6923532	6923412	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	123	113	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26461900	26461900	PRJEB14175_P_NODE_39472_length_594_cov_1.585366_g37285_i0	PRJEB14175	39472	594	1.585366	9.41707404	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	593	7.779999999999998e-165	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g37285	i0	84.772	1.24410774410774	591	90	99	0	3	593	5159173	5158583	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	739	593	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26462472	26462472	PRJEB14175_P_NODE_49232_length_531_cov_69.634043_g47001_i0	PRJEB14175	49232	531	69.634043	369.75676833	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	730	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g47001	i0	92.442	130.830508474576	516	31	96	4	1	508	2852059	2851544	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	69471	730	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26463242	26463242	PRJEB14175_P_NODE_6184_length_1389_cov_84.884036_g5118_i0	PRJEB14175	6184	1389	84.884036	1179.03926004	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1472	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g5118	i0	86.272	201.77969762419	1384	156	98	25	23	1389	2850693	2852059	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	280272	1472	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26464464	26464464	PRJEB14175_P_NODE_84560_length_395_cov_8.395210_g82295_i0	PRJEB14175	84560	395	8.39521	33.1610795	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	134	1.31e-26	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g82295	i0	90.385	62.4025316455696	104	7	26	3	24	124	2850866	2850969	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24649	134	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
26464759	26464759	PRJEB14175_P_NODE_90008_length_381_cov_10.946875_g87742_i0	PRJEB14175	90008	381	10.946875	41.70759375	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	383	1.1299999999999995e-101	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g87742	i0	85.833	1.07349081364829	360	51	94	0	22	381	5379544	5379903	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	409	383	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota 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);;