RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", tax_kingdom = "Promethearchaeati" and tax_phylum = "Promethearchaeota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Promethearchaeota · 21 ✖

tax_kingdom 1

  • Promethearchaeati · 21 ✖

analysis 1

  • blastn · 21 ✖

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
1286017 1286017 PRJEB10140_P_NODE_154642_length_241_cov_1.276042_g137334_i0 PRJEB10140 154642 241 1.276042 3.07526122 Promethearchaeota archaeon 2053489 Archaea Archaea 54.7 0.006   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g137334 i0 96.97 0.136929460580913 33 0 13 1 190 221 2013948 2013980 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 33 54.7 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
1513451 1513451 PRJNA1120060_P_NODE_1501642_length_293_cov_2.927273_g1483654_i0 PRJNA1120060 1501642 293 2.927273 8.57690989 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.027   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g1483654 i0 100 0.0955631399317406 28 0 10 0 231 258 2085605 2085632 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
3016123 3016123 PRJNA493632_P_NODE_515523_length_251_cov_0.865169_g512084_i0 PRJNA493632 515523 251 0.865169 2.17157419 Promethearchaeota archaeon 2053489 Archaea Archaea 58.4 4.89e-4   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g512084 i0 100 1.58964143426295 31 0 12 0 221 251 871947 871917 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 399 58.4 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
4256408 4256408 PRJNA432257_S_NODE_28784_length_283_cov_12.016260_g28403_i0 PRJNA432257 28784 283 12.01626 34.0060158 Promethearchaeota archaeon 2053489 Archaea Archaea 63.9 1.21e-5   NTclustered gi|2027294252|gb|MW958651.1| 2053489 g28403 i0 97.297 0.130742049469965 37 1 13 0 213 249 1281 1245 Promethearchaeota archaeon clone AB328_20_25 16S ribosomal RNA gene, partial sequence blastn 37 63.9 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
5114243 5114243 PRJEB10140_P_NODE_180545_length_212_cov_1.239264_g163236_i0 PRJEB10140 180545 212 1.239264 2.62723968 Promethearchaeum syntrophicum 2594042 Archaea Archaea 52.8 0.019   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g163236 i0 100 0.132075471698113 28 0 13 0 111 138 1452339 1452366 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
5815636 5815636 PRJNA725806_P_NODE_98385_length_198_cov_5.838509_g98083_i0 PRJNA725806 98385 198 5.838509 11.56024782 Promethearchaeota archaeon 2053489 Archaea Archaea 58.4 3.69e-4   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g98083 i0 100 0.156565656565657 31 0 16 0 37 67 1134204 1134234 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 31 58.4 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
6780536 6780536 PRJNA382357_P_NODE_135266_length_211_cov_0.866667_g134527_i0 PRJNA382357 135266 211 0.866667 1.82866737 Promethearchaeum syntrophicum 2594042 Archaea Archaea 54.7 0.005   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g134527 i0 92.308 0.350710900473934 39 1 18 2 141 179 2990751 2990715 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 74 54.7 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
10228721 10228721 PRJEB28589_S_NODE_1869_length_422_cov_7.290667_g1761_i0 PRJEB28589 1869 422 7.290667 30.76661474 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.041   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g1761 i0 100 0.0663507109004739 28 0 7 0 325 352 2007894 2007867 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
10403424 10403424 PRJNA1095825_P_NODE_181069_length_290_cov_1.419355_g178006_i0 PRJNA1095825 181069 290 1.419355 4.1161295 Promethearchaeum syntrophicum 2594042 Archaea Archaea 52.8 0.027   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g178006 i0 100 0.096551724137931 28 0 10 0 73 100 435471 435498 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
11130854 11130854 PRJNA946307_P_NODE_38769_length_214_cov_3.042424_g37895_i0 PRJNA946307 38769 214 3.042424 6.51078736 Promethearchaeota archaeon 2053489 Archaea Archaea 67.6 6.73e-7   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g37895 i0 87.719 0.644859813084112 57 7 27 0 119 175 162423 162479 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 138 67.6 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
12246912 12246912 PRJNA787741_P_NODE_27910_length_207_cov_4.305970_g27787_i0 PRJNA787741 27910 207 4.30597 8.9133579 Promethearchaeota archaeon 2053489 Archaea Archaea 54.7 0.005   NTclustered gi|2107931243|gb|CP070805.1| 2053489 g27787 i0 100 0.140096618357488 29 0 14 0 175 203 1048476 1048504 MAG: Promethearchaeota archaeon isolate bin132 chromosome blastn 29 54.7 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
12290068 12290068 PRJNA812001_P_NODE_49510_length_290_cov_1.400922_g49264_i0 PRJNA812001 49510 290 1.400922 4.0626738 Promethearchaeum syntrophicum 2594042 Archaea Archaea 52.8 0.027   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g49264 i0 100 0.096551724137931 28 0 10 0 172 199 1297044 1297071 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
13299423 13299423 PRJNA561212_P_NODE_17451_length_272_cov_1.140704_g17240_i0 PRJNA561212 17451 272 1.140704 3.10271488 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.025   NTclustered gi|2107767831|gb|CP070831.1| 2053489 g17240 i0 100 0.102941176470588 28 0 10 0 189 216 2348521 2348548 MAG: Promethearchaeota archaeon isolate bin108 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
15810277 15810277 PRJNA534016_P_NODE_18673_length_237_cov_2.756098_g18583_i0 PRJNA534016 18673 237 2.756098 6.53195226 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.021   NTclustered gi|2107767831|gb|CP070831.1| 2053489 g18583 i0 100 0.118143459915612 28 0 12 0 160 187 856896 856923 MAG: Promethearchaeota archaeon isolate bin108 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
20803827 20803827 PRJNA382357_P_NODE_103617_length_238_cov_2.146893_g102878_i0 PRJNA382357 103617 238 2.146893 5.10960534 Promethearchaeum syntrophicum 2594042 Archaea Archaea 52.8 0.021   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g102878 i0 100 0.117647058823529 28 0 12 0 79 106 1873658 1873685 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
22221626 22221626 PRJNA560932_P_NODE_21598_length_380_cov_1.368078_g21242_i0 PRJNA560932 21598 380 1.368078 5.1986964 Candidatus Lokiarchaeum ossiferum 2951803 Archaea Archaea 56.5 0.003   NTclustered gi|2321196112|gb|CP104013.1| 2951803 g21242 i0 100 0.0789473684210526 30 0 8 0 19 48 5843216 5843245 Candidatus Lokiarchaeum ossiferum isolate Loki-B35 chromosome, complete genome blastn 30 56.5 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Candidatus Lokiarchaeum Candidatus Lokiarchaeum ossiferum
22389323 22389323 PRJNA725806_P_NODE_31618_length_283_cov_4.142276_g31321_i0 PRJNA725806 31618 283 4.142276 11.72264108 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.026   NTclustered gi|2107767831|gb|CP070831.1| 2053489 g31321 i0 100 0.0989399293286219 28 0 10 0 245 272 1665930 1665903 MAG: Promethearchaeota archaeon isolate bin108 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
22597720 22597720 PRJNA940501_S_NODE_336058_length_160_cov_1.393162_g335240_i0 PRJNA940501 336058 160 1.393162 2.2290592 Promethearchaeota archaeon 2053489 Archaea Archaea 52.8 0.013   NTclustered gi|2107767831|gb|CP070831.1| 2053489 g335240 i0 100 0.175 28 0 18 0 77 104 532469 532496 MAG: Promethearchaeota archaeon isolate bin108 chromosome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
23554126 23554126 PRJNA630162_P_NODE_125899_length_171_cov_2.311475_g124376_i0 PRJNA630162 125899 171 2.311475 3.95262225 Promethearchaeum syntrophicum 2594042 Archaea Archaea 122 1.0799999999999999e-23   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g124376 i0 87.156 2.37426900584795 109 13 64 1 57 165 82959 83066 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 406 122 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
23581096 23581096 PRJNA662254_P_NODE_64979_length_241_cov_0.916667_g64328_i0 PRJNA662254 64979 241 0.916667 2.20916747 Promethearchaeum syntrophicum 2594042 Archaea Archaea 52.8 0.022   NTclustered gi|2778339399|gb|CP042905.2| 2594042 g64328 i0 100 0.116182572614108 28 0 12 0 194 221 783756 783729 Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome blastn 28 52.8 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Promethearchaeum Promethearchaeum syntrophicum
25546993 25546993 PRJNA1233465e_S_NODE_135961_length_170_cov_1.454545_g134651_i0 PRJNA1233465 135961 170 1.454545 2.4727265 Promethearchaeota archaeon 2053489 Archaea Archaea 65.8 1.83e-6   NTclustered gi|2027294132|gb|MW958532.1| 2053489 g134651 i0 100 6.27647058823529 35 0 21 0 136 170 1495 1461 Promethearchaeota archaeon clone AB209_5_10 16S ribosomal RNA gene, partial sequence blastn 1067 65.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota 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);;