contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Methanomethylicota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27166513 | 27166513 | PRJNA1148190_P_NODE_91722_length_562_cov_1.830266_g80581_i0 | PRJNA1148190 | 91722 | 562 | 1.830266 | 10.28609492 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 55.8 | 1.69e-5 | NR | MEM4203151.1 | 3058293 | g80581 | i0 | 37.3 | 0.400355871886121 | 75 | 46 | 39.5 | 1 | 339 | 560 | 35 | 109 | MEM4203151.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 225 | 55.8 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 27703223 | 27703223 | PRJNA1148190_P_NODE_37524_length_1068_cov_1.809045_g27279_i0 | PRJNA1148190 | 37524 | 1068 | 1.809045 | 19.3206006 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 293 | 1.74e-92 | NR | MEM4203009.1 | 3058293 | g27279 | i0 | 45.3 | 0.955056179775281 | 340 | 183 | 94.9 | 3 | 53 | 1066 | 10 | 348 | MEM4203009.1 replicative DNA helicase [Candidatus Methanomethylicaceae archaeon] | diamond | 1020 | 293 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 27987744 | 27987744 | PRJNA1148190_P_NODE_71565_length_657_cov_1.700342_g60473_i0 | PRJNA1148190 | 71565 | 657 | 1.700342 | 11.17124694 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 114 | 1.63e-26 | NR | MEM4203151.1 | 3058293 | g60473 | i0 | 40.9 | 0.80365296803653 | 176 | 95 | 78.1 | 4 | 10 | 522 | 158 | 329 | MEM4203151.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 528 | 114 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 27987918 | 27987918 | PRJNA1148190_P_NODE_94165_length_553_cov_2.456250_g83018_i0 | PRJNA1148190 | 94165 | 553 | 2.45625 | 13.5830625 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 114 | 1.37e-27 | NR | RLE52379.1 | 2250257 | g83018 | i0 | 40.5 | 0.857142857142857 | 158 | 90 | 84.6 | 3 | 523 | 56 | 1 | 156 | RLE52379.1 MAG: hypothetical protein DRJ26_04795, partial [Candidatus Methanomethylicota archaeon] | diamond | 474 | 114 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 28050934 | 28050934 | PRJNA1148190_P_NODE_789745_length_241_cov_0.916667_g778572_i0 | PRJNA1148190 | 789745 | 241 | 0.916667 | 2.20916747 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 127 | 5.689999999999998e-32 | NR | MEM2002945.1 | 3058293 | g778572 | i0 | 76.6 | 0.95850622406639 | 77 | 18 | 95.9 | 0 | 241 | 11 | 452 | 528 | MEM2002945.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 231 | 127 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 28397044 | 28397044 | PRJNA1148190_P_NODE_101266_length_531_cov_1.008734_g90110_i0 | PRJNA1148190 | 101266 | 531 | 1.008734 | 5.35637754 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 127 | 6.420000000000001e-33 | NR | RLE52379.1 | 2250257 | g90110 | i0 | 44.8 | 0.870056497175141 | 154 | 83 | 87 | 2 | 529 | 68 | 92 | 243 | RLE52379.1 MAG: hypothetical protein DRJ26_04795, partial [Candidatus Methanomethylicota archaeon] | diamond | 462 | 127 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 29913083 | 29913083 | PRJNA1148190_P_NODE_243911_length_347_cov_0.978102_g232741_i0 | PRJNA1148190 | 243911 | 347 | 0.978102 | 3.39401394 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 78.2 | 9.76e-15 | NR | RLE52379.1 | 2250257 | g232741 | i0 | 43 | 0.743515850144092 | 86 | 47 | 74.4 | 2 | 299 | 42 | 73 | 156 | RLE52379.1 MAG: hypothetical protein DRJ26_04795, partial [Candidatus Methanomethylicota archaeon] | diamond | 258 | 78.2 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 29976233 | 29976233 | PRJNA1148190_P_NODE_339691_length_304_cov_1.549784_g328518_i0 | PRJNA1148190 | 339691 | 304 | 1.549784 | 4.71134336 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 74.7 | 1.17e-13 | NR | RLE52379.1 | 2250257 | g328518 | i0 | 55.6 | 1.45065789473684 | 72 | 32 | 71.1 | 0 | 36 | 251 | 171 | 242 | RLE52379.1 MAG: hypothetical protein DRJ26_04795, partial [Candidatus Methanomethylicota archaeon] | diamond | 441 | 74.7 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 31335122 | 31335122 | PRJNA1148190_P_NODE_488976_length_269_cov_1.163265_g477803_i0 | PRJNA1148190 | 488976 | 269 | 1.163265 | 3.12918285 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 56.6 | 8.62e-8 | NR | MEM4202901.1 | 3058293 | g477803 | i0 | 51.5 | 1.4275092936803 | 66 | 32 | 73.6 | 0 | 72 | 269 | 10 | 75 | MEM4202901.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 384 | 56.6 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 32474348 | 32474348 | PRJNA1148190_P_NODE_50719_length_839_cov_2.249347_g39916_i0 | PRJNA1148190 | 50719 | 839 | 2.249347 | 18.87202133 | Candidatus Methanomethylicota archaeon | 2056631 | Archaea | Archaea | 166 | 2.7799999999999993e-46 | NR | RLE52379.1 | 2250257 | g39916 | i0 | 41.1 | 0.825983313468415 | 231 | 131 | 81.9 | 4 | 834 | 148 | 16 | 243 | RLE52379.1 MAG: hypothetical protein DRJ26_04795, partial [Candidatus Methanomethylicota archaeon] | diamond | 693 | 166 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon |
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);;