contig_metadata
9 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;