metadata: contig_metadata: 17 rows where bioproject = "PRJNA1180292" and tax

17 rows where bioproject = "PRJNA1180292" and tax_clade = "Stenosarchaea 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
6144071	6144071	PRJNA1180292_P_NODE_10865_length_247_cov_0.896552_g10733_i0	PRJNA1180292	10865	247	0.896552	2.21448344	Methanomicrobiales archaeon	2184052	Archaea	Archaea	99.4	1.22e-22	NR	MDD1652628.1	2184052	g10733	i0	94.3	0.643724696356275	53	3	64.4	0	159	1	187	239	MDD1652628.1 ABC transporter ATP-binding protein [Methanomicrobiales archaeon]	diamond	159	99.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
7971056	7971056	PRJNA1180292_P_NODE_10107_length_248_cov_0.891429_g9975_i0	PRJNA1180292	10107	248	0.891429	2.21074392	Methanolobus sediminis	3072978	Archaea	Archaea	353	5.49e-93	NTclustered	gi\|2575181144\|gb\|CP133592.1\|	3072978	g9975	i0	92.653	0.987903225806452	245	18	99	0	1	245	1669867	1670111	Methanolobus sediminis strain FTZ6 chromosome, complete genome	blastn	245	353	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus sediminis
15620600	15620600	PRJNA1180292_P_NODE_10693_length_247_cov_0.896552_g10561_i0	PRJNA1180292	10693	247	0.896552	2.21448344	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	106	4.57e-25	NR	HWR96992.1	2032688	g10561	i0	58.5	0.995951417004049	82	34	99.6	0	1	246	279	360	HWR96992.1 hypothetical protein [Candidatus Methanoperedens sp.]	diamond	246	106	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
15620610	15620610	PRJNA1180292_P_NODE_11693_length_245_cov_0.906977_g11561_i0	PRJNA1180292	11693	245	0.906977	2.22209365	Methanoregula sp.	2052170	Archaea	Archaea	187	5.809999999999998e-43	NTclustered	gi\|2381065543\|gb\|CP112999.1\|	2052170	g11561	i0	82.273	0.897959183673469	220	35	89	2	28	245	1234947	1235164	MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome	blastn	220	187	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
26597094	26597094	PRJNA1180292_P_NODE_11681_length_245_cov_0.906977_g11549_i0	PRJNA1180292	11681	245	0.906977	2.22209365	Methanoregulaceae archaeon	2485498	Archaea	Archaea	102	2.2899999999999998e-23	NR	MBP7716362.1	2485498	g11549	i0	85.2	2.24081632653061	61	9	74.7	0	62	244	1	61	MBP7716362.1 aspartate kinase [Methanoregulaceae archaeon]	diamond	549	102	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
26755493	26755493	PRJNA1180292_P_NODE_12921_length_242_cov_0.923077_g12789_i0	PRJNA1180292	12921	242	0.923077	2.23384634	Methanothrix sp.	90426	Archaea	Archaea	147	7.889999999999998e-42	NR	NTV76868.1	90426	g12789	i0	95	3.96694214876033	80	4	99.2	0	1	240	105	184	NTV76868.1 bifunctional ornithine acetyltransferase/N-acetylglutamate synthase [Methanothrix sp.]	diamond	960	147	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
27230206	27230206	PRJNA1180292_P_NODE_9723_length_249_cov_0.886364_g9591_i0	PRJNA1180292	9723	249	0.886364	2.20704636	Methanoregula sp.	2052170	Archaea	Archaea	166	1.48e-46	NR	MCX6684757.1	2052170	g9591	i0	96.3	2.96385542168675	82	3	98.8	0	248	3	463	544	MCX6684757.1 beta-CASP ribonuclease aCPSF1 [Methanoregula sp.]	diamond	738	166	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
27767400	27767400	PRJNA1180292_P_NODE_10124_length_248_cov_0.891429_g9992_i0	PRJNA1180292	10124	248	0.891429	2.21074392	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	84	1.03e-16	NR	HWR98730.1	2032688	g9992	i0	81.5	0.653225806451613	54	10	65.3	0	164	3	1	54	HWR98730.1 hypothetical protein [Candidatus Methanoperedens sp.]	diamond	162	84	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
27798927	27798927	PRJNA1180292_P_NODE_7884_length_253_cov_0.866667_g7752_i0	PRJNA1180292	7884	253	0.866667	2.19266751	Methanothrix sp.	90426	Archaea	Archaea	128	2e-34	NR	MDD1741511.1	90426	g7752	i0	90.5	3.72332015810277	74	7	87.7	0	224	3	1	74	MDD1741511.1 ABC transporter permease [Methanothrix sp.]	diamond	942	128	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28398650	28398650	PRJNA1180292_P_NODE_8506_length_252_cov_0.871508_g8374_i0	PRJNA1180292	8506	252	0.871508	2.19620016	Methanothrix sp.	90426	Archaea	Archaea	151	2.31e-42	NR	MDM7940585.1	90426	g8374	i0	94	0.988095238095238	83	5	98.8	0	251	3	126	208	MDM7940585.1 cysteine desulfurase family protein [Methanothrix sp.]	diamond	249	151	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28796473	28796473	PRJNA1180292_P_NODE_12147_length_244_cov_0.912281_g12015_i0	PRJNA1180292	12147	244	0.912281	2.22596564	Methanothrix	2222	Archaea	Archaea	150	3.5199999999999998e-43	NR	MCK9566064.1	90426	g12015	i0	87.7	10.9549180327869	81	10	99.6	0	244	2	118	198	MCK9566064.1 MTAP family purine nucleoside phosphorylase [Methanothrix sp.]	diamond	2673	150	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28840595	28840595	PRJNA1180292_P_NODE_10348_length_248_cov_0.891429_g10216_i0	PRJNA1180292	10348	248	0.891429	2.21074392	Methanomicrobiales archaeon	2184052	Archaea	Archaea	90.5	3.64e-19	NR	MDD1670830.1	2184052	g10216	i0	66.7	1.82661290322581	75	25	90.7	0	239	15	213	287	MDD1670830.1 threonine ammonia-lyase [Methanomicrobiales archaeon]	diamond	453	90.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
30186044	30186044	PRJNA1180292_P_NODE_10532_length_247_cov_0.896552_g10400_i0	PRJNA1180292	10532	247	0.896552	2.21448344	Archaea	2157	Archaea	Archaea	119	1.4e-31	NR	OPX66778.1	1811720	g10400	i0	66.7	4.89473684210526	81	27	98.4	0	247	5	115	195	OPX66778.1 MAG: hypothetical protein A4E36_01865 [Methanoregulaceae archaeon PtaB.Bin009]	diamond	1209	120	0.991666666666667	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon PtaB.Bin009
31671533	31671533	PRJNA1180292_P_NODE_12857_length_242_cov_0.923077_g12725_i0	PRJNA1180292	12857	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	105	1.12e-24	NR	WP_343089241.1	1262400	g12725	i0	69.2	4.89669421487603	78	24	96.7	0	234	1	206	283	WP_343089241.1 DNA polymerase [Methanocalculus natronophilus]	diamond	1185	105	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocalculaceae	Methanocalculus	Methanocalculus natronophilus
32095332	32095332	PRJNA1180292_P_NODE_10138_length_248_cov_0.891429_g10006_i0	PRJNA1180292	10138	248	0.891429	2.21074392	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	158	1.0599999999999999e-42	NR	HWR98489.1	2032688	g10006	i0	92.7	0.991935483870968	82	6	99.2	0	2	247	652	733	HWR98489.1 ATP-binding protein [Candidatus Methanoperedens sp.]	diamond	246	158	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
32651731	32651731	PRJNA1180292_P_NODE_7860_length_253_cov_0.866667_g7728_i0	PRJNA1180292	7860	253	0.866667	2.19266751	Methanobacteriati	3366610	Archaea	Archaea	98.6	4.73e-22	NR	RLG29126.1	2250255	g7728	i0	59.8	5.85770750988142	82	32	97.2	1	3	248	287	367	RLG29126.1 MAG: hypothetical protein DRN98_08700 [Methanosarcinales archaeon]	diamond	1482	98.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32651732	32651732	PRJNA1180292_P_NODE_8100_length_253_cov_0.866667_g7968_i0	PRJNA1180292	8100	253	0.866667	2.19266751	root	1	Root_unresolved	Root_unresolved	150	7.149999999999998e-42	NR	WP_048159054.1	1434103	g7968	i0	81	7.89723320158103	84	16	99.6	0	1	252	154	237	WP_048159054.1 dTDP-4-amino-4,6-dideoxygalactose transaminase [Methanosarcina sp. WWM596]	diamond	1998	150	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp. WWM596

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