contig_metadata
21 rows where bioproject = "PRJEB83711" and tax_kingdom = "Methanobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3970590 | 3970590 | PRJEB83711_P_NODE_60064_length_252_cov_0.871508_g59798_i0 | PRJEB83711 | 60064 | 252 | 0.871508 | 2.19620016 | Methanobacterium sp. BRmetb2 | 2025350 | Archaea | Archaea | 139 | 1.71e-28 | NTclustered | gi|1473087786|gb|CP022705.1| | 2025350 | g59798 | i0 | 78.355 | 538.813492063492 | 231 | 39 | 98 | 11 | 18 | 242 | 478214 | 478439 | MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome | blastn | 135781 | 139 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BRmetb2 | |
| 6522289 | 6522289 | PRJEB83711_P_NODE_43366_length_281_cov_1.250000_g43100_i0 | PRJEB83711 | 43366 | 281 | 1.25 | 3.5125 | Methanosarcina sp. Kolksee | 1434099 | Archaea | Archaea | 503 | 5.95e-138 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g43100 | i0 | 98.932 | 6 | 281 | 3 | 100 | 0 | 1 | 281 | 443473 | 443753 | Methanosarcina sp. Kolksee, complete genome | blastn | 1686 | 503 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 6522841 | 6522841 | PRJEB83711_P_NODE_67646_length_248_cov_0.891429_g67380_i0 | PRJEB83711 | 67646 | 248 | 0.891429 | 2.21074392 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 385 | 1.95e-102 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g67380 | i0 | 94.737 | 1.99193548387097 | 247 | 13 | 99 | 0 | 1 | 247 | 469881 | 470127 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 494 | 385 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 11622789 | 11622789 | PRJEB83711_P_NODE_52530_length_262_cov_1.386243_g52264_i0 | PRJEB83711 | 52530 | 262 | 1.386243 | 3.63195666 | Methanosarcina vacuolata | 2215 | Archaea | Archaea | 444 | 3.38e-120 | NTclustered | gi|805391208|gb|CP009520.1| | 1434123 | g52264 | i0 | 97.328 | 7.08778625954198 | 262 | 6 | 100 | 1 | 1 | 262 | 1155291 | 1155551 | Methanosarcina vacuolata Z-761, complete genome | blastn | 1857 | 444 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina vacuolata | |
| 16721593 | 16721593 | PRJEB83711_P_NODE_78794_length_242_cov_0.923077_g78528_i0 | PRJEB83711 | 78794 | 242 | 0.923077 | 2.23384634 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 387 | 5.26e-103 | NTclustered | gi|805398754|gb|CP009526.1| | 1434109 | g78528 | i0 | 95.455 | 4 | 242 | 11 | 100 | 0 | 1 | 242 | 4141494 | 4141253 | Methanosarcina barkeri str. Wiesmoor, complete genome | blastn | 968 | 387 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 17996540 | 17996540 | PRJEB83711_P_NODE_82515_length_215_cov_9.070423_g82249_i0 | PRJEB83711 | 82515 | 215 | 9.070423 | 19.50140945 | Methanosalsum zhilinae | 39669 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|335929340|gb|CP002101.1| | 679901 | g82249 | i0 | 100 | 0.13953488372093 | 30 | 0 | 14 | 0 | 47 | 76 | 1665167 | 1665138 | Methanosalsum zhilinae DSM 4017, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 21821439 | 21821439 | PRJEB83711_P_NODE_72138_length_245_cov_1.279070_g71872_i0 | PRJEB83711 | 72138 | 245 | 1.27907 | 3.1337215 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 442 | 1.1199999999999994e-119 | NTclustered | gi|952971377|emb|LN734822.1| | 2162 | g71872 | i0 | 99.184 | 5 | 245 | 2 | 100 | 0 | 1 | 245 | 122266 | 122022 | Methanobacterium formicicum genome assembly isolate Mb9, chromosome : I | blastn | 1225 | 442 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 24370536 | 24370536 | PRJEB83711_P_NODE_73980_length_244_cov_1.473684_g73714_i0 | PRJEB83711 | 73980 | 244 | 1.473684 | 3.59578896 | Salinigranum rubrum | 755307 | Archaea | Archaea | 309 | 1.1800000000000002e-79 | NTclustered | gi|1336549475|gb|CP026309.1| | 755307 | g73714 | i0 | 89.958 | 32.6188524590164 | 239 | 24 | 98 | 0 | 3 | 241 | 1737454 | 1737692 | Salinigranum rubrum strain GX10 chromosome, complete genome | blastn | 7959 | 309 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 24370543 | 24370543 | PRJEB83711_P_NODE_74300_length_244_cov_0.912281_g74034_i0 | PRJEB83711 | 74300 | 244 | 0.912281 | 2.22596564 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 390 | 4.11e-104 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g74034 | i0 | 95.492 | 2.12704918032787 | 244 | 11 | 100 | 0 | 1 | 244 | 2319454 | 2319211 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 519 | 390 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 26907770 | 26907770 | PRJEB83711_P_NODE_68222_length_247_cov_1.522989_g67956_i0 | PRJEB83711 | 68222 | 247 | 1.522989 | 3.76178283 | Natronoarchaeum rubrum | 755311 | Archaea | Archaea | 43.5 | 0.0197 | NR | WP_256391750.1 | 755311 | g67956 | i0 | 37.5 | 0.97165991902834 | 80 | 39 | 88.7 | 3 | 18 | 236 | 59 | 134 | WP_256391750.1 ATP-binding protein [Natronoarchaeum rubrum] | diamond | 240 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Natronoarchaeum | Natronoarchaeum rubrum | |
| 27097493 | 27097493 | PRJEB83711_P_NODE_62062_length_251_cov_0.876404_g61796_i0 | PRJEB83711 | 62062 | 251 | 0.876404 | 2.19977404 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 87.8 | 1.68e-19 | NR | MBO7212442.1 | 66852 | g61796 | i0 | 67.3 | 0.621513944223108 | 52 | 17 | 62.2 | 0 | 1 | 156 | 130 | 181 | MBO7212442.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 156 | 87.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27184862 | 27184862 | PRJEB83711_P_NODE_66862_length_248_cov_0.891429_g66596_i0 | PRJEB83711 | 66862 | 248 | 0.891429 | 2.21074392 | Methanobrevibacter | 2172 | Archaea | Archaea | 154 | 1.33e-42 | NR | WP_330027063.1 | 66852 | g66596 | i0 | 85.2 | 1.95967741935484 | 81 | 12 | 98 | 0 | 248 | 6 | 305 | 385 | WP_330027063.1 glutamate--tRNA ligase, partial [Methanobrevibacter sp.] | diamond | 486 | 154 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27382129 | 27382129 | PRJEB83711_P_NODE_54163_length_259_cov_1.322581_g53897_i0 | PRJEB83711 | 54163 | 259 | 1.322581 | 3.42548479 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 108 | 4.45e-27 | NR | WP_330009041.1 | 66852 | g53897 | i0 | 54.7 | 0.996138996138996 | 86 | 39 | 99.6 | 0 | 259 | 2 | 81 | 166 | WP_330009041.1 AraC family transcriptional regulator [Methanobrevibacter sp.] | diamond | 258 | 108 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27634733 | 27634733 | PRJEB83711_P_NODE_42004_length_284_cov_1.473934_g41738_i0 | PRJEB83711 | 42004 | 284 | 1.473934 | 4.18597256 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 155 | 2.16e-41 | NR | WP_244706568.1 | 179637 | g41738 | i0 | 76.6 | 0.992957746478873 | 94 | 22 | 99.3 | 0 | 282 | 1 | 1231 | 1324 | WP_244706568.1 hypothetical protein [Halococcus dombrowskii] | diamond | 282 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 27950413 | 27950413 | PRJEB83711_P_NODE_77085_length_243_cov_0.917647_g76819_i0 | PRJEB83711 | 77085 | 243 | 0.917647 | 2.22988221 | Halosimplex carlsbadense | 171164 | Archaea | Archaea | 94.4 | 9.62e-21 | NR | WP_006881789.1 | 171164 | g76819 | i0 | 58 | 2 | 81 | 34 | 100 | 0 | 1 | 243 | 88 | 168 | WP_006881789.1 aminopeptidase [Halosimplex carlsbadense] | diamond | 486 | 94.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex carlsbadense | |
| 27981980 | 27981980 | PRJEB83711_P_NODE_71465_length_246_cov_0.901734_g71199_i0 | PRJEB83711 | 71465 | 246 | 0.901734 | 2.21826564 | Methanobrevibacter sp. UBA412 | 1915486 | Archaea | Archaea | 129 | 6.030000000000001e-36 | NR | WP_413829086.1 | 1915486 | g71199 | i0 | 70.4 | 1.97560975609756 | 81 | 24 | 98.8 | 0 | 1 | 243 | 41 | 121 | WP_413829086.1 response regulator [Methanobrevibacter sp. UBA412] | diamond | 486 | 129 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. UBA412 | |
| 29908138 | 29908138 | PRJEB83711_P_NODE_44631_length_278_cov_1.502439_g44365_i0 | PRJEB83711 | 44631 | 278 | 1.502439 | 4.17678042 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 116 | 1.6699999999999999e-31 | NR | WP_181693274.1 | 2750669 | g44365 | i0 | 94.9 | 0.636690647482014 | 59 | 3 | 63.7 | 0 | 2 | 178 | 55 | 113 | WP_181693274.1 hypothetical protein [Natronomonas sp. LN261] | diamond | 177 | 116 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 31646027 | 31646027 | PRJEB83711_P_NODE_58597_length_253_cov_0.866667_g58331_i0 | PRJEB83711 | 58597 | 253 | 0.866667 | 2.19266751 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 132 | 3.4199999999999992e-34 | NR | MBO7212323.1 | 66852 | g58331 | i0 | 64.4 | 1.06719367588933 | 90 | 25 | 98.4 | 1 | 251 | 3 | 402 | 491 | MBO7212323.1 peptidoglycan-binding protein [Methanobrevibacter sp.] | diamond | 270 | 132 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31899266 | 31899266 | PRJEB83711_P_NODE_78197_length_242_cov_0.988166_g77931_i0 | PRJEB83711 | 78197 | 242 | 0.988166 | 2.39136172 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 42.7 | 0.0275 | NR | MDH4123785.1 | 1906666 | g77931 | i0 | 40.5 | 0.45867768595041303 | 37 | 22 | 45.9 | 0 | 187 | 77 | 46 | 82 | MDH4123785.1 phosphoesterase [Thermoplasmata archaeon] | diamond | 111 | 42.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32342465 | 32342465 | PRJEB83711_P_NODE_60119_length_252_cov_0.871508_g59853_i0 | PRJEB83711 | 60119 | 252 | 0.871508 | 2.19620016 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 151 | 8.459999999999998e-42 | NR | MBR2558764.1 | 66852 | g59853 | i0 | 92.8 | 1.97619047619048 | 83 | 6 | 98.8 | 0 | 2 | 250 | 260 | 342 | MBR2558764.1 lysine--tRNA ligase [Methanobrevibacter sp.] | diamond | 498 | 151 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32595300 | 32595300 | PRJEB83711_P_NODE_76840_length_243_cov_0.917647_g76574_i0 | PRJEB83711 | 76840 | 243 | 0.917647 | 2.22988221 | Methanosarcina sp. UBA5 | 1915593 | Archaea | Archaea | 48.9 | 5.57e-5 | NR | WP_292387852.1 | 1915593 | g76574 | i0 | 88 | 0.308641975308642 | 25 | 3 | 30.9 | 0 | 87 | 161 | 98 | 122 | WP_292387852.1 DDE-type integrase/transposase/recombinase, partial [Methanosarcina sp. UBA5] | diamond | 75 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. UBA5 |
Advanced export
JSON shape: default, array, newline-delimited
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);;