contig_metadata
25 rows where bioproject = "PRJNA1248424" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27073591 | 27073591 | PRJNA1248424_P_NODE_7742_length_2100_cov_23.779477_g1449_i6 | PRJNA1248424 | 7742 | 2100 | 23.779477 | 499.369017 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1059 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i6 | 98 | 0.79 | 553 | 11 | 79 | 0 | 2 | 1660 | 470 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1659 | 1059 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27263331 | 27263331 | PRJNA1248424_P_NODE_27023_length_586_cov_1.187135_g21032_i0 | PRJNA1248424 | 27023 | 586 | 1.187135 | 6.9566111 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 105 | 1.45e-22 | NR | MFO7795213.1 | 3067280 | g21032 | i0 | 68.4 | 0.389078498293515 | 76 | 24 | 38.9 | 0 | 230 | 3 | 806 | 881 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 228 | 105 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27326535 | 27326535 | PRJNA1248424_P_NODE_81703_length_227_cov_2.110390_g75633_i0 | PRJNA1248424 | 81703 | 227 | 2.11039 | 4.7905853 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 68.6 | 1.02e-11 | NR | MFO7797710.1 | 3067280 | g75633 | i0 | 53.2 | 1.01762114537445 | 77 | 30 | 93.8 | 1 | 227 | 15 | 3 | 79 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 231 | 68.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27515965 | 27515965 | PRJNA1248424_P_NODE_23543_length_703_cov_1.603175_g17700_i0 | PRJNA1248424 | 23543 | 703 | 1.603175 | 11.27032025 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 70.9 | 4.97e-10 | NR | MFO7795213.1 | 3067280 | g17700 | i0 | 67.3 | 0.209103840682788 | 49 | 16 | 20.9 | 0 | 201 | 347 | 898 | 946 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 147 | 70.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27705792 | 27705792 | PRJNA1248424_P_NODE_11084_length_1623_cov_4.352258_g7732_i0 | PRJNA1248424 | 11084 | 1623 | 4.352258 | 70.63714734 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 117 | 7.15e-26 | NR | MFO7797710.1 | 3067280 | g7732 | i0 | 43 | 0.537892791127542 | 149 | 82 | 27.2 | 3 | 933 | 1373 | 85 | 232 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 873 | 117 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27768800 | 27768800 | PRJNA1248424_P_NODE_11564_length_1571_cov_1.945260_g8061_i0 | PRJNA1248424 | 11564 | 1571 | 1.94526 | 30.5600346 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 155 | 1.3e-39 | NR | MFO7797710.1 | 3067280 | g8061 | i0 | 39.3 | 0.437301082113304 | 229 | 136 | 43.3 | 3 | 967 | 287 | 3 | 230 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 687 | 155 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 27831664 | 27831664 | PRJNA1248424_P_NODE_4144_length_2982_cov_22.909247_g1449_i4 | PRJNA1248424 | 4144 | 2982 | 22.909247 | 683.15374554 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1058 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i4 | 97.8 | 0.556338028169014 | 553 | 12 | 55.6 | 0 | 2 | 1660 | 470 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1659 | 1058 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28242012 | 28242012 | PRJNA1248424_P_NODE_6766_length_2281_cov_27.945652_g1449_i5 | PRJNA1248424 | 6766 | 2281 | 27.945652 | 637.44032212 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1060 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i5 | 97.8 | 0.729943007452872 | 555 | 12 | 73 | 0 | 617 | 2281 | 457 | 1011 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1665 | 1060 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28242024 | 28242024 | PRJNA1248424_P_NODE_9506_length_1824_cov_5.512850_g6691_i0 | PRJNA1248424 | 9506 | 1824 | 5.51285 | 100.554384 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 118 | 5.860000000000001e-26 | NR | MFO7797710.1 | 3067280 | g6691 | i0 | 35.1 | 0.370065789473684 | 225 | 139 | 36.7 | 5 | 644 | 1312 | 1 | 220 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 675 | 118 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28463373 | 28463373 | PRJNA1248424_P_NODE_2846_length_3507_cov_21.570181_g1449_i2 | PRJNA1248424 | 2846 | 3507 | 21.570181 | 756.46624767 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1058 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i2 | 97.8 | 0.473053892215569 | 553 | 12 | 47.3 | 0 | 2 | 1660 | 470 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1659 | 1058 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28936892 | 28936892 | PRJNA1248424_P_NODE_60508_length_274_cov_1.532338_g54440_i0 | PRJNA1248424 | 60508 | 274 | 1.532338 | 4.19860612 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 100 | 3.75e-22 | NR | MFO7795213.1 | 3067280 | g54440 | i0 | 61 | 0.897810218978102 | 82 | 30 | 87.6 | 1 | 2 | 241 | 915 | 996 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 246 | 100 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29599621 | 29599621 | PRJNA1248424_P_NODE_72970_length_247_cov_2.264368_g66901_i0 | PRJNA1248424 | 72970 | 247 | 2.264368 | 5.59298896 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 49.3 | 1.97e-4 | NR | MFO7795213.1 | 3067280 | g66901 | i0 | 66.7 | 0.473684210526316 | 39 | 13 | 47.4 | 0 | 1 | 117 | 941 | 979 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 117 | 49.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30231576 | 30231576 | PRJNA1248424_P_NODE_2872_length_3496_cov_21.812445_g1449_i3 | PRJNA1248424 | 2872 | 3496 | 21.812445 | 762.5630772 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1058 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i3 | 97.8 | 0.47454233409611 | 553 | 12 | 47.5 | 0 | 3495 | 1837 | 470 | 1022 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 1659 | 1058 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30326894 | 30326894 | PRJNA1248424_P_NODE_46032_length_330_cov_3.428016_g39968_i0 | PRJNA1248424 | 46032 | 330 | 3.428016 | 11.3124528 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 73.6 | 1.65e-12 | NR | MFO7795213.1 | 3067280 | g39968 | i0 | 88.1 | 0.381818181818182 | 42 | 5 | 38.2 | 0 | 126 | 1 | 960 | 1001 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 126 | 73.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30358431 | 30358431 | PRJNA1248424_P_NODE_42932_length_351_cov_1.482014_g36870_i0 | PRJNA1248424 | 42932 | 351 | 1.482014 | 5.20186914 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 45.1 | 0.0196 | NR | MFO7795213.1 | 3067280 | g36870 | i0 | 63.6 | 0.282051282051282 | 33 | 12 | 28.2 | 0 | 118 | 20 | 985 | 1017 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 99 | 45.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30705399 | 30705399 | PRJNA1248424_P_NODE_17894_length_1001_cov_2.451509_g12772_i0 | PRJNA1248424 | 17894 | 1001 | 2.451509 | 24.53960509 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 85.9 | 2.41e-15 | NR | MFO7797710.1 | 3067280 | g12772 | i0 | 50.6 | 0.266733266733267 | 89 | 42 | 26.1 | 2 | 72 | 332 | 141 | 229 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 267 | 85.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31337432 | 31337432 | PRJNA1248424_P_NODE_22556_length_744_cov_2.624441_g16776_i0 | PRJNA1248424 | 22556 | 744 | 2.624441 | 19.52584104 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 123 | 4.1699999999999995e-30 | NR | MFO7797710.1 | 3067280 | g16776 | i0 | 66 | 0.379032258064516 | 94 | 32 | 37.9 | 0 | 68 | 349 | 141 | 234 | MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] | diamond | 282 | 123 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31527437 | 31527437 | PRJNA1248424_P_NODE_42376_length_355_cov_1.195035_g36314_i0 | PRJNA1248424 | 42376 | 355 | 1.195035 | 4.24237425 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 175 | 5.3199999999999993e-48 | NR | MFO7795213.1 | 3067280 | g36314 | i0 | 97.7 | 0.726760563380282 | 86 | 0 | 71 | 1 | 101 | 352 | 1 | 86 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 258 | 175 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31780254 | 31780254 | PRJNA1248424_P_NODE_35697_length_419_cov_1.089595_g29641_i0 | PRJNA1248424 | 35697 | 419 | 1.089595 | 4.56540305 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 77 | 2.79e-13 | NR | MFO7795213.1 | 3067280 | g29641 | i0 | 59.3 | 0.422434367541766 | 59 | 24 | 42.2 | 0 | 180 | 4 | 475 | 533 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 177 | 77 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32160207 | 32160207 | PRJNA1248424_P_NODE_43258_length_349_cov_1.028986_g37195_i0 | PRJNA1248424 | 43258 | 349 | 1.028986 | 3.59116114 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 81.3 | 3.95e-15 | NR | MFO7795213.1 | 3067280 | g37195 | i0 | 78.7 | 0.404011461318052 | 47 | 10 | 40.4 | 0 | 245 | 105 | 441 | 487 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 141 | 81.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32286923 | 32286923 | PRJNA1248424_P_NODE_48579_length_318_cov_0.853061_g42512_i0 | PRJNA1248424 | 48579 | 318 | 0.853061 | 2.71273398 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 45.1 | 0.0138 | NR | MFO7795213.1 | 3067280 | g42512 | i0 | 48.9 | 0.443396226415094 | 47 | 24 | 44.3 | 0 | 311 | 171 | 969 | 1015 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 141 | 45.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32381617 | 32381617 | PRJNA1248424_P_NODE_73919_length_247_cov_0.885057_g67850_i0 | PRJNA1248424 | 73919 | 247 | 0.885057 | 2.18609079 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 44.7 | 0.00843 | NR | MFO7795213.1 | 3067280 | g67850 | i0 | 62.9 | 0.425101214574899 | 35 | 13 | 42.5 | 0 | 159 | 55 | 937 | 971 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 105 | 44.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32539943 | 32539943 | PRJNA1248424_P_NODE_1879_length_4128_cov_15.192602_g1449_i0 | PRJNA1248424 | 1879 | 4128 | 15.192602 | 627.15061056 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 1357 | 0 | NR | MFO7795213.1 | 3067280 | g1449 | i0 | 98.3 | 0.510901162790698 | 703 | 12 | 51.1 | 0 | 2109 | 1 | 309 | 1011 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 2109 | 1357 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32665701 | 32665701 | PRJNA1248424_P_NODE_62440_length_269_cov_1.255102_g56371_i0 | PRJNA1248424 | 62440 | 269 | 1.255102 | 3.37622438 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0118 | NR | TFG02163.1 | 2053489 | g56371 | i0 | 79.2 | 0.267657992565056 | 24 | 5 | 26.8 | 0 | 56 | 127 | 145 | 168 | TFG02163.1 MAG: GTP-binding protein, partial [Promethearchaeota archaeon] | diamond | 72 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32728811 | 32728811 | PRJNA1248424_P_NODE_27020_length_586_cov_1.524366_g21029_i0 | PRJNA1248424 | 27020 | 586 | 1.524366 | 8.93278476 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 106 | 1.07e-22 | NR | MFO7795213.1 | 3067280 | g21029 | i0 | 68.4 | 0.389078498293515 | 76 | 24 | 38.9 | 0 | 357 | 584 | 806 | 881 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 228 | 106 | 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);;