metadata: contig_metadata: 5 rows where bioproject = "PRJNA795983" and tax

5 rows where bioproject = "PRJNA795983" and tax_kingdom = "Thermoproteati"

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
5883479	5883479	PRJNA795983_S_NODE_10085_length_387_cov_2.515924_g9960_i0	PRJNA795983	10085	387	2.515924	9.73662588	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	181	5.7e-50	NR	MEM2110256.1	3045160	g9960	i0	68	1.98449612403101	128	41	99.2	0	386	3	632	759	MEM2110256.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Candidatus Bathyarchaeia archaeon]	diamond	768	181	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
22894103	22894103	PRJNA795983_S_NODE_16338_length_328_cov_1.760784_g16213_i0	PRJNA795983	16338	328	1.760784	5.77537152	Nitrososphaeria	1643678	Archaea	Archaea	139	2.3e-36	NR	WP_337863902.1	1971748	g16213	i0	62.3	6.79573170731707	106	40	97	0	322	5	7	112	WP_337863902.1 IMP dehydrogenase [Nitrososphaera sp.]	diamond	2229	140	0.992857142857143	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
27884221	27884221	PRJNA795983_S_NODE_41065_length_243_cov_1.805882_g40940_i0	PRJNA795983	41065	243	1.805882	4.38829326	Archaea	2157	Archaea	Archaea	48.5	2.32e-4	NR	HIE19324.1	2026714	g40940	i0	40.7	2.08641975308642	59	34	71.6	1	237	64	147	205	HIE19324.1 ribosome assembly factor SBDS [Candidatus Bathyarchaeota archaeon]	diamond	507	48.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30938644	30938644	PRJNA795983_S_NODE_22994_length_293_cov_2.709091_g22869_i0	PRJNA795983	22994	293	2.709091	7.93763663	Infirmifilum sp.	2856575	Archaea	Archaea	43.1	0.0472	NR	MEZ0346000.1	2856575	g22869	i0	42.5	0.409556313993174	40	18	41	1	184	65	27	61	MEZ0346000.1 hypothetical protein [Infirmifilum sp.]	diamond	120	43.1	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Infirmifilum	Infirmifilum sp.
32866430	32866430	PRJNA795983_S_NODE_37140_length_249_cov_0.875000_g37015_i0	PRJNA795983	37140	249	0.875	2.17875	Candidatus Caldarchaeum sp.	2972665	Archaea	Archaea	73.9	3.56e-13	NR	MEM2832785.1	2972665	g37015	i0	52.4	1.01204819277108	84	34	98.8	4	246	1	1	80	MEM2832785.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Candidatus Caldarchaeum sp.]	diamond	252	73.9	1	Archaea	Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum 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);;