contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4597625 | 4597625 | PRJNA788929_P_NODE_31404_length_280_cov_9.004831_g30743_i0 | PRJNA788929 | 31404 | 280 | 9.004831 | 25.2135268 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 158 | 5.309999999999999e-34 | NTclustered | gi|1434708495|gb|CP031148.1| | 1547898 | g30743 | i0 | 88.06 | 5.59642857142857 | 134 | 14 | 48 | 2 | 136 | 268 | 1692101 | 1692233 | Haloplanus rubicundus strain CBA1112 chromosome, complete genome | blastn | 1567 | 158 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 5872698 | 5872698 | PRJNA788929_P_NODE_17285_length_399_cov_7.260736_g16626_i0 | PRJNA788929 | 17285 | 399 | 7.260736 | 28.97033664 | Halosegnis marinus | 3034023 | Archaea | Archaea | 556 | 6.64e-154 | NTclustered | gi|2463595543|gb|CP119802.1| | 3034023 | g16626 | i0 | 95.415 | 125.355889724311 | 349 | 16 | 87 | 0 | 25 | 373 | 1197041 | 1196693 | Halosegnis marinus strain DT85 chromosome, complete genome | blastn | 50017 | 556 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halosegnis | Halosegnis marinus | |
| 7148112 | 7148112 | PRJNA788929_P_NODE_48006_length_211_cov_4.340580_g47345_i0 | PRJNA788929 | 48006 | 211 | 4.34058 | 9.1586238 | Salinigranum rubrum | 755307 | Archaea | Archaea | 148 | 2.3e-31 | NTclustered | gi|1336549475|gb|CP026309.1| | 755307 | g47345 | i0 | 84.615 | 0.739336492890995 | 156 | 17 | 72 | 5 | 39 | 189 | 2504514 | 2504361 | Salinigranum rubrum strain GX10 chromosome, complete genome | blastn | 156 | 148 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 7148127 | 7148127 | PRJNA788929_P_NODE_49246_length_203_cov_6.600000_g48585_i0 | PRJNA788929 | 49246 | 203 | 6.6 | 13.398 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 322 | 1.22e-83 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g48585 | i0 | 98.889 | 179.389162561576 | 180 | 2 | 89 | 0 | 1 | 180 | 1054205 | 1054026 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 36416 | 322 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 8867572 | 8867572 | PRJNA788929_P_NODE_887_length_2109_cov_9.964145_g764_i0 | PRJNA788929 | 887 | 2109 | 9.964145 | 210.14381805 | Halococcus | 2249 | Archaea | Archaea | 3249 | 0 | NTclustered | gi|1476009827|gb|MH194567.1| | 29286 | g764 | i0 | 99.331 | 90.6998577524893 | 1795 | 12 | 85 | 0 | 292 | 2086 | 1 | 1795 | Halococcus sp. strain J81 RNA polymerase subunit B' (rpoB') gene, complete cds | blastn | 191286 | 3249 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 9697712 | 9697712 | PRJNA788929_P_NODE_33448_length_270_cov_9.796954_g32787_i0 | PRJNA788929 | 33448 | 270 | 9.796954 | 26.4517758 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 187 | 6.4999999999999984e-43 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g32787 | i0 | 81.778 | 4.91851851851852 | 225 | 39 | 83 | 2 | 24 | 247 | 2140962 | 2141185 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 1328 | 187 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 9697830 | 9697830 | PRJNA788929_P_NODE_40228_length_246_cov_0.890173_g39567_i0 | PRJNA788929 | 40228 | 246 | 0.890173 | 2.18982558 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 196 | 9.7e-46 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g39567 | i0 | 81.781 | 1.00406504065041 | 247 | 33 | 98 | 10 | 2 | 242 | 1711412 | 1711652 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 247 | 196 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 9697867 | 9697867 | PRJNA788929_P_NODE_42488_length_241_cov_1.428571_g41827_i0 | PRJNA788929 | 42488 | 241 | 1.428571 | 3.44285611 | Natrinema sp. DC36 | 2878680 | Archaea | Archaea | 161 | 3.45e-35 | NTclustered | gi|2110956531|gb|CP084472.1| | 2878680 | g41827 | i0 | 84.524 | 79.0373443983403 | 168 | 20 | 68 | 6 | 1 | 165 | 3472066 | 3471902 | Natrinema sp. DC36 chromosome, complete genome | blastn | 19048 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. DC36 | |
| 10973538 | 10973538 | PRJNA788929_P_NODE_40389_length_245_cov_12.750000_g39728_i0 | PRJNA788929 | 40389 | 245 | 12.75 | 31.2375 | Haloferax gibbonsii | 35746 | Archaea | Archaea | 215 | 2.67e-51 | NTclustered | gi|909826324|gb|CP011948.1| | 35746 | g39728 | i0 | 85.507 | 6.51836734693878 | 207 | 28 | 84 | 2 | 17 | 222 | 148579 | 148374 | Haloferax gibbonsii strain ARA6 plasmid pHG1, complete sequence | blastn | 1597 | 215 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax gibbonsii | |
| 10973573 | 10973573 | PRJNA788929_P_NODE_42109_length_242_cov_0.911243_g41448_i0 | PRJNA788929 | 42109 | 242 | 0.911243 | 2.20520806 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 420 | 5.19e-113 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g41448 | i0 | 97.934 | 19.8223140495868 | 242 | 5 | 100 | 0 | 1 | 242 | 60079 | 59838 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 4797 | 420 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 12693786 | 12693786 | PRJNA788929_P_NODE_1410_length_1751_cov_55.284863_g1224_i0 | PRJNA788929 | 1410 | 1751 | 55.284863 | 968.03795113 | Halococcus | 2249 | Archaea | Archaea | 2769 | 0 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g1224 | i0 | 95.909 | 159.896630496859 | 1711 | 66 | 98 | 2 | 21 | 1728 | 209922 | 211631 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 279979 | 2769 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 12694045 | 12694045 | PRJNA788929_P_NODE_4510_length_950_cov_42.615735_g3982_i0 | PRJNA788929 | 4510 | 950 | 42.615735 | 404.8494825 | Halococcus | 2249 | Archaea | Archaea | 1319 | 0 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g3982 | i0 | 92.672 | 149.690526315789 | 928 | 49 | 96 | 9 | 24 | 934 | 128182 | 129107 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 142206 | 1319 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 13523002 | 13523002 | PRJNA788929_P_NODE_23171_length_335_cov_24.320611_g22510_i0 | PRJNA788929 | 23171 | 335 | 24.320611 | 81.47404685 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 449 | 9.59e-122 | NTclustered | gi|299126453|gb|CP002064.1| | 795797 | g22510 | i0 | 92.628 | 7.7910447761194 | 312 | 23 | 93 | 0 | 9 | 320 | 139680 | 139369 | Halalkalicoccus jeotgali B3 plasmid 2, complete sequence | blastn | 2610 | 449 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 14797705 | 14797705 | PRJNA788929_P_NODE_13032_length_476_cov_31.473945_g12375_i0 | PRJNA788929 | 13032 | 476 | 31.473945 | 149.8159782 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 58.4 | 0.001 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g12375 | i0 | 97.059 | 0.203781512605042 | 34 | 1 | 7 | 0 | 206 | 239 | 4110281 | 4110248 | Methanosarcina sp. MTP4, complete genome | blastn | 97 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 17792122 | 17792122 | PRJNA788929_P_NODE_7394_length_690_cov_20.517018_g6757_i0 | PRJNA788929 | 7394 | 690 | 20.517018 | 141.5674242 | Halococcus | 2249 | Archaea | Archaea | 1197 | 0 | NTclustered | gi|1784196379|gb|MN826726.1| | 29286 | g6757 | i0 | 99.847 | 94.0724637681159 | 652 | 0 | 94 | 1 | 17 | 667 | 908 | 257 | Halococcus sp. strain J162 16S ribosomal RNA gene, partial sequence | blastn | 64910 | 1197 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 18620829 | 18620829 | PRJNA788929_P_NODE_27815_length_301_cov_7.754386_g27154_i0 | PRJNA788929 | 27815 | 301 | 7.754386 | 23.34070186 | Salinarchaeum sp. Harcht-Bsk1 | 1333523 | Archaea | Archaea | 289 | 1.96e-73 | NTclustered | gi|507914357|gb|CP005962.1| | 1333523 | g27154 | i0 | 86.641 | 34.7176079734219 | 262 | 34 | 87 | 1 | 31 | 291 | 865815 | 865554 | Salinarchaeum sp. Harcht-Bsk1, complete genome | blastn | 10450 | 289 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. Harcht-Bsk1 | |
| 20340654 | 20340654 | PRJNA788929_P_NODE_31856_length_278_cov_2.887805_g31195_i0 | PRJNA788929 | 31856 | 278 | 2.887805 | 8.0280979 | Halobacteriales | 2235 | Archaea | Archaea | 233 | 8.51e-57 | NTclustered | gi|335339674|gb|CP002840.1| | 797210 | g31195 | i0 | 85.398 | 5.65467625899281 | 226 | 31 | 81 | 2 | 32 | 256 | 372295 | 372071 | Halopiger xanaduensis SH-6 plasmid pHALXA01, complete genome | blastn | 1572 | 233 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halopiger | Halopiger xanaduensis | |
| 22446675 | 22446675 | PRJNA788929_P_NODE_30698_length_284_cov_8.331754_g30037_i0 | PRJNA788929 | 30698 | 284 | 8.331754 | 23.66218136 | Halovivax gelatinilyticus | 2961597 | Archaea | Archaea | 169 | 2.5e-37 | NTclustered | gi|2273668750|gb|CP101322.1| | 2961597 | g30037 | i0 | 82.09 | 6.33450704225352 | 201 | 32 | 70 | 4 | 53 | 251 | 2432734 | 2432536 | Halovivax gelatinilyticus strain CGA30 chromosome, complete genome | blastn | 1799 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax gelatinilyticus | |
| 24995925 | 24995925 | PRJNA788929_P_NODE_33440_length_270_cov_11.213198_g32779_i0 | PRJNA788929 | 33440 | 270 | 11.213198 | 30.2756346 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 228 | 3.8299999999999994e-55 | NTclustered | gi|2221493270|gb|CP095009.1| | 179637 | g32779 | i0 | 84.889 | 0.833333333333333 | 225 | 34 | 83 | 0 | 7 | 231 | 110348 | 110124 | Halococcus dombrowskii strain H4 plasmid unnamed4, complete sequence | blastn | 225 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 24996266 | 24996266 | PRJNA788929_P_NODE_9220_length_598_cov_4.737143_g8569_i0 | PRJNA788929 | 9220 | 598 | 4.737143 | 28.32811514 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 473 | 1.07e-128 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g8569 | i0 | 85.777 | 62.7859531772575 | 457 | 53 | 75 | 7 | 139 | 586 | 2278778 | 2278325 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 37546 | 473 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis |
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);;