RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1046144 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
12488340 12488340 PRJNA1046144_P_NODE_66390_length_228_cov_0.905660_g66095_i0 PRJNA1046144 66390 228 0.90566 2.0649048 Halorubrum alkaliphilum 261290 Archaea Archaea 102 1.03e-24   NR MBP1921345.1 261290 g66095 i0 73.3 0.986842105263158 75 20 98.7 0 226 2 25 99 MBP1921345.1 hypothetical protein [Halorubrum alkaliphilum] diamond 225 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum alkaliphilum
16749733 16749733 PRJNA1046144_P_NODE_65074_length_229_cov_0.900000_g64779_i0 PRJNA1046144 65074 229 0.9 2.061 Halorubrum 56688 Archaea Archaea 117 2.5e-30   NR WP_049931830.1 56688 g64779 i0 76.7 2.86899563318777 73 17 95.6 0 1 219 178 250 WP_049931830.1 MULTISPECIES: ABC transporter permease [Halorubrum] diamond 657 117 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum  
27224719 27224719 PRJNA1046144_P_NODE_67123_length_228_cov_0.905660_g66828_i0 PRJNA1046144 67123 228 0.90566 2.0649048 Halapricum desulfuricans 2841257 Archaea Archaea 83.2 1.52e-17   NR WP_229123049.1 2841257 g66828 i0 50.7 1.76315789473684 67 32 86.8 1 202 5 1 67 WP_229123049.1 HNH endonuclease [Halapricum desulfuricans] diamond 402 83.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halapricum Halapricum desulfuricans
27446346 27446346 PRJNA1046144_P_NODE_65863_length_228_cov_1.723270_g65568_i0 PRJNA1046144 65863 228 1.72327 3.9290556 Haloparvum sedimenti 1678448 Archaea Archaea 72.4 1.12e-12   NR WP_058365498.1 1678448 g65568 i0 54.5 1.01315789473684 77 34 100 1 228 1 116 192 WP_058365498.1 PKD domain-containing protein [Haloparvum sedimenti] diamond 231 72.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloparvum Haloparvum sedimenti
27540891 27540891 PRJNA1046144_P_NODE_66904_length_228_cov_0.905660_g66609_i0 PRJNA1046144 66904 228 0.90566 2.0649048 Halopenitus persicus 1048396 Archaea Archaea 109 7.050000000000001e-26   NR WP_096388800.1 1048396 g66609 i0 68.1 0.907894736842105 69 22 90.8 0 213 7 385 453 WP_096388800.1 hypothetical protein [Halopenitus persicus] diamond 207 109 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halopenitus Halopenitus persicus
27667269 27667269 PRJNA1046144_P_NODE_44284_length_261_cov_1.145833_g43989_i0 PRJNA1046144 44284 261 1.145833 2.99062413 Haloparvum sedimenti 1678448 Archaea Archaea 134 1.66e-34   NR WP_080508470.1 1678448 g43989 i0 76.7 0.988505747126437 86 20 98.9 0 2 259 145 230 WP_080508470.1 alpha/beta hydrolase family protein [Haloparvum sedimenti] diamond 258 134 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloparvum Haloparvum sedimenti
27919623 27919623 PRJNA1046144_P_NODE_40185_length_271_cov_1.351485_g39890_i0 PRJNA1046144 40185 271 1.351485 3.66252435 Halopiger djelfimassiliensis 1293047 Archaea Archaea 116 4.76e-28   NR WP_049922524.1 1293047 g39890 i0 64 0.985239852398524 89 32 98.5 0 269 3 443 531 WP_049922524.1 Xaa-Pro dipeptidyl-peptidase [Halopiger djelfimassiliensis] diamond 267 116 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halopiger Halopiger djelfimassiliensis
28045945 28045945 PRJNA1046144_P_NODE_61105_length_232_cov_0.883436_g60810_i0 PRJNA1046144 61105 232 0.883436 2.04957152 Natronomonas sp. LN261 2750669 Archaea Archaea 126 1.06e-32   NR WP_181692612.1 2750669 g60810 i0 97.2 0.918103448275862 71 2 91.8 0 231 19 276 346 WP_181692612.1 hypothetical protein [Natronomonas sp. LN261] diamond 213 126 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
28077461 28077461 PRJNA1046144_P_NODE_68545_length_227_cov_0.911392_g68250_i0 PRJNA1046144 68545 227 0.911392 2.06885984 Haloparvum sedimenti 1678448 Archaea Archaea 107 1.31e-26   NR WP_058367063.1 1678448 g68250 i0 72 0.991189427312775 75 21 99.1 0 227 3 24 98 WP_058367063.1 AAA family ATPase [Haloparvum sedimenti] diamond 225 107 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloparvum Haloparvum sedimenti
28393290 28393290 PRJNA1046144_P_NODE_54446_length_238_cov_1.355030_g54151_i0 PRJNA1046144 54446 238 1.35503 3.2249714 Halorubrum sp. CSM-61 2485838 Archaea Archaea 81.3 2.21e-17   NR WP_123622875.1 2485838 g54151 i0 100 0.491596638655462 39 0 49.2 0 117 1 1 39 WP_123622875.1 TRAM domain-containing protein [Halorubrum sp. CSM-61] diamond 117 81.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CSM-61
28551342 28551342 PRJNA1046144_P_NODE_58827_length_233_cov_0.878049_g58532_i0 PRJNA1046144 58827 233 0.878049 2.04585417 Halostella salina 1547897 Archaea Archaea 72.8 5.81e-15   NR WP_375137058.1 1547897 g58532 i0 76.1 1.18454935622318 46 11 59.2 0 5 142 22 67 WP_375137058.1 helix-turn-helix domain-containing protein [Halostella salina] diamond 276 72.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Halostella Halostella salina
28614342 28614342 PRJNA1046144_P_NODE_54847_length_237_cov_1.684524_g54552_i0 PRJNA1046144 54847 237 1.684524 3.99232188 halophilic archaeon 29295 Archaea Archaea 73.9 2.03e-13   NR RBI61022.1 29295 g54552 i0 51.7 1.10126582278481 87 33 100 2 237 1 217 302 RBI61022.1 hypothetical protein DMJ13_14905 [halophilic archaeon] diamond 261 73.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon
29750737 29750737 PRJNA1046144_P_NODE_41691_length_267_cov_1.454545_g41396_i0 PRJNA1046144 41691 267 1.454545 3.88363515 Halalkalirubrum salinum 2563889 Archaea Archaea 148 2.46e-39   NR WP_138007138.1 2563889 g41396 i0 77.3 0.98876404494382 88 20 98.9 0 265 2 203 290 WP_138007138.1 transposase [Halalkalirubrum salinum] diamond 264 148 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halalkalirubrum Halalkalirubrum salinum
30667146 30667146 PRJNA1046144_P_NODE_46133_length_256_cov_2.197861_g45838_i0 PRJNA1046144 46133 256 2.197861 5.62652416 Halorubrum ejinorense 425309 Archaea Archaea 75.5 1.75e-14   NR WP_343779255.1 425309 g45838 i0 75 1.359375 52 13 60.9 0 229 74 128 179 WP_343779255.1 hypothetical protein [Halorubrum ejinorense] diamond 348 75.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum ejinorense
31765488 31765488 PRJNA1046144_P_NODE_33577_length_292_cov_3.327354_g33282_i0 PRJNA1046144 33577 292 3.327354 9.71587368 Halorubrum 56688 Archaea Archaea 83.2 6.51e-18   NR WP_050034028.1 413816 g33282 i0 91.3 0.945205479452055 46 4 47.3 0 2 139 51 96 WP_050034028.1 hypothetical protein [Halorubrum halophilum] diamond 276 83.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum halophilum
31963350 31963350 PRJNA1046144_P_NODE_67158_length_228_cov_0.880503_g66863_i0 PRJNA1046144 67158 228 0.880503 2.00754684 Halorubrum sp. Atlit-26R 2282128 Archaea Archaea 50.4 5.64e-5   NR WP_121597071.1 2282128 g66863 i0 65.5 0.381578947368421 29 10 38.2 0 87 1 4 32 WP_121597071.1 ATP-binding protein [Halorubrum sp. Atlit-26R] diamond 87 50.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. Atlit-26R

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