metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

29 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_clade = "Methanomada group"

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_family	tax_genus	tax_species
23695	23695	PRJEB28062_P_NODE_113321_length_277_cov_6.529412_g110958_i0	PRJEB28062	113321	277	6.529412	18.08647124	uncultured Methanobacterium sp.	176306	Archaea	Archaea	224	5.1e-54	NTclustered	gi\|2621703503\|emb\|OY762552.1\|	176306	g110958	i0	81.362	1.0072202166065	279	48	100	2	1	277	1119266	1119542	MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1	blastn	279	224	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
23887	23887	PRJEB28062_P_NODE_123621_length_252_cov_2.413408_g121257_i0	PRJEB28062	123621	252	2.413408	6.08178816	Methanobacterium subterraneum	59277	Archaea	Archaea	180	1e-40	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g121257	i0	90.511	0.543650793650794	137	12	54	1	117	252	1645165	1645029	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	137	180	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
25361	25361	PRJEB28062_P_NODE_72521_length_402_cov_8.598784_g70160_i0	PRJEB28062	72521	402	8.598784	34.56711168	uncultured Methanobacterium sp.	176306	Archaea	Archaea	171	1.0199999999999998e-37	NTclustered	gi\|2621703503\|emb\|OY762552.1\|	176306	g70160	i0	76.488	0.835820895522388	336	65	81	11	28	354	378651	378321	MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1	blastn	336	171	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
987732	987732	PRJEB28062_P_NODE_68121_length_418_cov_12.939130_g65760_i0	PRJEB28062	68121	418	12.93913	54.0855634	Methanobacterium	2160	Archaea	Archaea	571	2.5e-158	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g65760	i0	93.915	8.11004784688995	378	23	90	0	23	400	1331153	1331530	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	3390	571	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
987956	987956	PRJEB28062_P_NODE_93041_length_335_cov_17.480916_g90679_i0	PRJEB28062	93041	335	17.480916	58.5610686	Methanobacterium	2160	Archaea	Archaea	335	2.8e-87	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g90679	i0	87.629	3.55522388059702	291	33	87	2	24	314	1557996	1558283	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	1191	335	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
1299090	1299090	PRJEB28062_P_NODE_46942_length_524_cov_3.270510_g44598_i0	PRJEB28062	46942	524	3.27051	17.1374724	Methanobacterium alkalithermotolerans	2731220	Archaea	Archaea	828	0	NTclustered	gi\|2029999282\|gb\|CP058560.1\|	2731220	g44598	i0	96.957	0.940839694656489	493	15	94	0	12	504	665840	666332	Methanobacterium alkalithermotolerans strain CAN chromosome, complete genome	blastn	493	828	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium alkalithermotolerans
3850821	3850821	PRJEB28062_P_NODE_37544_length_596_cov_10.785851_g35217_i0	PRJEB28062	37544	596	10.785851	64.28367196	Methanobacterium alkalithermotolerans	2731220	Archaea	Archaea	1033	0	NTclustered	gi\|2029999282\|gb\|CP058560.1\|	2731220	g35217	i0	100	1.6761744966443	559	0	94	0	23	581	1337260	1336702	Methanobacterium alkalithermotolerans strain CAN chromosome, complete genome	blastn	999	1033	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium alkalithermotolerans
5125933	5125933	PRJEB28062_P_NODE_104185_length_302_cov_5.030568_g101822_i0	PRJEB28062	104185	302	5.030568	15.19231536	Methanobacterium subterraneum	59277	Archaea	Archaea	364	3.179999999999999e-96	NTclustered	gi\|1297874793\|gb\|CP017768.1\|	59277	g101822	i0	90.545	2.7317880794702	275	26	91	0	23	297	129669	129943	Methanobacterium subterraneum strain A8p chromosome, complete genome	blastn	825	364	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
6403471	6403471	PRJEB28062_P_NODE_68626_length_416_cov_22.166181_g66265_i0	PRJEB28062	68626	416	22.166181	92.21131296	Methanobacterium ferruginis	710191	Archaea	Archaea	420	9.52e-113	NTclustered	gi\|2465756734\|dbj\|AP027738.1\|	710191	g66265	i0	86.458	25.0192307692308	384	50	92	2	10	392	148113	148495	Methanobacterium ferruginis NBRC 105197 DNA, complete genome	blastn	10408	420	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium ferruginis
7677203	7677203	PRJEB28062_P_NODE_52047_length_492_cov_12.023866_g49696_i0	PRJEB28062	52047	492	12.023866	59.15742072	Methanobacterium petrolearium	710190	Archaea	Archaea	529	1.8199999999999993e-145	NTclustered	gi\|2465759960\|dbj\|AP027739.1\|	710190	g49696	i0	87.419	1.8719512195122	461	57	94	1	21	481	441204	441663	Methanobacterium petrolearium NBRC 105198 DNA, complete genome	blastn	921	529	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium petrolearium
10228418	10228418	PRJEB28062_P_NODE_86569_length_356_cov_3.000000_g84207_i0	PRJEB28062	86569	356	3	10.68	Methanobacterium petrolearium	710190	Archaea	Archaea	492	1.68e-134	NTclustered	gi\|2465759960\|dbj\|AP027739.1\|	710190	g84207	i0	97.895	126.266853932584	285	5	88	1	50	333	2432949	2433233	Methanobacterium petrolearium NBRC 105198 DNA, complete genome	blastn	44951	492	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium petrolearium
10228651	10228651	PRJEB28062_P_NODE_98449_length_319_cov_6.085366_g96087_i0	PRJEB28062	98449	319	6.085366	19.41231754	Methanobacterium sp. MB1	1379702	Archaea	Archaea	248	3.55e-61	NTclustered	gi\|557945513\|emb\|HG425166.1\|	1379702	g96087	i0	82.517	0.896551724137931	286	46	88	2	29	310	255714	255429	Methanobacterium sp. MB1 complete sequence	blastn	286	248	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. MB1
12777387	12777387	PRJEB28062_P_NODE_119791_length_261_cov_1.638298_g117428_i0	PRJEB28062	119791	261	1.638298	4.27595778	Methanobacterium alkalithermotolerans	2731220	Archaea	Archaea	451	2.01e-122	NTclustered	gi\|2029999282\|gb\|CP058560.1\|	2731220	g117428	i0	98.438	0.980842911877395	256	4	98	0	1	256	1425962	1426217	Methanobacterium alkalithermotolerans strain CAN chromosome, complete genome	blastn	256	451	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium alkalithermotolerans
12778922	12778922	PRJEB28062_P_NODE_71951_length_404_cov_9.984894_g69590_i0	PRJEB28062	71951	404	9.984894	40.33897176	Methanobacterium sp. MB1	1379702	Archaea	Archaea	237	9.97e-58	NTclustered	gi\|557945513\|emb\|HG425166.1\|	1379702	g69590	i0	85.217	3.32920792079208	230	34	57	0	23	252	771295	771524	Methanobacterium sp. MB1 complete sequence	blastn	1345	237	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. MB1
14053581	14053581	PRJEB28062_P_NODE_74252_length_396_cov_13.476780_g71890_i0	PRJEB28062	74252	396	13.47678	53.3680488	Methanobacterium subterraneum	59277	Archaea	Archaea	361	5.5499999999999996e-95	NTclustered	gi\|1297874793\|gb\|CP017768.1\|	59277	g71890	i0	85.154	2.3030303030303	357	47	90	4	19	374	885351	885702	Methanobacterium subterraneum strain A8p chromosome, complete genome	blastn	912	361	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
15326049	15326049	PRJEB28062_P_NODE_123013_length_253_cov_11.977778_g120649_i0	PRJEB28062	123013	253	11.977778	30.30377834	Methanobacterium ferruginis	710191	Archaea	Archaea	143	1.32e-29	NTclustered	gi\|2465756734\|dbj\|AP027738.1\|	710191	g120649	i0	89.076	5.58893280632411	119	8	46	4	23	138	472059	472175	Methanobacterium ferruginis NBRC 105197 DNA, complete genome	blastn	1414	143	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium ferruginis
15327846	15327846	PRJEB28062_P_NODE_87953_length_351_cov_9.593525_g85591_i0	PRJEB28062	87953	351	9.593525	33.67327275	Methanobacterium subterraneum	59277	Archaea	Archaea	451	2.8e-122	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g85591	i0	93.443	9.98860398860399	305	18	87	1	23	327	37177	36875	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	3506	451	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
16600666	16600666	PRJEB28062_P_NODE_120734_length_259_cov_1.080645_g118370_i0	PRJEB28062	120734	259	1.080645	2.79887055	Methanobacterium alkalithermotolerans	2731220	Archaea	Archaea	375	1.2299999999999998e-99	NTclustered	gi\|2029999282\|gb\|CP058560.1\|	2731220	g118370	i0	97.285	0.853281853281853	221	6	85	0	21	241	1916648	1916868	Methanobacterium alkalithermotolerans strain CAN chromosome, complete genome	blastn	221	375	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium alkalithermotolerans
16600808	16600808	PRJEB28062_P_NODE_128754_length_244_cov_0.900585_g126390_i0	PRJEB28062	128754	244	0.900585	2.1974274	Methanobacterium ferruginis	710191	Archaea	Archaea	255	1.5600000000000001e-63	NTclustered	gi\|2465756734\|dbj\|AP027738.1\|	710191	g126390	i0	86.192	2.93852459016393	239	30	98	2	4	242	1970046	1969811	Methanobacterium ferruginis NBRC 105197 DNA, complete genome	blastn	717	255	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium ferruginis
17565319	17565319	PRJEB28062_P_NODE_39814_length_576_cov_52.248509_g37481_i0	PRJEB28062	39814	576	52.248509	300.95141184	Methanobacterium	2160	Archaea	Archaea	682	0	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g37481	i0	89.831	6.35069444444444	531	54	92	0	24	554	1621525	1622055	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	3658	682	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
17875121	17875121	PRJEB28062_P_NODE_103235_length_305_cov_3.267241_g100872_i0	PRJEB28062	103235	305	3.267241	9.96508505	Methanobacterium ferruginis	710191	Archaea	Archaea	261	4.340000000000001e-65	NTclustered	gi\|2465756734\|dbj\|AP027738.1\|	710191	g100872	i0	84.791	2.3344262295082	263	37	85	3	20	279	275958	275696	Methanobacterium ferruginis NBRC 105197 DNA, complete genome	blastn	712	261	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium ferruginis
19150427	19150427	PRJEB28062_P_NODE_49096_length_510_cov_5.983982_g46749_i0	PRJEB28062	49096	510	5.983982	30.5183082	Methanobacterium petrolearium	710190	Archaea	Archaea	388	3.35e-103	NTclustered	gi\|2465759960\|dbj\|AP027739.1\|	710190	g46749	i0	81.607	8.60588235294118	473	84	93	3	21	492	977040	976570	Methanobacterium petrolearium NBRC 105198 DNA, complete genome	blastn	4389	388	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium petrolearium
19150543	19150543	PRJEB28062_P_NODE_54276_length_480_cov_5.262899_g51923_i0	PRJEB28062	54276	480	5.262899	25.2619152	uncultured Methanobacterium sp.	176306	Archaea	Archaea	231	5.59e-56	NTclustered	gi\|2621703503\|emb\|OY762552.1\|	176306	g51923	i0	83.137	0.65	255	41	53	2	23	276	2415094	2415347	MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1	blastn	312	231	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
21389869	21389869	PRJEB28062_P_NODE_65177_length_430_cov_1.862745_g62816_i0	PRJEB28062	65177	430	1.862745	8.0098035	Methanobacterium	2160	Archaea	Archaea	636	8.999999999999996e-178	NTclustered	gi\|1297874793\|gb\|CP017768.1\|	59277	g62816	i0	94.09	7.55813953488372	423	17	98	7	1	421	1991907	1992323	Methanobacterium subterraneum strain A8p chromosome, complete genome	blastn	3250	636	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
24251062	24251062	PRJEB28062_P_NODE_64320_length_433_cov_7.616667_g61959_i0	PRJEB28062	64320	433	7.616667	32.98016811	uncultured Methanobacterium sp.	176306	Archaea	Archaea	556	7.27e-154	NTclustered	gi\|2621703503\|emb\|OY762552.1\|	176306	g61959	i0	91.646	0.939953810623557	407	26	92	6	13	412	1770429	1770024	MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1	blastn	407	556	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
24251610	24251610	PRJEB28062_P_NODE_93340_length_335_cov_1.175573_g90978_i0	PRJEB28062	93340	335	1.175573	3.93816955	Methanobacterium formicicum	2162	Archaea	Archaea	568	2.5399999999999994e-157	NTclustered	gi\|952971377\|emb\|LN734822.1\|	2162	g90978	i0	97.305	0.997014925373134	334	9	99	0	2	335	1206660	1206993	Methanobacterium formicicum genome assembly isolate Mb9, chromosome : I	blastn	334	568	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium formicicum
24251707	24251707	PRJEB28062_P_NODE_98520_length_319_cov_3.528455_g96158_i0	PRJEB28062	98520	319	3.528455	11.25577145	Methanobacterium subterraneum	59277	Archaea	Archaea	420	7.12e-113	NTclustered	gi\|1297874793\|gb\|CP017768.1\|	59277	g96158	i0	91.234	4.78369905956113	308	27	97	0	1	308	1172258	1171951	Methanobacterium subterraneum strain A8p chromosome, complete genome	blastn	1526	420	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
25212982	25212982	PRJEB28062_P_NODE_101720_length_310_cov_1.164557_g99357_i0	PRJEB28062	101720	310	1.164557	3.6101267	Methanobrevibacter	2172	Archaea	Archaea	464	3.14e-126	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g99357	i0	97.426	126.812903225806	272	7	88	0	16	287	265946	265675	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	39312	464	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
25213740	25213740	PRJEB28062_P_NODE_59180_length_456_cov_2.133159_g56821_i0	PRJEB28062	59180	456	2.133159	9.72720504	Methanobacterium	2160	Archaea	Archaea	597	4.5299999999999986e-166	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g56821	i0	91.304	9.56578947368421	437	38	96	0	1	437	137638	137202	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	4362	597	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum

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