contig_metadata
15 rows where bioproject = "PRJEB10140", tax_phylum = "Thermoproteota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13252 | 13252 | PRJEB10140_P_NODE_58261_length_629_cov_7.518966_g41685_i0 | PRJEB10140 | 58261 | 629 | 7.518966 | 47.29429614 | Saccharolobus caldissimus | 1702097 | Archaea | Archaea | 54.7 | 0.017 | NTclustered | gi|2129441369|dbj|AP025226.1| | 1702097 | g41685 | i0 | 100 | 0.0461049284578696 | 29 | 0 | 5 | 0 | 175 | 203 | 866123 | 866095 | Saccharolobus caldissimus JCM32116 DNA, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus caldissimus | ||
| 11489924 | 11489924 | PRJEB10140_P_NODE_192710_length_201_cov_1.368421_g175401_i0 | PRJEB10140 | 192710 | 201 | 1.368421 | 2.75052621 | Acidianus ambivalens | 2283 | Archaea | Archaea | 62.1 | 2.9e-5 | NTclustered | gi|1780181985|gb|CP045482.1| | 2283 | g175401 | i0 | 93.182 | 0.766169154228856 | 44 | 0 | 20 | 2 | 81 | 121 | 2242076 | 2242033 | Acidianus ambivalens strain LEI 10 chromosome, complete genome | blastn | 154 | 62.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus ambivalens | ||
| 19136979 | 19136979 | PRJEB10140_P_NODE_114316_length_319_cov_3.100000_g97010_i0 | PRJEB10140 | 114316 | 319 | 3.1 | 9.889 | Thermoproteus uzoniensis | 184117 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|326946401|gb|CP002590.1| | 999630 | g97010 | i0 | 100 | 0.0877742946708464 | 28 | 0 | 9 | 0 | 4 | 31 | 1601335 | 1601308 | Thermoproteus uzoniensis 768-20, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus uzoniensis | ||
| 20413483 | 20413483 | PRJEB10140_P_NODE_277517_length_164_cov_0.904348_g260208_i0 | PRJEB10140 | 277517 | 164 | 0.904348 | 1.48313072 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g260208 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 67 | 94 | 336127 | 336100 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 22659265 | 22659265 | PRJEB10140_P_NODE_256198_length_167_cov_0.881356_g238889_i0 | PRJEB10140 | 256198 | 167 | 0.881356 | 1.47186452 | Sulfurisphaera | 69655 | Archaea | Archaea | 62.1 | 2.33e-5 | NTclustered | gi|1780177153|gb|CP045484.1| | 69656 | g238889 | i0 | 92.857 | 0.826347305389222 | 42 | 3 | 25 | 0 | 112 | 153 | 1204563 | 1204522 | Sulfurisphaera ohwakuensis strain TA-1 chromosome, complete genome | blastn | 138 | 62.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfurisphaera | Sulfurisphaera ohwakuensis | ||
| 26614903 | 26614903 | PRJEB10140_P_NODE_230861_length_176_cov_2.047244_g213552_i0 | PRJEB10140 | 230861 | 176 | 2.047244 | 3.60314944 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 1.65e-9 | NR | WP_081246776.1 | 1650659 | g213552 | i0 | 56 | 3.66477272727273 | 50 | 22 | 85.2 | 0 | 174 | 25 | 19 | 68 | WP_081246776.1 ADP-ribose-binding protein [Thermoproteus sp. CP80] | diamond | 645 | 60.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus sp. CP80 | ||
| 26652451 | 26652451 | PRJEB10140_P_NODE_187941_length_205_cov_1.346154_g170632_i0 | PRJEB10140 | 187941 | 205 | 1.346154 | 2.7596157 | Pyrobaculum sp. | 2004705 | Archaea | Archaea | 48.1 | 2.75e-4 | NR | MFN7105009.1 | 2004705 | g170632 | i0 | 37 | 0.790243902439024 | 54 | 34 | 79 | 0 | 5 | 166 | 2 | 55 | MFN7105009.1 hypothetical protein [Pyrobaculum sp.] | diamond | 162 | 48.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum sp. | ||
| 27380488 | 27380488 | PRJEB10140_P_NODE_230963_length_176_cov_1.921260_g213654_i0 | PRJEB10140 | 230963 | 176 | 1.92126 | 3.3814176 | Sulfuracidifex tepidarius | 1294262 | Archaea | Archaea | 79 | 2.17e-15 | NR | WP_149528435.1 | 1294262 | g213654 | i0 | 66.7 | 2.77840909090909 | 57 | 19 | 97.2 | 0 | 4 | 174 | 67 | 123 | WP_149528435.1 hydroxymethylglutaryl-CoA reductase (NADPH) [Sulfuracidifex tepidarius] | diamond | 489 | 79 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfuracidifex | Sulfuracidifex tepidarius | ||
| 27822589 | 27822589 | PRJEB10140_P_NODE_44504_length_812_cov_3.608126_g7533_i2 | PRJEB10140 | 44504 | 812 | 3.608126 | 29.29798312 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 66.2 | 2.79e-8 | NR | MDQ2684806.1 | 2056631 | g7533 | i2 | 62.8 | 0.158866995073892 | 43 | 16 | 15.9 | 0 | 235 | 107 | 259 | 301 | MDQ2684806.1 hypothetical protein [Thermoproteota archaeon] | diamond | 129 | 66.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28517057 | 28517057 | PRJEB10140_P_NODE_275667_length_164_cov_0.904348_g258358_i0 | PRJEB10140 | 275667 | 164 | 0.904348 | 1.48313072 | Sulfolobaceae archaeon | 2967306 | Archaea | Archaea | 84.3 | 9.06e-18 | NR | MEM0173169.1 | 2967306 | g258358 | i0 | 83.7 | 0.896341463414634 | 49 | 8 | 89.6 | 0 | 17 | 163 | 104 | 152 | MEM0173169.1 hypothetical protein [Sulfolobaceae archaeon] | diamond | 147 | 84.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobaceae archaeon | |||
| 29779932 | 29779932 | PRJEB10140_P_NODE_244331_length_169_cov_1.616667_g227022_i0 | PRJEB10140 | 244331 | 169 | 1.616667 | 2.73216723 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 90.5 | 2.2700000000000003e-22 | NR | MEC8530265.1 | 2056631 | g227022 | i0 | 80.8 | 2.73372781065089 | 52 | 10 | 92.3 | 0 | 1 | 156 | 14 | 65 | MEC8530265.1 adenosylhomocysteinase [Thermoproteota archaeon] | diamond | 462 | 90.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30475034 | 30475034 | PRJEB10140_P_NODE_158473_length_236_cov_1.326203_g141165_i0 | PRJEB10140 | 158473 | 236 | 1.326203 | 3.12983908 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 43.5 | 0.0184 | NR | MCR8455893.1 | 2056631 | g141165 | i0 | 37.5 | 1.44915254237288 | 56 | 32 | 71.2 | 2 | 175 | 8 | 46 | 98 | MCR8455893.1 hypothetical protein [Thermoproteota archaeon] | diamond | 342 | 43.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30790962 | 30790962 | PRJEB10140_P_NODE_37014_length_953_cov_2.988938_g23503_i0 | PRJEB10140 | 37014 | 953 | 2.988938 | 28.48457914 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 61.6 | 5.43e-7 | NR | RLE92860.1 | 2250277 | g23503 | i0 | 33 | 0.333683105981112 | 106 | 65 | 33.1 | 3 | 599 | 913 | 128 | 228 | RLE92860.1 MAG: hypothetical protein DRN04_09060 [Thermoprotei archaeon] | diamond | 318 | 61.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 31929053 | 31929053 | PRJEB10140_P_NODE_156117_length_239_cov_1.336842_g138809_i0 | PRJEB10140 | 156117 | 239 | 1.336842 | 3.19505238 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 42.4 | 0.0196 | NR | MDK2371869.1 | 2056631 | g138809 | i0 | 36.2 | 0.589958158995816 | 47 | 30 | 59 | 0 | 206 | 66 | 81 | 127 | MDK2371869.1 hypothetical protein [Thermoproteota archaeon] | diamond | 141 | 42.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32656145 | 32656145 | PRJEB10140_P_NODE_289040_length_162_cov_0.920354_g271731_i0 | PRJEB10140 | 289040 | 162 | 0.920354 | 1.49097348 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 48.5 | 1.15e-4 | NR | NIQ06866.1 | 2056631 | g271731 | i0 | 63.9 | 0.666666666666667 | 36 | 13 | 66.7 | 0 | 46 | 153 | 1 | 36 | NIQ06866.1 DUF3383 domain-containing protein [Thermoproteota archaeon] | diamond | 108 | 48.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota 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);;