contig_metadata
13 rows where bioproject = "PRJNA608894" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1147097 | 1147097 | PRJNA608894_P_NODE_13801_length_611_cov_4.109665_g13322_i0 | PRJNA608894 | 13801 | 611 | 4.109665 | 25.11005315 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 166 | 4.85e-49 | NR | XP_068702776.1 | 591990 | g13322 | i0 | 65.7 | 11.1505728314239 | 134 | 45 | 65.8 | 1 | 570 | 169 | 1 | 133 | XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa] | diamond | 6813 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 4975295 | 4975295 | PRJNA608894_P_NODE_61384_length_232_cov_2.786164_g60885_i0 | PRJNA608894 | 61384 | 232 | 2.786164 | 6.46390048 | Anthoathecata | 406427 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2744833442|ref|XM_047268933.2| | 6087 | g60885 | i0 | 100 | 0.482758620689655 | 28 | 0 | 12 | 0 | 187 | 214 | 445 | 472 | PREDICTED: Hydra vulgaris U1 small nuclear ribonucleoprotein C (LOC100201302), transcript variant X1, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 5689562 | 5689562 | PRJNA608894_P_NODE_59285_length_242_cov_0.911243_g58786_i0 | PRJNA608894 | 59285 | 242 | 0.911243 | 2.20520806 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 142 | 4.98e-41 | NR | KXJ11429.1 | 2652724 | g58786 | i0 | 87.5 | 86.095041322314 | 80 | 10 | 99.2 | 0 | 2 | 241 | 52 | 131 | KXJ11429.1 40S ribosomal protein S14 [Exaiptasia diaphana] | diamond | 20835 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 14614231 | 14614231 | PRJNA608894_P_NODE_27552_length_356_cov_1.925795_g27053_i0 | PRJNA608894 | 27552 | 356 | 1.925795 | 6.8558302 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 75.5 | 1.55e-14 | NR | KAK2556285.1 | 6130 | g27053 | i0 | 60.6 | 4.42415730337079 | 66 | 26 | 55.6 | 0 | 343 | 146 | 26 | 91 | KAK2556285.1 60S acidic ribosomal protein P2 [Acropora cervicornis] | diamond | 1575 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 24812089 | 24812089 | PRJNA608894_P_NODE_55800_length_245_cov_0.895349_g55301_i0 | PRJNA608894 | 55800 | 245 | 0.895349 | 2.19360505 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 70.5 | 1.25e-12 | NR | XP_028391902.1 | 151771 | g55301 | i0 | 38.5 | 1.91020408163265 | 78 | 48 | 95.5 | 0 | 11 | 244 | 40 | 117 | XP_028391902.1 ras-related protein Rab-22A-like [Dendronephthya gigantea] | diamond | 468 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 26605075 | 26605075 | PRJNA608894_P_NODE_48321_length_255_cov_1.692308_g47822_i0 | PRJNA608894 | 48321 | 255 | 1.692308 | 4.3153854 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 52 | 2.6e-6 | NR | KAJ7382075.1 | 174260 | g47822 | i0 | 31.4 | 5.76470588235294 | 70 | 48 | 82.4 | 0 | 16 | 225 | 11 | 80 | KAJ7382075.1 Katanin p60 ATPase-containing subunit A1 [Desmophyllum pertusum] | diamond | 1470 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 26840388 | 26840388 | PRJNA608894_P_NODE_33061_length_314_cov_1.950207_g32562_i0 | PRJNA608894 | 33061 | 314 | 1.950207 | 6.12364998 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 62.8 | 3.75e-9 | NR | CAH3139222.1 | 104759 | g32562 | i0 | 50.9 | 2.5318471337579598 | 55 | 21 | 52.5 | 1 | 309 | 145 | 148 | 196 | CAH3139222.1 unnamed protein product [Porites lobata] | diamond | 795 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 26985123 | 26985123 | PRJNA608894_P_NODE_53962_length_247_cov_0.885057_g53463_i0 | PRJNA608894 | 53962 | 247 | 0.885057 | 2.18609079 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 48.5 | 3.46e-4 | NR | CAH3163267.1 | 104178 | g53463 | i0 | 39.6 | 0.643724696356275 | 53 | 32 | 64.4 | 0 | 159 | 1 | 237 | 289 | CAH3163267.1 unnamed protein product [Porites evermanni] | diamond | 159 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29890732 | 29890732 | PRJNA608894_P_NODE_57131_length_244_cov_0.900585_g56632_i0 | PRJNA608894 | 57131 | 244 | 0.900585 | 2.1974274 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 73.2 | 7.15e-13 | NR | XP_057312234.1 | 13093 | g56632 | i0 | 50.6 | 2.84016393442623 | 77 | 38 | 94.7 | 0 | 3 | 233 | 990 | 1066 | XP_057312234.1 intraflagellar transport protein 172 homolog [Hydractinia symbiolongicarpus] | diamond | 693 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 30756778 | 30756778 | PRJNA608894_P_NODE_10914_length_742_cov_4.718984_g10452_i0 | PRJNA608894 | 10914 | 742 | 4.718984 | 35.01486128 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 176 | 1.12e-48 | NR | PFX18144.1 | 50429 | g10452 | i0 | 66.9 | 13.1482479784367 | 127 | 42 | 51.3 | 0 | 114 | 494 | 331 | 457 | PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] | diamond | 9756 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31660192 | 31660192 | PRJNA608894_P_NODE_29037_length_344_cov_0.904059_g28538_i0 | PRJNA608894 | 29037 | 344 | 0.904059 | 3.10996296 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 50.4 | 1.2e-4 | NR | XP_020609482.1 | 48498 | g28538 | i0 | 36.7 | 1.77906976744186 | 90 | 51 | 75.9 | 3 | 2 | 262 | 5 | 91 | XP_020609482.1 TLD domain-containing protein 1-like [Orbicella faveolata] | diamond | 612 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32653594 | 32653594 | PRJNA608894_P_NODE_18040_length_494_cov_2.026128_g17544_i0 | PRJNA608894 | 18040 | 494 | 2.026128 | 10.00907232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 1.7399999999999998e-32 | NR | XP_031562231.1 | 6105 | g17544 | i0 | 39.6 | 4.96761133603239 | 164 | 92 | 99 | 5 | 6 | 494 | 340 | 497 | XP_031562231.1 eukaryotic peptide chain release factor GTP-binding subunit ERF3A-like [Actinia tenebrosa] | diamond | 2454 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32797999 | 32797999 | PRJNA608894_P_NODE_52160_length_249_cov_0.875000_g51661_i0 | PRJNA608894 | 52160 | 249 | 0.875 | 2.17875 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 78.6 | 9.93e-15 | NR | KAJ7318626.1 | 174260 | g51661 | i0 | 54.7 | 1.5421686746988 | 64 | 28 | 77.1 | 1 | 1 | 192 | 273 | 335 | KAJ7318626.1 ATPase [Desmophyllum pertusum] | diamond | 384 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum |
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);;