contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131074 | 131074 | PRJEB66218_P_NODE_132521_length_259_cov_1.313131_g130092_i0 | PRJEB66218 | 132521 | 259 | 1.313131 | 3.40100929 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g130092 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 194 | 221 | 248049 | 248022 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 131704 | 131704 | PRJEB66218_P_NODE_166481_length_230_cov_0.840237_g164051_i0 | PRJEB66218 | 166481 | 230 | 0.840237 | 1.9325451 | Halorussus limi | 2938695 | Archaea | Archaea | 52.8 | 0.021 | NTclustered | gi|2234300126|gb|CP096659.1| | 2938695 | g164051 | i0 | 96.875 | 0.260869565217391 | 32 | 0 | 13 | 1 | 4 | 34 | 292152 | 292183 | Halorussus limi strain XZYJT49 chromosome, complete genome | blastn | 60 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus limi | |
| 3545050 | 3545050 | PRJEB66218_P_NODE_195203_length_212_cov_1.450331_g192773_i0 | PRJEB66218 | 195203 | 212 | 1.450331 | 3.07470172 | Methanothrix | 2222 | Archaea | Archaea | 392 | 9.67e-105 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g192773 | i0 | 100 | 142.716981132075 | 212 | 0 | 100 | 0 | 1 | 212 | 21 | 232 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 30256 | 392 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 5233649 | 5233649 | PRJEB66218_P_NODE_135645_length_255_cov_3.036082_g133216_i0 | PRJEB66218 | 135645 | 255 | 3.036082 | 7.7420091 | Natronococcus occultus | 29288 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|433671692|gb|CP003929.1| | 694430 | g133216 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 38 | 65 | 510764 | 510737 | Natronococcus occultus SP4, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus occultus | |
| 5236895 | 5236895 | PRJEB66218_P_NODE_78845_length_356_cov_3.657627_g76419_i0 | PRJEB66218 | 78845 | 356 | 3.657627 | 13.02115212 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 542 | 1.64e-149 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g76419 | i0 | 94.101 | 99.6292134831461 | 356 | 21 | 100 | 0 | 1 | 356 | 3127450 | 3127095 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 35468 | 542 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 9060154 | 9060154 | PRJEB66218_P_NODE_244148_length_197_cov_3.227941_g241717_i0 | PRJEB66218 | 244148 | 197 | 3.227941 | 6.35904377 | Haloarcula marina | 2961574 | Archaea | Archaea | 52.8 | 0.017 | NTclustered | gi|2269702776|gb|CP100405.1| | 2961574 | g241717 | i0 | 100 | 0.284263959390863 | 28 | 0 | 14 | 0 | 108 | 135 | 252714 | 252687 | Haloarcula marina strain DT1 plasmid unnamed1, complete sequence | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marina | |
| 12472981 | 12472981 | PRJEB66218_P_NODE_110870_length_288_cov_1.325991_g108441_i0 | PRJEB66218 | 110870 | 288 | 1.325991 | 3.81885408 | Haloplanus | 376170 | Archaea | Archaea | 63.9 | 1.23e-5 | NTclustered | gi|1785199060|gb|CP034345.1| | 1816183 | g108441 | i0 | 95.122 | 5.92361111111111 | 41 | 0 | 14 | 2 | 49 | 87 | 2979690 | 2979650 | Haloplanus rallus strain MBLA0036 chromosome, complete genome | blastn | 1706 | 63.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rallus | |
| 14160412 | 14160412 | PRJEB66218_P_NODE_18512_length_926_cov_167971.856647_g16522_i0 | PRJEB66218 | 18512 | 926 | 167971.856647 | 1555419.39255122 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 1184 | 0 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g16522 | i0 | 95.473 | 189.897408207343 | 751 | 18 | 81 | 10 | 179 | 926 | 3114395 | 3115132 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 175845 | 1184 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 16297492 | 16297492 | PRJEB66218_P_NODE_38153_length_572_cov_6747.238748_g35759_i0 | PRJEB66218 | 38153 | 572 | 6747.238748 | 38594.20563856 | root | 1 | Root_unresolved | Root_unresolved | 878 | 0 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g35759 | i0 | 94.415 | 208.255244755245 | 573 | 28 | 100 | 4 | 1 | 572 | 3117431 | 3118000 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 119122 | 883 | 0.994337485843715 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 16707215 | 16707215 | PRJEB66218_P_NODE_108654_length_291_cov_3.621739_g106225_i0 | PRJEB66218 | 108654 | 291 | 3.621739 | 10.53926049 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 359 | 1.42e-94 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g106225 | i0 | 89.437 | 91.0893470790378 | 284 | 30 | 98 | 0 | 8 | 291 | 3083530 | 3083247 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 26507 | 359 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 17983685 | 17983685 | PRJEB66218_P_NODE_191695_length_214_cov_1.464052_g189265_i0 | PRJEB66218 | 191695 | 214 | 1.464052 | 3.13307128 | Natronobacterium lacisalsi | 229731 | Archaea | Archaea | 52.8 | 0.019 | NTclustered | gi|1134496220|gb|CP019285.1| | 358396 | g189265 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 38 | 65 | 48827 | 48854 | Halobiforma lacisalsi AJ5, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium lacisalsi | |
| 19257427 | 19257427 | PRJEB66218_P_NODE_175476_length_224_cov_1.196319_g173046_i0 | PRJEB66218 | 175476 | 224 | 1.196319 | 2.67975456 | Salinirarus marinus | 3068310 | Archaea | Archaea | 52.8 | 0.02 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g173046 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 124 | 151 | 357306 | 357333 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 19259075 | 19259075 | PRJEB66218_P_NODE_44436_length_517_cov_3.831140_g42025_i0 | PRJEB66218 | 44436 | 517 | 3.83114 | 19.8069938 | Methanobacterium sp. BAmetb5 | 2025351 | Archaea | Archaea | 69.4 | 5.03e-7 | NTclustered | gi|1473089901|gb|CP022706.1| | 2025351 | g42025 | i0 | 91.837 | 2.44100580270793 | 49 | 4 | 9 | 0 | 1 | 49 | 2118621 | 2118669 | MAG: Methanobacterium sp. BAmetb5 chromosome, complete genome | blastn | 1262 | 69.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BAmetb5 | |
| 20120655 | 20120655 | PRJEB66218_P_NODE_125236_length_268_cov_1.130435_g122807_i0 | PRJEB66218 | 125236 | 268 | 1.130435 | 3.0295658 | Methanothrix | 2222 | Archaea | Archaea | 490 | 4.39e-134 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g122807 | i0 | 99.627 | 35.4664179104478 | 268 | 1 | 100 | 0 | 1 | 268 | 1148 | 881 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 9505 | 490 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 22671213 | 22671213 | PRJEB66218_P_NODE_148678_length_242_cov_2.513812_g146249_i0 | PRJEB66218 | 148678 | 242 | 2.513812 | 6.08342504 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.022 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g146249 | i0 | 100 | 0.347107438016529 | 28 | 0 | 12 | 0 | 2 | 29 | 2906133 | 2906160 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum | |
| 22672137 | 22672137 | PRJEB66218_P_NODE_92778_length_321_cov_1.638462_g90350_i0 | PRJEB66218 | 92778 | 321 | 1.638462 | 5.25946302 | root | 1 | Root_unresolved | Root_unresolved | 388 | 2.02e-103 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g90350 | i0 | 88.509 | 97.006230529595 | 322 | 36 | 100 | 1 | 1 | 321 | 3124451 | 3124772 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 31139 | 390 | 0.994871794871795 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 23084463 | 23084463 | PRJEB66218_P_NODE_225059_length_205_cov_1.041667_g222629_i0 | PRJEB66218 | 225059 | 205 | 1.041667 | 2.13541735 | Thermococcus hydrothermalis | 46539 | Archaea | Archaea | 296 | 7.49e-76 | NTclustered | gi|11602744|emb|AJ245819.1| | 46539 | g222629 | i0 | 92.683 | 6.48780487804878 | 205 | 15 | 100 | 0 | 1 | 205 | 5055 | 5259 | Thermococcus hydrothermalis partial DNA polymerase precursor gene for DNA polymerase and endonuclease | blastn | 1330 | 296 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus hydrothermalis | ||
| 25220518 | 25220518 | PRJEB66218_P_NODE_175600_length_224_cov_1.067485_g173170_i0 | PRJEB66218 | 175600 | 224 | 1.067485 | 2.3911664 | root | 1 | Root_unresolved | Root_unresolved | 65.8 | 2.56e-6 | NTclustered | gi|1214545799|gb|CP014862.1| | 49899 | g173170 | i0 | 86.441 | 75.6294642857143 | 59 | 8 | 26 | 0 | 39 | 97 | 410572 | 410514 | Thermococcus profundus strain DT 5432, complete genome | blastn | 16941 | 65.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus profundus |
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);;