contig_metadata
19 rows where bioproject = "PRJNA326068" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940036 | 2940036 | PRJNA326068_P_NODE_12863_length_254_cov_2.200000_g11900_i0 | PRJNA326068 | 12863 | 254 | 2.2 | 5.588 | archaeon | 1906665 | Archaea | Archaea | 124 | 2.04e-34 | NR | RYH30236.1 | 1906665 | g11900 | i0 | 79.7 | 0.874015748031496 | 74 | 15 | 87.4 | 0 | 3 | 224 | 64 | 137 | RYH30236.1 MAG: hypothetical protein EON65_05740 [archaeon] | diamond | 222 | 124 | 1 | Archaea | archaeon | ||||||||
| 3619876 | 3619876 | PRJNA326068_P_NODE_5163_length_486_cov_2.792123_g4341_i0 | PRJNA326068 | 5163 | 486 | 2.792123 | 13.56971778 | archaeon | 1906665 | Archaea | Archaea | 241 | 7.1e-79 | NR | RYH03712.1 | 1906665 | g4341 | i0 | 89 | 0.839506172839506 | 136 | 15 | 84 | 0 | 3 | 410 | 23 | 158 | RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon] | diamond | 408 | 241 | 1 | Archaea | archaeon | ||||||||
| 4216705 | 4216705 | PRJNA326068_P_NODE_1284_length_933_cov_3.032080_g923_i0 | PRJNA326068 | 1284 | 933 | 3.03208 | 28.2893064 | archaeon | 1906665 | Archaea | Archaea | 379 | 5.139999999999998e-130 | NR | RYG65124.1 | 1906665 | g923 | i0 | 92.9 | 0.636655948553055 | 198 | 14 | 63.7 | 0 | 692 | 99 | 18 | 215 | RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon] | diamond | 594 | 379 | 1 | Archaea | archaeon | ||||||||
| 5492981 | 5492981 | PRJNA326068_P_NODE_3605_length_584_cov_2.772973_g2892_i0 | PRJNA326068 | 3605 | 584 | 2.772973 | 16.19416232 | archaeon | 1906665 | Archaea | Archaea | 127 | 3.11e-34 | NR | RYH29492.1 | 1906665 | g2892 | i0 | 81.1 | 0.38013698630137 | 74 | 14 | 38 | 0 | 506 | 285 | 45 | 118 | RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] | diamond | 222 | 127 | 1 | Archaea | archaeon | ||||||||
| 14418296 | 14418296 | PRJNA326068_P_NODE_6892_length_410_cov_2.110236_g5968_i0 | PRJNA326068 | 6892 | 410 | 2.110236 | 8.6519676 | archaeon | 1906665 | Archaea | Archaea | 124 | 1.4799999999999998e-31 | NR | RYH13701.1 | 1906665 | g5968 | i0 | 59.8 | 1.85853658536585 | 127 | 51 | 92.9 | 0 | 409 | 29 | 197 | 323 | RYH13701.1 MAG: 50S ribosomal protein L4 [archaeon] | diamond | 762 | 124 | 1 | Archaea | archaeon | ||||||||
| 15692105 | 15692105 | PRJNA326068_P_NODE_1953_length_772_cov_3.697174_g1460_i0 | PRJNA326068 | 1953 | 772 | 3.697174 | 28.54218328 | archaeon | 1906665 | Archaea | Archaea | 397 | 4.289999999999999e-138 | NR | RYH25290.1 | 1906665 | g1460 | i0 | 92.7 | 0.800518134715026 | 206 | 15 | 80.1 | 0 | 83 | 700 | 1 | 206 | RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] | diamond | 618 | 397 | 1 | Archaea | archaeon | ||||||||
| 20195258 | 20195258 | PRJNA326068_P_NODE_2656_length_673_cov_2.984472_g2060_i0 | PRJNA326068 | 2656 | 673 | 2.984472 | 20.08549656 | archaeon | 1906665 | Archaea | Archaea | 293 | 4.1299999999999985e-96 | NR | RYH04926.1 | 1906665 | g2060 | i0 | 81.3 | 0.904903417533432 | 203 | 37 | 90 | 1 | 2 | 607 | 119 | 321 | RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] | diamond | 609 | 293 | 1 | Archaea | archaeon | ||||||||
| 26662764 | 26662764 | PRJNA326068_P_NODE_18521_length_172_cov_1.748252_g17558_i0 | PRJNA326068 | 18521 | 172 | 1.748252 | 3.00699344 | archaeon | 1906665 | Archaea | Archaea | 100 | 5.830000000000001e-26 | NR | RYG60404.1 | 1906665 | g17558 | i0 | 83.9 | 2.93023255813953 | 56 | 9 | 97.7 | 0 | 170 | 3 | 3 | 58 | RYG60404.1 MAG: hypothetical protein EON64_19315, partial [archaeon] | diamond | 504 | 100 | 1 | Archaea | archaeon | ||||||||
| 26726023 | 26726023 | PRJNA326068_P_NODE_3841_length_565_cov_3.044776_g3108_i0 | PRJNA326068 | 3841 | 565 | 3.044776 | 17.2029844 | archaeon | 1906665 | Archaea | Archaea | 153 | 4.6899999999999996e-43 | NR | RYG58925.1 | 1906665 | g3108 | i0 | 80.5 | 1.80530973451327 | 87 | 17 | 46.2 | 0 | 3 | 263 | 135 | 221 | RYG58925.1 MAG: 30S ribosomal protein S2, partial [archaeon] | diamond | 1020 | 153 | 1 | Archaea | archaeon | ||||||||
| 27485417 | 27485417 | PRJNA326068_P_NODE_4783_length_505_cov_3.668067_g3979_i0 | PRJNA326068 | 4783 | 505 | 3.668067 | 18.52373835 | archaeon | 1906665 | Archaea | Archaea | 120 | 6.259999999999999e-32 | NR | RYH28340.1 | 1906665 | g3979 | i0 | 67.5 | 0.712871287128713 | 120 | 35 | 71.3 | 1 | 51 | 410 | 1 | 116 | RYH28340.1 MAG: 50S ribosomal protein P1 [archaeon] | diamond | 360 | 120 | 1 | Archaea | archaeon | ||||||||
| 28148571 | 28148571 | PRJNA326068_P_NODE_18045_length_180_cov_1.801325_g17082_i0 | PRJNA326068 | 18045 | 180 | 1.801325 | 3.242385 | archaeon | 1906665 | Archaea | Archaea | 75.1 | 2.62e-14 | NR | RYH29451.1 | 1906665 | g17082 | i0 | 97.1 | 0.566666666666667 | 34 | 1 | 56.7 | 0 | 179 | 78 | 251 | 284 | RYH29451.1 MAG: solute carrier family 25 protein [archaeon] | diamond | 102 | 75.1 | 1 | Archaea | archaeon | ||||||||
| 28242981 | 28242981 | PRJNA326068_P_NODE_16926_length_199_cov_2.117647_g15963_i0 | PRJNA326068 | 16926 | 199 | 2.117647 | 4.21411753 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 55.5 | 2.77e-7 | NR | MDH4213144.1 | 2053491 | g15963 | i0 | 50 | 3.15075376884422 | 56 | 23 | 84.4 | 2 | 1 | 168 | 128 | 178 | MDH4213144.1 50S ribosomal protein L6 [Candidatus Thorarchaeota archaeon] | diamond | 627 | 55.5 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 29032738 | 29032738 | PRJNA326068_P_NODE_5588_length_467_cov_2.753425_g4748_i0 | PRJNA326068 | 5588 | 467 | 2.753425 | 12.85849475 | archaeon | 1906665 | Archaea | Archaea | 136 | 1.48e-38 | NR | RYG99347.1 | 1906665 | g4748 | i0 | 82.1 | 0.539614561027837 | 84 | 15 | 54 | 0 | 214 | 465 | 1 | 84 | RYG99347.1 MAG: hypothetical protein EON65_50365 [archaeon] | diamond | 252 | 136 | 1 | Archaea | archaeon | ||||||||
| 30011539 | 30011539 | PRJNA326068_P_NODE_18331_length_175_cov_3.054795_g17368_i0 | PRJNA326068 | 18331 | 175 | 3.054795 | 5.34589125 | archaeon | 1906665 | Archaea | Archaea | 46.2 | 2.47e-4 | NR | RYY73917.1 | 1906665 | g17368 | i0 | 78.6 | 0.48 | 28 | 6 | 48 | 0 | 175 | 92 | 91 | 118 | RYY73917.1 MAG: 50S ribosomal protein P1 [archaeon] | diamond | 84 | 46.2 | 1 | Archaea | archaeon | ||||||||
| 30074417 | 30074417 | PRJNA326068_P_NODE_5692_length_463_cov_2.914747_g4844_i0 | PRJNA326068 | 5692 | 463 | 2.914747 | 13.49527861 | archaeon | 1906665 | Archaea | Archaea | 78.2 | 6.5e-15 | NR | RYG68742.1 | 1906665 | g4844 | i0 | 90 | 0.259179265658747 | 40 | 4 | 25.9 | 0 | 462 | 343 | 50 | 89 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 120 | 78.2 | 1 | Archaea | archaeon | ||||||||
| 30422535 | 30422535 | PRJNA326068_P_NODE_18833_length_167_cov_2.000000_g17870_i0 | PRJNA326068 | 18833 | 167 | 2 | 3.34 | archaeon | 1906665 | Archaea | Archaea | 38.9 | 0.0462 | NR | MCP8304388.1 | 1906665 | g17870 | i0 | 56.1 | 0.736526946107784 | 41 | 15 | 73.7 | 1 | 156 | 34 | 4 | 41 | MCP8304388.1 30S ribosomal protein S30e [archaeon] | diamond | 123 | 38.9 | 1 | Archaea | archaeon | ||||||||
| 31054351 | 31054351 | PRJNA326068_P_NODE_5535_length_469_cov_4.722727_g4697_i0 | PRJNA326068 | 5535 | 469 | 4.722727 | 22.14958963 | archaeon | 1906665 | Archaea | Archaea | 113 | 2.61e-29 | NR | RYH00022.1 | 1906665 | g4697 | i0 | 67.7 | 0.633262260127932 | 99 | 31 | 63.3 | 1 | 114 | 410 | 1 | 98 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 297 | 113 | 1 | Archaea | archaeon | ||||||||
| 31528448 | 31528448 | PRJNA326068_P_NODE_14756_length_223_cov_1.932990_g13793_i0 | PRJNA326068 | 14756 | 223 | 1.93299 | 4.3105677 | Methanopyrus | 2319 | Archaea | Archaea | 41.6 | 0.00893 | NR | WP_011019823.1 | 2319 | g13793 | i0 | 43.2 | 0.591928251121076 | 44 | 24 | 57.8 | 1 | 17 | 145 | 17 | 60 | WP_011019823.1 MULTISPECIES: 30S ribosomal protein S27ae [Methanopyrus] | diamond | 132 | 41.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyrales | Methanopyraceae | Methanopyrus | ||
| 32256331 | 32256331 | PRJNA326068_P_NODE_5258_length_482_cov_2.306843_g4432_i0 | PRJNA326068 | 5258 | 482 | 2.306843 | 11.11898326 | archaeon | 1906665 | Archaea | Archaea | 189 | 2.06e-58 | NR | RYG68310.1 | 1906665 | g4432 | i0 | 74.1 | 0.890041493775934 | 143 | 31 | 87.1 | 5 | 1 | 420 | 14 | 153 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 429 | 189 | 1 | Archaea | 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);;