metadata: contig_metadata: 10 rows where bioproject = "PRJNA857857" and tax

10 rows where bioproject = "PRJNA857857" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2120398	2120398	PRJNA857857_P_NODE_30802_length_278_cov_1.126829_g30353_i0	PRJNA857857	30802	278	1.126829	3.13258462	Pyrobaculum islandicum	2277	Archaea	Archaea	54.7	0.007	NTclustered	gi\|119672928\|gb\|CP000504.1\|	384616	g30353	i0	100	0.10431654676259	29	0	10	0	183	211	217334	217362	Pyrobaculum islandicum DSM 4184, complete genome	blastn	29	54.7	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum islandicum
5948394	5948394	PRJNA857857_P_NODE_34705_length_259_cov_1.107527_g34256_i0	PRJNA857857	34705	259	1.107527	2.86849493	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	171	4.91e-49	NR	HET6457955.1	2202732	g34256	i0	92.9	0.984555984555985	85	6	98.5	0	3	257	268	352	HET6457955.1 reverse transcriptase family protein [Nitrosopumilaceae archaeon]	diamond	255	171	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
5948764	5948764	PRJNA857857_P_NODE_51545_length_241_cov_0.916667_g51096_i0	PRJNA857857	51545	241	0.916667	2.20916747	Nitrososphaerota archaeon	2026795	Archaea	Archaea	88.6	2.61e-18	NR	TLX94279.1	2026795	g51096	i0	71.2	1.46887966804979	59	17	73.4	0	179	3	229	287	TLX94279.1 MAG: DDE-type integrase/transposase/recombinase, partial [Nitrososphaerota archaeon]	diamond	354	88.6	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
14872897	14872897	PRJNA857857_P_NODE_25312_length_309_cov_1.381356_g24863_i0	PRJNA857857	25312	309	1.381356	4.26839004	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	167	3.0399999999999995e-47	NR	HET6457955.1	2202732	g24863	i0	76.3	0.941747572815534	97	23	94.2	0	291	1	1	97	HET6457955.1 reverse transcriptase family protein [Nitrosopumilaceae archaeon]	diamond	291	167	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
26873719	26873719	PRJNA857857_P_NODE_41861_length_248_cov_0.880000_g41412_i0	PRJNA857857	41861	248	0.88	2.1824	Thermoproteati	1783275	Archaea	Archaea	143	8.33e-42	NR	HEY7506666.1	1971748	g41412	i0	87.8	5.95161290322581	82	10	99.2	0	248	3	21	102	HEY7506666.1 glycosyl transferase [Nitrososphaera sp.]	diamond	1476	143	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
27497553	27497553	PRJNA857857_P_NODE_31223_length_276_cov_1.123153_g30774_i0	PRJNA857857	31223	276	1.123153	3.09990228	Nitrososphaerota archaeon	2026795	Archaea	Archaea	95.5	1.24e-20	NR	TLX65607.1	2026795	g30774	i0	57.9	1.03260869565217	95	35	100	3	1	276	86	178	TLX65607.1 MAG: hypothetical protein E6L02_08070, partial [Nitrososphaerota archaeon]	diamond	285	95.5	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28034377	28034377	PRJNA857857_P_NODE_39905_length_249_cov_0.875000_g39456_i0	PRJNA857857	39905	249	0.875	2.17875	Nitrososphaerota archaeon	2026795	Archaea	Archaea	132	1.6100000000000002e-33	NR	TLX94279.1	2026795	g39456	i0	78.5	0.951807228915663	79	17	95.2	0	12	248	876	954	TLX94279.1 MAG: DDE-type integrase/transposase/recombinase, partial [Nitrososphaerota archaeon]	diamond	237	132	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
29392014	29392014	PRJNA857857_P_NODE_37509_length_251_cov_0.865169_g37060_i0	PRJNA857857	37509	251	0.865169	2.17157419	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	133	4.3499999999999997e-38	NR	NIR87746.1	2026714	g37060	i0	87	0.920318725099602	77	10	92	0	21	251	2	78	NIR87746.1 hypothetical protein [Candidatus Bathyarchaeota archaeon]	diamond	231	133	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30781748	30781748	PRJNA857857_P_NODE_12514_length_445_cov_1.241935_g12070_i0	PRJNA857857	12514	445	1.241935	5.52661075	Candidatus Marsarchaeota G1 archaeon BE_D	1978156	Archaea	Archaea	83.2	1.36e-15	NR	PSN85220.1	1978156	g12070	i0	44.6	0.620224719101124	92	49	60.7	1	9	278	272	363	PSN85220.1 MAG: hypothetical protein B9Q02_07200 [Candidatus Marsarchaeota G1 archaeon BE_D]	diamond	276	83.2	1	Archaea	Candidatus Marsarchaeota group 1	Thermoproteati	Candidatus Marsarchaeota					Candidatus Marsarchaeota G1 archaeon BE_D
32426319	32426319	PRJNA857857_P_NODE_27099_length_298_cov_1.026667_g26650_i0	PRJNA857857	27099	298	1.026667	3.05946766	Candidatus Calditenuaceae archaeon	3079264	Archaea	Archaea	62.8	6.42e-9	NR	MCS7145754.1	3079264	g26650	i0	40.6	0.694630872483222	69	38	66.4	1	233	36	5	73	MCS7145754.1 glycoside hydrolase family 78 protein [Candidatus Calditenuaceae archaeon]	diamond	207	62.8	1	Archaea		Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Calditenuaceae		Candidatus Calditenuaceae archaeon

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