metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
1808256	1808256	PRJNA556992_P_NODE_757702_length_248_cov_1.754286_g755513_i0	PRJNA556992	757702	248	1.754286	4.35062928	Methanobrevibacter ruminantium	83816	Archaea	Archaea	364	2.539999999999999e-96	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g755513	i0	93.145	2	248	17	100	0	1	248	796162	796409	Methanobrevibacter ruminantium M1, complete genome	blastn	496	364	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
1808827	1808827	PRJNA556992_P_NODE_800242_length_246_cov_0.890173_g798052_i0	PRJNA556992	800242	246	0.890173	2.18982558	Methanobrevibacter ruminantium	83816	Archaea	Archaea	200	7.5e-47	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g798052	i0	82.479	0.951219512195122	234	35	94	5	16	246	1863966	1864196	Methanobrevibacter ruminantium M1, complete genome	blastn	234	200	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
2400519	2400519	PRJNA556992_P_NODE_15442_length_854_cov_10.233035_g13669_i0	PRJNA556992	15442	854	10.233035	87.3901189	Methanobrevibacter	2172	Archaea	Archaea	1513	0	NTclustered	gi\|5725307\|emb\|AJ009958.1\|	66852	g13669	i0	98.822	106.286885245902	849	10	99	0	1	849	849	1	Methanobrevibacter sp. SM9 16S rRNA gene, partial	blastn	90769	1528	0.990183246073298	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
4361893	4361893	PRJNA556992_P_NODE_90604_length_417_cov_6.174419_g88421_i0	PRJNA556992	90604	417	6.174419	25.74732723	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	684	0	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g88421	i0	96.386	125.407673860911	415	15	99	0	1	415	495286	494872	Methanobrevibacter sp. YE315, complete genome	blastn	52295	684	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
6904670	6904670	PRJNA556992_P_NODE_290606_length_290_cov_2.382488_g288417_i0	PRJNA556992	290606	290	2.382488	6.9092152	Methanobrevibacter ruminantium	83816	Archaea	Archaea	246	1.1499999999999999e-60	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g288417	i0	82.734	0.958620689655172	278	46	96	2	14	290	891335	891611	Methanobrevibacter ruminantium M1, complete genome	blastn	278	246	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
6906758	6906758	PRJNA556992_P_NODE_444926_length_272_cov_2.095477_g442737_i0	PRJNA556992	444926	272	2.095477	5.69969744	Methanobrevibacter ruminantium	83816	Archaea	Archaea	298	2.9e-76	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g442737	i0	86.397	1	272	37	100	0	1	272	1814317	1814588	Methanobrevibacter ruminantium M1, complete genome	blastn	272	298	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
8178696	8178696	PRJNA556992_P_NODE_236227_length_310_cov_2.902954_g234039_i0	PRJNA556992	236227	310	2.902954	8.9991574	Methanobrevibacter sp. TLL-48-HuF1	2870563	Archaea	Archaea	121	7.83e-23	NTclustered	gi\|2246976648\|gb\|CP081485.1\|	2870563	g234039	i0	92.857	6.33870967741935	84	5	27	1	228	310	1288169	1288086	Methanobrevibacter sp. TLL-48-HuF1 chromosome, complete genome	blastn	1965	121	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. TLL-48-HuF1
10052762	10052762	PRJNA556992_P_NODE_1048_length_2604_cov_43.693007_g832_i1	PRJNA556992	1048	2604	43.693007	1137.76590228	Methanobrevibacter	2172	Archaea	Archaea	4117	0	NTclustered	gi\|470484903\|ref\|NR_076674.1\|	83816	g832	i1	95.989	171.376344086022	2543	87	99	13	2	2538	2539	6	Methanobrevibacter ruminantium strain M1 23S ribosomal RNA gene, complete sequence	blastn	446264	4117	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
11330897	11330897	PRJNA556992_P_NODE_872729_length_242_cov_1.810651_g870539_i0	PRJNA556992	872729	242	1.810651	4.38177542	Methanobacterium	2160	Archaea	Archaea	442	1.1099999999999995e-119	NTclustered	gi\|1297867845\|gb\|CP017766.1\|	59277	g870539	i0	99.587	153.760330578512	242	1	100	0	1	242	1149041	1148800	Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome	blastn	37210	442	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium subterraneum
12006759	12006759	PRJNA556992_P_NODE_370850_length_280_cov_1.135266_g368661_i0	PRJNA556992	370850	280	1.135266	3.1787448	Methanobrevibacter ruminantium	83816	Archaea	Archaea	375	1.3499999999999995e-99	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g368661	i0	91.039	5.49642857142857	279	23	99	2	1	278	380706	380983	Methanobrevibacter ruminantium M1, complete genome	blastn	1539	375	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
16427597	16427597	PRJNA556992_P_NODE_125033_length_378_cov_35.252459_g122846_i0	PRJNA556992	125033	378	35.252459	133.25429502	Methanobrevibacter	2172	Archaea	Archaea	665	0	NTclustered	gi\|470484903\|ref\|NR_076674.1\|	83816	g122846	i0	98.67	150.769841269841	376	4	99	1	3	378	2972	2598	Methanobrevibacter ruminantium strain M1 23S ribosomal RNA gene, complete sequence	blastn	56991	665	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
17702234	17702234	PRJNA556992_P_NODE_1034_length_2623_cov_49.616863_g832_i0	PRJNA556992	1034	2623	49.616863	1301.45031649	Methanobrevibacter	2172	Archaea	Archaea	4388	0	NTclustered	gi\|470484903\|ref\|NR_076674.1\|	83816	g832	i0	97.658	171.537933663744	2562	49	99	7	67	2623	6	2561	Methanobrevibacter ruminantium strain M1 23S ribosomal RNA gene, complete sequence	blastn	449944	4388	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
18380562	18380562	PRJNA556992_P_NODE_439895_length_272_cov_8.442211_g437706_i0	PRJNA556992	439895	272	8.442211	22.96281392	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	449	7.57e-122	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g437706	i0	96.703	44.6727941176471	273	4	100	5	1	272	494841	494573	Methanobrevibacter sp. YE315, complete genome	blastn	12151	449	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
18383772	18383772	PRJNA556992_P_NODE_69295_length_455_cov_8.753927_g67122_i0	PRJNA556992	69295	455	8.753927	39.83036785	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	789	0	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g67122	i0	98.022	164.206593406593	455	7	99	2	1	454	495740	496193	Methanobrevibacter sp. YE315, complete genome	blastn	74714	789	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
20251955	20251955	PRJNA556992_P_NODE_229956_length_312_cov_1.267782_g227768_i0	PRJNA556992	229956	312	1.267782	3.95547984	root	1	Root_unresolved	Root_unresolved	58.4	6.27e-4	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g227768	i0	100	10.0352564102564	31	0	10	0	85	115	265488	265518	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	3131	58.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
20937061	20937061	PRJNA556992_P_NODE_94617_length_412_cov_2.271386_g92433_i0	PRJNA556992	94617	412	2.271386	9.35811032	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	693	0	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g92433	i0	97.08	154.128640776699	411	12	99	0	2	412	496562	496152	Methanobrevibacter sp. YE315, complete genome	blastn	63501	693	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
21527048	21527048	PRJNA556992_P_NODE_14257_length_887_cov_50.541769_g12530_i0	PRJNA556992	14257	887	50.541769	448.30549103	Methanobrevibacter	2172	Archaea	Archaea	1618	0	NTclustered	gi\|5725308\|emb\|AJ009959.1\|	66852	g12530	i0	99.886	96.3517474633596	879	1	99	0	2	880	879	1	Methanobrevibacter sp. NT7, 16S rRNA gene, partial	blastn	85464	1620	0.998765432098765	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
22204159	22204159	PRJNA556992_P_NODE_312698_length_287_cov_1.439252_g310509_i0	PRJNA556992	312698	287	1.439252	4.13065324	Methanobrevibacter olleyae	294671	Archaea	Archaea	233	8.829999999999999e-57	NTclustered	gi\|998157363\|gb\|CP014265.1\|	294671	g310509	i0	81.533	1	287	49	99	4	1	285	224227	223943	Methanobrevibacter olleyae strain YLM1 chromosome, complete genome	blastn	287	233	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter olleyae
22212438	22212438	PRJNA556992_P_NODE_974738_length_233_cov_2.956250_g972548_i0	PRJNA556992	974738	233	2.95625	6.8880625	Methanobrevibacter millerae	230361	Archaea	Archaea	425	1.07e-114	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g972548	i0	99.571	140.412017167382	233	1	100	0	1	233	542024	542256	Methanobrevibacter millerae strain SM9, complete genome	blastn	32716	425	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae

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