contig_metadata
12 rows where bioproject = "PRJEB83711" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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);;