contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 711791 | 711791 | PRJNA725806_P_NODE_180261_length_156_cov_0.983193_g179959_i0 | PRJNA725806 | 180261 | 156 | 0.983193 | 1.53378108 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 171 | 3.399999999999999e-38 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g179959 | i0 | 86.538 | 3.75 | 156 | 19 | 99 | 2 | 2 | 156 | 754823 | 754977 | Halalkalicoccus jeotgali B3, complete genome | blastn | 585 | 171 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 3263119 | 3263119 | PRJNA725806_P_NODE_185223_length_154_cov_1.333333_g184921_i0 | PRJNA725806 | 185223 | 154 | 1.333333 | 2.05333282 | Haloglomus salinum | 2962673 | Archaea | Archaea | 156 | 9.359999999999999e-34 | NTclustered | gi|2273560668|gb|CP101153.1| | 2962673 | g184921 | i0 | 85.333 | 9.29220779220779 | 150 | 22 | 97 | 0 | 3 | 152 | 2832754 | 2832903 | Haloglomus salinum strain ZY58 chromosome, complete genome | blastn | 1431 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus salinum | |
| 4540129 | 4540129 | PRJNA725806_P_NODE_13164_length_351_cov_7.662420_g12874_i0 | PRJNA725806 | 13164 | 351 | 7.66242 | 26.8950942 | Candidatus Methanophaga sp. ANME-1 ERB7 | 2759913 | Archaea | Archaea | 52.8 | 0.033 | NTclustered | gi|1899284429|gb|MT631630.1| | 2759913 | g12874 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 84 | 111 | 9111 | 9138 | Candidatus Methanophaga sp. ANME-1 ERB7 clone GZfos33E4_3436646 seq_00001 genomic sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. ANME-1 ERB7 | |
| 4540326 | 4540326 | PRJNA725806_P_NODE_49184_length_250_cov_1.671362_g48887_i0 | PRJNA725806 | 49184 | 250 | 1.671362 | 4.178405 | Methanolapillus ohkumae | 3028298 | Archaea | Archaea | 60.2 | 1.35e-4 | NTclustered | gi|2591778106|gb|CP131061.1| | 3028298 | g48887 | i0 | 100 | 0.128 | 32 | 0 | 13 | 0 | 73 | 104 | 375132 | 375101 | Methanolapillus ohkumae strain Am2 chromosome, complete genome | blastn | 32 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolapillus | Methanolapillus ohkumae | |
| 5815438 | 5815438 | PRJNA725806_P_NODE_190905_length_152_cov_1.000000_g190603_i0 | PRJNA725806 | 190905 | 152 | 1 | 1.52 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 86.1 | 1.23e-12 | NTclustered | gi|1434708495|gb|CP031148.1| | 1547898 | g190603 | i0 | 79.104 | 2.25 | 134 | 20 | 86 | 8 | 1 | 130 | 541090 | 540961 | Haloplanus rubicundus strain CBA1112 chromosome, complete genome | blastn | 342 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 5815578 | 5815578 | PRJNA725806_P_NODE_74005_length_219_cov_3.917582_g73704_i0 | PRJNA725806 | 74005 | 219 | 3.917582 | 8.57950458 | Haladaptatus pallidirubidus | 1008152 | Archaea | Archaea | 52.8 | 0.019 | NTclustered | gi|2126652605|gb|CP085303.1| | 1008152 | g73704 | i0 | 96.875 | 0.146118721461187 | 32 | 0 | 15 | 1 | 107 | 138 | 210022 | 209992 | Haladaptatus pallidirubidus strain YIM 93656 plasmid unnamed2, complete sequence | blastn | 32 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus pallidirubidus | |
| 7090505 | 7090505 | PRJNA725806_P_NODE_131686_length_178_cov_1.099291_g131384_i0 | PRJNA725806 | 131686 | 178 | 1.099291 | 1.95673798 | Haloprofundus sp. MHR1 | 2572921 | Archaea | Archaea | 135 | 1.4500000000000002e-27 | NTclustered | gi|1633225932|gb|CP039833.1| | 2572921 | g131384 | i0 | 80.663 | 15.7865168539326 | 181 | 29 | 100 | 5 | 1 | 178 | 2243185 | 2243008 | Haloprofundus sp. MHR1 chromosome, complete genome | blastn | 2810 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus sp. MHR1 | |
| 8365306 | 8365306 | PRJNA725806_P_NODE_90127_length_205_cov_1.380952_g89825_i0 | PRJNA725806 | 90127 | 205 | 1.380952 | 2.8309516 | Haladaptatus salinisoli | 2884876 | Archaea | Archaea | 143 | 1.03e-29 | NTclustered | gi|2124061132|gb|CP085327.1| | 2884876 | g89825 | i0 | 80.769 | 1.18536585365854 | 182 | 35 | 89 | 0 | 24 | 205 | 1198173 | 1197992 | Haladaptatus salinisoli strain PSR8 chromosome, complete genome | blastn | 243 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus salinisoli | |
| 11398147 | 11398147 | PRJNA725806_P_NODE_73249_length_220_cov_2.092896_g72948_i0 | PRJNA725806 | 73249 | 220 | 2.092896 | 4.6043712 | Halobacteriales | 2235 | Archaea | Archaea | 407 | 3.61e-109 | NTclustered | gi|1041620905|dbj|AP017571.1| | 29284 | g72948 | i0 | 100 | 53.0772727272727 | 220 | 0 | 100 | 0 | 1 | 220 | 77458 | 77239 | Halorubrum trapanicum plasmid pCBA1232-02 DNA, complete genome, strain: CBA1232 | blastn | 11677 | 407 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 17289802 | 17289802 | PRJNA725806_P_NODE_154114_length_167_cov_1.200000_g153812_i0 | PRJNA725806 | 154114 | 167 | 1.2 | 2.004 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 150 | 4.83e-32 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g153812 | i0 | 83.333 | 3.01796407185629 | 168 | 22 | 99 | 5 | 1 | 165 | 562599 | 562763 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 504 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 17289828 | 17289828 | PRJNA725806_P_NODE_169894_length_160_cov_1.268293_g169592_i0 | PRJNA725806 | 169894 | 160 | 1.268293 | 2.0292688 | Haloterrigena turkmenica | 62320 | Archaea | Archaea | 257 | 2.62e-64 | NTclustered | gi|284017614|gb|CP001863.1| | 543526 | g169592 | i0 | 95.625 | 7 | 160 | 7 | 100 | 0 | 1 | 160 | 94913 | 94754 | Haloterrigena turkmenica DSM 5511 plasmid pHTUR03, complete sequence | blastn | 1120 | 257 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena turkmenica | |
| 21114365 | 21114365 | PRJNA725806_P_NODE_151897_length_168_cov_1.473282_g151595_i0 | PRJNA725806 | 151897 | 168 | 1.473282 | 2.47511376 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 163 | 6.25e-36 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g151595 | i0 | 84.431 | 18.4702380952381 | 167 | 25 | 99 | 1 | 3 | 168 | 2467177 | 2467011 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 3103 | 163 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 22389181 | 22389181 | PRJNA725806_P_NODE_132338_length_177_cov_5.278571_g132036_i0 | PRJNA725806 | 132338 | 177 | 5.278571 | 9.34307067 | Halorussus vallis | 2953749 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|2263970334|gb|CP100001.1| | 2953749 | g132036 | i0 | 89.362 | 1.1864406779661 | 47 | 2 | 25 | 3 | 54 | 98 | 6906 | 6951 | Halorussus vallis strain XZYJT10 plasmid unnamed1, complete sequence | blastn | 210 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 23664831 | 23664831 | PRJNA725806_P_NODE_169979_length_160_cov_1.252033_g169677_i0 | PRJNA725806 | 169979 | 160 | 1.252033 | 2.0032528 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 143 | 7.649999999999998e-30 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g169677 | i0 | 84.247 | 0.9125 | 146 | 23 | 91 | 0 | 1 | 146 | 1403856 | 1404001 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 146 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 23664921 | 23664921 | PRJNA725806_P_NODE_3859_length_471_cov_4.474654_g3591_i0 | PRJNA725806 | 3859 | 471 | 4.474654 | 21.07562034 | Natrialba magadii | 13769 | Archaea | Archaea | 63.9 | 2.12e-5 | NTclustered | gi|289529249|gb|CP001932.1| | 547559 | g3591 | i0 | 97.297 | 27.0403397027601 | 37 | 1 | 8 | 0 | 198 | 234 | 1141208 | 1141172 | Natrialba magadii ATCC 43099, complete sequence | blastn | 12736 | 63.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba magadii | |
| 23664937 | 23664937 | PRJNA725806_P_NODE_44259_length_258_cov_1.733032_g43962_i0 | PRJNA725806 | 44259 | 258 | 1.733032 | 4.47122256 | Methanosarcina hadiensis | 3078083 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2878048566|gb|CP136241.1| | 3078083 | g43962 | i0 | 96.97 | 0.127906976744186 | 33 | 1 | 13 | 0 | 3 | 35 | 4335704 | 4335736 | Methanosarcina hadiensis strain TD41E1-1 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina hadiensis | |
| 24145903 | 24145903 | PRJNA725806_P_NODE_156019_length_166_cov_1.720930_g155717_i0 | PRJNA725806 | 156019 | 166 | 1.72093 | 2.8567438 | root | 1 | Root_unresolved | Root_unresolved | 200 | 4.69e-47 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g155717 | i0 | 95.968 | 132.759036144578 | 124 | 4 | 74 | 1 | 44 | 166 | 3117924 | 3118047 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 22038 | 200 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 24938270 | 24938270 | PRJNA725806_P_NODE_156160_length_166_cov_1.472868_g155858_i0 | PRJNA725806 | 156160 | 166 | 1.472868 | 2.44496088 | Halobaculum halobium | 3032281 | Archaea | Archaea | 156 | 1.03e-33 | NTclustered | gi|2511738010|gb|CP126158.1| | 3032281 | g155858 | i0 | 84.049 | 0.981927710843373 | 163 | 24 | 98 | 2 | 2 | 163 | 1108968 | 1109129 | Halobaculum halobium strain SYNS20 chromosome, complete genome | blastn | 163 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum halobium | |
| 24938373 | 24938373 | PRJNA725806_P_NODE_38700_length_268_cov_1.930736_g38403_i0 | PRJNA725806 | 38700 | 268 | 1.930736 | 5.17437248 | Methanosarcina mazei | 2209 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|805369809|gb|CP009513.1| | 1434114 | g38403 | i0 | 100 | 0.104477611940299 | 28 | 0 | 10 | 0 | 141 | 168 | 3173522 | 3173549 | Methanosarcina mazei LYC, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei |
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);;