contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA474911" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1097090 | 1097090 | PRJNA474911_P_NODE_7681_length_205_cov_0.888889_g7554_i0 | PRJNA474911 | 7681 | 205 | 0.888889 | 1.82222245 | Neotoma lepida | 56216 | Chordata | Chordata | 56.6 | 2.5e-7 | NR | OBS77061.1 | 56216 | g7554 | i0 | 71.4 | 24.3219512195122 | 42 | 12 | 61.5 | 0 | 126 | 1 | 4 | 45 | OBS77061.1 hypothetical protein A6R68_16470 [Neotoma lepida] | diamond | 4986 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Neotoma | Neotoma lepida | |
| 4274606 | 4274606 | PRJNA474911_P_NODE_6204_length_225_cov_0.853659_g6077_i0 | PRJNA474911 | 6204 | 225 | 0.853659 | 1.92073275 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.8 | 2.789999999999999e-23 | NR | XP_031561868.1 | 6105 | g6077 | i0 | 68.9 | 14.7866666666667 | 74 | 19 | 98.7 | 1 | 224 | 3 | 40 | 109 | XP_031561868.1 60S ribosomal protein L5-A-like [Actinia tenebrosa] | diamond | 3327 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26791520 | 26791520 | PRJNA474911_P_NODE_1821_length_467_cov_1.886700_g1697_i0 | PRJNA474911 | 1821 | 467 | 1.8867 | 8.810889 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 53.5 | 5.53e-5 | NR | CAF1634619.1 | 1234261 | g1697 | i0 | 41.9 | 1.11777301927195 | 86 | 45 | 54.6 | 3 | 211 | 465 | 131 | 212 | CAF1634619.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 522 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 26823239 | 26823239 | PRJNA474911_P_NODE_6481_length_218_cov_2.031847_g6354_i0 | PRJNA474911 | 6481 | 218 | 2.031847 | 4.42942646 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 49.7 | 9.55e-5 | NR | CAD2167694.1 | 390850 | g6354 | i0 | 45.8 | 1.21100917431193 | 48 | 26 | 66.1 | 0 | 169 | 26 | 16 | 63 | CAD2167694.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 264 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 27202496 | 27202496 | PRJNA474911_P_NODE_4022_length_293_cov_0.745690_g3895_i0 | PRJNA474911 | 4022 | 293 | 0.74569 | 2.1848717 | Bufotes viridis | 30338 | Chordata | Chordata | 43.1 | 0.0462 | NR | CAK8629749.1 | 30338 | g3895 | i0 | 69.2 | 0.266211604095563 | 26 | 8 | 26.6 | 0 | 115 | 192 | 335 | 360 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 78 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27929156 | 27929156 | PRJNA474911_P_NODE_4885_length_260_cov_1.286432_g4758_i0 | PRJNA474911 | 4885 | 260 | 1.286432 | 3.3447232 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 64.7 | 9.41e-11 | NR | CAF1128076.1 | 2762511 | g4758 | i0 | 38.5 | 2.36538461538462 | 78 | 47 | 88.8 | 1 | 231 | 1 | 26 | 103 | CAF1128076.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 615 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28750048 | 28750048 | PRJNA474911_P_NODE_7327_length_207_cov_0.876712_g7200_i0 | PRJNA474911 | 7327 | 207 | 0.876712 | 1.81479384 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 43.9 | 0.00275 | NR | CAJ0962865.1 | 2138241 | g7200 | i0 | 42.1 | 1.65217391304348 | 57 | 31 | 81.2 | 2 | 171 | 4 | 21 | 76 | CAJ0962865.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 342 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 28797484 | 28797484 | PRJNA474911_P_NODE_7707_length_205_cov_0.888889_g7580_i0 | PRJNA474911 | 7707 | 205 | 0.888889 | 1.82222245 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.47e-13 | NR | KAL3117111.1 | 157864 | g7580 | i0 | 48.5 | 6.80487804878049 | 66 | 34 | 96.6 | 0 | 205 | 8 | 148 | 213 | KAL3117111.1 hypothetical protein niasHT_007514 [Heterodera trifolii] | diamond | 1395 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28829155 | 28829155 | PRJNA474911_P_NODE_6228_length_224_cov_1.570552_g6101_i0 | PRJNA474911 | 6228 | 224 | 1.570552 | 3.51803648 | Cervidae | 9850 | Chordata | Chordata | 47 | 8.85e-4 | NR | XP_043734565.1 | 9860 | g6101 | i0 | 37.8 | 6.83035714285714 | 74 | 45 | 99.1 | 1 | 2 | 223 | 75 | 147 | XP_043734565.1 interferon-induced protein 44 isoform X3 [Cervus elaphus] | diamond | 1530 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 28876270 | 28876270 | PRJNA474911_P_NODE_7508_length_206_cov_0.882759_g7381_i0 | PRJNA474911 | 7508 | 206 | 0.882759 | 1.81848354 | Homalodisca vitripennis | 197043 | Arthropoda | Arthropoda | 63.9 | 7.59e-10 | NR | XP_046660008.1 | 197043 | g7381 | i0 | 49.2 | 0.946601941747573 | 65 | 33 | 94.7 | 0 | 206 | 12 | 404 | 468 | XP_046660008.1 uncharacterized protein LOC124353963 isoform X2 [Homalodisca vitripennis] | diamond | 195 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cicadellidae | Homalodisca | Homalodisca vitripennis | |
| 30107778 | 30107778 | PRJNA474911_P_NODE_8132_length_202_cov_0.907801_g8005_i0 | PRJNA474911 | 8132 | 202 | 0.907801 | 1.83375802 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47 | 6.75e-4 | NR | XP_071499744.1 | 105358 | g8005 | i0 | 41.1 | 3.60891089108911 | 56 | 31 | 80.2 | 2 | 3 | 164 | 246 | 301 | XP_071499744.1 adhesion G-protein coupled receptor G2-like [Diadema antillarum] | diamond | 729 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30139065 | 30139065 | PRJNA474911_P_NODE_7372_length_207_cov_0.876712_g7245_i0 | PRJNA474911 | 7372 | 207 | 0.876712 | 1.81479384 | Erythrolamprus reginae | 121349 | Chordata | Chordata | 78.2 | 2.17e-16 | NR | XP_070620966.1 | 121349 | g7245 | i0 | 54.5 | 7.7536231884058 | 66 | 30 | 95.7 | 0 | 1 | 198 | 10 | 75 | XP_070620966.1 glia maturation factor gamma [Erythrolamprus reginae] | diamond | 1605 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dipsadidae | Erythrolamprus | Erythrolamprus reginae | |
| 31308520 | 31308520 | PRJNA474911_P_NODE_8315_length_201_cov_0.914286_g8188_i0 | PRJNA474911 | 8315 | 201 | 0.914286 | 1.83771486 | Patella vulgata | 6465 | Mollusca | Mollusca | 57.8 | 3.87e-8 | NR | XP_050405916.1 | 6465 | g8188 | i0 | 58.7 | 1.37313432835821 | 46 | 19 | 68.7 | 0 | 156 | 19 | 3 | 48 | XP_050405916.1 COMM domain-containing protein 1 [Patella vulgata] | diamond | 276 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32052246 | 32052246 | PRJNA474911_P_NODE_8258_length_201_cov_0.914286_g8131_i0 | PRJNA474911 | 8258 | 201 | 0.914286 | 1.83771486 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 52.4 | 8.48e-6 | NR | XP_002115615.1 | 10228 | g8131 | i0 | 43.9 | 1.97014925373134 | 66 | 35 | 98.5 | 1 | 200 | 3 | 140 | 203 | XP_002115615.1 uncharacterized protein TRIADDRAFT_29799 [Trichoplax adhaerens] | diamond | 396 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32479317 | 32479317 | PRJNA474911_P_NODE_4999_length_256_cov_1.641026_g4872_i0 | PRJNA474911 | 4999 | 256 | 1.641026 | 4.20102656 | Ancylostoma ceylanicum | 53326 | Nematoda | Nematoda | 50.8 | 6.3e-5 | NR | EYC17923.1 | 53326 | g4872 | i0 | 42.7 | 1.79296875 | 82 | 44 | 94.9 | 3 | 244 | 2 | 302 | 381 | EYC17923.1 hypothetical protein Y032_0029g1960 [Ancylostoma ceylanicum] | diamond | 459 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 32636712 | 32636712 | PRJNA474911_P_NODE_1940_length_449_cov_3.528351_g1815_i0 | PRJNA474911 | 1940 | 449 | 3.528351 | 15.84229599 | Mytilus edulis | 6550 | Mollusca | Mollusca | 79 | 6.11e-15 | NR | CAG2210062.1 | 6550 | g1815 | i0 | 32.8 | 1.75055679287305 | 131 | 83 | 86.2 | 2 | 445 | 59 | 67 | 194 | CAG2210062.1 unnamed protein product [Mytilus edulis] | diamond | 786 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;