contig_metadata
12 rows where bioproject = "PRJNA715462" and tax_phylum = "Promethearchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 706161 | 706161 | PRJNA715462_P_NODE_4981_length_1104_cov_2.803104_g4408_i0 | PRJNA715462 | 4981 | 1104 | 2.803104 | 30.94626816 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 322 | 9.319999999999999e-98 | NR | MFO7795213.1 | 3067280 | g4408 | i0 | 96.5 | 0.46195652173913 | 170 | 5 | 46.2 | 1 | 657 | 148 | 546 | 714 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 510 | 322 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27462907 | 27462907 | PRJNA715462_P_NODE_65163_length_243_cov_0.905882_g64367_i0 | PRJNA715462 | 65163 | 243 | 0.905882 | 2.20129326 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 87.4 | 7.22e-18 | NR | MFO7795213.1 | 3067280 | g64367 | i0 | 74.5 | 0.679012345679012 | 55 | 14 | 67.9 | 0 | 165 | 1 | 852 | 906 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 165 | 87.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28283445 | 28283445 | PRJNA715462_P_NODE_7466_length_834_cov_1.379763_g6759_i0 | PRJNA715462 | 7466 | 834 | 1.379763 | 11.50722342 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 58.2 | 7.06e-6 | NR | MFO7797710.1 | 3067280 | g6759 | i0 | 63 | 0.496402877697842 | 46 | 17 | 16.5 | 0 | 196 | 59 | 134 | 179 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 414 | 58.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28378368 | 28378368 | PRJNA715462_P_NODE_58486_length_247_cov_0.885057_g57690_i0 | PRJNA715462 | 58486 | 247 | 0.885057 | 2.18609079 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 150 | 3.92e-40 | NR | MFO7795213.1 | 3067280 | g57690 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 246 | 1 | 893 | 974 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 246 | 150 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29041664 | 29041664 | PRJNA715462_P_NODE_4548_length_1172_cov_3.264786_g4010_i0 | PRJNA715462 | 4548 | 1172 | 3.264786 | 38.26329192 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 658 | 5.279999999999997e-227 | NR | MFO7795213.1 | 3067280 | g4010 | i0 | 95.5 | 0.901023890784983 | 352 | 16 | 90.1 | 0 | 1170 | 115 | 671 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1056 | 658 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29546457 | 29546457 | PRJNA715462_P_NODE_16870_length_465_cov_1.313776_g16074_i0 | PRJNA715462 | 16870 | 465 | 1.313776 | 6.1090584 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 307 | 1.7e-95 | NR | MFO7795213.1 | 3067280 | g16074 | i0 | 97.4 | 0.993548387096774 | 154 | 4 | 99.4 | 0 | 463 | 2 | 123 | 276 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 462 | 307 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29704108 | 29704108 | PRJNA715462_P_NODE_64610_length_243_cov_1.482353_g63814_i0 | PRJNA715462 | 64610 | 243 | 1.482353 | 3.60211779 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 126 | 1.1399999999999999e-31 | NR | MFO7795213.1 | 3067280 | g63814 | i0 | 85.7 | 0.950617283950617 | 77 | 11 | 95.1 | 0 | 12 | 242 | 906 | 982 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 231 | 126 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30020514 | 30020514 | PRJNA715462_P_NODE_44571_length_267_cov_1.587629_g43775_i0 | PRJNA715462 | 44571 | 267 | 1.587629 | 4.23896943 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 70.1 | 1.23e-11 | NR | MFO7795213.1 | 3067280 | g43775 | i0 | 53 | 0.741573033707865 | 66 | 31 | 74.2 | 0 | 210 | 13 | 935 | 1000 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 198 | 70.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30241560 | 30241560 | PRJNA715462_P_NODE_18212_length_441_cov_1.877717_g17416_i0 | PRJNA715462 | 18212 | 441 | 1.877717 | 8.28073197 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 108 | 4.49e-24 | NR | MFO7795213.1 | 3067280 | g17416 | i0 | 88.9 | 0.428571428571429 | 63 | 7 | 42.9 | 0 | 232 | 44 | 960 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 189 | 108 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31125795 | 31125795 | PRJNA715462_P_NODE_17075_length_461_cov_1.268041_g16279_i0 | PRJNA715462 | 17075 | 461 | 1.268041 | 5.84566901 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 170 | 1.21e-45 | NR | MFO7795213.1 | 3067280 | g16279 | i0 | 97.6 | 0.546637744034707 | 84 | 2 | 54.7 | 0 | 2 | 253 | 395 | 478 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 252 | 170 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31948385 | 31948385 | PRJNA715462_P_NODE_17277_length_457_cov_1.044271_g16481_i0 | PRJNA715462 | 17277 | 457 | 1.044271 | 4.77231847 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 170 | 8.55e-46 | NR | MFO7795213.1 | 3067280 | g16481 | i0 | 100 | 0.518599562363239 | 79 | 0 | 51.9 | 0 | 196 | 432 | 1 | 79 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 237 | 170 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32581408 | 32581408 | PRJNA715462_P_NODE_12139_length_586_cov_1.333333_g11351_i0 | PRJNA715462 | 12139 | 586 | 1.333333 | 7.81333138 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 305 | 3.81e-102 | NR | MFO7797710.1 | 3067280 | g11351 | i0 | 98 | 0.783276450511945 | 153 | 3 | 78.3 | 0 | 1 | 459 | 102 | 254 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 459 | 305 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia 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);;