contig_metadata
12 rows where bioproject = "PRJEB75230" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4823788 | 4823788 | PRJEB75230_P_NODE_11064_length_455_cov_1.460733_g10882_i0 | PRJEB75230 | 11064 | 455 | 1.460733 | 6.64633515 | root | 1 | Root_unresolved | Root_unresolved | 841 | 0 | NTclustered | gi|471648006|gb|KC661715.1| | 29281 | g10882 | i0 | 100 | 100 | 455 | 0 | 100 | 0 | 1 | 455 | 117 | 571 | Uncultured crenarchaeote clone BC-M-Sd-S1-D8 16S ribosomal RNA gene, partial sequence | blastn | 45500 | 841 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 11615835 | 11615835 | PRJEB75230_P_NODE_46450_length_317_cov_1.577869_g46268_i0 | PRJEB75230 | 46450 | 317 | 1.577869 | 5.00184473 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 492 | 1.48e-134 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g46268 | i0 | 94.654 | 87.3596214511041 | 318 | 15 | 100 | 2 | 1 | 317 | 42608 | 42292 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 27693 | 492 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 12474958 | 12474958 | PRJEB75230_P_NODE_24530_length_366_cov_1.385666_g24348_i0 | PRJEB75230 | 24530 | 366 | 1.385666 | 5.07153756 | Thermoproteati | 1783275 | Archaea | Archaea | 503 | 7.98e-138 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g24348 | i0 | 91.53 | 112.125683060109 | 366 | 30 | 100 | 1 | 1 | 366 | 7281 | 6917 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 41038 | 503 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 27532498 | 27532498 | PRJEB75230_P_NODE_53803_length_307_cov_1.252137_g53621_i0 | PRJEB75230 | 53803 | 307 | 1.252137 | 3.8440605900000002 | Nitrosopumilaceae | 338190 | Archaea | Archaea | 110 | 1.02e-25 | NR | MFB5616604.1 | 2024843 | g53621 | i0 | 58 | 3.9185667752443 | 100 | 41 | 97.7 | 1 | 6 | 305 | 258 | 356 | MFB5616604.1 copper-translocating P-type ATPase [Nitrosopumilus sp.] | diamond | 1203 | 110 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 27571299 | 27571299 | PRJEB75230_P_NODE_122264_length_251_cov_0.865169_g122082_i0 | PRJEB75230 | 122264 | 251 | 0.865169 | 2.17157419 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 43.5 | 0.0163 | NR | MCD6349017.1 | 2056631 | g122082 | i0 | 30.3 | 0.908366533864542 | 76 | 44 | 90.8 | 1 | 19 | 246 | 106 | 172 | MCD6349017.1 pyroglutamyl-peptidase I [Thermoproteota archaeon] | diamond | 228 | 43.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27824088 | 27824088 | PRJEB75230_P_NODE_129584_length_249_cov_1.312500_g129402_i0 | PRJEB75230 | 129584 | 249 | 1.3125 | 3.268125 | Vulcanisaeta distributa | 164451 | Archaea | Archaea | 42.4 | 0.0495 | NR | WP_013336163.1 | 164451 | g129402 | i0 | 35.5 | 0.746987951807229 | 62 | 34 | 74.7 | 1 | 232 | 47 | 161 | 216 | WP_013336163.1 PD-(D/E)XK nuclease family protein [Vulcanisaeta distributa] | diamond | 186 | 42.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta distributa | ||
| 28455611 | 28455611 | PRJEB75230_P_NODE_666_length_1455_cov_2.392909_g583_i0 | PRJEB75230 | 666 | 1455 | 2.392909 | 34.81682595 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 59.3 | 3.16e-5 | NR | MCX6655225.1 | 2026714 | g583 | i0 | 38.7 | 0.218556701030928 | 106 | 55 | 21.2 | 6 | 1364 | 1056 | 565 | 663 | MCX6655225.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 318 | 59.3 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29654828 | 29654828 | PRJEB75230_P_NODE_68770_length_290_cov_1.064516_g68588_i0 | PRJEB75230 | 68770 | 290 | 1.064516 | 3.0870964 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 43.5 | 0.0345 | NR | MFB5600260.1 | 2169593 | g68588 | i0 | 37.8 | 0.76551724137931 | 74 | 43 | 73.4 | 1 | 13 | 225 | 81 | 154 | MFB5600260.1 DNA polymerase/3'-5' exonuclease PolX [Nitrososphaeraceae archaeon] | diamond | 222 | 43.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31077020 | 31077020 | PRJEB75230_P_NODE_41455_length_325_cov_1.408730_g41273_i0 | PRJEB75230 | 41455 | 325 | 1.40873 | 4.5783725 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 43.9 | 0.0365 | NR | MEM1676955.1 | 2026795 | g41273 | i0 | 36.9 | 0.6 | 65 | 40 | 60 | 1 | 120 | 314 | 503 | 566 | MEM1676955.1 glycoside hydrolase family 31 protein [Nitrososphaerota archaeon] | diamond | 195 | 43.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32120734 | 32120734 | PRJEB75230_P_NODE_153318_length_245_cov_1.558140_g153136_i0 | PRJEB75230 | 153318 | 245 | 1.55814 | 3.817443 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 43.5 | 0.0201 | NR | HYC23744.1 | 3045160 | g153136 | i0 | 37.7 | 0.844897959183673 | 69 | 41 | 84.5 | 1 | 228 | 22 | 387 | 453 | HYC23744.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 207 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 32183992 | 32183992 | PRJEB75230_P_NODE_63558_length_295_cov_1.734234_g63376_i0 | PRJEB75230 | 63558 | 295 | 1.734234 | 5.1159903 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 43.5 | 0.0257 | NR | HYU87664.1 | 3045160 | g63376 | i0 | 32.4 | 0.722033898305085 | 71 | 45 | 71.2 | 2 | 288 | 79 | 57 | 125 | HYU87664.1 CHRD domain-containing protein [Candidatus Bathyarchaeia archaeon] | diamond | 213 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 32405447 | 32405447 | PRJEB75230_P_NODE_170179_length_243_cov_0.905882_g169997_i0 | PRJEB75230 | 170179 | 243 | 0.905882 | 2.20129326 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 54.7 | 6.93e-7 | NR | HEY7081356.1 | 2169593 | g169997 | i0 | 85.2 | 0.864197530864197 | 27 | 4 | 33.3 | 0 | 163 | 243 | 23 | 49 | HEY7081356.1 RidA family protein [Nitrososphaeraceae archaeon] | diamond | 210 | 54.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;