contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9230953 | 9230953 | PRJNA1156092_P_NODE_31588_length_242_cov_0.911243_g31458_i0 | PRJNA1156092 | 31588 | 242 | 0.911243 | 2.20520806 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 134 | 1.59e-34 | NR | MCD6461348.1 | 1906666 | g31458 | i0 | 82.3 | 2.90082644628099 | 79 | 14 | 97.9 | 0 | 241 | 5 | 79 | 157 | MCD6461348.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Thermoplasmata archaeon] | diamond | 702 | 134 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26628718 | 26628718 | PRJNA1156092_P_NODE_29041_length_244_cov_0.900585_g28911_i0 | PRJNA1156092 | 29041 | 244 | 0.900585 | 2.1974274 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 138 | 7.1699999999999995e-37 | NR | MBD3351434.1 | 2053489 | g28911 | i0 | 81 | 0.971311475409836 | 79 | 15 | 97.1 | 0 | 242 | 6 | 77 | 155 | MBD3351434.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 237 | 138 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 26660124 | 26660124 | PRJNA1156092_P_NODE_31001_length_242_cov_0.911243_g30871_i0 | PRJNA1156092 | 31001 | 242 | 0.911243 | 2.20520806 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 151 | 1.4e-45 | NR | MDH3617759.1 | 2024843 | g30871 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 2 | 241 | 11 | 90 | MDH3617759.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 240 | 151 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 26787238 | 26787238 | PRJNA1156092_P_NODE_26081_length_247_cov_0.885057_g25951_i0 | PRJNA1156092 | 26081 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 50.1 | 8.11e-5 | NR | NDB56545.1 | 1906665 | g25951 | i0 | 36.2 | 0.838056680161943 | 69 | 44 | 83.8 | 0 | 218 | 12 | 6 | 74 | NDB56545.1 hypothetical protein [archaeon] | diamond | 207 | 50.1 | 1 | Archaea | archaeon | ||||||||
| 27008485 | 27008485 | PRJNA1156092_P_NODE_32542_length_241_cov_0.916667_g32412_i0 | PRJNA1156092 | 32542 | 241 | 0.916667 | 2.20916747 | Halohasta salina | 2961621 | Archaea | Archaea | 45.4 | 0.00401 | NR | WP_253737137.1 | 2961621 | g32412 | i0 | 48.7 | 0.485477178423237 | 39 | 20 | 48.5 | 0 | 124 | 240 | 51 | 89 | WP_253737137.1 cytochrome P450 [Halohasta salina] | diamond | 117 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta salina | |
| 27293173 | 27293173 | PRJNA1156092_P_NODE_20443_length_260_cov_1.647059_g20313_i0 | PRJNA1156092 | 20443 | 260 | 1.647059 | 4.2823534 | archaeon | 1906665 | Archaea | Archaea | 143 | 3.3599999999999998e-40 | NR | RYG64625.1 | 1906665 | g20313 | i0 | 81.4 | 0.992307692307692 | 86 | 16 | 99.2 | 0 | 260 | 3 | 152 | 237 | RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon] | diamond | 258 | 143 | 1 | Archaea | archaeon | ||||||||
| 27672321 | 27672321 | PRJNA1156092_P_NODE_22104_length_251_cov_0.865169_g21974_i0 | PRJNA1156092 | 22104 | 251 | 0.865169 | 2.17157419 | archaeon | 1906665 | Archaea | Archaea | 70.1 | 8.35e-12 | NR | MCQ2818097.1 | 1906665 | g21974 | i0 | 36 | 1.19521912350598 | 100 | 43 | 98 | 2 | 2 | 247 | 96 | 192 | MCQ2818097.1 TCR domain-containing protein [archaeon] | diamond | 300 | 70.1 | 1 | Archaea | archaeon | ||||||||
| 27704075 | 27704075 | PRJNA1156092_P_NODE_29504_length_244_cov_0.900585_g29374_i0 | PRJNA1156092 | 29504 | 244 | 0.900585 | 2.1974274 | archaeon | 1906665 | Archaea | Archaea | 89.4 | 1.5e-18 | NR | MDP2435113.1 | 1906665 | g29374 | i0 | 47.6 | 1.97950819672131 | 82 | 41 | 98.4 | 1 | 240 | 1 | 540 | 621 | MDP2435113.1 hypothetical protein [archaeon] | diamond | 483 | 89.4 | 1 | Archaea | archaeon | ||||||||
| 27861468 | 27861468 | PRJNA1156092_P_NODE_26105_length_247_cov_0.885057_g25975_i0 | PRJNA1156092 | 26105 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 62 | 2.11e-9 | NR | RYH21457.1 | 1906665 | g25975 | i0 | 41 | 0.740890688259109 | 61 | 35 | 74.1 | 1 | 183 | 1 | 58 | 117 | RYH21457.1 MAG: PaaI family thioesterase [archaeon] | diamond | 183 | 62 | 1 | Archaea | archaeon | ||||||||
| 29850882 | 29850882 | PRJNA1156092_P_NODE_23971_length_249_cov_0.875000_g23841_i0 | PRJNA1156092 | 23971 | 249 | 0.875 | 2.17875 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 43.1 | 0.0259 | NR | MAG25949.1 | 2026773 | g23841 | i0 | 34.2 | 0.91566265060241 | 76 | 48 | 89.2 | 1 | 28 | 249 | 100 | 175 | MAG25949.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 228 | 43.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30166538 | 30166538 | PRJNA1156092_P_NODE_25032_length_248_cov_0.880000_g24902_i0 | PRJNA1156092 | 25032 | 248 | 0.88 | 2.1824 | Candidatus Anstonellales archaeon | 3058027 | Archaea | Archaea | 56.6 | 4.91e-7 | NR | MEM4366749.1 | 3058027 | g24902 | i0 | 35.8 | 0.810483870967742 | 67 | 40 | 79.8 | 2 | 26 | 223 | 189 | 253 | MEM4366749.1 hypothetical protein [Candidatus Anstonellales archaeon] | diamond | 201 | 56.6 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Anstonellales archaeon | ||||
| 30767020 | 30767020 | PRJNA1156092_P_NODE_22294_length_251_cov_0.865169_g22164_i0 | PRJNA1156092 | 22294 | 251 | 0.865169 | 2.17157419 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 92 | 7.360000000000001e-21 | NR | HWR98909.1 | 2032688 | g22164 | i0 | 59.7 | 0.860557768924303 | 72 | 29 | 86.1 | 0 | 3 | 218 | 141 | 212 | HWR98909.1 deoxynucleoside kinase [Candidatus Methanoperedens sp.] | diamond | 216 | 92 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 31841761 | 31841761 | PRJNA1156092_P_NODE_25917_length_247_cov_0.885057_g25787_i0 | PRJNA1156092 | 25917 | 247 | 0.885057 | 2.18609079 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 80.9 | 1.54e-15 | NR | MBI2664459.1 | 2026803 | g25787 | i0 | 55.6 | 0.983805668016194 | 81 | 36 | 98.4 | 0 | 1 | 243 | 6864 | 6944 | MBI2664459.1 VCBS repeat-containing protein [Candidatus Woesearchaeota archaeon] | diamond | 243 | 80.9 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32253573 | 32253573 | PRJNA1156092_P_NODE_25658_length_248_cov_0.880000_g25528_i0 | PRJNA1156092 | 25658 | 248 | 0.88 | 2.1824 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 108 | 4.87e-26 | NR | RLI35948.1 | 2026714 | g25528 | i0 | 58.2 | 0.955645161290323 | 79 | 33 | 95.6 | 0 | 248 | 12 | 305 | 383 | RLI35948.1 MAG: hypothetical protein DRO66_06560 [Candidatus Bathyarchaeota archaeon] | diamond | 237 | 108 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32840743 | 32840743 | PRJNA1156092_P_NODE_25680_length_248_cov_0.880000_g25550_i0 | PRJNA1156092 | 25680 | 248 | 0.88 | 2.1824 | Archaea | 2157 | Archaea | Archaea | 108 | 8.910000000000001e-27 | NR | MBS3094758.1 | 2026773 | g25550 | i0 | 59.8 | 2.9758064516129 | 82 | 33 | 99.2 | 0 | 2 | 247 | 48 | 129 | MBS3094758.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 738 | 109 | 0.990825688073395 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota 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);;