metadata: contig_metadata: 9 rows where bioproject = "PRJNA515078" and tax

9 rows where bioproject = "PRJNA515078" and tax_kingdom = "Methanobacteriati"

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
12589897	12589897	PRJNA515078_P_NODE_25570_length_172_cov_1.155556_g25337_i0	PRJNA515078	25570	172	1.155556	1.98755632	Halobacteriales	2235	Archaea	Archaea	75	3.08e-9	NTclustered	gi\|2270268909\|gb\|CP100466.1\|	1702103	g25337	i0	87.692	5.75581395348837	65	6	37	2	19	82	229980	229917	Halomicrococcus gelatinilyticus strain GSLN9 plasmid unnamed1, complete sequence	blastn	990	75	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halomicrococcus	Halomicrococcus gelatinilyticus
26665412	26665412	PRJNA515078_P_NODE_19861_length_195_cov_1.075949_g19628_i0	PRJNA515078	19861	195	1.075949	2.09810055	Haloarchaeobius amylolyticus	1198296	Archaea	Archaea	45.8	0.00157	NR	WP_267639183.1	1198296	g19628	i0	53.8	0.6	39	18	60	0	178	62	340	378	WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus]	diamond	117	45.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Haloarchaeobius	Haloarchaeobius amylolyticus
26855916	26855916	PRJNA515078_P_NODE_32961_length_153_cov_1.344828_g32728_i0	PRJNA515078	32961	153	1.344828	2.05758684	Thermococcus sp. LS1	1638259	Archaea	Archaea	47	3.4e-4	NR	WP_167899884.1	1638259	g32728	i0	54.2	1.94117647058824	48	21	94.1	1	149	6	328	374	WP_167899884.1 serpin family protein [Thermococcus sp. LS1]	diamond	297	47	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. LS1
28703245	28703245	PRJNA515078_P_NODE_15427_length_223_cov_1.467742_g15194_i0	PRJNA515078	15427	223	1.467742	3.27306466	Methanoregula	395331	Archaea	Archaea	42.7	0.0297	NR	MCK9580549.1	2052170	g15194	i0	56.7	0.807174887892377	30	13	40.4	0	135	46	499	528	MCK9580549.1 WD40 repeat domain-containing protein [Methanoregula sp.]	diamond	180	43.1	0.990719257540603	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
28766227	28766227	PRJNA515078_P_NODE_19387_length_197_cov_1.462500_g19154_i0	PRJNA515078	19387	197	1.4625	2.881125	Archaea	2157	Archaea	Archaea	44.7	0.00422	NR	MDI9643305.1	2250258	g19154	i0	66.7	4.79695431472081	33	11	50.3	0	94	192	394	426	MDI9643305.1 protein kinase [Archaeoglobales archaeon]	diamond	945	44.7	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales			Archaeoglobales archaeon
28955971	28955971	PRJNA515078_P_NODE_23948_length_177_cov_1.764286_g23715_i0	PRJNA515078	23948	177	1.764286	3.12278622	Methanobacteriati	3366610	Archaea	Archaea	62.4	1.82e-9	NR	OIR20009.1	1889001	g23715	i0	50	1.64406779661017	48	24	81.4	0	31	174	5	52	OIR20009.1 MAG: hypothetical protein BEU04_04135 [Marine Group III euryarchaeote CG-Bathy1]	diamond	291	62.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Thermoprofundales			Marine Group III euryarchaeote CG-Bathy1
30014099	30014099	PRJNA515078_P_NODE_29031_length_162_cov_1.240000_g28798_i0	PRJNA515078	29031	162	1.24	2.0088	Halovivax gelatinilyticus	2961597	Archaea	Archaea	49.3	5.91e-5	NR	WP_254861485.1	2961597	g28798	i0	65	0.740740740740741	40	14	74.1	0	122	3	87	126	WP_254861485.1 serpin family protein [Halovivax gelatinilyticus]	diamond	120	49.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax gelatinilyticus
31341164	31341164	PRJNA515078_P_NODE_29116_length_162_cov_0.936000_g28883_i0	PRJNA515078	29116	162	0.936	1.51632	Methanobrevibacter sp.	66852	Archaea	Archaea	41.2	0.0434	NR	MER2013494.1	66852	g28883	i0	41.3	0.851851851851852	46	27	85.2	0	5	142	137	182	MER2013494.1 hypothetical protein [Methanobrevibacter sp.]	diamond	138	41.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32052436	32052436	PRJNA515078_P_NODE_9958_length_287_cov_1.544000_g9725_i0	PRJNA515078	9958	287	1.544	4.43128	root	1	Root_unresolved	Root_unresolved	81.6	8.52e-16	NR	EQB72821.1	667135	g9725	i0	60.3	19.4634146341463	68	24	71.1	1	204	1	3	67	EQB72821.1 MAG: hypothetical protein AMDU1_APLC00001G0001 [Thermoplasmatales archaeon A-plasma]	diamond	5586	82.4	0.990291262135922	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon A-plasma

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