metadata: contig_metadata: 5 rows where bioproject = "PRJNA816047", tax_phylum = "Thermoproteota" and tax

5 rows where bioproject = "PRJNA816047", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25908247	25908247	PRJNA816047d_S_NODE_53811_length_303_cov_11295.384000_g51976_i0	PRJNA816047	53811	303	11295.384	34225.01352	root	1	Root_unresolved	Root_unresolved	71.3	7.79e-8	NTclustered	gi\|969874815\|gb\|CP013695.1\|	2285	g51976	i0	100	110.471947194719	38	0	13	0	212	249	40	3	Sulfolobus acidocaldarius strain NG05B_CO5_07 chromosome	blastn	33473	71.3	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus acidocaldarius
32973714	32973714	PRJNA816047d_S_NODE_79954_length_263_cov_0.923810_g78119_i0	PRJNA816047	79954	263	0.92381	2.4296203	Candidatus Methanomethylicia archaeon	2268187	Archaea	Archaea	79	4.4e-17	NR	MEM4483218.1	2268187	g78119	i0	65	0.684410646387833	60	20	68.4	1	261	82	22	80	MEM4483218.1 hypothetical protein [Candidatus Methanomethylicia archaeon]	diamond	180	79	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia				Candidatus Methanomethylicia archaeon
33143188	33143188	PRJNA816047a_S_NODE_53031_length_290_cov_1.354839_g50371_i0	PRJNA816047	53031	290	1.354839	3.9290331	Candidatus Korarchaeum cryptofilum	498846	Archaea	Archaea	41.2	0.0492	NR	WP_012310218.1	498846	g50371	i0	42.9	0.43448275862069	42	24	43.4	0	122	247	3	44	WP_012310218.1 50S ribosomal protein L14e [Candidatus Korarchaeum cryptofilum]	diamond	126	41.2	1	Archaea	Thermoproteati	Thermoproteota	Candidatus Korarchaeia	Candidatus Korarchaeales	Candidatus Korarchaeaceae	Candidatus Korarchaeum	Candidatus Korarchaeum cryptofilum
33160973	33160973	PRJNA816047d_S_NODE_59616_length_292_cov_0.995816_g57781_i0	PRJNA816047	59616	292	0.995816	2.90778272	Candidatus Methanomethylicia archaeon	2268187	Archaea	Archaea	197	3.47e-59	NR	MEM4483221.1	2268187	g57781	i0	99	0.996575342465753	97	1	99.7	0	291	1	52	148	MEM4483221.1 hypothetical protein [Candidatus Methanomethylicia archaeon]	diamond	291	197	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia				Candidatus Methanomethylicia archaeon
33161047	33161047	PRJNA816047d_S_NODE_72192_length_271_cov_1.555046_g70357_i0	PRJNA816047	72192	271	1.555046	4.21417466	Ignisphaera sp.	2268142	Archaea	Archaea	74.3	1.9e-13	NR	MCI4437878.1	2268142	g70357	i0	45.8	0.797047970479705	72	37	79.7	1	55	270	15	84	MCI4437878.1 hypothetical protein [Ignisphaera sp.]	diamond	216	74.3	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera 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);;