contig_metadata
18 rows where bioproject = "PRJNA395690", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 411797 | 411797 | PRJNA395690_P_NODE_5921_length_330_cov_2.032028_g5771_i0 | PRJNA395690 | 5921 | 330 | 2.032028 | 6.7056924 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 97.1 | 1.2199999999999999e-23 | NR | XP_065667799.1 | 6087 | g5771 | i0 | 46.4 | 6.23636363636364 | 97 | 51 | 88.2 | 1 | 298 | 8 | 4 | 99 | XP_065667799.1 cystatin-A isoform X1 [Hydra vulgaris] | diamond | 2058 | 97.4 | 0.996919917864476 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15106703 | 15106703 | PRJNA395690_P_NODE_23232_length_179_cov_1.207692_g23080_i0 | PRJNA395690 | 23232 | 179 | 1.207692 | 2.16176868 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.015 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g23080 | i0 | 100 | 3.12849162011173 | 28 | 0 | 16 | 0 | 152 | 179 | 11043298 | 11043271 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 560 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18263114 | 18263114 | PRJNA395690_P_NODE_12035_length_235_cov_1.096774_g11883_i0 | PRJNA395690 | 12035 | 235 | 1.096774 | 2.5774189 | Ceratomyxa ayami | 1579381 | Cnidaria | other_Eukaryota | 58.4 | 4.53e-4 | NTclustered | gi|730837045|gb|KM392429.1| | 1579381 | g11883 | i0 | 100 | 0.374468085106383 | 31 | 0 | 13 | 0 | 200 | 230 | 1236 | 1206 | Ceratomyxa ayami isolate LJ-Lepto 28S ribosomal RNA gene, partial sequence | blastn | 88 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa ayami | |
| 27281860 | 27281860 | PRJNA395690_P_NODE_31383_length_165_cov_0.879310_g31231_i0 | PRJNA395690 | 31383 | 165 | 0.87931 | 1.4508615 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 73.6 | 1.8e-13 | NR | KAK2566848.1 | 6130 | g31231 | i0 | 63 | 8.81818181818182 | 54 | 20 | 98.2 | 0 | 165 | 4 | 347 | 400 | KAK2566848.1 Hypoxia up-regulated protein 1 [Acropora cervicornis] | diamond | 1455 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 27296632 | 27296632 | PRJNA395690_P_NODE_33463_length_163_cov_0.894737_g33311_i0 | PRJNA395690 | 33463 | 163 | 0.894737 | 1.45842131 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 65.9 | 8.92e-11 | NR | XP_044174077.1 | 45264 | g33311 | i0 | 66 | 7.45398773006135 | 50 | 16 | 92 | 1 | 4 | 153 | 174 | 222 | XP_044174077.1 brefeldin A-inhibited guanine nucleotide-exchange protein 1-like [Acropora millepora] | diamond | 1215 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27503057 | 27503057 | PRJNA395690_P_NODE_22623_length_180_cov_1.923664_g22471_i0 | PRJNA395690 | 22623 | 180 | 1.923664 | 3.4625952 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 65.1 | 2.06e-10 | NR | XP_015779737.1 | 70779 | g22471 | i0 | 53.3 | 4 | 60 | 26 | 96.7 | 1 | 3 | 176 | 614 | 673 | XP_015779737.1 PREDICTED: uncharacterized protein LOC107357611 [Acropora digitifera] | diamond | 720 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27644259 | 27644259 | PRJNA395690_P_NODE_34804_length_162_cov_0.902655_g34652_i0 | PRJNA395690 | 34804 | 162 | 0.902655 | 1.4623011 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 46.6 | 5.63e-4 | NR | XP_044173206.1 | 45264 | g34652 | i0 | 49 | 3.5 | 49 | 22 | 90.7 | 1 | 16 | 162 | 86 | 131 | XP_044173206.1 probable ATP-dependent RNA helicase DDX60 [Acropora millepora] | diamond | 567 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28401792 | 28401792 | PRJNA395690_P_NODE_31406_length_165_cov_0.879310_g31254_i0 | PRJNA395690 | 31406 | 165 | 0.87931 | 1.4508615 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 72.8 | 2.81e-13 | NR | XP_065673296.1 | 6087 | g31254 | i0 | 58.9 | 2.03636363636364 | 56 | 21 | 98.2 | 1 | 3 | 164 | 121 | 176 | XP_065673296.1 potential E3 ubiquitin-protein ligase ariadne-2-like [Hydra vulgaris] | diamond | 336 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28513284 | 28513284 | PRJNA395690_P_NODE_3207_length_439_cov_2.161538_g3058_i0 | PRJNA395690 | 3207 | 439 | 2.161538 | 9.48915182 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 88.6 | 4.92e-20 | NR | CAH3194379.1 | 104178 | g3058 | i0 | 82.2 | 0.93621867881549 | 45 | 8 | 30.8 | 0 | 3 | 137 | 28 | 72 | CAH3194379.1 unnamed protein product, partial [Porites evermanni] | diamond | 411 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29081699 | 29081699 | PRJNA395690_P_NODE_19068_length_189_cov_1.107143_g18916_i0 | PRJNA395690 | 19068 | 189 | 1.107143 | 2.09250027 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52 | 9.44e-6 | NR | XP_047138961.1 | 6087 | g18916 | i0 | 56.4 | 2.31746031746032 | 39 | 17 | 61.9 | 0 | 3 | 119 | 234 | 272 | XP_047138961.1 uncharacterized protein LOC124814903 [Hydra vulgaris] | diamond | 438 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29285740 | 29285740 | PRJNA395690_P_NODE_31309_length_165_cov_0.879310_g31157_i0 | PRJNA395690 | 31309 | 165 | 0.87931 | 1.4508615 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 67.4 | 2.66e-11 | NR | XP_028516623.1 | 2652724 | g31157 | i0 | 49.1 | 7.50909090909091 | 55 | 28 | 100 | 0 | 1 | 165 | 12 | 66 | XP_028516623.1 uncharacterized protein LOC110244904 [Exaiptasia diaphana] | diamond | 1239 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 29997482 | 29997482 | PRJNA395690_P_NODE_15031_length_209_cov_13.481250_g14879_i0 | PRJNA395690 | 15031 | 209 | 13.48125 | 28.1758125 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 53.1 | 1.34e-6 | NR | KAJ7385993.1 | 174260 | g14879 | i0 | 80.6 | 1.33492822966507 | 31 | 6 | 44.5 | 0 | 8 | 100 | 82 | 112 | KAJ7385993.1 hypothetical protein OS493_012326 [Desmophyllum pertusum] | diamond | 279 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 30660834 | 30660834 | PRJNA395690_P_NODE_33273_length_163_cov_0.894737_g33121_i0 | PRJNA395690 | 33273 | 163 | 0.894737 | 1.45842131 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 80.1 | 8.57e-16 | NR | XP_027042716.1 | 46731 | g33121 | i0 | 70.6 | 6.80981595092025 | 51 | 15 | 93.9 | 0 | 156 | 4 | 749 | 799 | XP_027042716.1 maltase-glucoamylase, intestinal-like [Pocillopora damicornis] | diamond | 1110 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30755677 | 30755677 | PRJNA395690_P_NODE_36014_length_161_cov_0.910714_g35862_i0 | PRJNA395690 | 36014 | 161 | 0.910714 | 1.46624954 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 100 | 4.049999999999999e-23 | NR | XP_031550358.1 | 6105 | g35862 | i0 | 79.2 | 43.4534161490683 | 53 | 11 | 98.8 | 0 | 161 | 3 | 460 | 512 | XP_031550358.1 SWI/SNF-related matrix-associated actin-dependent regulator of chromatin subfamily A member 5-like [Actinia tenebrosa] | diamond | 6996 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30850340 | 30850340 | PRJNA395690_P_NODE_23594_length_178_cov_1.418605_g23442_i0 | PRJNA395690 | 23594 | 178 | 1.418605 | 2.5251169 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 52.4 | 6.16e-6 | NR | EDO45389.1 | 45351 | g23442 | i0 | 55 | 5.20786516853933 | 40 | 18 | 67.4 | 0 | 59 | 178 | 273 | 312 | EDO45389.1 predicted protein [Nematostella vectensis] | diamond | 927 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31640677 | 31640677 | PRJNA395690_P_NODE_1536_length_630_cov_1.666093_g1393_i0 | PRJNA395690 | 1536 | 630 | 1.666093 | 10.4963859 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 176 | 3.12e-49 | NR | PFX18144.1 | 50429 | g1393 | i0 | 66.9 | 9.52380952380952 | 127 | 42 | 60.5 | 0 | 500 | 120 | 331 | 457 | PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] | diamond | 6000 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31908680 | 31908680 | PRJNA395690_P_NODE_6577_length_314_cov_1.569811_g6425_i0 | PRJNA395690 | 6577 | 314 | 1.569811 | 4.92920654 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 122 | 9.37e-30 | NR | CAB4008039.1 | 317549 | g6425 | i0 | 57.3 | 0.917197452229299 | 96 | 40 | 90.8 | 1 | 313 | 29 | 85 | 180 | CAB4008039.1 Meprin A subunit beta, partial [Paramuricea clavata] | diamond | 288 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32904570 | 32904570 | PRJNA395690_P_NODE_3440_length_424_cov_1.450667_g3291_i0 | PRJNA395690 | 3440 | 424 | 1.450667 | 6.15082808 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 48.9 | 0.00197 | NR | XP_031559195.1 | 6105 | g3291 | i0 | 39.1 | 3.49528301886792 | 64 | 38 | 44.6 | 1 | 396 | 208 | 4895 | 4958 | XP_031559195.1 uncharacterized protein LOC116295506 [Actinia tenebrosa] | diamond | 1482 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa |
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);;