contig_metadata
17 rows where bioproject = "PRJNA704949", tax_phylum = "Thermoplasmatota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 697818 | 697818 | PRJNA704949_P_NODE_454021_length_404_cov_2.152113_g438819_i0 | PRJNA704949 | 454021 | 404 | 2.152113 | 8.69453652 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 79 | 1.33e-15 | NR | MDN5357341.1 | 2517205 | g438819 | i0 | 49.5 | 0.690594059405941 | 93 | 47 | 69.1 | 0 | 282 | 4 | 7 | 99 | MDN5357341.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 279 | 79 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 4519432 | 4519432 | PRJNA704949_P_NODE_1647584_length_189_cov_1.178571_g1632245_i0 | PRJNA704949 | 1647584 | 189 | 1.178571 | 2.22749919 | methanogenic archaeon ISO4-H5 | 1495144 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|992543061|gb|CP014214.1| | 1495144 | g1632245 | i0 | 100 | 0.158730158730159 | 30 | 0 | 16 | 0 | 23 | 52 | 827363 | 827392 | Methanogenic archaeon ISO4-H5 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | methanogenic archaeon ISO4-H5 | |||||
| 26893307 | 26893307 | PRJNA704949_P_NODE_1130181_length_241_cov_1.625000_g1114845_i0 | PRJNA704949 | 1130181 | 241 | 1.625 | 3.91625 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 97.1 | 5.16e-22 | NR | MFA5772863.1 | 1906666 | g1114845 | i0 | 63.4 | 0.883817427385892 | 71 | 26 | 88.4 | 0 | 218 | 6 | 79 | 149 | MFA5772863.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 213 | 97.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27020205 | 27020205 | PRJNA704949_P_NODE_847142_length_288_cov_1.476987_g831808_i0 | PRJNA704949 | 847142 | 288 | 1.476987 | 4.25372256 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.5 | 0.0344 | NR | HKZ63209.1 | 1906666 | g831808 | i0 | 37.7 | 0.71875 | 69 | 42 | 70.8 | 1 | 29 | 232 | 618 | 686 | HKZ63209.1 Ig-like domain-containing protein [Thermoplasmata archaeon] | diamond | 207 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27177910 | 27177910 | PRJNA704949_P_NODE_389782_length_435_cov_1.966321_g374695_i0 | PRJNA704949 | 389782 | 435 | 1.966321 | 8.55349635 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 116 | 2.47e-28 | NR | MEK9694403.1 | 2163009 | g374695 | i0 | 41.9 | 0.937931034482759 | 136 | 77 | 93.8 | 2 | 8 | 415 | 131 | 264 | MEK9694403.1 AAA family ATPase [Candidatus Poseidoniales archaeon] | diamond | 408 | 116 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27241193 | 27241193 | PRJNA704949_P_NODE_2138203_length_163_cov_0.912281_g2122864_i0 | PRJNA704949 | 2138203 | 163 | 0.912281 | 1.48701803 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 55.8 | 2.97e-7 | NR | MDX1610931.1 | 2806419 | g2122864 | i0 | 52.9 | 0.938650306748466 | 51 | 21 | 93.9 | 1 | 153 | 1 | 311 | 358 | MDX1610931.1 aminotransferase class V-fold PLP-dependent enzyme [Thermoplasmatota archaeon] | diamond | 153 | 55.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29451357 | 29451357 | PRJNA704949_P_NODE_313190_length_481_cov_2.893519_g298327_i0 | PRJNA704949 | 313190 | 481 | 2.893519 | 13.91782639 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 62 | 7.34e-8 | NR | HSV42639.1 | 1906667 | g298327 | i0 | 34.2 | 0.748440748440748 | 120 | 72 | 72.3 | 4 | 101 | 448 | 34 | 150 | HSV42639.1 fibronectin type III domain-containing protein [Methanomassiliicoccales archaeon] | diamond | 360 | 62 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 29735371 | 29735371 | PRJNA704949_P_NODE_1745930_length_181_cov_2.166667_g1730591_i0 | PRJNA704949 | 1745930 | 181 | 2.166667 | 3.92166727 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 68.9 | 9.07e-12 | NR | MCU0798423.1 | 2806419 | g1730591 | i0 | 55.2 | 6.79558011049724 | 58 | 26 | 96.1 | 0 | 179 | 6 | 352 | 409 | MCU0798423.1 DNA gyrase subunit A [Thermoplasmatota archaeon] | diamond | 1230 | 68.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29777964 | 29777964 | PRJNA704949_P_NODE_1061451_length_251_cov_1.287129_g1046115_i0 | PRJNA704949 | 1061451 | 251 | 1.287129 | 3.23069379 | Methanobacteriati | 3366610 | Archaea | Archaea | 42 | 0.00992 | NR | HYR81996.1 | 1906666 | g1046115 | i0 | 48.6 | 0.836653386454183 | 35 | 18 | 41.8 | 0 | 249 | 145 | 32 | 66 | HYR81996.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 210 | 42 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30493917 | 30493917 | PRJNA704949_P_NODE_1699513_length_185_cov_1.272059_g1684174_i0 | PRJNA704949 | 1699513 | 185 | 1.272059 | 2.35330915 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 51.6 | 1.15e-5 | NR | HYY48305.1 | 1906666 | g1684174 | i0 | 63.4 | 0.664864864864865 | 41 | 15 | 66.5 | 0 | 61 | 183 | 226 | 266 | HYY48305.1 dihydropteroate synthase [Thermoplasmata archaeon] | diamond | 123 | 51.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31283580 | 31283580 | PRJNA704949_P_NODE_1361335_length_214_cov_1.381818_g1345997_i0 | PRJNA704949 | 1361335 | 214 | 1.381818 | 2.95709052 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 45.8 | 0.00212 | NR | MED5350003.1 | 2806419 | g1345997 | i0 | 47.4 | 0.799065420560748 | 57 | 26 | 77.1 | 2 | 29 | 193 | 217 | 271 | MED5350003.1 DnaA/Hda family protein [Thermoplasmatota archaeon] | diamond | 171 | 45.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31505622 | 31505622 | PRJNA704949_P_NODE_424876_length_417_cov_3.258152_g409715_i0 | PRJNA704949 | 424876 | 417 | 3.258152 | 13.58649384 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 44.7 | 0.0429 | NR | HIH95966.1 | 1906666 | g409715 | i0 | 35 | 0.575539568345324 | 80 | 41 | 57.6 | 1 | 2 | 241 | 162 | 230 | HIH95966.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 240 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31863968 | 31863968 | PRJNA704949_P_NODE_915477_length_275_cov_1.079646_g900143_i0 | PRJNA704949 | 915477 | 275 | 1.079646 | 2.9690265 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 3.94e-5 | NR | HEX9567559.1 | 1906666 | g900143 | i0 | 68.8 | 1.02545454545455 | 32 | 10 | 34.9 | 0 | 102 | 7 | 2 | 33 | HEX9567559.1 acyltransferase [Thermoplasmata archaeon] | diamond | 282 | 51.2 | 0.9921875 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32169682 | 32169682 | PRJNA704949_P_NODE_1432418_length_207_cov_1.316456_g1417080_i0 | PRJNA704949 | 1432418 | 207 | 1.316456 | 2.72506392 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 90.9 | 2.52e-19 | NR | RLF26115.1 | 1906666 | g1417080 | i0 | 58.8 | 0.985507246376812 | 68 | 26 | 98.6 | 1 | 3 | 206 | 44 | 109 | RLF26115.1 MAG: hypothetical protein DRN14_07395 [Thermoplasmata archaeon] | diamond | 204 | 90.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32180558 | 32180558 | PRJNA704949_P_NODE_1486718_length_202_cov_1.359477_g1471380_i0 | PRJNA704949 | 1486718 | 202 | 1.359477 | 2.74614354 | Archaea | 2157 | Archaea | Archaea | 42.4 | 0.0309 | NR | MCD6146725.1 | 1906666 | g1471380 | i0 | 41.5 | 1.21782178217822 | 41 | 21 | 60.9 | 1 | 198 | 76 | 1119 | 1156 | MCD6146725.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 246 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32201205 | 32201205 | PRJNA704949_P_NODE_1669778_length_187_cov_1.507246_g1654439_i0 | PRJNA704949 | 1669778 | 187 | 1.507246 | 2.81855002 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 47.8 | 3.11e-4 | NR | MFA5311946.1 | 1906667 | g1654439 | i0 | 43.2 | 0.705882352941177 | 44 | 25 | 70.6 | 0 | 175 | 44 | 1297 | 1340 | MFA5311946.1 STT3 domain-containing protein [Methanomassiliicoccales archaeon] | diamond | 132 | 47.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 32769924 | 32769924 | PRJNA704949_P_NODE_790180_length_300_cov_1.772908_g774848_i0 | PRJNA704949 | 790180 | 300 | 1.772908 | 5.318724 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 74.3 | 4.26e-14 | NR | MDA7463941.1 | 1915863 | g774848 | i0 | 45.8 | 2.4 | 72 | 38 | 71 | 1 | 66 | 278 | 56 | 127 | MDA7463941.1 glycosyltransferase [Candidatus Poseidonia alphae] | diamond | 720 | 74.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae |
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);;