contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23663553 | 23663553 | PRJNA724011_P_NODE_2439_length_1860_cov_99.802462_g2115_i0 | PRJNA724011 | 2439 | 1860 | 99.802462 | 1856.3257932 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 446 | 3.5599999999999984e-148 | NR | XP_055344506.1 | 2943436 | g2115 | i0 | 53.4 | 3.42903225806452 | 416 | 193 | 67.1 | 1 | 1806 | 559 | 9 | 423 | XP_055344506.1 eukaryotic peptide chain release factor subunit 1-like [Paramacrobiotus metropolitanus] | diamond | 6378 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 26767352 | 26767352 | PRJNA724011_P_NODE_86161_length_265_cov_1.359375_g85138_i0 | PRJNA724011 | 86161 | 265 | 1.359375 | 3.60234375 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 65.1 | 6.63e-10 | NR | GAU95449.1 | 947166 | g85138 | i0 | 41.6 | 1.00754716981132 | 89 | 45 | 92.8 | 2 | 265 | 20 | 501 | 589 | GAU95449.1 hypothetical protein RvY_07064 [Ramazzottius varieornatus] | diamond | 267 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 26925536 | 26925536 | PRJNA724011_P_NODE_19522_length_667_cov_1.730640_g18516_i0 | PRJNA724011 | 19522 | 667 | 1.73064 | 11.5433688 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 66.6 | 8.78e-9 | NR | XP_055342170.1 | 2943436 | g18516 | i0 | 33.3 | 0.472263868065967 | 105 | 68 | 46.3 | 1 | 66 | 374 | 7 | 111 | XP_055342170.1 histone-lysine N-methyltransferase SMYD3-like isoform X3 [Paramacrobiotus metropolitanus] | diamond | 315 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 26925629 | 26925629 | PRJNA724011_P_NODE_81702_length_274_cov_1.149254_g80679_i0 | PRJNA724011 | 81702 | 274 | 1.149254 | 3.14895596 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 70.9 | 7.16e-12 | NR | GAV03873.1 | 947166 | g80679 | i0 | 53.3 | 9.18613138686131 | 60 | 28 | 65.7 | 0 | 181 | 2 | 312 | 371 | GAV03873.1 hypothetical protein RvY_14242, partial [Ramazzottius varieornatus] | diamond | 2517 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27241769 | 27241769 | PRJNA724011_P_NODE_92763_length_252_cov_1.720670_g91740_i0 | PRJNA724011 | 92763 | 252 | 1.72067 | 4.3360884 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 74.3 | 3.3e-13 | NR | GAU94869.1 | 947166 | g91740 | i0 | 44 | 1.95238095238095 | 84 | 47 | 100 | 0 | 252 | 1 | 1429 | 1512 | GAU94869.1 hypothetical protein RvY_06575 [Ramazzottius varieornatus] | diamond | 492 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27305143 | 27305143 | PRJNA724011_P_NODE_68523_length_304_cov_2.242424_g67500_i0 | PRJNA724011 | 68523 | 304 | 2.242424 | 6.81696896 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 47.8 | 0.0013 | NR | OQV23253.1 | 2072580 | g67500 | i0 | 32.6 | 0.848684210526316 | 86 | 55 | 81.9 | 2 | 3 | 251 | 54 | 139 | OQV23253.1 putative endoglucanase type K [Hypsibius exemplaris] | diamond | 258 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27463176 | 27463176 | PRJNA724011_P_NODE_88603_length_260_cov_1.631016_g87580_i0 | PRJNA724011 | 88603 | 260 | 1.631016 | 4.2406416 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 46.2 | 0.00232 | NR | XP_055341626.1 | 2943436 | g87580 | i0 | 36.4 | 0.888461538461538 | 77 | 36 | 88.8 | 4 | 246 | 16 | 136 | 199 | XP_055341626.1 phospholipid scramblase 1-like isoform X2 [Paramacrobiotus metropolitanus] | diamond | 231 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27715893 | 27715893 | PRJNA724011_P_NODE_11844_length_904_cov_2.212996_g10965_i0 | PRJNA724011 | 11844 | 904 | 2.212996 | 20.00548384 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 113 | 5.430000000000001e-26 | NR | GAV06567.1 | 947166 | g10965 | i0 | 43.3 | 0.467920353982301 | 141 | 74 | 46.8 | 3 | 329 | 751 | 13 | 147 | GAV06567.1 hypothetical protein RvY_16533 [Ramazzottius varieornatus] | diamond | 423 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28094471 | 28094471 | PRJNA724011_P_NODE_67025_length_308_cov_2.995745_g66002_i0 | PRJNA724011 | 67025 | 308 | 2.995745 | 9.2268946 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 59.7 | 9.11e-8 | NR | OWA52727.1 | 2072580 | g66002 | i0 | 38.8 | 1.17857142857143 | 121 | 54 | 98.4 | 5 | 3 | 305 | 1035 | 1155 | OWA52727.1 hypothetical protein BV898_17173 [Hypsibius exemplaris] | diamond | 363 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 28851969 | 28851969 | PRJNA724011_P_NODE_16988_length_727_cov_5.492355_g16003_i0 | PRJNA724011 | 16988 | 727 | 5.492355 | 39.92942085 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 50.8 | 9.46e-4 | NR | GAV00831.1 | 947166 | g16003 | i0 | 46.2 | 0.214580467675378 | 52 | 27 | 21 | 1 | 700 | 548 | 32 | 83 | GAV00831.1 hypothetical protein RvY_11625 [Ramazzottius varieornatus] | diamond | 156 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28852059 | 28852059 | PRJNA724011_P_NODE_78048_length_281_cov_2.951923_g77025_i0 | PRJNA724011 | 78048 | 281 | 2.951923 | 8.29490363 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 75.5 | 5.14e-15 | NR | OQV19725.1 | 2072580 | g77025 | i0 | 53.3 | 0.96085409252669 | 90 | 36 | 90.7 | 4 | 21 | 275 | 4 | 92 | OQV19725.1 hypothetical protein BV898_06264 [Hypsibius exemplaris] | diamond | 270 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29104984 | 29104984 | PRJNA724011_P_NODE_53648_length_351_cov_1.769784_g52625_i0 | PRJNA724011 | 53648 | 351 | 1.769784 | 6.21194184 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 80.5 | 6.2e-16 | NR | XP_055346023.1 | 2943436 | g52625 | i0 | 43.3 | 1.86324786324786 | 104 | 50 | 83.8 | 4 | 300 | 7 | 5 | 105 | XP_055346023.1 glutathione S-transferase 1-like [Paramacrobiotus metropolitanus] | diamond | 654 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 29294271 | 29294271 | PRJNA724011_P_NODE_58549_length_334_cov_1.287356_g57526_i0 | PRJNA724011 | 58549 | 334 | 1.287356 | 4.29976904 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 51.6 | 8.12e-5 | NR | OQV23253.1 | 2072580 | g57526 | i0 | 33.7 | 0.79940119760479 | 89 | 52 | 79.9 | 3 | 308 | 42 | 31 | 112 | OQV23253.1 putative endoglucanase type K [Hypsibius exemplaris] | diamond | 267 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29483528 | 29483528 | PRJNA724011_P_NODE_92470_length_253_cov_1.283333_g91447_i0 | PRJNA724011 | 92470 | 253 | 1.283333 | 3.24683249 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 77 | 3.48e-14 | NR | GAU93542.1 | 947166 | g91447 | i0 | 45.8 | 2.92885375494071 | 83 | 43 | 98.4 | 1 | 253 | 5 | 55 | 135 | GAU93542.1 hypothetical protein RvY_05468 [Ramazzottius varieornatus] | diamond | 741 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 29525801 | 29525801 | PRJNA724011_P_NODE_39270_length_427_cov_1.087571_g38247_i0 | PRJNA724011 | 39270 | 427 | 1.087571 | 4.64392817 | Metazoa | 33208 | Tardigrada | other_Eukaryota | 105 | 5.529999999999999e-24 | NR | OWA50627.1 | 2072580 | g38247 | i0 | 52.7 | 4.83372365339578 | 91 | 43 | 63.9 | 0 | 153 | 425 | 197 | 287 | OWA50627.1 Ras-like protein 1 [Hypsibius exemplaris] | diamond | 2064 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29578131 | 29578131 | PRJNA724011_P_NODE_15330_length_775_cov_5.383191_g14368_i0 | PRJNA724011 | 15330 | 775 | 5.383191 | 41.71973025 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 125 | 1.15e-30 | NR | OQV13591.1 | 2072580 | g14368 | i0 | 38.3 | 6.4258064516129 | 188 | 113 | 71.6 | 2 | 219 | 773 | 6 | 193 | OQV13591.1 putative Aquaporin-4 [Hypsibius exemplaris] | diamond | 4980 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29767708 | 29767708 | PRJNA724011_P_NODE_2431_length_1862_cov_14.954164_g2108_i0 | PRJNA724011 | 2431 | 1862 | 14.954164 | 278.44653368 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 536 | 1.4099999999999994e-182 | NR | GAV01754.1 | 947166 | g2108 | i0 | 55 | 2.23630504833512 | 460 | 203 | 73.8 | 3 | 1678 | 305 | 50 | 507 | GAV01754.1 hypothetical protein RvY_12413 [Ramazzottius varieornatus] | diamond | 4164 | 536 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30368532 | 30368532 | PRJNA724011_P_NODE_30292_length_502_cov_3.249417_g29274_i0 | PRJNA724011 | 30292 | 502 | 3.2494170000000002 | 16.31207334 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 49.3 | 0.00247 | NR | OQV23253.1 | 2072580 | g29274 | i0 | 37.2 | 0.51394422310757 | 86 | 50 | 49 | 3 | 500 | 255 | 54 | 139 | OQV23253.1 putative endoglucanase type K [Hypsibius exemplaris] | diamond | 258 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30810400 | 30810400 | PRJNA724011_P_NODE_24434_length_575_cov_2.320717_g23418_i0 | PRJNA724011 | 24434 | 575 | 2.320717 | 13.34412275 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 114 | 8.610000000000001e-26 | NR | XP_055346259.1 | 2943436 | g23418 | i0 | 37 | 1.60173913043478 | 165 | 104 | 86.1 | 0 | 514 | 20 | 375 | 539 | XP_055346259.1 heparan-alpha-glucosaminide N-acetyltransferase-like [Paramacrobiotus metropolitanus] | diamond | 921 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31000067 | 31000067 | PRJNA724011_P_NODE_21214_length_631_cov_1.946237_g20202_i0 | PRJNA724011 | 21214 | 631 | 1.946237 | 12.28075547 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 111 | 1.93e-24 | NR | XP_055347033.1 | 2943436 | g20202 | i0 | 38.2 | 5.83835182250396 | 165 | 98 | 77.5 | 3 | 494 | 6 | 16 | 178 | XP_055347033.1 uncharacterized protein LOC129594380 [Paramacrobiotus metropolitanus] | diamond | 3684 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31537743 | 31537743 | PRJNA724011_P_NODE_79056_length_279_cov_1.868932_g78033_i0 | PRJNA724011 | 79056 | 279 | 1.868932 | 5.21432028 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 127 | 2.52e-33 | NR | GAU97488.1 | 947166 | g78033 | i0 | 72 | 0.881720430107527 | 82 | 23 | 88.2 | 0 | 2 | 247 | 218 | 299 | GAU97488.1 hypothetical protein RvY_08772 [Ramazzottius varieornatus] | diamond | 246 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 31600860 | 31600860 | PRJNA724011_P_NODE_106456_length_243_cov_0.905882_g105433_i0 | PRJNA724011 | 106456 | 243 | 0.905882 | 2.20129326 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 48.5 | 3.21e-4 | NR | GAU88192.1 | 947166 | g105433 | i0 | 33.3 | 1.03703703703704 | 84 | 53 | 100 | 1 | 243 | 1 | 147 | 230 | GAU88192.1 hypothetical protein RvY_00936 [Ramazzottius varieornatus] | diamond | 252 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 32328784 | 32328784 | PRJNA724011_P_NODE_77579_length_282_cov_2.937799_g76556_i0 | PRJNA724011 | 77579 | 282 | 2.937799 | 8.28459318 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 64.7 | 1.15e-9 | NR | OQV25773.1 | 2072580 | g76556 | i0 | 41.4 | 0.925531914893617 | 87 | 51 | 92.6 | 0 | 262 | 2 | 1368 | 1454 | OQV25773.1 DNA polymerase epsilon catalytic subunit A [Hypsibius exemplaris] | diamond | 261 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32644118 | 32644118 | PRJNA724011_P_NODE_24860_length_569_cov_2.227823_g23844_i0 | PRJNA724011 | 24860 | 569 | 2.227823 | 12.67631287 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 60.1 | 7.58e-7 | NR | GAU91550.1 | 947166 | g23844 | i0 | 34.8 | 0.48506151142355 | 92 | 57 | 48.5 | 1 | 293 | 568 | 44 | 132 | GAU91550.1 hypothetical protein RvY_03782 [Ramazzottius varieornatus] | diamond | 276 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus |
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);;