contig_metadata
14 rows where bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13154278 | 13154278 | PRJNA379145_P_NODE_13351_length_796_cov_3.431193_g11887_i0 | PRJNA379145 | 13351 | 796 | 3.431193 | 27.31229628 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 401 | 6.889999999999999e-107 | NTclustered | gi|2493405654|ref|XM_055472580.1| | 2943436 | g11887 | i0 | 79.201 | 72.487437185929707 | 601 | 107 | 74 | 18 | 93 | 684 | 2087 | 2678 | PREDICTED: Paramacrobiotus metropolitanus eukaryotic translation elongation factor 2-like (LOC129581475), mRNA | blastn | 57700 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 13154929 | 13154929 | PRJNA379145_P_NODE_8051_length_1071_cov_5.270713_g7089_i0 | PRJNA379145 | 8051 | 1071 | 5.270713 | 56.44933623 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 254 | 4.18e-80 | NR | XP_055345436.1 | 2943436 | g7089 | i0 | 59.9 | 1.82913165266106 | 217 | 85 | 60.8 | 1 | 54 | 704 | 3 | 217 | XP_055345436.1 60S ribosomal protein L10a-like [Paramacrobiotus metropolitanus] | diamond | 1959 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 18252360 | 18252360 | PRJNA379145_P_NODE_24555_length_503_cov_4.391489_g11887_i1 | PRJNA379145 | 24555 | 503 | 4.391489 | 22.08918967 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 279 | 2.07e-70 | NTclustered | gi|2493405658|ref|XM_055472581.1| | 2943436 | g11887 | i1 | 80.157 | 68.0874751491054 | 383 | 68 | 75 | 8 | 13 | 391 | 3283 | 2905 | PREDICTED: Paramacrobiotus metropolitanus polycystic kidney disease 2-like 2 protein (LOC129581476), mRNA | blastn | 34248 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 22077663 | 22077663 | PRJNA379145_P_NODE_70818_length_158_cov_0.984000_g68663_i0 | PRJNA379145 | 70818 | 158 | 0.984 | 1.55472 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 134 | 4.53e-27 | NTclustered | gi|2493418936|ref|XM_055475954.1| | 2943436 | g68663 | i0 | 88.288 | 69.4493670886076 | 111 | 13 | 70 | 0 | 1 | 111 | 230 | 120 | PREDICTED: Paramacrobiotus metropolitanus histone H4 (LOC129583912), mRNA | blastn | 10973 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 23353241 | 23353241 | PRJNA379145_P_NODE_9779_length_965_cov_8.094421_g8645_i0 | PRJNA379145 | 9779 | 965 | 8.094421 | 78.11116265 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 307 | 1.17e-100 | NR | OQV15233.1 | 2072580 | g8645 | i0 | 66.4 | 10.8497409326425 | 220 | 74 | 68.4 | 0 | 186 | 845 | 50 | 269 | OQV15233.1 40S ribosomal protein S2 [Hypsibius exemplaris] | diamond | 10470 | 310 | 0.990322580645161 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 26916773 | 26916773 | PRJNA379145_P_NODE_42982_length_279_cov_1.439024_g40830_i0 | PRJNA379145 | 42982 | 279 | 1.439024 | 4.01487696 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 84 | 1.9e-16 | NR | OQV17845.1 | 2072580 | g40830 | i0 | 52 | 15.7311827956989 | 75 | 36 | 80.6 | 0 | 8 | 232 | 13 | 87 | OQV17845.1 Spectrin beta chain [Hypsibius exemplaris] | diamond | 4389 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27296217 | 27296217 | PRJNA379145_P_NODE_42303_length_284_cov_2.191235_g40151_i0 | PRJNA379145 | 42303 | 284 | 2.191235 | 6.2231074 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 73.2 | 1.21e-12 | NR | XP_055339889.1 | 2943436 | g40151 | i0 | 45.2 | 0.77112676056338 | 73 | 40 | 77.1 | 0 | 1 | 219 | 561 | 633 | XP_055339889.1 LOW QUALITY PROTEIN: glycogen [starch] synthase, muscle-like [Paramacrobiotus metropolitanus] | diamond | 219 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27391251 | 27391251 | PRJNA379145_P_NODE_9763_length_966_cov_4.385852_g8631_i0 | PRJNA379145 | 9763 | 966 | 4.385852 | 42.36733032 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 100 | 2.52e-20 | NR | GAU98225.1 | 947166 | g8631 | i0 | 52.9 | 0.782608695652174 | 85 | 40 | 26.4 | 0 | 831 | 577 | 182 | 266 | GAU98225.1 hypothetical protein RvY_09401 [Ramazzottius varieornatus] | diamond | 756 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27548856 | 27548856 | PRJNA379145_P_NODE_6644_length_1181_cov_2.404181_g5844_i0 | PRJNA379145 | 6644 | 1181 | 2.404181 | 28.39337761 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 70.1 | 8.54e-9 | NR | GAV03563.1 | 947166 | g5844 | i0 | 30.2 | 0.41151566469094 | 162 | 102 | 38.4 | 4 | 442 | 894 | 391 | 552 | GAV03563.1 hypothetical protein RvY_13963-1 [Ramazzottius varieornatus] | diamond | 486 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28274947 | 28274947 | PRJNA379145_P_NODE_13746_length_780_cov_2.714859_g11530_i1 | PRJNA379145 | 13746 | 780 | 2.714859 | 21.1759002 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 114 | 6.09e-28 | NR | XP_055344787.1 | 2943436 | g11530 | i1 | 43.3 | 0.811538461538462 | 104 | 58 | 39.6 | 1 | 465 | 773 | 7 | 110 | XP_055344787.1 transforming growth factor beta-1-induced transcript 1 protein-like [Paramacrobiotus metropolitanus] | diamond | 633 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 28969729 | 28969729 | PRJNA379145_P_NODE_12968_length_812_cov_2.700899_g11530_i0 | PRJNA379145 | 12968 | 812 | 2.700899 | 21.93129988 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 114 | 8.07e-28 | NR | XP_055344787.1 | 2943436 | g11530 | i0 | 43.3 | 0.779556650246305 | 104 | 58 | 38.1 | 1 | 316 | 8 | 7 | 110 | XP_055344787.1 transforming growth factor beta-1-induced transcript 1 protein-like [Paramacrobiotus metropolitanus] | diamond | 633 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 29001690 | 29001690 | PRJNA379145_P_NODE_28508_length_438_cov_2.562963_g26415_i0 | PRJNA379145 | 28508 | 438 | 2.562963 | 11.22577794 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 123 | 7.22e-32 | NR | XP_055338391.1 | 2943436 | g26415 | i0 | 49.3 | 0.917808219178082 | 134 | 59 | 91.1 | 3 | 35 | 433 | 96 | 221 | XP_055338391.1 zinc D-Ala-D-Ala carboxypeptidase-like [Paramacrobiotus metropolitanus] | diamond | 402 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 29600972 | 29600972 | PRJNA379145_P_NODE_62310_length_181_cov_1.439189_g60156_i0 | PRJNA379145 | 62310 | 181 | 1.439189 | 2.60493209 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 116 | 7.95e-29 | NR | XP_055345434.1 | 2943436 | g60156 | i0 | 90 | 7.92265193370166 | 60 | 6 | 99.4 | 0 | 1 | 180 | 116 | 175 | XP_055345434.1 fumarate hydratase, mitochondrial-like [Paramacrobiotus metropolitanus] | diamond | 1434 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 32635357 | 32635357 | PRJNA379145_P_NODE_11680_length_868_cov_4.548503_g8631_i1 | PRJNA379145 | 11680 | 868 | 4.548503 | 39.48100604 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 100 | 1.32e-20 | NR | GAU98225.1 | 947166 | g8631 | i1 | 52.9 | 0.870967741935484 | 85 | 40 | 29.4 | 0 | 733 | 479 | 182 | 266 | GAU98225.1 hypothetical protein RvY_09401 [Ramazzottius varieornatus] | diamond | 756 | 100 | 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);;