contig_metadata
20 rows where bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1133846 | 1133846 | PRJNA565584_P_NODE_120281_length_281_cov_2.706731_g119129_i0 | PRJNA565584 | 120281 | 281 | 2.706731 | 7.60591411 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 162 | 8.62e-45 | NR | XP_055343099.1 | 2943436 | g119129 | i0 | 76.3 | 14.8932384341637 | 93 | 22 | 99.3 | 0 | 3 | 281 | 274 | 366 | XP_055343099.1 glucose-6-phosphate isomerase-like [Paramacrobiotus metropolitanus] | diamond | 4185 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 6934797 | 6934797 | PRJNA565584_P_NODE_31646_length_542_cov_1.417910_g30498_i0 | PRJNA565584 | 31646 | 542 | 1.41791 | 7.6850722 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 211 | 1.85e-66 | NR | XP_055339518.1 | 2943436 | g30498 | i0 | 78.3 | 19.1568265682657 | 138 | 30 | 76.4 | 0 | 129 | 542 | 8 | 145 | XP_055339518.1 40S ribosomal protein S9 [Paramacrobiotus metropolitanus] | diamond | 10383 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 6936136 | 6936136 | PRJNA565584_P_NODE_99026_length_300_cov_1.696035_g97874_i0 | PRJNA565584 | 99026 | 300 | 1.696035 | 5.088105 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 111 | 2.87e-26 | NR | OQV19177.1 | 2072580 | g97874 | i0 | 70.8 | 0.72 | 72 | 19 | 72 | 1 | 218 | 3 | 18 | 87 | OQV19177.1 Tubulin beta-4 chain [Hypsibius exemplaris] | diamond | 216 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 9485770 | 9485770 | PRJNA565584_P_NODE_6648_length_1325_cov_8.768371_g5993_i0 | PRJNA565584 | 6648 | 1325 | 8.768371 | 116.18091575 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 454 | 4.95e-154 | NR | XP_055344506.1 | 2943436 | g5993 | i0 | 52.6 | 6.79245283018868 | 426 | 200 | 96.5 | 2 | 3 | 1280 | 9 | 432 | XP_055344506.1 eukaryotic peptide chain release factor subunit 1-like [Paramacrobiotus metropolitanus] | diamond | 9000 | 454 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 12035376 | 12035376 | PRJNA565584_P_NODE_208790_length_242_cov_0.911243_g207638_i0 | PRJNA565584 | 208790 | 242 | 0.911243 | 2.20520806 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 130 | 1.1800000000000001e-36 | NR | OQV20336.1 | 2072580 | g207638 | i0 | 70 | 6.84297520661157 | 80 | 24 | 99.2 | 0 | 241 | 2 | 1 | 80 | OQV20336.1 40S ribosomal protein S18 [Hypsibius exemplaris] | diamond | 1656 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 13887573 | 13887573 | PRJNA565584_P_NODE_106491_length_290_cov_1.889401_g105339_i0 | PRJNA565584 | 106491 | 290 | 1.889401 | 5.4792629 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 149 | 3.589999999999999e-42 | NR | OQV15233.1 | 2072580 | g105339 | i0 | 74.5 | 9.81724137931034 | 94 | 24 | 97.2 | 0 | 283 | 2 | 53 | 146 | OQV15233.1 40S ribosomal protein S2 [Hypsibius exemplaris] | diamond | 2847 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 14586507 | 14586507 | PRJNA565584_P_NODE_82432_length_327_cov_2.629921_g81280_i0 | PRJNA565584 | 82432 | 327 | 2.629921 | 8.59984167 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|2493409534|ref|XM_055473594.1| | 2943436 | g81280 | i0 | 92.105 | 0.116207951070336 | 38 | 2 | 12 | 1 | 200 | 237 | 339 | 303 | PREDICTED: Paramacrobiotus metropolitanus bone morphogenetic protein 2-like (LOC129582160), mRNA | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 19684399 | 19684399 | PRJNA565584_P_NODE_95256_length_307_cov_0.987179_g94104_i0 | PRJNA565584 | 95256 | 307 | 0.987179 | 3.03063953 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 144 | 7.64e-39 | NR | OQV22048.1 | 2072580 | g94104 | i0 | 64.4 | 4.92508143322476 | 101 | 36 | 98.7 | 0 | 3 | 305 | 32 | 132 | OQV22048.1 Calreticulin [Hypsibius exemplaris] | diamond | 1512 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 24086424 | 24086424 | PRJNA565584_P_NODE_204019_length_243_cov_0.905882_g202867_i0 | PRJNA565584 | 204019 | 243 | 0.905882 | 2.20129326 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 133 | 9.179999999999999e-35 | NR | GAU98156.1 | 947166 | g202867 | i0 | 78.5 | 1.95061728395062 | 79 | 17 | 97.5 | 0 | 238 | 2 | 250 | 328 | GAU98156.1 hypothetical protein RvY_09336 [Ramazzottius varieornatus] | diamond | 474 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27079393 | 27079393 | PRJNA565584_P_NODE_181082_length_248_cov_1.320000_g179930_i0 | PRJNA565584 | 181082 | 248 | 1.32 | 3.2736 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 71.2 | 3.59e-12 | NR | OQV15405.1 | 2072580 | g179930 | i0 | 43.6 | 0.943548387096774 | 78 | 42 | 94.4 | 1 | 248 | 15 | 178 | 253 | OQV15405.1 hypothetical protein BV898_10415 [Hypsibius exemplaris] | diamond | 234 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27110891 | 27110891 | PRJNA565584_P_NODE_56782_length_394_cov_2.255452_g55631_i0 | PRJNA565584 | 56782 | 394 | 2.255452 | 8.88648088 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 119 | 1.17e-28 | NR | OQV18148.1 | 2072580 | g55631 | i0 | 61.5 | 1.78934010152284 | 78 | 30 | 59.4 | 0 | 154 | 387 | 64 | 141 | OQV18148.1 Delta(5) fatty acid desaturase A [Hypsibius exemplaris] | diamond | 705 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27237350 | 27237350 | PRJNA565584_P_NODE_16183_length_806_cov_1.724420_g15114_i0 | PRJNA565584 | 16183 | 806 | 1.72442 | 13.8988252 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 331 | 1.0399999999999996e-107 | NR | GAV01754.1 | 947166 | g15114 | i0 | 57.8 | 0.997518610421836 | 268 | 112 | 99.4 | 1 | 801 | 1 | 198 | 465 | GAV01754.1 hypothetical protein RvY_12413 [Ramazzottius varieornatus] | diamond | 804 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28184615 | 28184615 | PRJNA565584_P_NODE_43006_length_456_cov_1.759791_g41855_i0 | PRJNA565584 | 43006 | 456 | 1.759791 | 8.02464696 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 57.8 | 2.01e-6 | NR | XP_055341865.1 | 2943436 | g41855 | i0 | 55 | 0.263157894736842 | 40 | 17 | 25.7 | 1 | 124 | 8 | 184 | 223 | XP_055341865.1 LOW QUALITY PROTEIN: radial spoke head 10 homolog B-like [Paramacrobiotus metropolitanus] | diamond | 120 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 30142290 | 30142290 | PRJNA565584_P_NODE_76712_length_339_cov_1.736842_g75561_i0 | PRJNA565584 | 76712 | 339 | 1.736842 | 5.88789438 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 115 | 2.4400000000000003e-27 | NR | GAV01754.1 | 947166 | g75561 | i0 | 52.6 | 7.0353982300885 | 114 | 50 | 99.1 | 3 | 2 | 337 | 296 | 407 | GAV01754.1 hypothetical protein RvY_12413 [Ramazzottius varieornatus] | diamond | 2385 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30521672 | 30521672 | PRJNA565584_P_NODE_148553_length_263_cov_1.621053_g147401_i0 | PRJNA565584 | 148553 | 263 | 1.621053 | 4.26336939 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 42.7 | 0.0487 | NR | GAV04833.1 | 947166 | g147401 | i0 | 67.9 | 0.319391634980989 | 28 | 9 | 31.9 | 0 | 208 | 125 | 701 | 728 | GAV04833.1 hypothetical protein RvY_15053 [Ramazzottius varieornatus] | diamond | 84 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30521718 | 30521718 | PRJNA565584_P_NODE_205233_length_243_cov_0.905882_g204081_i0 | PRJNA565584 | 205233 | 243 | 0.905882 | 2.20129326 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 68.6 | 2.87e-11 | NR | OQV25167.1 | 2072580 | g204081 | i0 | 46.7 | 1.95061728395062 | 75 | 31 | 81.5 | 1 | 42 | 239 | 7 | 81 | OQV25167.1 Kynureninase [Hypsibius exemplaris] | diamond | 474 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30837676 | 30837676 | PRJNA565584_P_NODE_182274_length_248_cov_0.880000_g181122_i0 | PRJNA565584 | 182274 | 248 | 0.88 | 2.1824 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 64.7 | 2.69e-10 | NR | XP_055338374.1 | 2943436 | g181122 | i0 | 55.1 | 0.592741935483871 | 49 | 22 | 59.3 | 0 | 248 | 102 | 171 | 219 | XP_055338374.1 MOB kinase activator 1B-like isoform X2 [Paramacrobiotus metropolitanus] | diamond | 147 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31027402 | 31027402 | PRJNA565584_P_NODE_171055_length_250_cov_1.740113_g169903_i0 | PRJNA565584 | 171055 | 250 | 1.740113 | 4.3502825 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 80.9 | 8.51e-16 | NR | XP_055354485.1 | 2943436 | g169903 | i0 | 47.4 | 0.912 | 76 | 40 | 91.2 | 0 | 248 | 21 | 251 | 326 | XP_055354485.1 glyoxal reductase-like [Paramacrobiotus metropolitanus] | diamond | 228 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 32324350 | 32324350 | PRJNA565584_P_NODE_146019_length_265_cov_1.203125_g144867_i0 | PRJNA565584 | 146019 | 265 | 1.203125 | 3.18828125 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 50.4 | 8.3e-5 | NR | OQV16256.1 | 2072580 | g144867 | i0 | 41.4 | 0.984905660377358 | 87 | 44 | 96.2 | 4 | 3 | 257 | 173 | 254 | OQV16256.1 putative Dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 2 [Hypsibius exemplaris] | diamond | 261 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32639871 | 32639871 | PRJNA565584_P_NODE_58400_length_389_cov_1.275316_g57249_i0 | PRJNA565584 | 58400 | 389 | 1.275316 | 4.96097924 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 109 | 1.3e-25 | NR | OWA50627.1 | 2072580 | g57249 | i0 | 45.8 | 7.62724935732648 | 118 | 61 | 91 | 1 | 376 | 23 | 188 | 302 | OWA50627.1 Ras-like protein 1 [Hypsibius exemplaris] | diamond | 2967 | 109 | 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);;