contig_metadata
13 rows where bioproject = "PRJNA1132896", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6661467 | 6661467 | PRJNA1132896_P_NODE_1626_length_416_cov_1.857143_g1535_i0 | PRJNA1132896 | 1626 | 416 | 1.857143 | 7.72571488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 217 | 1.46e-65 | NR | CAH3141996.1 | 104759 | g1535 | i0 | 77.5 | 9.97355769230769 | 138 | 31 | 99.5 | 0 | 2 | 415 | 158 | 295 | CAH3141996.1 unnamed protein product [Porites lobata] | diamond | 4149 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 6661540 | 6661540 | PRJNA1132896_P_NODE_8546_length_246_cov_0.890173_g8455_i0 | PRJNA1132896 | 8546 | 246 | 0.890173 | 2.18982558 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g8455 | i0 | 92.308 | 1.76422764227642 | 39 | 2 | 16 | 1 | 172 | 210 | 4613928 | 4613891 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 434 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 12510512 | 12510512 | PRJNA1132896_P_NODE_8270_length_247_cov_0.885057_g8179_i0 | PRJNA1132896 | 8270 | 247 | 0.885057 | 2.18609079 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 95.3 | 3.66e-15 | NTclustered | gi|636577270|gb|KJ483104.1| | 6110 | g8179 | i0 | 91.304 | 26.4008097165992 | 69 | 6 | 28 | 0 | 2 | 70 | 3269 | 3337 | Anthopleura elegantissima isolate aele 28S large subunit ribosomal RNA gene and external transcribed spacer, partial sequence | blastn | 6521 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anthopleura | Anthopleura elegantissima | |
| 18135376 | 18135376 | PRJNA1132896_P_NODE_3635_length_298_cov_1.222222_g3544_i0 | PRJNA1132896 | 3635 | 298 | 1.222222 | 3.64222156 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 182 | 3.39e-41 | NTclustered | gi|1603789296|ref|XM_028542322.1| | 151771 | g3544 | i0 | 80.335 | 7.58389261744966 | 239 | 47 | 80 | 0 | 5 | 243 | 130 | 368 | PREDICTED: Dendronephthya gigantea ras-related protein Rap-1b-like (LOC114521782), mRNA | blastn | 2260 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 24509610 | 24509610 | PRJNA1132896_P_NODE_820_length_569_cov_3.350806_g729_i0 | PRJNA1132896 | 820 | 569 | 3.350806 | 19.06608614 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 224 | 1.28e-71 | NR | KAJ7384493.1 | 174260 | g729 | i0 | 69.2 | 2.53602811950791 | 159 | 49 | 83.8 | 0 | 80 | 556 | 3 | 161 | KAJ7384493.1 60S ribosomal protein L17 [Desmophyllum pertusum] | diamond | 1443 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 27091073 | 27091073 | PRJNA1132896_P_NODE_3642_length_298_cov_1.026667_g3551_i0 | PRJNA1132896 | 3642 | 298 | 1.026667 | 3.05946766 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 80.1 | 3.45e-16 | NR | XP_031557306.1 | 6105 | g3551 | i0 | 46.4 | 6.19127516778523 | 84 | 40 | 84.6 | 1 | 283 | 32 | 99 | 177 | XP_031557306.1 dual specificity protein phosphatase 14-like [Actinia tenebrosa] | diamond | 1845 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27544317 | 27544317 | PRJNA1132896_P_NODE_2764_length_334_cov_1.574713_g2673_i0 | PRJNA1132896 | 2764 | 334 | 1.574713 | 5.25954142 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 84 | 3.9e-16 | NR | KAK3712872.1 | 3060491 | g2673 | i0 | 42.2 | 0.979041916167665 | 109 | 60 | 97 | 2 | 4 | 327 | 204 | 310 | KAK3712872.1 hypothetical protein QZH41_016903 [Actinostola sp. cb2023] | diamond | 327 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 28007189 | 28007189 | PRJNA1132896_P_NODE_6265_length_257_cov_1.255435_g6174_i0 | PRJNA1132896 | 6265 | 257 | 1.255435 | 3.22646795 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 60.5 | 2.44e-8 | NR | XP_031562673.1 | 6105 | g6174 | i0 | 45 | 4.27237354085603 | 60 | 33 | 70 | 0 | 78 | 257 | 6 | 65 | XP_031562673.1 V-type proton ATPase subunit C 1-B-like isoform X1 [Actinia tenebrosa] | diamond | 1098 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28175581 | 28175581 | PRJNA1132896_P_NODE_2966_length_324_cov_0.896414_g2875_i0 | PRJNA1132896 | 2966 | 324 | 0.896414 | 2.90438136 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52 | 4.14e-5 | NR | XP_029199992.2 | 45264 | g2875 | i0 | 36.8 | 1.76851851851852 | 95 | 57 | 87 | 2 | 40 | 321 | 107 | 199 | XP_029199992.2 cation-dependent mannose-6-phosphate receptor-like [Acropora millepora] | diamond | 573 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29249155 | 29249155 | PRJNA1132896_P_NODE_7209_length_250_cov_0.870056_g7118_i0 | PRJNA1132896 | 7209 | 250 | 0.870056 | 2.17514 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 71.6 | 2.77e-12 | NR | XP_048577460.1 | 45351 | g7118 | i0 | 46.8 | 2.856 | 79 | 40 | 94.8 | 2 | 247 | 11 | 113 | 189 | XP_048577460.1 DNA mismatch repair protein Msh2 isoform X2 [Nematostella vectensis] | diamond | 714 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29743310 | 29743310 | PRJNA1132896_P_NODE_7090_length_250_cov_0.870056_g6999_i0 | PRJNA1132896 | 7090 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 6.6e-6 | NR | PFX33087.1 | 50429 | g6999 | i0 | 41 | 5.532 | 61 | 36 | 73.2 | 0 | 14 | 196 | 401 | 461 | PFX33087.1 Serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit C [Stylophora pistillata] | diamond | 1383 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30860246 | 30860246 | PRJNA1132896_P_NODE_7494_length_249_cov_0.875000_g7403_i0 | PRJNA1132896 | 7494 | 249 | 0.875 | 2.17875 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 92 | 9.08e-20 | NR | KXJ21723.1 | 2652724 | g7403 | i0 | 57.7 | 2.81927710843373 | 78 | 32 | 94 | 1 | 240 | 7 | 92 | 168 | KXJ21723.1 Sphingosine kinase 2 [Exaiptasia diaphana] | diamond | 702 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 31987548 | 31987548 | PRJNA1132896_P_NODE_9998_length_242_cov_0.911243_g9907_i0 | PRJNA1132896 | 9998 | 242 | 0.911243 | 2.20520806 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 82 | 5.38e-16 | NR | XP_020622740.1 | 48498 | g9907 | i0 | 59.7 | 8.39256198347107 | 67 | 26 | 81.8 | 1 | 200 | 3 | 160 | 226 | XP_020622740.1 solute carrier family 15 member 1-like [Orbicella faveolata] | diamond | 2031 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata |
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);;