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

9 rows where bioproject = "PRJNA669701" 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
1912250	1912250	PRJNA669701_P_NODE_66502_length_303_cov_1.004348_g66107_i0	PRJNA669701	66502	303	1.004348	3.04317444	Halorussus caseinilyticus	3034025	Archaea	Archaea	63.9	1.3e-5	NTclustered	gi\|2463595563\|gb\|CP119809.1\|	3034025	g66107	i0	82.278	112.818481848185	79	9	24	3	24	97	2485099	2485021	Halorussus caseinilyticus strain DT72 chromosome, complete genome	blastn	34184	63.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus caseinilyticus
3186397	3186397	PRJNA669701_P_NODE_148183_length_224_cov_4.748344_g147788_i0	PRJNA669701	148183	224	4.748344	10.63629056	Halococcus dombrowskii	179637	Archaea	Archaea	202	1.87e-47	NTclustered	gi\|2221489803\|gb\|CP095005.1\|	179637	g147788	i0	83.258	1.76339285714286	221	35	98	2	5	224	824902	824683	Halococcus dombrowskii strain H4 chromosome, complete genome	blastn	395	202	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
4462848	4462848	PRJNA669701_P_NODE_107764_length_251_cov_0.865169_g107369_i0	PRJNA669701	107764	251	0.865169	2.17157419	Halogeometricum borinquense	60847	Archaea	Archaea	80.5	1.04e-10	NTclustered	gi\|312294075\|gb\|CP001691.1\|	469382	g107369	i0	80	0.47808764940239	120	14	45	7	138	251	11998	11883	Halogeometricum borinquense DSM 11551 plasmid pHBOR01, complete sequence	blastn	120	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halogeometricum	Halogeometricum borinquense
4462920	4462920	PRJNA669701_P_NODE_113384_length_249_cov_1.909091_g112989_i0	PRJNA669701	113384	249	1.909091	4.75363659	root	1	Root_unresolved	Root_unresolved	84.7	6.99e-17	NR	RYE85496.1	2250255	g112989	i0	53.2	6.62650602409639	79	34	95.2	1	1	237	127	202	RYE85496.1 MAG: hypothetical protein EOO65_00260 [Methanosarcinales archaeon]	diamond	1650	84.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
26986604	26986604	PRJNA669701_P_NODE_81682_length_280_cov_1.202899_g81287_i0	PRJNA669701	81682	280	1.202899	3.3681172	Halolamina pelagica	699431	Archaea	Archaea	43.1	0.0414	NR	KPN29342.1	699431	g81287	i0	47.4	1.01785714285714	95	38	94.3	4	2	265	111	200	KPN29342.1 hypothetical protein SY89_00055 [Halolamina pelagica]	diamond	285	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halolamina	Halolamina pelagica
27018330	27018330	PRJNA669701_P_NODE_111302_length_250_cov_0.870056_g110907_i0	PRJNA669701	111302	250	0.870056	2.17514	Methanomethylovorans sp.	2758717	Archaea	Archaea	166	1.07e-45	NR	MBC7085956.1	2758717	g110907	i0	100	0.996	83	0	99.6	0	1	249	244	326	MBC7085956.1 type II secretion system F family protein [Methanomethylovorans sp.]	diamond	249	166	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	Methanomethylovorans sp.
27144462	27144462	PRJNA669701_P_NODE_90802_length_269_cov_1.566327_g90407_i0	PRJNA669701	90802	269	1.566327	4.21341963	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	70.1	1.16e-11	NR	MCK4734193.1	2056316	g90407	i0	41.4	0.970260223048327	87	46	92.6	2	251	3	92	177	MCK4734193.1 hypothetical protein [Candidatus Methanophagales archaeon]	diamond	261	70.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales archaeon
29892301	29892301	PRJNA669701_P_NODE_7171_length_912_cov_4.983313_g6836_i0	PRJNA669701	7171	912	4.983313	45.44781456	Candidatus Methanophagaceae archaeon	3386247	Archaea	Archaea	79.7	1.41e-12	NR	KAF5437882.1	3386247	g6836	i0	27.5	1.86184210526316	273	165	87.2	13	20	814	222	469	KAF5437882.1 Kazal-type serine protease inhibitor domain-containing protein [Candidatus Methanophagaceae archaeon]	diamond	1698	79.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales	Candidatus Methanophagaceae		Candidatus Methanophagaceae archaeon
31313927	31313927	PRJNA669701_P_NODE_123075_length_246_cov_2.508671_g122680_i0	PRJNA669701	123075	246	2.508671	6.17133066	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	125	2.22e-33	NR	WP_332321601.1	1980530	g122680	i0	76.5	1.97560975609756	81	19	98.8	0	3	245	23	103	WP_332321601.1 hypothetical protein [Halodesulfurarchaeum sp.]	diamond	486	125	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum 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);;