contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA315399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16962420 | 16962420 | PRJNA315399_S_NODE_28214_length_252_cov_9.209302_g28013_i0 | PRJNA315399 | 28214 | 252 | 9.209302 | 23.20744104 | Pseudobiotus spinifer | 1477120 | Tardigrada | other_Eukaryota | 91.7 | 2.36e-19 | NR | AHZ34692.1 | 1477120 | g28013 | i0 | 68.9 | 0.726190476190476 | 61 | 19 | 72.6 | 0 | 10 | 192 | 431 | 491 | AHZ34692.1 cytochrome c oxidase subunit I, partial [Pseudobiotus spinifer] | diamond | 183 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Doryphoribiidae | Pseudobiotus | Pseudobiotus spinifer | |
| 24611693 | 24611693 | PRJNA315399_S_NODE_59020_length_205_cov_4.880952_g58819_i0 | PRJNA315399 | 59020 | 205 | 4.880952 | 10.0059516 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 94 | 2.12e-20 | NR | OQV15683.1 | 2072580 | g58819 | i0 | 81.6 | 1.43414634146341 | 49 | 9 | 71.7 | 0 | 14 | 160 | 2299 | 2347 | OQV15683.1 Target of rapamycin [Hypsibius exemplaris] | diamond | 294 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27011114 | 27011114 | PRJNA315399_S_NODE_68762_length_197_cov_3.525000_g68561_i0 | PRJNA315399 | 68762 | 197 | 3.525 | 6.94425 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 88.6 | 7.06e-20 | NR | OQV25877.1 | 2072580 | g68561 | i0 | 67.8 | 1.79695431472081 | 59 | 18 | 89.8 | 1 | 193 | 17 | 81 | 138 | OQV25877.1 Calcium-dependent secretion activator [Hypsibius exemplaris] | diamond | 354 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27927323 | 27927323 | PRJNA315399_S_NODE_19505_length_282_cov_5.179592_g19304_i0 | PRJNA315399 | 19505 | 282 | 5.179592 | 14.60644944 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 50.4 | 1.22e-4 | NR | OQV13667.1 | 2072580 | g19304 | i0 | 34.1 | 0.936170212765957 | 88 | 47 | 91.5 | 3 | 270 | 13 | 748 | 826 | OQV13667.1 Vascular endothelial growth factor receptor 1 [Hypsibius exemplaris] | diamond | 264 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 28116637 | 28116637 | PRJNA315399_S_NODE_175485_length_155_cov_0.991525_g175284_i0 | PRJNA315399 | 175485 | 155 | 0.991525 | 1.53686375 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 56.2 | 1.94e-7 | NR | XP_055343465.1 | 2943436 | g175284 | i0 | 74.1 | 1.0258064516129 | 27 | 7 | 52.3 | 0 | 2 | 82 | 1672 | 1698 | XP_055343465.1 mucin-19-like isoform X1 [Paramacrobiotus metropolitanus] | diamond | 159 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 28937765 | 28937765 | PRJNA315399_S_NODE_49368_length_215_cov_6.511236_g49167_i0 | PRJNA315399 | 49368 | 215 | 6.511236 | 13.9991574 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 69.3 | 1.08e-11 | NR | GAV00201.1 | 947166 | g49167 | i0 | 65.9 | 0.613953488372093 | 44 | 15 | 61.4 | 0 | 165 | 34 | 218 | 261 | GAV00201.1 hypothetical protein RvY_11085 [Ramazzottius varieornatus] | diamond | 132 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 29190348 | 29190348 | PRJNA315399_S_NODE_120269_length_170_cov_3.511278_g120068_i0 | PRJNA315399 | 120269 | 170 | 3.511278 | 5.9691726 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 55.5 | 1.26e-7 | NR | OWA53688.1 | 2072580 | g120068 | i0 | 64.9 | 0.652941176470588 | 37 | 13 | 65.3 | 0 | 22 | 132 | 124 | 160 | OWA53688.1 putative Glutathione S-transferase B [Hypsibius exemplaris] | diamond | 111 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29821450 | 29821450 | PRJNA315399_P_NODE_478591_length_153_cov_3.844828_g478143_i0 | PRJNA315399 | 478591 | 153 | 3.844828 | 5.88258684 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 58.5 | 2.97e-8 | NR | XP_055348846.1 | 2943436 | g478143 | i0 | 57.8 | 2.64705882352941 | 45 | 18 | 86.3 | 1 | 144 | 13 | 1072 | 1116 | XP_055348846.1 uncharacterized protein LOC129595768 [Paramacrobiotus metropolitanus] | diamond | 405 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 30548366 | 30548366 | PRJNA315399_S_NODE_94293_length_181_cov_4.138889_g94092_i0 | PRJNA315399 | 94293 | 181 | 4.138889 | 7.49138909 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 70.1 | 1.34e-13 | NR | GAU88680.1 | 947166 | g94092 | i0 | 85 | 0.662983425414365 | 40 | 6 | 66.3 | 0 | 11 | 130 | 82 | 121 | GAU88680.1 hypothetical protein RvY_01330 [Ramazzottius varieornatus] | diamond | 120 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30579726 | 30579726 | PRJNA315399_S_NODE_40993_length_227_cov_2.247368_g40792_i0 | PRJNA315399 | 40993 | 227 | 2.247368 | 5.10152536 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 70.5 | 5.09e-12 | NR | OQV23770.1 | 2072580 | g40792 | i0 | 50 | 1.69162995594714 | 66 | 33 | 87.2 | 0 | 225 | 28 | 399 | 464 | OQV23770.1 Cullin-1 [Hypsibius exemplaris] | diamond | 384 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 30706280 | 30706280 | PRJNA315399_S_NODE_52314_length_212_cov_4.068571_g52113_i0 | PRJNA315399 | 52314 | 212 | 4.068571 | 8.62537052 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 54.7 | 1.55e-6 | NR | XP_055351264.1 | 2943436 | g52113 | i0 | 50 | 0.820754716981132 | 58 | 25 | 82.1 | 1 | 201 | 28 | 1052 | 1105 | XP_055351264.1 nucleosome-remodeling factor subunit BPTF-like isoform X2 [Paramacrobiotus metropolitanus] | diamond | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31623053 | 31623053 | PRJNA315399_S_NODE_98816_length_179_cov_2.936620_g98615_i0 | PRJNA315399 | 98816 | 179 | 2.93662 | 5.2565498 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 53.5 | 2.46e-6 | NR | OWA51198.1 | 2072580 | g98615 | i0 | 46.3 | 0.905027932960894 | 54 | 22 | 85.5 | 2 | 18 | 170 | 31 | 80 | OWA51198.1 putative Slit-like protein 1 protein [Hypsibius exemplaris] | diamond | 162 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 31812852 | 31812852 | PRJNA315399_S_NODE_113457_length_173_cov_1.279412_g113256_i0 | PRJNA315399 | 113457 | 173 | 1.279412 | 2.21338276 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 95.9 | 1.25e-21 | NR | OQV23416.1 | 2072580 | g113256 | i0 | 84 | 0.867052023121387 | 50 | 8 | 86.7 | 0 | 150 | 1 | 328 | 377 | OQV23416.1 Eukaryotic translation initiation factor 3 subunit M [Hypsibius exemplaris] | diamond | 150 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32350943 | 32350943 | PRJNA315399_S_NODE_56599_length_208_cov_1.362573_g56398_i0 | PRJNA315399 | 56599 | 208 | 1.362573 | 2.83415184 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 92 | 1.03e-19 | NR | GAU99686.1 | 947166 | g56398 | i0 | 67.7 | 0.894230769230769 | 62 | 20 | 89.4 | 0 | 207 | 22 | 321 | 382 | GAU99686.1 hypothetical protein RvY_10647 [Ramazzottius varieornatus] | diamond | 186 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 32746965 | 32746965 | PRJNA315399_S_NODE_39060_length_230_cov_2.917098_g38859_i0 | PRJNA315399 | 39060 | 230 | 2.917098 | 6.7093254 | Parachela | 149990 | Tardigrada | other_Eukaryota | 51.2 | 3.22e-5 | NR | OWA50984.1 | 2072580 | g38859 | i0 | 72.4 | 0.808695652173913 | 29 | 8 | 37.8 | 0 | 19 | 105 | 291 | 319 | OWA50984.1 Peptide chain release factor 1-like, mitochondrial [Hypsibius exemplaris] | diamond | 186 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32886882 | 32886882 | PRJNA315399_S_NODE_184500_length_153_cov_1.413793_g184299_i0 | PRJNA315399 | 184500 | 153 | 1.413793 | 2.16310329 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 72 | 1.64e-13 | NR | OQV12642.1 | 2072580 | g184299 | i0 | 94.3 | 1.37254901960784 | 35 | 2 | 68.6 | 0 | 7 | 111 | 96 | 130 | OQV12642.1 60S ribosomal protein L15 [Hypsibius exemplaris] | diamond | 210 | 72 | 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);;