contig_metadata
24 rows where bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1198277 | 1198277 | PRJNA743294_P_NODE_13461_length_435_cov_4.477901_g13005_i0 | PRJNA743294 | 13461 | 435 | 4.477901 | 19.47886935 | Methanosarcina | 2207 | Archaea | Archaea | 732 | 0 | NTclustered | gi|2047643091|dbj|AP019780.1| | 2209 | g13005 | i0 | 97.011 | 223.76091954023 | 435 | 13 | 100 | 0 | 1 | 435 | 2736599 | 2737033 | Methanosarcina mazei TMA DNA, complete genome | blastn | 97336 | 732 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 1198313 | 1198313 | PRJNA743294_P_NODE_33481_length_290_cov_1.142857_g33025_i0 | PRJNA743294 | 33481 | 290 | 1.142857 | 3.3142853 | Methanosarcina | 2207 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g33025 | i0 | 91.892 | 0.255172413793103 | 37 | 3 | 13 | 0 | 104 | 140 | 3968026 | 3967990 | Methanosarcina sp. Kolksee, complete genome | blastn | 74 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 8851317 | 8851317 | PRJNA743294_P_NODE_18447_length_376_cov_3.029703_g17991_i0 | PRJNA743294 | 18447 | 376 | 3.029703 | 11.39168328 | Methanosarcina | 2207 | Archaea | Archaea | 628 | 1.2999999999999994e-175 | NTclustered | gi|805339246|gb|CP009504.1| | 1434102 | g17991 | i0 | 97.059 | 228.186170212766 | 374 | 10 | 99 | 1 | 3 | 376 | 43940 | 43568 | Methanosarcina sp. WH1, complete genome | blastn | 85798 | 628 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. WH1 | |
| 10126985 | 10126985 | PRJNA743294_P_NODE_13788_length_430_cov_3.546218_g13332_i0 | PRJNA743294 | 13788 | 430 | 3.546218 | 15.2487374 | Methanosarcina | 2207 | Archaea | Archaea | 580 | 4.2799999999999996e-161 | NTclustered | gi|1491786200|gb|CP032683.1| | 1715806 | g13332 | i0 | 96.839 | 185 | 348 | 10 | 100 | 1 | 83 | 430 | 464014 | 463668 | Methanosarcina flavescens strain E03.2 chromosome, complete genome | blastn | 79550 | 580 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina flavescens | |
| 12677926 | 12677926 | PRJNA743294_P_NODE_32970_length_291_cov_3.330275_g32514_i0 | PRJNA743294 | 32970 | 291 | 3.330275 | 9.69110025 | Methanosarcina | 2207 | Archaea | Archaea | 499 | 8.01e-137 | NTclustered | gi|805384997|gb|CP009517.1| | 1434107 | g32514 | i0 | 97.595 | 213.838487972509 | 291 | 7 | 100 | 0 | 1 | 291 | 56203 | 56493 | Methanosarcina barkeri 3, complete genome | blastn | 62227 | 499 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 13952262 | 13952262 | PRJNA743294_P_NODE_28611_length_310_cov_2.341772_g28155_i0 | PRJNA743294 | 28611 | 310 | 2.341772 | 7.2594932 | root | 1 | Root_unresolved | Root_unresolved | 573 | 4.999999999999998e-159 | NTclustered | gi|1808683266|gb|MT052672.1| | 2213 | g28155 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 344 | 653 | Methanosarcina sp. strain WLC-01 16S ribosomal RNA gene, partial sequence | blastn | 31000 | 573 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 14750987 | 14750987 | PRJNA743294_P_NODE_37752_length_275_cov_2.970297_g37296_i0 | PRJNA743294 | 37752 | 275 | 2.970297 | 8.16831675 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 243 | 1.4000000000000001e-59 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g37296 | i0 | 82.847 | 51.1018181818182 | 274 | 43 | 99 | 4 | 2 | 273 | 3650033 | 3650304 | Methanosarcina sp. MTP4, complete genome | blastn | 14053 | 243 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 19849140 | 19849140 | PRJNA743294_P_NODE_44676_length_256_cov_2.934426_g44220_i0 | PRJNA743294 | 44676 | 256 | 2.934426 | 7.51213056 | Methanosarcina siciliae | 38027 | Archaea | Archaea | 159 | 1.33e-34 | NTclustered | gi|805346097|gb|CP009506.1| | 1434120 | g44220 | i0 | 79.008 | 2.609375 | 262 | 34 | 100 | 11 | 1 | 256 | 458725 | 458971 | Methanosarcina siciliae T4/M, complete genome | blastn | 668 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina siciliae | |
| 21600551 | 21600551 | PRJNA743294_P_NODE_59817_length_223_cov_4.313333_g59361_i0 | PRJNA743294 | 59817 | 223 | 4.313333 | 9.61873259 | root | 1 | Root_unresolved | Root_unresolved | 399 | 6.139999999999999e-107 | NTclustered | gi|313766567|gb|HQ591417.1| | 2208 | g59361 | i0 | 99.099 | 113.511210762332 | 222 | 2 | 99 | 0 | 2 | 223 | 1105 | 884 | Methanosarcina barkeri strain TR-Z13 16S ribosomal RNA gene, partial sequence | blastn | 25313 | 399 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 27663106 | 27663106 | PRJNA743294_P_NODE_53144_length_245_cov_1.779070_g52688_i0 | PRJNA743294 | 53144 | 245 | 1.77907 | 4.3587215 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00777 | NR | WP_052725692.1 | 2208 | g52688 | i0 | 40 | 7.67755102040816 | 60 | 35 | 73.5 | 1 | 192 | 13 | 82 | 140 | WP_052725692.1 PKD domain-containing protein [Methanosarcina barkeri] | diamond | 1881 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 28252724 | 28252724 | PRJNA743294_P_NODE_45306_length_255_cov_1.510989_g44850_i0 | PRJNA743294 | 45306 | 255 | 1.510989 | 3.85302195 | Natronolimnohabitans sp. A-GB9 | 3069757 | Archaea | Archaea | 67.4 | 8.81e-11 | NR | WP_306759904.1 | 3069757 | g44850 | i0 | 54.1 | 0.870588235294118 | 74 | 29 | 87.1 | 3 | 2 | 223 | 316 | 384 | WP_306759904.1 GH32 C-terminal domain-containing protein [Natronolimnohabitans sp. A-GB9] | diamond | 222 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronolimnohabitans | Natronolimnohabitans sp. A-GB9 | |
| 28347477 | 28347477 | PRJNA743294_P_NODE_2766_length_893_cov_2.665854_g2425_i0 | PRJNA743294 | 2766 | 893 | 2.665854 | 23.80607622 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.3 | 4.58e-9 | NR | HNJ81026.1 | 2485498 | g2425 | i0 | 53.3 | 0.201567749160134 | 60 | 26 | 20.2 | 1 | 788 | 609 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 28452455 | 28452455 | PRJNA743294_P_NODE_5166_length_673_cov_2.315000_g4723_i0 | PRJNA743294 | 5166 | 673 | 2.315 | 15.57995 | root | 1 | Root_unresolved | Root_unresolved | 166 | 3.02e-43 | NR | OPX78749.1 | 1811685 | g4723 | i0 | 45 | 1.97473997028232 | 222 | 108 | 97.6 | 7 | 11 | 667 | 1539 | 1749 | OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039] | diamond | 1329 | 166 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaB.Bin039 | |
| 28515497 | 28515497 | PRJNA743294_P_NODE_23867_length_336_cov_1.650190_g23411_i0 | PRJNA743294 | 23867 | 336 | 1.65019 | 5.5446384 | root | 1 | Root_unresolved | Root_unresolved | 104 | 5.11e-25 | NR | RLG24560.1 | 2250255 | g23411 | i0 | 52.3 | 2.91964285714286 | 109 | 52 | 97.3 | 0 | 9 | 335 | 14 | 122 | RLG24560.1 MAG: pyrroline-5-carboxylate reductase, partial [Methanosarcinales archaeon] | diamond | 981 | 105 | 0.990476190476191 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28631890 | 28631890 | PRJNA743294_P_NODE_40367_length_268_cov_1.133333_g39911_i0 | PRJNA743294 | 40367 | 268 | 1.133333 | 3.03733244 | Halobacteriales archaeon | 1904752 | Archaea | Archaea | 45.4 | 0.00543 | NR | MDX1748068.1 | 1904752 | g39911 | i0 | 75.9 | 0.626865671641791 | 29 | 7 | 32.5 | 0 | 1 | 87 | 3 | 31 | MDX1748068.1 LamG-like jellyroll fold domain-containing protein [Halobacteriales archaeon] | diamond | 168 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 28979124 | 28979124 | PRJNA743294_P_NODE_34168_length_287_cov_2.186916_g33712_i0 | PRJNA743294 | 34168 | 287 | 2.186916 | 6.27644892 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 82.8 | 6.24e-17 | NR | MDD1679754.1 | 2184052 | g33712 | i0 | 43.6 | 0.982578397212544 | 94 | 53 | 98.3 | 0 | 4 | 285 | 5 | 98 | MDD1679754.1 cation transporting ATPase C-terminal domain-containing protein [Methanomicrobiales archaeon] | diamond | 282 | 82.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 29168600 | 29168600 | PRJNA743294_P_NODE_29429_length_306_cov_2.635193_g28973_i0 | PRJNA743294 | 29429 | 306 | 2.635193 | 8.06369058 | Methanospirillum sp. | 45200 | Archaea | Archaea | 45.4 | 0.00699 | NR | MEN6519097.1 | 45200 | g28973 | i0 | 41.1 | 0.901960784313726 | 56 | 32 | 53.9 | 1 | 37 | 201 | 168 | 223 | MEN6519097.1 hypothetical protein [Methanospirillum sp.] | diamond | 276 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29904856 | 29904856 | PRJNA743294_P_NODE_41451_length_265_cov_0.869792_g40995_i0 | PRJNA743294 | 41451 | 265 | 0.869792 | 2.3049488 | Halovivax | 332951 | Archaea | Archaea | 50.1 | 9.95e-5 | NR | WP_007699857.1 | 332953 | g40995 | i0 | 34.2 | 2.54716981132075 | 79 | 51 | 88.3 | 1 | 30 | 263 | 90 | 168 | WP_007699857.1 CHRD domain-containing protein [Halovivax asiaticus] | diamond | 675 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax asiaticus | |
| 30495044 | 30495044 | PRJNA743294_P_NODE_11133_length_475_cov_3.228856_g10677_i0 | PRJNA743294 | 11133 | 475 | 3.228856 | 15.337066 | Methanospirillum sp. | 45200 | Archaea | Archaea | 47 | 0.00743 | NR | MDD1723749.1 | 45200 | g10677 | i0 | 73.3 | 0.397894736842105 | 30 | 8 | 18.9 | 0 | 402 | 313 | 24 | 53 | MDD1723749.1 C39 family peptidase [Methanospirillum sp.] | diamond | 189 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 31253296 | 31253296 | PRJNA743294_P_NODE_38235_length_274_cov_1.487562_g37779_i0 | PRJNA743294 | 38235 | 274 | 1.487562 | 4.07591988 | Methanolacinia paynteri | 230356 | Archaea | Archaea | 48.9 | 4.75e-5 | NR | WP_157199044.1 | 230356 | g37779 | i0 | 45.9 | 0.405109489051095 | 37 | 20 | 40.5 | 0 | 70 | 180 | 35 | 71 | WP_157199044.1 tetratricopeptide repeat protein, partial [Methanolacinia paynteri] | diamond | 111 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanolacinia | Methanolacinia paynteri | |
| 31294954 | 31294954 | PRJNA743294_P_NODE_22615_length_344_cov_1.151292_g22159_i0 | PRJNA743294 | 22615 | 344 | 1.151292 | 3.96044448 | Methanoregula | 395331 | Archaea | Archaea | 146 | 1.48e-38 | NR | WP_015286036.1 | 882104 | g22159 | i0 | 60.4 | 7.3953488372093 | 106 | 41 | 92.4 | 1 | 343 | 26 | 455 | 559 | WP_015286036.1 AMP-binding protein [Methanoregula formicica] | diamond | 2544 | 147 | 0.993197278911565 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula formicica | |
| 31800860 | 31800860 | PRJNA743294_P_NODE_12117_length_457_cov_3.026042_g11661_i0 | PRJNA743294 | 12117 | 457 | 3.026042 | 13.82901194 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.0155 | NR | OPX68170.1 | 1811720 | g11661 | i0 | 57.1 | 0.557986870897155 | 35 | 15 | 23 | 0 | 443 | 339 | 187 | 221 | OPX68170.1 MAG: lipoprotein NlpI [Methanoregulaceae archaeon PtaB.Bin009] | diamond | 255 | 46.6 | 0.991416309012876 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon PtaB.Bin009 | ||
| 32613356 | 32613356 | PRJNA743294_P_NODE_18720_length_374_cov_1.521595_g18264_i0 | PRJNA743294 | 18720 | 374 | 1.521595 | 5.6907653 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 49.7 | 8.16e-5 | NR | NYT02140.1 | 2250255 | g18264 | i0 | 45.7 | 0.368983957219251 | 46 | 25 | 36.9 | 0 | 17 | 154 | 62 | 107 | NYT02140.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 138 | 49.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 32906718 | 32906718 | PRJNA743294_P_NODE_37960_length_275_cov_1.321782_g37504_i0 | PRJNA743294 | 37960 | 275 | 1.321782 | 3.6349005 | Methanoculleus | 45989 | Archaea | Archaea | 43.1 | 0.028 | NR | MDD3071884.1 | 528314 | g37504 | i0 | 37.2 | 0.938181818181818 | 43 | 27 | 46.9 | 0 | 228 | 100 | 131 | 173 | MDD3071884.1 flavodoxin family protein [Methanoculleus horonobensis] | diamond | 258 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus horonobensis |
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);;