contig_metadata
24 rows where bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4423060 | 4423060 | PRJNA615351_P_NODE_11984_length_1884_cov_304.278529_g8619_i0 | PRJNA615351 | 11984 | 1884 | 304.278529 | 5732.60748636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 440 | 8.42e-146 | NR | XP_055344506.1 | 2943436 | g8619 | i0 | 53.5 | 21.7133757961783 | 409 | 189 | 65.1 | 1 | 1812 | 586 | 15 | 422 | XP_055344506.1 eukaryotic peptide chain release factor subunit 1-like [Paramacrobiotus metropolitanus] | diamond | 40908 | 442 | 0.995475113122172 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 8248633 | 8248633 | PRJNA615351_P_NODE_117347_length_257_cov_3.193694_g103248_i0 | PRJNA615351 | 117347 | 257 | 3.193694 | 8.20779358 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 104 | 5.05e-26 | NR | GAU93811.1 | 947166 | g103248 | i0 | 69.4 | 2.75486381322957 | 72 | 22 | 84 | 0 | 13 | 228 | 1 | 72 | GAU93811.1 hypothetical protein RvY_05693 [Ramazzottius varieornatus] | diamond | 708 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 12075060 | 12075060 | PRJNA615351_P_NODE_31030_length_1103_cov_144.255618_g22598_i1 | PRJNA615351 | 31030 | 1103 | 144.255618 | 1591.13946654 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 127 | 2.36e-29 | NR | XP_055354490.1 | 2943436 | g22598 | i1 | 30.6 | 3.73708068902992 | 281 | 146 | 72.6 | 9 | 131 | 931 | 111 | 356 | XP_055354490.1 cathepsin B-like cysteine proteinase [Paramacrobiotus metropolitanus] | diamond | 4122 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 15178294 | 15178294 | PRJNA615351_P_NODE_121532_length_246_cov_2.071090_g107432_i0 | PRJNA615351 | 121532 | 246 | 2.07109 | 5.0948814 | Metazoa | 33208 | Tardigrada | other_Eukaryota | 120 | 4.4699999999999995e-30 | NR | GAU98919.1 | 947166 | g107432 | i0 | 60.5 | 3.96341463414634 | 81 | 32 | 98.8 | 0 | 245 | 3 | 196 | 276 | GAU98919.1 hypothetical protein RvY_09994 [Ramazzottius varieornatus] | diamond | 975 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 26922329 | 26922329 | PRJNA615351_P_NODE_62322_length_572_cov_4.608939_g48892_i0 | PRJNA615351 | 62322 | 572 | 4.608939 | 26.36313108 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 123 | 1.16e-31 | NR | XP_055345648.1 | 2943436 | g48892 | i0 | 40.5 | 1.75699300699301 | 168 | 93 | 88.1 | 3 | 526 | 23 | 21 | 181 | XP_055345648.1 NEDD8-conjugating enzyme Ubc12-like [Paramacrobiotus metropolitanus] | diamond | 1005 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27491420 | 27491420 | PRJNA615351_P_NODE_99343_length_321_cov_1.398601_g85246_i0 | PRJNA615351 | 99343 | 321 | 1.398601 | 4.48950921 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 48.9 | 6.01e-4 | NR | XP_055356988.1 | 2943436 | g85246 | i0 | 42.9 | 2.38317757009346 | 56 | 31 | 52.3 | 1 | 319 | 152 | 82 | 136 | XP_055356988.1 LOW QUALITY PROTEIN: importin subunit alpha-5-like [Paramacrobiotus metropolitanus] | diamond | 765 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27744202 | 27744202 | PRJNA615351_P_NODE_87684_length_378_cov_2.411079_g73609_i0 | PRJNA615351 | 87684 | 378 | 2.411079 | 9.11387862 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 48.5 | 8.21e-4 | NR | GAV00831.1 | 947166 | g73609 | i0 | 45.5 | 0.349206349206349 | 44 | 23 | 34.1 | 1 | 199 | 71 | 40 | 83 | GAV00831.1 hypothetical protein RvY_11625 [Ramazzottius varieornatus] | diamond | 132 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27901552 | 27901552 | PRJNA615351_P_NODE_47645_length_762_cov_8.845942_g35929_i0 | PRJNA615351 | 47645 | 762 | 8.845942 | 67.40607804 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 50.8 | 0.00216 | NR | XP_055339990.1 | 2943436 | g35929 | i0 | 26.8 | 0.720472440944882 | 183 | 115 | 68.5 | 5 | 571 | 50 | 41 | 213 | XP_055339990.1 thioredoxin-related transmembrane protein 1-like [Paramacrobiotus metropolitanus] | diamond | 549 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 28312311 | 28312311 | PRJNA615351_P_NODE_75326_length_458_cov_9.661939_g61329_i0 | PRJNA615351 | 75326 | 458 | 9.661939 | 44.25168062 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 155 | 2.23e-45 | NR | OQV12465.1 | 2072580 | g61329 | i0 | 62.7 | 2.7707423580786 | 142 | 52 | 93 | 1 | 33 | 458 | 4 | 144 | OQV12465.1 putative 60S ribosomal protein L27a [Hypsibius exemplaris] | diamond | 1269 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 28406921 | 28406921 | PRJNA615351_P_NODE_25286_length_1271_cov_3.194984_g18421_i0 | PRJNA615351 | 25286 | 1271 | 3.194984 | 40.60824664 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 47.8 | 0.0277 | NR | XP_055352736.1 | 2943436 | g18421 | i0 | 38.6 | 0.134539732494099 | 57 | 30 | 13.5 | 2 | 1048 | 1218 | 20 | 71 | XP_055352736.1 MORN repeat-containing protein 5-like [Paramacrobiotus metropolitanus] | diamond | 171 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 28704073 | 28704073 | PRJNA615351_P_NODE_45887_length_793_cov_2.179420_g34465_i0 | PRJNA615351 | 45887 | 793 | 2.17942 | 17.2828006 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 2.2e-7 | NR | GAV08644.1 | 947166 | g34465 | i0 | 26.4 | 7.8499369482976 | 216 | 146 | 77.6 | 4 | 717 | 103 | 289 | 502 | GAV08644.1 hypothetical protein RvY_18306 [Ramazzottius varieornatus] | diamond | 6225 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28880324 | 28880324 | PRJNA615351_P_NODE_151848_length_187_cov_1.901316_g137748_i0 | PRJNA615351 | 151848 | 187 | 1.901316 | 3.55546092 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 45.1 | 0.00251 | NR | GAV07546.1 | 947166 | g137748 | i0 | 50.8 | 0.946524064171123 | 59 | 21 | 93 | 4 | 179 | 6 | 62 | 113 | GAV07546.1 hypothetical protein RvY_17370 [Ramazzottius varieornatus] | diamond | 177 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28911749 | 28911749 | PRJNA615351_P_NODE_18088_length_1548_cov_4.999339_g13086_i0 | PRJNA615351 | 18088 | 1548 | 4.999339 | 77.38976772 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 82 | 1.72e-12 | NR | OWA54404.1 | 2072580 | g13086 | i0 | 22.6 | 0.916666666666667 | 473 | 319 | 88.6 | 17 | 35 | 1405 | 7 | 448 | OWA54404.1 Protein disulfide-isomerase [Hypsibius exemplaris] | diamond | 1419 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29480052 | 29480052 | PRJNA615351_P_NODE_183930_length_153_cov_1.008475_g169830_i0 | PRJNA615351 | 183930 | 153 | 1.008475 | 1.54296675 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 43.9 | 0.00424 | NR | XP_055338628.1 | 2943436 | g169830 | i0 | 43.2 | 3.15686274509804 | 44 | 25 | 86.3 | 0 | 143 | 12 | 526 | 569 | XP_055338628.1 atrial natriuretic peptide receptor 1-like isoform X1 [Paramacrobiotus metropolitanus] | diamond | 483 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 29637783 | 29637783 | PRJNA615351_P_NODE_110450_length_279_cov_1.147541_g96351_i0 | PRJNA615351 | 110450 | 279 | 1.147541 | 3.20163939 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 94.4 | 3.81e-20 | NR | OQV18148.1 | 2072580 | g96351 | i0 | 44.7 | 2.01075268817204 | 94 | 49 | 97.8 | 1 | 273 | 1 | 194 | 287 | OQV18148.1 Delta(5) fatty acid desaturase A [Hypsibius exemplaris] | diamond | 561 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30617350 | 30617350 | PRJNA615351_P_NODE_103173_length_305_cov_1.214815_g89074_i0 | PRJNA615351 | 103173 | 305 | 1.214815 | 3.70518575 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 76.6 | 9.4e-14 | NR | OWA54359.1 | 2072580 | g89074 | i0 | 44.6 | 0.816393442622951 | 83 | 46 | 81.6 | 0 | 6 | 254 | 369 | 451 | OWA54359.1 hypothetical protein BV898_18764 [Hypsibius exemplaris] | diamond | 249 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30870272 | 30870272 | PRJNA615351_P_NODE_22374_length_1372_cov_3.851159_g16269_i0 | PRJNA615351 | 22374 | 1372 | 3.851159 | 52.83790148 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 55.1 | 5.61e-4 | NR | OQV16374.1 | 2072580 | g16269 | i0 | 41.5 | 0.277696793002915 | 65 | 34 | 14 | 2 | 197 | 6 | 510 | 571 | OQV16374.1 hypothetical protein BV898_09519 [Hypsibius exemplaris] | diamond | 381 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 31280990 | 31280990 | PRJNA615351_P_NODE_12695_length_1835_cov_6.732222_g9122_i0 | PRJNA615351 | 12695 | 1835 | 6.732222 | 123.5362737 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 50.8 | 0.0154 | NR | XP_055330985.1 | 2943436 | g9122 | i0 | 29 | 0.163487738419619 | 100 | 60 | 15.9 | 5 | 528 | 238 | 37 | 128 | XP_055330985.1 LIM and senescent cell antigen-like-containing domain protein 2 [Paramacrobiotus metropolitanus] | diamond | 300 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31281033 | 31281033 | PRJNA615351_P_NODE_17255_length_1584_cov_83.141382_g12477_i0 | PRJNA615351 | 17255 | 1584 | 83.141382 | 1316.95949088 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 74.7 | 4.11e-10 | NR | XP_055340028.1 | 2943436 | g12477 | i0 | 26.2 | 1.97537878787879 | 355 | 229 | 65.2 | 12 | 1391 | 360 | 58 | 390 | XP_055340028.1 protein disulfide-isomerase 2-like [Paramacrobiotus metropolitanus] | diamond | 3129 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31281114 | 31281114 | PRJNA615351_P_NODE_43575_length_833_cov_21.813283_g32570_i0 | PRJNA615351 | 43575 | 833 | 21.813283 | 181.70464739 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 52.4 | 0.00119 | NR | OQV12514.1 | 2072580 | g32570 | i0 | 30.9 | 0.641056422569028 | 178 | 92 | 62.3 | 8 | 193 | 711 | 74 | 225 | OQV12514.1 putative Testicular acid phosphatase-like protein [Hypsibius exemplaris] | diamond | 534 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 31344508 | 31344508 | PRJNA615351_P_NODE_43576_length_833_cov_21.476190_g32571_i0 | PRJNA615351 | 43576 | 833 | 21.47619 | 178.8966627 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 52.4 | 0.00119 | NR | OQV12514.1 | 2072580 | g32571 | i0 | 30.3 | 1.17406962785114 | 178 | 93 | 62.3 | 7 | 193 | 711 | 74 | 225 | OQV12514.1 putative Testicular acid phosphatase-like protein [Hypsibius exemplaris] | diamond | 978 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 31439129 | 31439129 | PRJNA615351_P_NODE_149876_length_190_cov_1.548387_g135776_i0 | PRJNA615351 | 149876 | 190 | 1.548387 | 2.9419353 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 43.9 | 0.0069 | NR | XP_055344526.1 | 2943436 | g135776 | i0 | 37.9 | 1.87894736842105 | 58 | 31 | 83.7 | 2 | 1 | 159 | 205 | 262 | XP_055344526.1 uncharacterized protein LOC129592499 [Paramacrobiotus metropolitanus] | diamond | 357 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 32515309 | 32515309 | PRJNA615351_P_NODE_9739_length_2061_cov_12.403751_g6971_i0 | PRJNA615351 | 9739 | 2061 | 12.403751 | 255.64130811 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 102 | 2.41e-21 | NR | XP_055350283.1 | 2943436 | g6971 | i0 | 42 | 0.190684133915575 | 131 | 67 | 17.9 | 3 | 1663 | 2031 | 11 | 140 | XP_055350283.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Paramacrobiotus metropolitanus] | diamond | 393 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 32704065 | 32704065 | PRJNA615351_P_NODE_9740_length_2061_cov_12.119941_g6971_i1 | PRJNA615351 | 9740 | 2061 | 12.119941 | 249.79198401 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 102 | 2.41e-21 | NR | XP_055350283.1 | 2943436 | g6971 | i1 | 42 | 0.190684133915575 | 131 | 67 | 17.9 | 3 | 1663 | 2031 | 11 | 140 | XP_055350283.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Paramacrobiotus metropolitanus] | diamond | 393 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus |
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);;