RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 15 ✖

bioproject 1

  • PRJNA737474 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
25571802 25571802 PRJNA737474c_S_NODE_30641_length_229_cov_3.948718_g29810_i0 PRJNA737474 30641 229 3.948718 9.04256422 uncultured archaeon 115547 Archaea Archaea 89.8 1.56e-13   NTclustered gi|765560213|gb|KP308714.1| 115547 g29810 i0 90 26.4061135371179 70 5 31 2 160 229 3974 3907 Uncultured archaeon clone gwa2_scaffold_21945 genomic sequence blastn 6047 89.8 1 Archaea               uncultured archaeon
25572158 25572158 PRJNA737474c_S_NODE_7601_length_395_cov_5.593168_g6770_i0 PRJNA737474 7601 395 5.593168 22.0930136 Halovalidus salilacus 3075124 Archaea Archaea 52.8 0.038   NTclustered gi|2581323319|gb|CP134700.1| 3075124 g6770 i0 100 0.0708860759493671 28 0 7 0 59 86 1617456 1617483 Halovalidus salilacus strain CCL63 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovalidus Halovalidus salilacus
25704872 25704872 PRJNA737474b_S_NODE_29282_length_297_cov_1.799107_g28243_i0 PRJNA737474 29282 297 1.799107 5.34334779 uncultured archaeon 115547 Archaea Archaea 344 4.06e-90   NTclustered gi|1032564008|gb|KX029804.1| 115547 g28243 i0 95.045 14.3333333333333 222 5 75 3 73 294 239 24 Uncultured archaeon clone A_OTU_328 16S ribosomal RNA gene, partial sequence blastn 4257 344 1 Archaea               uncultured archaeon
25714414 25714414 PRJNA737474f_S_NODE_193826_length_252_cov_1.720670_g193148_i0 PRJNA737474 193826 252 1.72067 4.3360884 Methanolobus sp. ZRKC3 3125786 Archaea Archaea 52.8 0.023   NTclustered gi|2708465663|gb|CP146982.1| 3125786 g193148 i0 100 0.111111111111111 28 0 11 0 221 248 1563628 1563655 Methanolobus sp. ZRKC3 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus sp. ZRKC3
25853160 25853160 PRJNA737474f_S_NODE_65379_length_319_cov_3.040650_g64701_i0 PRJNA737474 65379 319 3.04065 9.6996735 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 52.8 0.03   NTclustered gi|2107974951|gb|CP070784.1| 2026714 g64701 i0 100 0.0877742946708464 28 0 9 0 254 281 364733 364760 MAG: Candidatus Bathyarchaeota archaeon isolate bin16 chromosome blastn 28 52.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
25981150 25981150 PRJNA737474d_S_NODE_18804_length_353_cov_3.567857_g18210_i0 PRJNA737474 18804 353 3.567857 12.59453521 uncultured archaeon 115547 Archaea Archaea 270 8.46e-68   NTclustered gi|1032564008|gb|KX029804.1| 115547 g18210 i0 95.376 60.7988668555241 173 2 49 3 181 353 250 84 Uncultured archaeon clone A_OTU_328 16S ribosomal RNA gene, partial sequence blastn 21462 270 1 Archaea               uncultured archaeon
26038766 26038766 PRJNA737474g_S_NODE_189052_length_281_cov_1.596154_g187758_i0 PRJNA737474 189052 281 1.596154 4.48519274 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|2621703503|emb|OY762552.1| 176306 g187758 i0 100 0.807829181494662 29 0 10 0 65 93 1710159 1710187 MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 blastn 227 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium uncultured Methanobacterium sp.
26262200 26262200 PRJNA737474f_S_NODE_90598_length_297_cov_2.477679_g89920_i0 PRJNA737474 90598 297 2.477679 7.35870663 Methanobrevibacter smithii 2173 Archaea Archaea 54.7 0.008   NTclustered gi|2188913606|dbj|AP025587.1| 2173 g89920 i0 96.875 0.215488215488215 32 1 11 0 118 149 1461358 1461327 Methanobrevibacter smithii CE91-St68 DNA, complete genome blastn 64 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
26306995 26306995 PRJNA737474c_S_NODE_16390_length_294_cov_1.950226_g15559_i0 PRJNA737474 16390 294 1.950226 5.73366444 Methanofervidicoccus 2607661 Archaea Archaea 89.8 2.08e-13   NTclustered gi|2891698910|gb|CP178159.1| 2082189 g15559 i0 98.039 25.8095238095238 51 1 17 0 243 293 660441 660491 Methanofervidicoccus abyssi strain HHB chromosome, complete genome blastn 7588 89.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales   Methanofervidicoccus Methanofervidicoccus abyssi
26387578 26387578 PRJNA737474c_S_NODE_19607_length_276_cov_4.295567_g18776_i0 PRJNA737474 19607 276 4.295567 11.85576492 uncultured archaeon 115547 Archaea Archaea 87.9 6.96e-13   NTclustered gi|765560210|gb|KP308711.1| 115547 g18776 i0 96.296 20.7536231884058 54 0 20 1 1 54 15896 15947 Uncultured archaeon clone gwa2_scaffold_1731 genomic sequence blastn 5728 87.9 1 Archaea               uncultured archaeon
26388271 26388271 PRJNA737474c_S_NODE_32143_length_210_cov_5.693431_g31312_i0 PRJNA737474 32143 210 5.693431 11.9562051 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 108 3.88e-19   NTclustered gi|2258812665|gb|CP060219.1| 2026803 g31312 i0 88.764 45.9761904761905 89 8 42 2 121 209 1084522 1084608 MAG: Candidatus Woesearchaeota archaeon isolate HK-STAS-Nano-3 chromosome, complete genome blastn 9655 108 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
26401200 26401200 PRJNA737474g_S_NODE_228479_length_269_cov_1.663265_g227185_i0 PRJNA737474 228479 269 1.663265 4.47418285 Halosimplex pelagicum 869886 Archaea Archaea 60.2 1.47e-4   NTclustered gi|1870066477|gb|CP058909.1| 869886 g227185 i0 97.143 0.130111524163569 35 1 13 0 235 269 2160277 2160243 Halosimplex pelagicum strain R2 chromosome, complete genome blastn 35 60.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex pelagicum
26443833 26443833 PRJNA737474d_S_NODE_19231_length_349_cov_2.514493_g18637_i0 PRJNA737474 19231 349 2.514493 8.77558057 root 1 Root_unresolved Root_unresolved 62.1 5.48e-5   NTclustered gi|1572541187|emb|LR135910.1| 1462426 g18637 i0 97.222 10.5702005730659 36 1 10 0 1 36 24569 24534 uncultured Aenigmarchaeota archaeon genomic DNA containing deoA-rbcL-e2b2 region region blastn 3689 62.1 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         uncultured Aenigmarchaeota archaeon
26524392 26524392 PRJNA737474c_S_NODE_30520_length_230_cov_3.242038_g29689_i0 PRJNA737474 30520 230 3.242038 7.4566874 Methanotorris igneus Kol 5 880724 Archaea Archaea 71.3 5.67e-8   NTclustered gi|333750483|gb|CP002737.1| 880724 g29689 i0 95.556 46.7173913043478 45 0 20 2 186 230 1091820 1091778 Methanotorris igneus Kol 5, complete genome blastn 10745 71.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanotorris Methanotorris igneus
26579753 26579753 PRJNA737474d_S_NODE_18928_length_352_cov_2.939068_g18334_i0 PRJNA737474 18928 352 2.939068 10.34551936 Archaea 2157 Archaea Archaea 52.8 0.033   NTclustered gi|663512395|gb|KF900666.1| 1457911 g18334 i0 92.308 0.221590909090909 39 0 10 2 281 316 6124 6162 Uncultured marine group II/III euryarchaeote KM3_15_H06 genomic sequence blastn 78 52.8 1 Archaea   Methanobacteriati Methanobacteriota         uncultured marine group II/III euryarchaeote KM3_15_H06

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