metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA946307" 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
1259948	1259948	PRJNA946307_P_NODE_12841_length_366_cov_3.252366_g11975_i0	PRJNA946307	12841	366	3.252366	11.90365956	root	1	Root_unresolved	Root_unresolved	553	7.81e-153	NTclustered	gi\|1651227316\|emb\|LR590664.1\|	2173	g11975	i0	94.602	101.953551912568	352	10	96	2	15	366	889	1231	Methanobrevibacter smithii partial 16S rRNA gene, strain C2 CSUR P5816	blastn	37315	553	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
1260163	1260163	PRJNA946307_P_NODE_155721_length_163_cov_2.508772_g154847_i0	PRJNA946307	155721	163	2.508772	4.08929836	Methanobrevibacter	2172	Archaea	Archaea	265	1.6e-66	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g154847	i0	98.658	8.20858895705521	149	2	91	0	15	163	1616217	1616365	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	1338	265	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
2535899	2535899	PRJNA946307_P_NODE_161102_length_162_cov_1.690265_g160228_i0	PRJNA946307	161102	162	1.690265	2.7382293	root	1	Root_unresolved	Root_unresolved	292	7.3e-75	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g160228	i0	100	99.5185185185185	158	0	98	0	4	161	1283319	1283162	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	16122	292	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
2536078	2536078	PRJNA946307_P_NODE_23422_length_265_cov_3.365741_g22548_i0	PRJNA946307	23422	265	3.365741	8.91921365	Methanobrevibacter	2172	Archaea	Archaea	363	9.849999999999999e-96	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g22548	i0	90.672	90.6943396226415	268	12	96	3	11	265	265066	265333	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	24034	363	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
5089016	5089016	PRJNA946307_P_NODE_55864_length_210_cov_2.875776_g54990_i0	PRJNA946307	55864	210	2.875776	6.0391296	root	1	Root_unresolved	Root_unresolved	315	2.13e-81	NTclustered	gi\|1721134173\|emb\|LR698975.1\|	2317	g54990	i0	93.878	97.1095238095238	196	12	93	0	15	210	409648	409843	Methanosphaera stadtmanae isolate MGYG-HGUT-02164 genome assembly, chromosome: 1	blastn	20393	315	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera stadtmanae
8912791	8912791	PRJNA946307_P_NODE_137907_length_168_cov_0.873950_g137033_i0	PRJNA946307	137907	168	0.87395	1.468236	Methanobrevibacter	2172	Archaea	Archaea	285	1.28e-72	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g137033	i0	99.363	100.196428571429	157	1	93	0	12	168	1286445	1286601	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	16833	285	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
11130682	11130682	PRJNA946307_P_NODE_29649_length_238_cov_4.555556_g28775_i0	PRJNA946307	29649	238	4.555556	10.84222328	Methanobrevibacter smithii	2173	Archaea	Archaea	414	2.37e-111	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g28775	i0	100	26.4117647058824	224	0	94	0	15	238	265509	265732	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	6286	414	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
15287775	15287775	PRJNA946307_P_NODE_117152_length_176_cov_2.787402_g116278_i0	PRJNA946307	117152	176	2.787402	4.90582752	Methanobacterium	2160	Archaea	Archaea	268	1.3499999999999999e-67	NTclustered	gi\|584298059\|gb\|KF881998.1\|	2161	g116278	i0	96.875	105.471590909091	160	5	91	0	3	162	910	751	Methanobacterium bryantii strain M.o.H. 23S ribosomal RNA gene, partial sequence	blastn	18563	268	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium bryantii
19111160	19111160	PRJNA946307_P_NODE_11155_length_399_cov_4.357143_g10295_i0	PRJNA946307	11155	399	4.357143	17.38500057	Methanobrevibacter	2172	Archaea	Archaea	555	2.3899999999999995e-153	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g10295	i0	93.734	79.1779448621554	383	2	96	3	15	397	262046	262406	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	31592	555	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
20387215	20387215	PRJNA946307_P_NODE_80296_length_193_cov_5.576389_g79422_i0	PRJNA946307	80296	193	5.576389	10.76243077	Methanobrevibacter	2172	Archaea	Archaea	327	2.47e-85	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g79422	i0	99.444	88.0310880829015	180	1	93	0	4	183	1286838	1286659	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	16990	327	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
21662824	21662824	PRJNA946307_P_NODE_33697_length_226_cov_2.305085_g32823_i0	PRJNA946307	33697	226	2.305085	5.2094921	root	1	Root_unresolved	Root_unresolved	388	1.3499999999999998e-103	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g32823	i0	98.636	163.615044247788	220	1	96	2	5	222	1286945	1287164	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	36977	388	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
22937762	22937762	PRJNA946307_P_NODE_138538_length_167_cov_6.872881_g137664_i0	PRJNA946307	138538	167	6.872881	11.47771127	root	1	Root_unresolved	Root_unresolved	276	7.64e-70	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g137664	i0	99.342	83.8263473053892	152	1	91	0	2	153	1287329	1287178	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	13999	276	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
23878671	23878671	PRJNA946307_P_NODE_132439_length_170_cov_1.074380_g131565_i0	PRJNA946307	132439	170	1.07438	1.826446	Methanobrevibacter smithii	2173	Archaea	Archaea	289	9.949999999999999e-74	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g131565	i0	100	18.9235294117647	156	0	92	0	1	156	264331	264176	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	3217	289	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
24211545	24211545	PRJNA946307_P_NODE_127339_length_172_cov_1.569106_g126465_i0	PRJNA946307	127339	172	1.569106	2.69886232	Methanobacterium	2160	Archaea	Archaea	215	1.74e-51	NTclustered	gi\|584298061\|gb\|KF882000.1\|	483896	g126465	i0	91.195	104.912790697674	159	13	92	1	14	172	514	671	Methanobacterium kanagiense strain 169 23S ribosomal RNA gene, partial sequence	blastn	18045	217	0.990783410138249	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium kanagiense
25154030	25154030	PRJNA946307_P_NODE_78040_length_195_cov_4.678082_g77166_i0	PRJNA946307	78040	195	4.678082	9.1222599	Methanobacterium petrolearium	710190	Archaea	Archaea	135	1.6300000000000002e-27	NTclustered	gi\|2465759960\|dbj\|AP027739.1\|	710190	g77166	i0	91.753	0.497435897435897	97	8	50	0	1	97	1582009	1582105	Methanobacterium petrolearium NBRC 105198 DNA, complete genome	blastn	97	135	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium petrolearium
25487135	25487135	PRJNA946307_P_NODE_36740_length_218_cov_3.295858_g35866_i0	PRJNA946307	36740	218	3.295858	7.18497044	Methanobrevibacter	2172	Archaea	Archaea	372	1.3e-98	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g35866	i0	99.034	143.344036697248	207	2	95	0	1	207	1285962	1285756	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	31249	372	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii

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