RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 11 ✖

bioproject 1

  • PRJNA917598 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
895489 895489 PRJNA917598_P_NODE_23801_length_475_cov_0.950249_g22859_i0 PRJNA917598 23801 475 0.950249 4.51368275 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 878 0   NTclustered gi|2695672494|gb|CP118753.2| 1452353 g22859 i0 100 49.5073684210526 475 0 100 0 1 475 852620 853094 Methanosphaera sp. ISO3-F5 chromosome, complete genome blastn 23516 878 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5
2171408 2171408 PRJNA917598_P_NODE_41622_length_356_cov_1.088339_g40678_i0 PRJNA917598 41622 356 1.088339 3.87448684 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 658 0   NTclustered gi|2695672494|gb|CP118753.2| 1452353 g40678 i0 100 21.1685393258427 356 0 100 0 1 356 2230648 2230293 Methanosphaera sp. ISO3-F5 chromosome, complete genome blastn 7536 658 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5
7275383 7275383 PRJNA917598_P_NODE_91526_length_244_cov_0.900585_g90582_i0 PRJNA917598 91526 244 0.900585 2.1974274 Halorubrum sp. 2020YC2 2836432 Archaea Archaea 52.8 0.022   NTclustered gi|2047351610|gb|CP076019.1| 2836432 g90582 i0 100 0.114754098360656 28 0 11 0 91 118 1110880 1110907 Halorubrum sp. 2020YC2 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. 2020YC2
11454872 11454872 PRJNA917598_P_NODE_14469_length_620_cov_1.641682_g13535_i0 PRJNA917598 14469 620 1.641682 10.1784284 root 1 Root_unresolved Root_unresolved 1146 0   NTclustered gi|216917|dbj|D12983.1|PYWPOL 2261 g13535 i0 100 7.95483870967742 620 0 100 0 1 620 1099 1718 Pyrococcus furiosus pol gene for DNA polymerase, complete cds blastn 4932 1146 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus furiosus
14005780 14005780 PRJNA917598_P_NODE_92171_length_243_cov_0.905882_g91227_i0 PRJNA917598 92171 243 0.905882 2.20129326 Haloplanus 376170 Archaea Archaea 52.8 0.022   NTclustered gi|1785199060|gb|CP034345.1| 1816183 g91227 i0 96.774 0.255144032921811 31 1 13 0 44 74 846437 846467 Haloplanus rallus strain MBLA0036 chromosome, complete genome blastn 62 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus rallus
17474838 17474838 PRJNA917598_P_NODE_66854_length_278_cov_1.478049_g65910_i0 PRJNA917598 66854 278 1.478049 4.10897622 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 248 3.0399999999999997e-61   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g65910 i0 83.846 0.935251798561151 260 42 94 0 1 260 1499663 1499922 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 260 248 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
18748659 18748659 PRJNA917598_P_NODE_8455_length_825_cov_9.295213_g7610_i0 PRJNA917598 8455 825 9.295213 76.68550725 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 1498 0   NTclustered gi|2695672494|gb|CP118753.2| 1452353 g7610 i0 100 148.814545454545 811 0 98 0 1 811 394133 393323 Methanosphaera sp. ISO3-F5 chromosome, complete genome blastn 122772 1498 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5
20023904 20023904 PRJNA917598_P_NODE_92936_length_243_cov_0.905882_g91992_i0 PRJNA917598 92936 243 0.905882 2.20129326 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 272 1.5399999999999998e-68   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g91992 i0 86.831 2.95473251028807 243 32 100 0 1 243 2521583 2521825 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 718 272 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
23848523 23848523 PRJNA917598_P_NODE_50439_length_322_cov_3.871486_g49495_i0 PRJNA917598 50439 322 3.871486 12.46618492 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 595 1.1099999999999995e-165   NTclustered gi|575790353|gb|KF697734.1| 1452353 g49495 i0 100 102.860248447205 322 0 100 0 1 322 10 331 Methanosphaera sp. ISO3-F5 16S ribosomal RNA gene, partial sequence blastn 33121 595 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5
24202661 24202661 PRJNA917598_P_NODE_15519_length_596_cov_2.797323_g14585_i0 PRJNA917598 15519 596 2.797323 16.67204508 root 1 Root_unresolved Root_unresolved 1101 0   NTclustered gi|216917|dbj|D12983.1|PYWPOL 2261 g14585 i0 100 7.35906040268456 596 0 100 0 1 596 301 896 Pyrococcus furiosus pol gene for DNA polymerase, complete cds blastn 4386 1101 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus furiosus
25478192 25478192 PRJNA917598_P_NODE_7140_length_903_cov_2.084337_g6350_i0 PRJNA917598 7140 903 2.084337 18.82156311 root 1 Root_unresolved Root_unresolved 1548 0   NTclustered gi|216917|dbj|D12983.1|PYWPOL 2261 g6350 i0 100 13.0985603543743 838 0 93 0 1 838 1726 2563 Pyrococcus furiosus pol gene for DNA polymerase, complete cds blastn 11828 1548 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus furiosus

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