contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2707168 | 2707168 | PRJNA1011844_P_NODE_29063_length_980_cov_18.964719_g22509_i0 | PRJNA1011844 | 29063 | 980 | 18.964719 | 185.8542462 | Haloarcula ordinaria | 3033390 | Archaea | Archaea | 54.7 | 0.028 | NTclustered | gi|2463595535|gb|CP119789.1| | 3033390 | g22509 | i0 | 94.286 | 0.0357142857142857 | 35 | 2 | 4 | 0 | 193 | 227 | 1185698 | 1185732 | Haloarcula ordinaria strain ZS-22-S1 chromosome, complete genome | blastn | 35 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula ordinaria | |
| 4830429 | 4830429 | PRJNA1011844_P_NODE_98204_length_332_cov_3.389961_g89640_i0 | PRJNA1011844 | 98204 | 332 | 3.389961 | 11.25467052 | root | 1 | Root_unresolved | Root_unresolved | 377 | 4.54e-100 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g89640 | i0 | 91.606 | 38.9728915662651 | 274 | 22 | 82 | 1 | 9 | 281 | 3147116 | 3146843 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 12939 | 377 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 7810425 | 7810425 | PRJNA1011844_P_NODE_88267_length_365_cov_4.883562_g79714_i0 | PRJNA1011844 | 88267 | 365 | 4.883562 | 17.8250013 | Halapricum desulfuricans | 2841257 | Archaea | Archaea | 54.7 | 0.01 | NTclustered | gi|1995635729|gb|CP064789.1| | 2841257 | g79714 | i0 | 100 | 0.235616438356164 | 29 | 0 | 8 | 0 | 124 | 152 | 1557793 | 1557821 | Halapricum desulfuricans strain HSR-Bgl chromosome, complete genome | blastn | 86 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 7810484 | 7810484 | PRJNA1011844_P_NODE_92467_length_350_cov_3.898917_g83908_i0 | PRJNA1011844 | 92467 | 350 | 3.898917 | 13.6462095 | Haloarcula taiwanensis | 1932004 | Archaea | Archaea | 52.8 | 0.033 | NTclustered | gi|1315059818|gb|CP019154.1| | 1932004 | g83908 | i0 | 100 | 0.08 | 28 | 0 | 8 | 0 | 254 | 281 | 341882 | 341909 | Haloarcula taiwanensis strain Taiwanensis chromosome I, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula taiwanensis | |
| 9083725 | 9083725 | PRJNA1011844_P_NODE_144168_length_252_cov_5.888268_g135590_i0 | PRJNA1011844 | 144168 | 252 | 5.888268 | 14.83843536 | Natronomonas salina | 1710540 | Archaea | Archaea | 58.4 | 4.91e-4 | NTclustered | gi|1865519430|gb|CP058335.1| | 1710540 | g135590 | i0 | 100 | 0.123015873015873 | 31 | 0 | 12 | 0 | 151 | 181 | 2926015 | 2925985 | Natronomonas salina strain YPL13 chromosome, complete genome | blastn | 31 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas salina | |
| 10359508 | 10359508 | PRJNA1011844_P_NODE_155689_length_244_cov_3.812865_g147109_i0 | PRJNA1011844 | 155689 | 244 | 3.812865 | 9.3033906 | Salinigranum marinum | 1515595 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|2270305257|gb|CP100461.1| | 1515595 | g147109 | i0 | 100 | 0.118852459016393 | 29 | 0 | 12 | 0 | 101 | 129 | 2403036 | 2403008 | Salinigranum marinum strain ZS-10 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum marinum | |
| 14185515 | 14185515 | PRJNA1011844_P_NODE_3112_length_2841_cov_10.548410_g2090_i0 | PRJNA1011844 | 3112 | 2841 | 10.54841 | 299.6803281 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 56.5 | 0.023 | NTclustered | gi|1434708495|gb|CP031148.1| | 1547898 | g2090 | i0 | 92.683 | 0.0288630763815558 | 41 | 0 | 1 | 3 | 473 | 511 | 180841 | 180880 | Haloplanus rubicundus strain CBA1112 chromosome, complete genome | blastn | 82 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 16304773 | 16304773 | PRJNA1011844_P_NODE_76893_length_414_cov_22.627566_g68389_i0 | PRJNA1011844 | 76893 | 414 | 22.627566 | 93.67812324 | Halobacteriales | 2235 | Archaea | Archaea | 54.7 | 0.011 | NTclustered | gi|1804090075|gb|CP048032.1| | 1071085 | g68389 | i0 | 100 | 0.210144927536232 | 29 | 0 | 7 | 0 | 220 | 248 | 2727883 | 2727855 | Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome | blastn | 87 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | haloarchaeon 3A1-DGR | |||
| 16733277 | 16733277 | PRJNA1011844_P_NODE_15734_length_1438_cov_12.373626_g11513_i0 | PRJNA1011844 | 15734 | 1438 | 12.373626 | 177.93274188 | Natrinema marinum | 2961598 | Archaea | Archaea | 54.7 | 0.041 | NTclustered | gi|2273363723|gb|CP100763.1| | 2961598 | g11513 | i0 | 100 | 0.0201668984700974 | 29 | 0 | 2 | 0 | 285 | 313 | 2947973 | 2948001 | Natrinema marinum strain DT87 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema marinum | |
| 18008141 | 18008141 | PRJNA1011844_P_NODE_15735_length_1438_cov_12.222711_g11513_i1 | PRJNA1011844 | 15735 | 1438 | 12.222711 | 175.76258418 | Natrinema marinum | 2961598 | Archaea | Archaea | 54.7 | 0.041 | NTclustered | gi|2273363723|gb|CP100763.1| | 2961598 | g11513 | i1 | 100 | 0.0201668984700974 | 29 | 0 | 2 | 0 | 285 | 313 | 2947973 | 2948001 | Natrinema marinum strain DT87 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema marinum | |
| 19283600 | 19283600 | PRJNA1011844_P_NODE_9876_length_1800_cov_48.368269_g7009_i0 | PRJNA1011844 | 9876 | 1800 | 48.368269 | 870.628842 | Salinirarus marinus | 3068310 | Archaea | Archaea | 58.4 | 0.004 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g7009 | i0 | 94.737 | 0.0211111111111111 | 38 | 1 | 2 | 1 | 1175 | 1211 | 806260 | 806297 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 38 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 23110142 | 23110142 | PRJNA1011844_P_NODE_87239_length_369_cov_5.209459_g78688_i0 | PRJNA1011844 | 87239 | 369 | 5.209459 | 19.22290371 | Haloferax larsenii | 302484 | Archaea | Archaea | 52.8 | 0.035 | NTclustered | gi|2288350906|gb|CP078063.1| | 302484 | g78688 | i0 | 100 | 0.0758807588075881 | 28 | 0 | 8 | 0 | 32 | 59 | 162567 | 162594 | Haloferax larsenii strain NCIM 5678 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax larsenii | |
| 24383566 | 24383566 | PRJNA1011844_P_NODE_62360_length_507_cov_14.382488_g53948_i0 | PRJNA1011844 | 62360 | 507 | 14.382488 | 72.91921416 | Natrinema marinum | 2961598 | Archaea | Archaea | 56.5 | 0.004 | NTclustered | gi|2273363723|gb|CP100763.1| | 2961598 | g53948 | i0 | 100 | 0.0591715976331361 | 30 | 0 | 6 | 0 | 220 | 249 | 2948002 | 2947973 | Natrinema marinum strain DT87 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema 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);;