RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA946307", tax_phylum = "Thermoplasmatota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 11 ✖

tax_phylum 1

  • Thermoplasmatota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA946307 · 11 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
3477023 3477023 PRJNA946307_P_NODE_145903_length_166_cov_0.871795_g145029_i0 PRJNA946307 145903 166 0.871795 1.4471797 Thermoplasmatales archaeon BRNA1 1054217 Archaea Archaea 52.8 0.014   NTclustered gi|472831278|gb|CP002916.1| 1054217 g145029 i0 100 0.168674698795181 28 0 17 0 42 69 336151 336124 Thermoplasmatales archaeon BRNA1, complete genome blastn 28 52.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon BRNA1
4754636 4754636 PRJNA946307_P_NODE_141044_length_167_cov_0.881356_g140170_i0 PRJNA946307 141044 167 0.881356 1.47186452 Methanomassiliicoccaceae archaeon 2052168 Archaea Archaea 174 2.87e-39   NTclustered gi|2621703346|emb|OY760646.1| 2052168 g140170 i0 89.286 19.6107784431138 140 13 83 2 16 154 412016 412154 MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 blastn 3275 174 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
4756552 4756552 PRJNA946307_P_NODE_94424_length_187_cov_0.760870_g93550_i0 PRJNA946307 94424 187 0.76087 1.4228269 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 244 2.4599999999999999e-60   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g93550 i0 92.045 16.5935828877005 176 11 93 3 1 173 1503980 1504155 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 3103 244 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
28011489 28011489 PRJNA946307_P_NODE_13685_length_352_cov_3.115512_g12815_i0 PRJNA946307 13685 352 3.115512 10.96660224 Archaea 2157 Archaea Archaea 45.4 0.013   NR WP_236993901.1 1080712 g12815 i0 52.4 0.724431818181818 42 20 35.8 0 226 351 258 299 WP_236993901.1 RNA-guided endonuclease InsQ/TnpB family protein [Methanomassiliicoccus luminyensis] diamond 255 45.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Methanomassiliicoccus Methanomassiliicoccus luminyensis
28541548 28541548 PRJNA946307_P_NODE_136627_length_168_cov_2.201681_g135753_i0 PRJNA946307 136627 168 2.2016810000000002 3.69882408 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 57.4 5.78e-8   NR MFA7161944.1 2517205 g135753 i0 47.1 0.910714285714286 51 26 89.3 1 14 163 176 226 MFA7161944.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] diamond 153 57.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
28604591 28604591 PRJNA946307_P_NODE_95067_length_186_cov_2.708029_g94193_i0 PRJNA946307 95067 186 2.708029 5.03693394 Thermoplasmatales archaeon 2268204 Archaea Archaea 43.1 0.0127   NR MBP1661917.1 2268204 g94193 i0 41.2 0.82258064516129 51 29 80.6 1 2 151 58 108 MBP1661917.1 peptidase and subtilisin kexin sedolisin [Thermoplasmatales archaeon] diamond 153 43.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
28983579 28983579 PRJNA946307_P_NODE_108088_length_180_cov_3.366412_g107214_i0 PRJNA946307 108088 180 3.366412 6.0595416 Thermoplasmata archaeon 1906666 Archaea Archaea 41.6 0.0408   NR HUJ77987.1 1906666 g107214 i0 43.1 0.85 51 28 83.3 1 175 26 259 309 HUJ77987.1 type I 3-dehydroquinate dehydratase [Thermoplasmata archaeon] diamond 153 41.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29015302 29015302 PRJNA946307_P_NODE_45728_length_210_cov_4.888199_g44854_i0 PRJNA946307 45728 210 4.888199 10.2652179 Thermoplasmatota archaeon 2806419 Archaea Archaea 55.8 5.64e-7   NR HLE48401.1 2806419 g44854 i0 30.2 1.84285714285714 129 23 88.6 1 14 199 172 300 HLE48401.1 CocE/NonD family hydrolase [Thermoplasmatota archaeon] diamond 387 55.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
30056930 30056930 PRJNA946307_P_NODE_70831_length_199_cov_3.060000_g69957_i0 PRJNA946307 70831 199 3.06 6.0894 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 42.4 0.0278   NR MBR6911019.1 2517205 g69957 i0 36.5 0.949748743718593 63 34 85.9 2 16 186 164 226 MBR6911019.1 glycosyltransferase family 2 protein [Candidatus Methanomethylophilaceae archaeon] diamond 189 42.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
31542456 31542456 PRJNA946307_P_NODE_151456_length_164_cov_2.495652_g150582_i0 PRJNA946307 151456 164 2.495652 4.09286928 Methanomassiliicoccus sp. 2528041 Archaea Archaea 86.3 5.81e-19   NR NLT37801.1 2528041 g150582 i0 87.8 0.896341463414634 49 6 89.6 0 163 17 109 157 NLT37801.1 energy-coupling factor ABC transporter permease [Methanomassiliicoccus sp.] diamond 147 86.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Methanomassiliicoccus Methanomassiliicoccus sp.
32555056 32555056 PRJNA946307_P_NODE_117979_length_176_cov_1.535433_g117105_i0 PRJNA946307 117979 176 1.535433 2.70236208 Thermoplasmata archaeon 1906666 Archaea Archaea 48.1 1.53e-4   NR UCG69083.1 1906666 g117105 i0 38.5 0.886363636363636 52 32 88.6 0 16 171 92 143 UCG69083.1 MAG: hypothetical protein JSV09_15065 [Thermoplasmata archaeon] diamond 156 48.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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