RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA599026" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 12 ✖

bioproject 1

  • PRJNA599026 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
1847751 1847751 PRJNA599026_S_NODE_66322_length_162_cov_0.902655_g65866_i0 PRJNA599026 66322 162 0.902655 1.4623011 Salinigranum rubrum 755307 Archaea Archaea 62.1 2.24e-5   NTclustered gi|1336549475|gb|CP026309.1| 755307 g65866 i0 100 1.69135802469136 33 0 20 0 115 147 1058470 1058438 Salinigranum rubrum strain GX10 chromosome, complete genome blastn 274 62.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinigranum Salinigranum rubrum
3122877 3122877 PRJNA599026_S_NODE_58543_length_165_cov_0.879310_g58087_i0 PRJNA599026 58543 165 0.87931 1.4508615 Natronomonas gomsonensis 1046043 Archaea Archaea 267 4.53e-67   NTclustered gi|2273673090|gb|CP101323.1| 1046043 g58087 i0 95.758 13.2363636363636 165 7 100 0 1 165 482879 482715 Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome blastn 2184 267 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas gomsonensis
4969490 4969490 PRJNA599026_S_NODE_66684_length_162_cov_0.902655_g66228_i0 PRJNA599026 66684 162 0.902655 1.4623011 Halobacteriales 2235 Archaea Archaea 213 5.84e-51   NTclustered gi|2281256326|gb|CP101943.1| 224402 g66228 i0 90.625 96.0555555555556 160 15 99 0 1 160 425877 425718 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 15561 213 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
8225117 8225117 PRJNA599026_S_NODE_61527_length_164_cov_0.886957_g61071_i0 PRJNA599026 61527 164 0.886957 1.45460948 Haloplanus sp. GX21 3127120 Archaea Archaea 110 8.01e-20   NTclustered gi|2700851762|gb|CP147874.1| 3127120 g61071 i0 80.405 1.79268292682927 148 25 89 4 1 146 1101243 1101098 Haloplanus sp. GX21 chromosome, complete genome blastn 294 110 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus sp. GX21
10775984 10775984 PRJNA599026_S_NODE_3909_length_481_cov_3.826389_g3456_i0 PRJNA599026 3909 481 3.826389 18.40493109 Thermococcus henrietii 2016361 Archaea Archaea 84.2 1.66e-11   NTclustered gi|1264229935|emb|LT900021.1| 2016361 g3456 i0 96.078 0.432432432432432 51 2 11 0 227 277 1646084 1646134 Thermococcus sp. EXT12c genome assembly, chromosome: I blastn 208 84.2 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus henrietii
10776043 10776043 PRJNA599026_S_NODE_44809_length_174_cov_2.680000_g44353_i0 PRJNA599026 44809 174 2.68 4.6632 Methanosalsum zhilinae 39669 Archaea Archaea 56.5 0.001   NTclustered gi|335929340|gb|CP002101.1| 679901 g44353 i0 100 0.172413793103448 30 0 17 0 101 130 1665138 1665167 Methanosalsum zhilinae DSM 4017, complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosalsum Methanosalsum zhilinae
11344658 11344658 PRJNA599026_S_NODE_58689_length_165_cov_0.879310_g58233_i0 PRJNA599026 58689 165 0.87931 1.4508615 Halobacteriales 2235 Archaea Archaea 267 4.53e-67   NTclustered gi|222454053|gb|CP001366.1| 416348 g58233 i0 95.758 8.93939393939394 165 7 100 0 1 165 315878 315714 Halorubrum lacusprofundi ATCC 49239 chromosome 2, complete sequence blastn 1475 267 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum lacusprofundi
13325793 13325793 PRJNA599026_S_NODE_52611_length_167_cov_0.864407_g52155_i0 PRJNA599026 52611 167 0.864407 1.44355969 Natronomonas gomsonensis 1046043 Archaea Archaea 137 3.76e-28   NTclustered gi|2273673091|gb|CP101324.1| 1046043 g52155 i0 98.701 0.922155688622755 77 1 46 0 1 77 19321 19245 Natronomonas gomsonensis strain KCTC 4088 plasmid unnamed1, complete sequence blastn 154 137 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas gomsonensis
15169578 15169578 PRJNA599026_S_NODE_64752_length_163_cov_0.894737_g64296_i0 PRJNA599026 64752 163 0.894737 1.45842131 Halobacteriales 2235 Archaea Archaea 209 7.62e-50   NTclustered gi|2089988103|gb|CP082249.1| 2871694 g64296 i0 91.447 91.2208588957055 152 13 93 0 1 152 1094241 1094392 Natrinema sp. SYSU A 869 chromosome, complete genome blastn 14869 209 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrinema Natrinema sp. SYSU A 869
17149466 17149466 PRJNA599026_S_NODE_51194_length_167_cov_0.864407_g50738_i0 PRJNA599026 51194 167 0.864407 1.44355969 Natronomonas gomsonensis 1046043 Archaea Archaea 243 7.739999999999999e-60   NTclustered gi|2273673090|gb|CP101323.1| 1046043 g50738 i0 92.814 1 167 12 100 0 1 167 1785748 1785582 Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome blastn 167 243 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas gomsonensis
17149637 17149637 PRJNA599026_S_NODE_63494_length_163_cov_0.894737_g63038_i0 PRJNA599026 63494 163 0.894737 1.45842131 Halorubrum sp. 2020YC2 2836432 Archaea Archaea 102 1.33e-17   NTclustered gi|2047351610|gb|CP076019.1| 2836432 g63038 i0 88.235 7.48466257668712 85 10 52 0 76 160 1102455 1102371 Halorubrum sp. 2020YC2 chromosome, complete genome blastn 1220 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. 2020YC2
18423886 18423886 PRJNA599026_S_NODE_57595_length_165_cov_0.879310_g57139_i0 PRJNA599026 57595 165 0.87931 1.4508615 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 52.8 0.014   NTclustered gi|985614202|gb|CP010834.1| 1609968 g57139 i0 94.118 0.206060606060606 34 2 21 0 67 100 1095963 1095930 Methanobrevibacter sp. YE315, complete genome blastn 34 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315

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