metadata: contig_metadata: 5 rows where bioproject = "PRJNA195897", tax_kingdom = "Thermoproteati" and tax

5 rows where bioproject = "PRJNA195897", tax_kingdom = "Thermoproteati" 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
366013	366013	PRJNA195897_P_NODE_6621_length_192_cov_1.454545_g6588_i0	PRJNA195897	6621	192	1.454545	2.7927264	Caldisphaera lagunensis	200415	Archaea	Archaea	54.7	0.005	NTclustered	gi\|429132784\|gb\|CP003378.1\|	1056495	g6588	i0	100	0.151041666666667	29	0	15	0	130	158	286103	286131	Caldisphaera lagunensis DSM 15908, complete genome	blastn	29	54.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Acidilobales	Caldisphaeraceae	Caldisphaera	Caldisphaera lagunensis
11844533	11844533	PRJNA195897_P_NODE_3110_length_278_cov_2.768559_g3077_i0	PRJNA195897	3110	278	2.768559	7.69659402	Candidatus Caldarchaeum subterraneum	311458	Archaea	Archaea	56.5	0.002	NTclustered	gi\|315425078\|dbj\|AP011708.1\|	311458	g3077	i0	100	0.41726618705036	30	0	11	0	6	35	41457	41486	Candidatus Caldiarchaeum subterraneum DNA, fosmid clone: JFF022_F09	blastn	116	56.5	1	Archaea	Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum subterraneum
27579415	27579415	PRJNA195897_P_NODE_1904_length_374_cov_1.483077_g1871_i0	PRJNA195897	1904	374	1.483077	5.54670798	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	71.2	1.79e-11	NR	TMI42530.1	2026714	g1871	i0	34.9	1.01069518716578	126	76	97.9	4	1	366	1165	1288	TMI42530.1 MAG: hypothetical protein E6H21_00250 [Candidatus Bathyarchaeota archaeon]	diamond	378	71.2	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
29820989	29820989	PRJNA195897_P_NODE_6811_length_190_cov_1.106383_g6778_i0	PRJNA195897	6811	190	1.106383	2.1021277	Nitrosopumilus sp.	2024843	Archaea	Archaea	62	2.96e-9	NR	MBA4717734.1	2024843	g6778	i0	65.2	1.46842105263158	46	16	72.6	0	186	49	34	79	MBA4717734.1 SBBP repeat-containing protein [Nitrosopumilus sp.]	diamond	279	62	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
30800528	30800528	PRJNA195897_P_NODE_5434_length_208_cov_1.100629_g5401_i0	PRJNA195897	5434	208	1.100629	2.28930832	Nitrososphaerales archaeon	2268197	Archaea	Archaea	65.9	1.65e-10	NR	HVB11633.1	2268197	g5401	i0	50.7	3.85096153846154	67	26	96.6	1	8	208	79	138	HVB11633.1 IMP dehydrogenase [Nitrososphaerales archaeon]	diamond	801	65.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales 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);;