contig_metadata
19 rows where bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4003781 | 4003781 | PRJNA1059246_P_NODE_61504_length_251_cov_1.235955_g60878_i0 | PRJNA1059246 | 61504 | 251 | 1.235955 | 3.10224705 | Haloferacaceae archaeon | 2080321 | Archaea | Archaea | 109 | 3.82e-28 | NR | MFB6154400.1 | 2080321 | g60878 | i0 | 62.7 | 1.9840637450199201 | 83 | 30 | 99.2 | 1 | 249 | 1 | 52 | 133 | MFB6154400.1 peptide-methionine (S)-S-oxide reductase MsrA [Haloferacaceae archaeon] | diamond | 498 | 109 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon | ||
| 5279564 | 5279564 | PRJNA1059246_P_NODE_19925_length_510_cov_2.151030_g19307_i0 | PRJNA1059246 | 19925 | 510 | 2.15103 | 10.970253 | Haloterrigena salinisoli | 3132747 | Archaea | Archaea | 52.8 | 0.05 | NTclustered | gi|2706837818|gb|CP149787.1| | 3132747 | g19307 | i0 | 100 | 0.0549019607843137 | 28 | 0 | 5 | 0 | 405 | 432 | 831195 | 831168 | Haloterrigena salinisoli strain KLK7 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salinisoli | |
| 10380111 | 10380111 | PRJNA1059246_P_NODE_18769_length_529_cov_2.109649_g18152_i0 | PRJNA1059246 | 18769 | 529 | 2.109649 | 11.16004321 | Haloferax gibbonsii | 35746 | Archaea | Archaea | 60.2 | 3.1e-4 | NTclustered | gi|909826707|gb|CP011949.1| | 35746 | g18152 | i0 | 100 | 0.741020793950851 | 32 | 0 | 6 | 0 | 307 | 338 | 282967 | 282998 | Haloferax gibbonsii strain ARA6 plasmid pHG2, complete sequence | blastn | 392 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax gibbonsii | |
| 10380183 | 10380183 | PRJNA1059246_P_NODE_23529_length_463_cov_1.730769_g22905_i0 | PRJNA1059246 | 23529 | 463 | 1.730769 | 8.01346047 | Methanolapillus ohkumae | 3028298 | Archaea | Archaea | 52.8 | 0.045 | NTclustered | gi|2591778106|gb|CP131061.1| | 3028298 | g22905 | i0 | 100 | 0.060475161987041 | 28 | 0 | 6 | 0 | 256 | 283 | 901472 | 901499 | Methanolapillus ohkumae strain Am2 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolapillus | Methanolapillus ohkumae | |
| 10380309 | 10380309 | PRJNA1059246_P_NODE_33489_length_375_cov_1.003311_g32863_i0 | PRJNA1059246 | 33489 | 375 | 1.003311 | 3.76241625 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g32863 | i0 | 92.308 | 0.104 | 39 | 3 | 10 | 0 | 155 | 193 | 906620 | 906582 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 39 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 16313951 | 16313951 | PRJNA1059246_P_NODE_47833_length_299_cov_0.867257_g47207_i0 | PRJNA1059246 | 47833 | 299 | 0.867257 | 2.59309843 | Halobacterium | 2239 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|573484043|gb|CP007060.1| | 751944 | g47207 | i0 | 100 | 0.193979933110368 | 29 | 0 | 10 | 0 | 44 | 72 | 2343187 | 2343215 | Halobacterium sp. DL1, complete genome | blastn | 58 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 | |
| 16754330 | 16754330 | PRJNA1059246_P_NODE_64634_length_248_cov_1.394286_g64008_i0 | PRJNA1059246 | 64634 | 248 | 1.394286 | 3.45782928 | Haloquadratum walsbyi | 293091 | Archaea | Archaea | 60.2 | 1.34e-4 | NTclustered | gi|109624723|emb|AM180088.1| | 362976 | g64008 | i0 | 100 | 0.491935483870968 | 32 | 0 | 13 | 0 | 1 | 32 | 1275095 | 1275064 | Haloquadratum walsbyi DSM 16790 complete genome | blastn | 122 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 18029156 | 18029156 | PRJNA1059246_P_NODE_68615_length_245_cov_0.895349_g67989_i0 | PRJNA1059246 | 68615 | 245 | 0.895349 | 2.19360505 | Halorussus pelagicus | 2505977 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1560271289|gb|CP035119.1| | 2505977 | g67989 | i0 | 96.774 | 0.126530612244898 | 31 | 1 | 13 | 0 | 75 | 105 | 2317467 | 2317497 | Halorussus pelagicus strain RC-68 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus pelagicus | |
| 18029221 | 18029221 | PRJNA1059246_P_NODE_7975_length_863_cov_2.401266_g7465_i0 | PRJNA1059246 | 7975 | 863 | 2.401266 | 20.72292558 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 58.4 | 0.002 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g7465 | i0 | 94.737 | 0.0440324449594438 | 38 | 0 | 4 | 2 | 566 | 602 | 1318926 | 1318962 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 38 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 19302746 | 19302746 | PRJNA1059246_P_NODE_35596_length_361_cov_1.756944_g34970_i0 | PRJNA1059246 | 35596 | 361 | 1.756944 | 6.34256784 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 54.7 | 0.01 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g34970 | i0 | 100 | 0.0803324099722992 | 29 | 0 | 8 | 0 | 313 | 341 | 649164 | 649136 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 23129165 | 23129165 | PRJNA1059246_P_NODE_22559_length_475_cov_1.067164_g21937_i0 | PRJNA1059246 | 22559 | 475 | 1.067164 | 5.069029 | Natrinema sp. J7-2 | 406552 | Archaea | Archaea | 60.2 | 2.76e-4 | NTclustered | gi|397680883|gb|CP003412.1| | 406552 | g21937 | i0 | 97.143 | 0.642105263157895 | 35 | 1 | 7 | 0 | 270 | 304 | 1516063 | 1516097 | Natrinema sp. J7-2, complete genome | blastn | 305 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. J7-2 | |
| 27825248 | 27825248 | PRJNA1059246_P_NODE_48764_length_294_cov_1.533937_g48138_i0 | PRJNA1059246 | 48764 | 294 | 1.533937 | 4.50977478 | Methanothrix sp. | 90426 | Archaea | Archaea | 52 | 2.87e-5 | NR | NMB86174.1 | 90426 | g48138 | i0 | 49.1 | 0.561224489795918 | 55 | 28 | 56.1 | 0 | 2 | 166 | 48 | 102 | NMB86174.1 tetratricopeptide repeat protein [Methanothrix sp.] | diamond | 165 | 52 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28077581 | 28077581 | PRJNA1059246_P_NODE_37305_length_351_cov_2.093525_g36679_i0 | PRJNA1059246 | 37305 | 351 | 2.093525 | 7.34827275 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 84.3 | 3.16e-16 | NR | RYE85578.1 | 2250255 | g36679 | i0 | 44.4 | 0.923076923076923 | 108 | 54 | 88.9 | 3 | 349 | 38 | 404 | 509 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 324 | 84.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28330265 | 28330265 | PRJNA1059246_P_NODE_67546_length_246_cov_0.890173_g66920_i0 | PRJNA1059246 | 67546 | 246 | 0.890173 | 2.18982558 | Natronoarchaeum rubrum | 755311 | Archaea | Archaea | 60.1 | 1.46e-8 | NR | WP_256393113.1 | 755311 | g66920 | i0 | 54.8 | 1.51219512195122 | 62 | 25 | 74.4 | 2 | 61 | 243 | 4 | 63 | WP_256393113.1 histidine phosphatase family protein [Natronoarchaeum rubrum] | diamond | 372 | 60.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Natronoarchaeum | Natronoarchaeum rubrum | |
| 29151612 | 29151612 | PRJNA1059246_P_NODE_54649_length_275_cov_1.252475_g54023_i0 | PRJNA1059246 | 54649 | 275 | 1.252475 | 3.44430625 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 67 | 9.09e-12 | NR | RYE81919.1 | 2250255 | g54023 | i0 | 42.1 | 0.829090909090909 | 76 | 42 | 81.8 | 2 | 2 | 226 | 34 | 108 | RYE81919.1 MAG: hypothetical protein EOO65_06165 [Methanosarcinales archaeon] | diamond | 228 | 67 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 29372238 | 29372238 | PRJNA1059246_P_NODE_15529_length_593_cov_1.184615_g14929_i0 | PRJNA1059246 | 15529 | 593 | 1.184615 | 7.02476695 | Methanoregula sp. | 2052170 | Archaea | Archaea | 77.8 | 8.44e-13 | NR | MDD1698370.1 | 2052170 | g14929 | i0 | 29.7 | 1.02192242833052 | 202 | 109 | 97.1 | 7 | 591 | 16 | 336 | 514 | MDD1698370.1 GPI anchored serine-threonine rich family protein [Methanoregula sp.] | diamond | 606 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30730489 | 30730489 | PRJNA1059246_P_NODE_47394_length_301_cov_1.013158_g46768_i0 | PRJNA1059246 | 47394 | 301 | 1.013158 | 3.04960558 | Candidatus Methanophagaceae archaeon | 3386247 | Archaea | Archaea | 72.4 | 2.63e-12 | NR | KAF5437882.1 | 3386247 | g46768 | i0 | 48.6 | 0.737541528239203 | 74 | 30 | 73.8 | 2 | 48 | 269 | 137 | 202 | KAF5437882.1 Kazal-type serine protease inhibitor domain-containing protein [Candidatus Methanophagaceae archaeon] | diamond | 222 | 72.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophagaceae archaeon | ||
| 31014877 | 31014877 | PRJNA1059246_P_NODE_58375_length_262_cov_1.539683_g57749_i0 | PRJNA1059246 | 58375 | 262 | 1.539683 | 4.03396946 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 56.2 | 9.2e-8 | NR | NYT06209.1 | 2184052 | g57749 | i0 | 38.2 | 1.54580152671756 | 68 | 42 | 77.9 | 0 | 204 | 1 | 1 | 68 | NYT06209.1 hypothetical protein [Methanomicrobiales archaeon] | diamond | 405 | 56.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 32058462 | 32058462 | PRJNA1059246_P_NODE_46438_length_305_cov_1.793103_g45812_i0 | PRJNA1059246 | 46438 | 305 | 1.793103 | 5.46896415 | Methanogenium marinum | 348610 | Archaea | Archaea | 40.8 | 0.0489 | NR | WP_274923711.1 | 348610 | g45812 | i0 | 43.9 | 0.40327868852459 | 41 | 23 | 40.3 | 0 | 162 | 40 | 7 | 47 | WP_274923711.1 hypothetical protein [Methanogenium marinum] | diamond | 123 | 40.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium marinum |
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);;