contig_metadata
16 rows where bioproject = "PRJNA966993" and tax_phylum = "Tardigrada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2217253 | 2217253 | PRJNA966993_P_NODE_2002_length_1381_cov_2.803517_g1806_i0 | PRJNA966993 | 2002 | 1381 | 2.803517 | 38.71656977 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 439 | 5.579999999999998e-148 | NR | XP_055344506.1 | 2943436 | g1806 | i0 | 53.4 | 39.5561187545257 | 410 | 190 | 89.1 | 1 | 17 | 1246 | 15 | 423 | XP_055344506.1 eukaryotic peptide chain release factor subunit 1-like [Paramacrobiotus metropolitanus] | diamond | 54627 | 439 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 17520102 | 17520102 | PRJNA966993_P_NODE_33094_length_371_cov_1.322148_g32642_i0 | PRJNA966993 | 33094 | 371 | 1.322148 | 4.90516908 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 177 | 6.36e-51 | NR | GAV05741.1 | 947166 | g32642 | i0 | 76.4 | 0.994609164420485 | 123 | 28 | 98.7 | 1 | 366 | 1 | 1 | 123 | GAV05741.1 hypothetical protein RvY_15822 [Ramazzottius varieornatus] | diamond | 369 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 26962427 | 26962427 | PRJNA966993_P_NODE_39502_length_342_cov_1.717472_g39050_i0 | PRJNA966993 | 39502 | 342 | 1.717472 | 5.87375424 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 90.1 | 2.1e-18 | NR | GAU98412.1 | 947166 | g39050 | i0 | 55.2 | 2.2719298245614 | 87 | 37 | 74.6 | 1 | 68 | 322 | 2 | 88 | GAU98412.1 hypothetical protein RvY_09564 [Ramazzottius varieornatus] | diamond | 777 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27089204 | 27089204 | PRJNA966993_P_NODE_55522_length_291_cov_2.018349_g55070_i0 | PRJNA966993 | 55522 | 291 | 2.018349 | 5.87339559 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 142 | 8.63e-38 | NR | XP_055332054.1 | 2943436 | g55070 | i0 | 71.9 | 0.917525773195876 | 89 | 25 | 91.8 | 0 | 267 | 1 | 7 | 95 | XP_055332054.1 pancreatic alpha-amylase-like [Paramacrobiotus metropolitanus] | diamond | 267 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27342172 | 27342172 | PRJNA966993_P_NODE_86843_length_248_cov_3.188571_g86391_i0 | PRJNA966993 | 86843 | 248 | 3.188571 | 7.90765608 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 43.1 | 0.0286 | NR | OQV13661.1 | 2072580 | g86391 | i0 | 46.5 | 0.520161290322581 | 43 | 23 | 52 | 0 | 236 | 108 | 52 | 94 | OQV13661.1 putative Monocarboxylate transporter 13 [Hypsibius exemplaris] | diamond | 129 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27500001 | 27500001 | PRJNA966993_P_NODE_81683_length_251_cov_2.269663_g81231_i0 | PRJNA966993 | 81683 | 251 | 2.269663 | 5.69685413 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 46.2 | 0.00253 | NR | GAV07996.1 | 947166 | g81231 | i0 | 43.2 | 1.57768924302789 | 44 | 23 | 52.6 | 1 | 6 | 137 | 998 | 1039 | GAV07996.1 hypothetical protein RvY_17762 [Ramazzottius varieornatus] | diamond | 396 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28706146 | 28706146 | PRJNA966993_P_NODE_48527_length_310_cov_3.426160_g48075_i0 | PRJNA966993 | 48527 | 310 | 3.42616 | 10.621096 | Opisthokonta | 33154 | Tardigrada | other_Eukaryota | 63.5 | 1.5e-9 | NR | GAU95530.1 | 947166 | g48075 | i0 | 66 | 2.45806451612903 | 50 | 17 | 48.4 | 0 | 297 | 148 | 137 | 186 | GAU95530.1 hypothetical protein RvY_07131 [Ramazzottius varieornatus] | diamond | 762 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 29488897 | 29488897 | PRJNA966993_P_NODE_87450_length_248_cov_0.880000_g86998_i0 | PRJNA966993 | 87450 | 248 | 0.88 | 2.1824 | Hypsibius dujardini | 232323 | Tardigrada | other_Eukaryota | 85.9 | 1.57e-17 | NR | ALT32096.1 | 232323 | g86998 | i0 | 48.1 | 6.45967741935484 | 77 | 40 | 93.1 | 0 | 8 | 238 | 233 | 309 | ALT32096.1 putative pre-mRNA-splicing factor RBM22 [Hypsibius dujardini] | diamond | 1602 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius dujardini | |
| 30279014 | 30279014 | PRJNA966993_P_NODE_46792_length_316_cov_1.267490_g46340_i0 | PRJNA966993 | 46792 | 316 | 1.26749 | 4.0052684 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 60.8 | 2.92e-8 | NR | OQV22079.1 | 2072580 | g46340 | i0 | 35.9 | 0.873417721518987 | 92 | 50 | 84.5 | 4 | 274 | 8 | 48 | 133 | OQV22079.1 hypothetical protein BV898_03924 [Hypsibius exemplaris] | diamond | 276 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30348714 | 30348714 | PRJNA966993_P_NODE_28552_length_396_cov_2.198142_g28102_i0 | PRJNA966993 | 28552 | 396 | 2.198142 | 8.70464232 | Parachela | 149990 | Tardigrada | other_Eukaryota | 114 | 7.71e-30 | NR | GAU90086.1 | 947166 | g28102 | i0 | 43.5 | 1.63636363636364 | 108 | 60 | 81.1 | 1 | 369 | 49 | 3 | 110 | GAU90086.1 hypothetical protein RvY_02556-1 [Ramazzottius varieornatus] | diamond | 648 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30657761 | 30657761 | PRJNA966993_P_NODE_28693_length_395_cov_2.720497_g28241_i0 | PRJNA966993 | 28693 | 395 | 2.720497 | 10.74596315 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 76.6 | 3.03e-14 | NR | OWA50473.1 | 2072580 | g28241 | i0 | 65.5 | 0.89620253164557 | 58 | 19 | 44.1 | 1 | 216 | 389 | 4 | 60 | OWA50473.1 putative Glutathione S-transferase 1 [Hypsibius exemplaris] | diamond | 354 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30917077 | 30917077 | PRJNA966993_P_NODE_63254_length_280_cov_1.483092_g62802_i0 | PRJNA966993 | 63254 | 280 | 1.483092 | 4.1526576 | Metazoa | 33208 | Tardigrada | other_Eukaryota | 122 | 2.63e-30 | NR | GAU91452.1 | 947166 | g62802 | i0 | 71.1 | 4.44642857142857 | 76 | 22 | 81.4 | 0 | 47 | 274 | 53 | 128 | GAU91452.1 hypothetical protein RvY_03701 [Ramazzottius varieornatus] | diamond | 1245 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 31890753 | 31890753 | PRJNA966993_P_NODE_55417_length_291_cov_2.655963_g54965_i0 | PRJNA966993 | 55417 | 291 | 2.655963 | 7.72885233 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 43.1 | 0.0487 | NR | OWA55033.1 | 2072580 | g54965 | i0 | 40.8 | 0.731958762886598 | 71 | 29 | 59.8 | 3 | 3 | 176 | 556 | 626 | OWA55033.1 putative Vascular endothelial growth factor receptor 3 [Hypsibius exemplaris] | diamond | 213 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32017297 | 32017297 | PRJNA966993_P_NODE_34398_length_364_cov_3.443299_g33946_i0 | PRJNA966993 | 34398 | 364 | 3.443299 | 12.53360836 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 53.1 | 2.88e-5 | NR | GAV07460.1 | 947166 | g33946 | i0 | 35.4 | 1.07142857142857 | 130 | 48 | 78.3 | 5 | 2 | 286 | 202 | 330 | GAV07460.1 hypothetical protein RvY_17290 [Ramazzottius varieornatus] | diamond | 390 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 32365638 | 32365638 | PRJNA966993_P_NODE_80579_length_253_cov_1.711111_g80127_i0 | PRJNA966993 | 80579 | 253 | 1.711111 | 4.32911083 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 44.7 | 0.0087 | NR | GAU98834.1 | 947166 | g80127 | i0 | 39.7 | 0.687747035573123 | 58 | 33 | 66.4 | 1 | 170 | 3 | 679 | 736 | GAU98834.1 hypothetical protein RvY_09924 [Ramazzottius varieornatus] | diamond | 174 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 32561851 | 32561851 | PRJNA966993_P_NODE_33139_length_371_cov_1.033557_g32687_i0 | PRJNA966993 | 33139 | 371 | 1.033557 | 3.83449647 | Parachela | 149990 | Tardigrada | other_Eukaryota | 182 | 2.6299999999999996e-54 | NR | OWA51711.1 | 2072580 | g32687 | i0 | 68.4 | 12.7035040431267 | 117 | 37 | 94.6 | 0 | 10 | 360 | 98 | 214 | OWA51711.1 40S ribosomal protein SA [Hypsibius exemplaris] | diamond | 4713 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris |
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);;