metadata: contig_metadata: 16 rows where bioproject = "PRJNA415856" and tax

16 rows where bioproject = "PRJNA415856" 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
11286582	11286582	PRJNA415856_P_NODE_1169_length_910_cov_4.167247_g1003_i0	PRJNA415856	1169	910	4.167247	37.9219477	Nitrososphaera	497726	Archaea	Archaea	1123	0	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g1003	i0	89.207	52.810989010989	908	87	99	10	6	909	921	21	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	48058	1123	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
13173068	13173068	PRJNA415856_P_NODE_311_length_1522_cov_3.315682_g241_i0	PRJNA415856	311	1522	3.315682	50.46468004	uncultured crenarchaeote	29281	Archaea	Archaea	2206	0	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g241	i0	92.857	102.687253613666	1526	99	100	8	1	1522	6919	8438	Uncultured crenarchaeote 34 kb genomic fragment	blastn	156290	2206	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
18270862	18270862	PRJNA415856_P_NODE_23895_length_185_cov_2.397059_g23634_i0	PRJNA415856	23895	185	2.397059	4.43455915	Sulfolobaceae archaeon	2967306	Archaea	Archaea	103	6.3799999999999996e-24	NR	MEM0173168.1	2967306	g23634	i0	75	0.972972972972973	60	15	97.3	0	2	181	332	391	MEM0173168.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	180	103	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae		Sulfolobaceae archaeon
19545251	19545251	PRJNA415856_P_NODE_44476_length_164_cov_0.886957_g44215_i0	PRJNA415856	44476	164	0.886957	1.45460948	Archaea	2157	Archaea	Archaea	102	6.649999999999998e-24	NR	MBI3638791.1	2026795	g44215	i0	88.9	8.89024390243902	54	6	98.8	0	1	162	57	110	MBI3638791.1 4-hydroxyphenylacetate 3-hydroxylase family protein [Nitrososphaerota archaeon]	diamond	1458	102	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
21485364	21485364	PRJNA415856_P_NODE_9657_length_287_cov_2.310924_g9396_i0	PRJNA415856	9657	287	2.310924	6.63235188	Nitrososphaera	497726	Archaea	Archaea	479	1.0299999999999996e-130	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g9396	i0	97.5	42.3728222996516	280	7	98	0	6	285	921	642	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	12161	479	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
25309521	25309521	PRJNA415856_P_NODE_17720_length_207_cov_1.094937_g17459_i0	PRJNA415856	17720	207	1.094937	2.26651959	Nitrososphaera	497726	Archaea	Archaea	316	5.819999999999998e-82	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g17459	i0	94.203	36.0821256038647	207	12	100	0	1	207	1772	1566	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	7469	316	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
27739304	27739304	PRJNA415856_P_NODE_21564_length_190_cov_1.219858_g21303_i0	PRJNA415856	21564	190	1.219858	2.3177302	Sulfolobaceae archaeon	2967306	Archaea	Archaea	67.4	2.75e-11	NR	MEM0174246.1	2967306	g21303	i0	50.8	0.963157894736842	61	30	96.3	0	188	6	110	170	MEM0174246.1 helix-turn-helix domain-containing protein [Sulfolobaceae archaeon]	diamond	183	67.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae		Sulfolobaceae archaeon
28608091	28608091	PRJNA415856_P_NODE_49447_length_162_cov_0.902655_g49186_i0	PRJNA415856	49447	162	0.902655	1.4623011	Nitrososphaeria	1643678	Archaea	Archaea	70.5	6.07e-13	NR	RPJ25338.1	2026768	g49186	i0	88.6	1.66666666666667	44	5	81.5	0	31	162	1	44	RPJ25338.1 MAG: hypothetical protein EHM25_13540, partial [Nitrosopumilales archaeon]	diamond	270	70.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
28906960	28906960	PRJNA415856_P_NODE_48388_length_162_cov_1.469027_g48127_i0	PRJNA415856	48388	162	1.469027	2.37982374	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	111	4.68e-29	NR	HEX2407753.1	2169593	g48127	i0	88.7	9.81481481481481	53	6	98.1	0	2	160	56	108	HEX2407753.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon]	diamond	1590	111	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29538580	29538580	PRJNA415856_P_NODE_24010_length_185_cov_1.500000_g23749_i0	PRJNA415856	24010	185	1.5	2.775	Sulfolobaceae archaeon	2967306	Archaea	Archaea	49.3	5.44e-5	NR	MEM0173399.1	2967306	g23749	i0	45	0.972972972972973	60	33	97.3	0	180	1	7	66	MEM0173399.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	180	49.3	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae		Sulfolobaceae archaeon
30439936	30439936	PRJNA415856_P_NODE_8993_length_300_cov_1.884462_g8732_i0	PRJNA415856	8993	300	1.884462	5.653386	root	1	Root_unresolved	Root_unresolved	85.1	1.87e-17	NR	MEK6877666.1	2056631	g8732	i0	75	0.97	48	12	48	0	1	144	220	267	MEK6877666.1 site-specific DNA-methyltransferase [Thermoproteota archaeon]	diamond	291	85.9	0.990686845168801	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
30517910	30517910	PRJNA415856_P_NODE_26613_length_180_cov_1.557252_g26352_i0	PRJNA415856	26613	180	1.557252	2.8030536	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	90.5	7.95e-20	NR	HJR46673.1	2169593	g26352	i0	78.9	1.9	57	12	95	0	8	178	1	57	HJR46673.1 site-specific integrase [Nitrososphaeraceae archaeon]	diamond	342	90.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31813978	31813978	PRJNA415856_P_NODE_46477_length_163_cov_0.894737_g46216_i0	PRJNA415856	46477	163	0.894737	1.45842131	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	120	1.45e-33	NR	HET6640053.1	2169593	g46216	i0	100	1.95092024539877	53	0	97.5	0	161	3	64	116	HET6640053.1 cbb3-type cytochrome c oxidase subunit I [Nitrososphaeraceae archaeon]	diamond	318	120	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31908887	31908887	PRJNA415856_P_NODE_28457_length_177_cov_1.367188_g28196_i0	PRJNA415856	28457	177	1.367188	2.41992276	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	79.3	2.11e-16	NR	HXW12010.1	2169593	g28196	i0	77.6	0.983050847457627	58	13	98.3	0	2	175	42	99	HXW12010.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	174	79.3	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32257283	32257283	PRJNA415856_P_NODE_50138_length_162_cov_0.902655_g49877_i0	PRJNA415856	50138	162	0.902655	1.4623011	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	48.5	2.96e-5	NR	MDW0283126.1	2169593	g49877	i0	66.7	1.09259259259259	30	10	55.6	0	2	91	93	122	MDW0283126.1 ArsR family transcriptional regulator [Nitrososphaeraceae archaeon]	diamond	177	48.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32446994	32446994	PRJNA415856_P_NODE_11919_length_254_cov_1.068293_g11658_i0	PRJNA415856	11919	254	1.068293	2.71346422	Nitrososphaera sp.	1971748	Archaea	Archaea	43.9	0.0163	NR	HVX03469.1	1971748	g11658	i0	37.8	0.874015748031496	74	36	87.4	3	27	248	405	468	HVX03469.1 glycosyltransferase family 2 protein [Nitrososphaera sp.]	diamond	222	43.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera 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);;