contig_metadata
15 rows where bioproject = "PRJNA944406", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924912 | 924912 | PRJNA944406_P_NODE_76321_length_248_cov_1.422857_g75362_i0 | PRJNA944406 | 76321 | 248 | 1.422857 | 3.52868536 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 120 | 6.84e-30 | NR | XP_033108028.1 | 1529436 | g75362 | i0 | 72.5 | 10.741935483871 | 80 | 22 | 96.8 | 0 | 1 | 240 | 80 | 159 | XP_033108028.1 retinoid-inducible serine carboxypeptidase-like isoform X1 [Anneissia japonica] | diamond | 2664 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 1259324 | 1259324 | PRJNA944406_P_NODE_14681_length_334_cov_2.015326_g13722_i0 | PRJNA944406 | 14681 | 334 | 2.015326 | 6.73118884 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 1.55e-39 | NR | XP_033634627.1 | 7604 | g13722 | i0 | 64 | 14.9281437125749 | 111 | 37 | 99.7 | 1 | 334 | 2 | 47 | 154 | XP_033634627.1 60S ribosomal protein L17-like [Asterias rubens] | diamond | 4986 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 9852806 | 9852806 | PRJNA944406_P_NODE_64108_length_251_cov_0.865169_g63149_i0 | PRJNA944406 | 64108 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 87.4 | 6.17e-18 | NR | XP_041470552.1 | 7654 | g63149 | i0 | 70.9 | 4.69721115537849 | 55 | 16 | 65.7 | 0 | 165 | 1 | 4 | 58 | XP_041470552.1 protein disulfide-isomerase A6 homolog [Lytechinus variegatus] | diamond | 1179 | 87.8 | 0.995444191343964 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 14952379 | 14952379 | PRJNA944406_P_NODE_33332_length_279_cov_1.208738_g32373_i0 | PRJNA944406 | 33332 | 279 | 1.208738 | 3.37237902 | root | 1 | Root_unresolved | Root_unresolved | 89 | 2.91e-18 | NR | XP_038067302.1 | 46514 | g32373 | i0 | 50 | 6.68817204301075 | 88 | 44 | 94.6 | 0 | 266 | 3 | 211 | 298 | XP_038067302.1 arylsulfatase B-like isoform X2 [Patiria miniata] | diamond | 1866 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26968718 | 26968718 | PRJNA944406_P_NODE_39842_length_273_cov_0.870000_g38883_i0 | PRJNA944406 | 39842 | 273 | 0.87 | 2.3751 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 59.7 | 3.82e-8 | NR | XP_063951657.1 | 7653 | g38883 | i0 | 64.1 | 0.857142857142857 | 39 | 14 | 42.9 | 0 | 168 | 52 | 115 | 153 | XP_063951657.1 fibropellin-3-like [Lytechinus pictus] | diamond | 234 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 28099157 | 28099157 | PRJNA944406_P_NODE_63485_length_251_cov_0.865169_g62526_i0 | PRJNA944406 | 63485 | 251 | 0.865169 | 2.17157419 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 58.9 | 8.25e-8 | NR | XP_030853195.1 | 7668 | g62526 | i0 | 52 | 0.597609561752988 | 50 | 24 | 59.8 | 0 | 97 | 246 | 116 | 165 | XP_030853195.1 NADPH oxidase 5-like [Strongylocentrotus purpuratus] | diamond | 150 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30088475 | 30088475 | PRJNA944406_P_NODE_36992_length_275_cov_1.524752_g36033_i0 | PRJNA944406 | 36992 | 275 | 1.524752 | 4.193068 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 66.6 | 2.1e-10 | NR | XP_071512061.1 | 105358 | g36033 | i0 | 44.1 | 2.00727272727273 | 93 | 44 | 99.3 | 3 | 274 | 2 | 129 | 215 | XP_071512061.1 protein disulfide-isomerase-like [Diadema antillarum] | diamond | 552 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30183315 | 30183315 | PRJNA944406_P_NODE_8232_length_436_cov_1.735537_g7275_i0 | PRJNA944406 | 8232 | 436 | 1.735537 | 7.56694132 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 157 | 5.49e-44 | NR | KAJ8020839.1 | 206669 | g7275 | i0 | 48.1 | 1.05963302752294 | 154 | 62 | 99.1 | 5 | 2 | 433 | 39 | 184 | KAJ8020839.1 Cathepsin B [Holothuria leucospilota] | diamond | 462 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30910134 | 30910134 | PRJNA944406_P_NODE_38494_length_274_cov_1.318408_g37535_i0 | PRJNA944406 | 38494 | 274 | 1.318408 | 3.61243792 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 45.1 | 0.00826 | NR | XP_030832941.1 | 7668 | g37535 | i0 | 34.4 | 1.22627737226277 | 61 | 40 | 66.8 | 0 | 11 | 193 | 481 | 541 | XP_030832941.1 maltase-glucoamylase, intestinal, partial [Strongylocentrotus purpuratus] | diamond | 336 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31130862 | 31130862 | PRJNA944406_P_NODE_100655_length_243_cov_0.905882_g99696_i0 | PRJNA944406 | 100655 | 243 | 0.905882 | 2.20129326 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 67.8 | 5.19e-11 | NR | PIK54332.1 | 307972 | g99696 | i0 | 57.9 | 1.39506172839506 | 57 | 24 | 70.4 | 0 | 37 | 207 | 131 | 187 | PIK54332.1 putative RNA-directed DNA polymerase from mobile element jockey-like [Apostichopus japonicus] | diamond | 339 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31200683 | 31200683 | PRJNA944406_P_NODE_32095_length_280_cov_1.333333_g31136_i0 | PRJNA944406 | 32095 | 280 | 1.333333 | 3.7333324 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 55.8 | 1.16e-6 | NR | XP_030853499.1 | 7668 | g31136 | i0 | 59.5 | 2.28214285714286 | 37 | 15 | 39.6 | 0 | 1 | 111 | 249 | 285 | XP_030853499.1 phytanoyl-CoA dioxygenase domain-containing protein 1 [Strongylocentrotus purpuratus] | diamond | 639 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31763686 | 31763686 | PRJNA944406_P_NODE_54097_length_259_cov_1.655914_g53138_i0 | PRJNA944406 | 54097 | 259 | 1.655914 | 4.28881726 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 119 | 4.73e-29 | NR | KAJ8048503.1 | 206669 | g53138 | i0 | 64.7 | 32.4440154440154 | 85 | 30 | 98.5 | 0 | 259 | 5 | 433 | 517 | KAJ8048503.1 Inositol-3-phosphate synthase 1-A [Holothuria leucospilota] | diamond | 8403 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31985062 | 31985062 | PRJNA944406_P_NODE_33518_length_278_cov_5.897561_g32559_i0 | PRJNA944406 | 33518 | 278 | 5.897561 | 16.39521958 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 3.1e-4 | NR | KAJ8043773.1 | 206669 | g32559 | i0 | 51.1 | 1.04676258992806 | 47 | 23 | 50.7 | 0 | 43 | 183 | 53 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 291 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32365023 | 32365023 | PRJNA944406_P_NODE_6919_length_481_cov_1.821078_g5963_i0 | PRJNA944406 | 6919 | 481 | 1.821078 | 8.75938518 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 119 | 1.6999999999999996e-31 | NR | XP_794681.2 | 7668 | g5963 | i0 | 74.7 | 1.6029106029106 | 87 | 22 | 54.3 | 0 | 3 | 263 | 21 | 107 | XP_794681.2 40S ribosomal protein S25 [Strongylocentrotus purpuratus] | diamond | 771 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32869591 | 32869591 | PRJNA944406_P_NODE_78700_length_248_cov_0.880000_g77741_i0 | PRJNA944406 | 78700 | 248 | 0.88 | 2.1824 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 91.3 | 3.29e-19 | NR | XP_038065316.1 | 46514 | g77741 | i0 | 76.5 | 2.87903225806452 | 51 | 12 | 61.7 | 0 | 95 | 247 | 321 | 371 | XP_038065316.1 DNA repair protein XRCC1-like isoform X2 [Patiria miniata] | diamond | 714 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;