metadata: contig_metadata: 23 rows where bioproject = "PRJNA814235" and tax

23 rows where bioproject = "PRJNA814235" 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
8469907	8469907	PRJNA814235_P_NODE_191627_length_151_cov_2.877193_g190232_i0	PRJNA814235	191627	151	2.877193	4.34456143	Methanobacterium paludis	868131	Archaea	Archaea	102	1.21e-17	NTclustered	gi\|333824386\|gb\|CP002772.1\|	868131	g190232	i0	89.873	0.52317880794702	79	8	52	0	1	79	1107292	1107214	Methanobacterium paludis strain SWAN1, complete genome	blastn	79	102	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium paludis
9744970	9744970	PRJNA814235_P_NODE_189908_length_151_cov_3.052632_g188513_i0	PRJNA814235	189908	151	3.052632	4.60947432	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	110	7.21e-20	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g188513	i0	94.366	0.470198675496689	71	4	47	0	81	151	1349112	1349042	Methanobrevibacter sp. YE315, complete genome	blastn	71	110	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
11020198	11020198	PRJNA814235_P_NODE_163289_length_164_cov_1.220472_g161894_i0	PRJNA814235	163289	164	1.220472	2.00157408	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	270	3.4699999999999992e-68	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g161894	i0	96.341	34.1219512195122	164	6	100	0	1	164	496241	496078	Methanobrevibacter sp. YE315, complete genome	blastn	5596	270	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
13570625	13570625	PRJNA814235_P_NODE_193531_length_151_cov_2.666667_g192136_i0	PRJNA814235	193531	151	2.666667	4.02666717	Methanobacterium	2160	Archaea	Archaea	74.3	7.74e-14	NR	MCC7563364.1	2164	g192136	i0	52.7	31.4105960264901	93	1	99.3	1	1	150	625	717	MCC7563364.1 endopeptidase La [Methanobacterium sp.]	diamond	4743	74.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
16117680	16117680	PRJNA814235_P_NODE_103713_length_203_cov_2.283133_g102318_i0	PRJNA814235	103713	203	2.283133	4.63475999	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	97.1	8.06e-16	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g102318	i0	95.082	0.300492610837438	61	3	30	0	8	68	485328	485268	Methanobrevibacter sp. YE315, complete genome	blastn	61	97.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
26737437	26737437	PRJNA814235_P_NODE_191961_length_151_cov_2.850877_g190566_i0	PRJNA814235	191961	151	2.850877	4.30482427	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	63.2	6.36e-10	NR	WP_295609577.1	253161	g190566	i0	48.1	3.05960264900662	77	12	97.4	1	149	3	939	1015	WP_295609577.1 right-handed parallel beta-helix repeat-containing protein [uncultured Methanobrevibacter sp.]	diamond	462	63.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
27307468	27307468	PRJNA814235_P_NODE_95403_length_203_cov_2.728916_g94008_i0	PRJNA814235	95403	203	2.728916	5.53969948	Methanobrevibacter sp.	66852	Archaea	Archaea	90.5	5.32e-20	NR	MEE1156966.1	66852	g94008	i0	71.6	0.990147783251232	67	17	99	1	202	2	32	96	MEE1156966.1 aldo/keto reductase [Methanobrevibacter sp.]	diamond	201	90.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27906988	27906988	PRJNA814235_P_NODE_197485_length_150_cov_3.920354_g196090_i0	PRJNA814235	197485	150	3.920354	5.880531	Methanobrevibacter ruminantium	83816	Archaea	Archaea	78.2	1.34e-17	NR	WP_304163529.1	83816	g196090	i0	84.3	1.02	51	6	98	1	150	4	3	53	WP_304163529.1 hypothetical protein [Methanobrevibacter ruminantium]	diamond	153	78.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
27938936	27938936	PRJNA814235_P_NODE_201625_length_150_cov_2.504425_g200230_i0	PRJNA814235	201625	150	2.504425	3.7566375	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	64.3	2.59e-10	NR	WP_295608119.1	253161	g200230	i0	37.9	2.64	132	0	100	1	1	150	208	339	WP_295608119.1 B12-binding domain-containing radical SAM protein [uncultured Methanobrevibacter sp.]	diamond	396	64.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
28610612	28610612	PRJNA814235_P_NODE_199647_length_150_cov_3.097345_g198252_i0	PRJNA814235	199647	150	3.097345	4.6460175	Methanobrevibacter	2172	Archaea	Archaea	47.4	2.31e-5	NR	MBQ2637242.1	66852	g198252	i0	80	1	25	5	50	0	75	1	40	64	MBQ2637242.1 hypothetical protein [Methanobrevibacter sp.]	diamond	150	47.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28854287	28854287	PRJNA814235_P_NODE_186468_length_151_cov_3.578947_g185073_i0	PRJNA814235	186468	151	3.578947	5.40420997	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	93.2	1.8e-20	NR	WP_296894188.1	253161	g185073	i0	65.8	1.50993377483444	76	0	99.3	1	2	151	34	109	WP_296894188.1 TIR domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	228	93.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29044039	29044039	PRJNA814235_P_NODE_122728_length_202_cov_2.448485_g121333_i0	PRJNA814235	122728	202	2.448485	4.9459397	Methanobrevibacter sp.	66852	Archaea	Archaea	55.1	1.64e-7	NR	WP_406536969.1	66852	g121333	i0	96	1.11386138613861	25	1	37.1	0	75	1	97	121	WP_406536969.1 cell wall-binding repeat-containing protein [Methanobrevibacter sp.]	diamond	225	55.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29485695	29485695	PRJNA814235_P_NODE_188050_length_151_cov_3.307018_g186655_i0	PRJNA814235	188050	151	3.307018	4.99359718	Methanobacterium sp.	2164	Archaea	Archaea	74.7	5.4e-14	NR	TMS43369.1	2164	g186655	i0	67.2	3.63576158940397	61	7	95.4	1	6	149	84	144	TMS43369.1 MAG: hypothetical protein FGO69_00845 [Methanobacterium sp.]	diamond	549	74.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
29485703	29485703	PRJNA814235_P_NODE_196830_length_150_cov_4.407080_g195435_i0	PRJNA814235	196830	150	4.40708	6.61062	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	48.9	6.79e-5	NR	WP_298534579.1	253161	g195435	i0	96	0.5	25	1	50	0	3	77	402	426	WP_298534579.1 MATE family efflux transporter [uncultured Methanobrevibacter sp.]	diamond	75	48.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29738320	29738320	PRJNA814235_P_NODE_91490_length_203_cov_3.138554_g90095_i0	PRJNA814235	91490	203	3.138554	6.37126462	Methanobrevibacter sp.	66852	Archaea	Archaea	80.1	6.41e-16	NR	WP_405275890.1	66852	g90095	i0	58.2	1.98029556650246	67	19	99	1	3	203	121	178	WP_405275890.1 aldo/keto reductase [Methanobrevibacter sp.]	diamond	402	80.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29928226	29928226	PRJNA814235_P_NODE_189331_length_151_cov_3.122807_g187936_i0	PRJNA814235	189331	151	3.122807	4.71543857	Methanobrevibacter sp.	66852	Archaea	Archaea	52	1.97e-6	NR	WP_407462509.1	66852	g187936	i0	96.3	1.0728476821192101	27	1	53.6	0	82	2	30	56	WP_407462509.1 threonyl-tRNA synthetase editing domain-containing protein, partial [Methanobrevibacter sp.]	diamond	162	52	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31326976	31326976	PRJNA814235_P_NODE_116755_length_203_cov_1.885542_g115360_i0	PRJNA814235	116755	203	1.885542	3.82765026	Methanobrevibacter	2172	Archaea	Archaea	55.1	8.11e-7	NR	WP_407461363.1	66852	g115360	i0	100	1.10837438423645	25	0	36.9	0	75	1	237	261	WP_407461363.1 hypothetical protein [Methanobrevibacter sp.]	diamond	225	55.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31381707	31381707	PRJNA814235_P_NODE_113796_length_203_cov_1.969880_g112401_i0	PRJNA814235	113796	203	1.96988	3.9988564	Methanobrevibacter sp.	66852	Archaea	Archaea	51.2	2.21e-5	NR	MDO5826936.1	66852	g112401	i0	92	0.738916256157635	25	2	36.9	0	202	128	431	455	MDO5826936.1 undecaprenyl-phosphate glucose phosphotransferase [Methanobrevibacter sp.]	diamond	150	51.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31381781	31381781	PRJNA814235_P_NODE_90936_length_203_cov_3.234940_g89541_i0	PRJNA814235	90936	203	3.23494	6.5669282	Methanobrevibacter sp.	66852	Archaea	Archaea	47.4	4.98e-4	NR	WP_296855693.1	66852	g89541	i0	92	0.724137931034483	25	2	36.9	0	203	129	307	331	WP_296855693.1 L-sulfolactate dehydrogenase [Methanobrevibacter sp.]	diamond	147	47.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32077573	32077573	PRJNA814235_P_NODE_97718_length_203_cov_2.566265_g96323_i0	PRJNA814235	97718	203	2.566265	5.20951795	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	52	1.57e-6	NR	WP_298533847.1	253161	g96323	i0	100	0.354679802955665	24	0	35.5	0	131	202	73	96	WP_298533847.1 hypothetical protein [uncultured Methanobrevibacter sp.]	diamond	72	52	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32118000	32118000	PRJNA814235_P_NODE_98858_length_203_cov_2.506024_g97463_i0	PRJNA814235	98858	203	2.506024	5.08722872	Methanobrevibacter	2172	Archaea	Archaea	45.1	0.00342	NR	MER2014381.1	66852	g97463	i0	88	1.10837438423645	25	3	36.9	0	75	1	993	1017	MER2014381.1 C1 family peptidase [Methanobrevibacter sp.]	diamond	225	45.4	0.993392070484582	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32244780	32244780	PRJNA814235_P_NODE_89318_length_203_cov_3.590361_g87923_i0	PRJNA814235	89318	203	3.590361	7.28843283	Methanobrevibacter	2172	Archaea	Archaea	53.1	4.77e-6	NR	WP_292821724.1	66852	g87923	i0	100	9.97536945812808	25	0	36.9	0	202	128	1383	1407	WP_292821724.1 non-ribosomal peptide synthetase [Methanobrevibacter sp.]	diamond	2025	53.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32330958	32330958	PRJNA814235_P_NODE_108739_length_203_cov_2.102410_g107344_i0	PRJNA814235	108739	203	2.10241	4.2678923	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	45.1	0.00335	NR	WP_296884148.1	253161	g107344	i0	81.8	0.32512315270936	22	4	32.5	0	200	135	1	22	WP_296884148.1 hypothetical protein, partial [uncultured Methanobrevibacter sp.]	diamond	66	45.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.

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