contig_metadata
13 rows where bioproject = "PRJNA1150539", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 301420 | 301420 | PRJNA1150539_S_NODE_60961_length_293_cov_1.854545_g60365_i0 | PRJNA1150539 | 60961 | 293 | 1.854545 | 5.43381685 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2784646160|ref|XM_067174174.1| | 159855 | g60365 | i0 | 100 | 0.286689419795222 | 28 | 0 | 10 | 0 | 120 | 147 | 4365 | 4338 | PREDICTED: Acropora muricata peroxidasin homolog (LOC136907478), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 301655 | 301655 | PRJNA1150539_S_NODE_82681_length_262_cov_3.116402_g82085_i0 | PRJNA1150539 | 82681 | 262 | 3.116402 | 8.16497324 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g82085 | i0 | 100 | 0.114503816793893 | 30 | 0 | 11 | 0 | 79 | 108 | 14057462 | 14057433 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 4128675 | 4128675 | PRJNA1150539_S_NODE_87564_length_256_cov_3.060109_g86968_i0 | PRJNA1150539 | 87564 | 256 | 3.060109 | 7.83387904 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2751515433|ref|XM_059111930.2| | 203993 | g86968 | i0 | 100 | 0.11328125 | 29 | 0 | 11 | 0 | 165 | 193 | 2190 | 2218 | PREDICTED: Pocillopora verrucosa CCHC-type zinc finger nucleic acid binding protein (LOC131794408), transcript variant X1, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 4128751 | 4128751 | PRJNA1150539_S_NODE_95004_length_248_cov_1.965714_g94408_i0 | PRJNA1150539 | 95004 | 248 | 1.965714 | 4.87497072 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2213065759|ref|XM_047285346.1| | 6087 | g94408 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 182 | 209 | 546 | 573 | PREDICTED: Hydra vulgaris alpha-(1,6)-fucosyltransferase-like (LOC124816241), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 11780187 | 11780187 | PRJNA1150539_S_NODE_70070_length_279_cov_3.281553_g69474_i0 | PRJNA1150539 | 70070 | 279 | 3.281553 | 9.15553287 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.54e-4 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g69474 | i0 | 100 | 0.114695340501792 | 32 | 0 | 11 | 0 | 81 | 112 | 8609634 | 8609603 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13054610 | 13054610 | PRJNA1150539_S_NODE_105291_length_236_cov_2.300613_g104695_i0 | PRJNA1150539 | 105291 | 236 | 2.300613 | 5.42944668 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2518962117|ref|XM_057434974.1| | 13093 | g104695 | i0 | 100 | 0.11864406779661 | 28 | 0 | 12 | 0 | 183 | 210 | 107 | 134 | PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130613657 (LOC130613657), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 14330373 | 14330373 | PRJNA1150539_S_NODE_48952_length_313_cov_1.766667_g48356_i0 | PRJNA1150539 | 48952 | 313 | 1.766667 | 5.52966771 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g48356 | i0 | 94.286 | 0.111821086261981 | 35 | 2 | 11 | 0 | 279 | 313 | 35 | 1 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 26596805 | 26596805 | PRJNA1150539_S_NODE_105241_length_236_cov_2.361963_g104645_i0 | PRJNA1150539 | 105241 | 236 | 2.361963 | 5.57423268 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 44.7 | 0.0066 | NR | XP_068680545.1 | 591990 | g104645 | i0 | 52.3 | 2.23728813559322 | 44 | 21 | 55.9 | 0 | 230 | 99 | 240 | 283 | XP_068680545.1 uncharacterized protein [Montipora foliosa] | diamond | 528 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 29597793 | 29597793 | PRJNA1150539_S_NODE_76310_length_271_cov_1.166667_g75714_i0 | PRJNA1150539 | 76310 | 271 | 1.166667 | 3.16166757 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 57.8 | 2.35e-7 | NR | CAH3161428.1 | 104759 | g75714 | i0 | 49.1 | 0.6309963099631 | 57 | 27 | 60.9 | 1 | 178 | 14 | 30 | 86 | CAH3161428.1 unnamed protein product, partial [Porites lobata] | diamond | 171 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29660877 | 29660877 | PRJNA1150539_S_NODE_73610_length_274_cov_3.164179_g73014_i0 | PRJNA1150539 | 73610 | 274 | 3.164179 | 8.66985046 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 44.3 | 0.0153 | NR | PFX15504.1 | 50429 | g73014 | i0 | 35.4 | 3.94160583941606 | 65 | 39 | 71.2 | 1 | 212 | 18 | 636 | 697 | PFX15504.1 putative RNA-directed DNA polymerase from transposon BS [Stylophora pistillata] | diamond | 1080 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30451273 | 30451273 | PRJNA1150539_S_NODE_63333_length_289_cov_3.134259_g62737_i0 | PRJNA1150539 | 63333 | 289 | 3.134259 | 9.05800851 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 45.8 | 0.00505 | NR | PFX34701.1 | 50429 | g62737 | i0 | 47.9 | 2.2318339100346 | 48 | 22 | 49.8 | 1 | 2 | 145 | 246 | 290 | PFX34701.1 RNA-directed DNA polymerase from mobile element jockey [Stylophora pistillata] | diamond | 645 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30545797 | 30545797 | PRJNA1150539_S_NODE_102413_length_241_cov_2.291667_g101817_i0 | PRJNA1150539 | 102413 | 241 | 2.291667 | 5.52291747 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.2 | 1.29e-7 | NR | XP_028519371.1 | 2652724 | g101817 | i0 | 55.1 | 2.43983402489627 | 49 | 19 | 57.3 | 2 | 230 | 93 | 345 | 393 | XP_028519371.1 uncharacterized protein K02A2.6 [Exaiptasia diaphana] | diamond | 588 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32019557 | 32019557 | PRJNA1150539_S_NODE_18118_length_389_cov_5.623418_g17522_i0 | PRJNA1150539 | 18118 | 389 | 5.623418 | 21.87509602 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 75.1 | 9.39e-13 | NR | PFX16388.1 | 50429 | g17522 | i0 | 42.7 | 4.3573264781491 | 89 | 50 | 67.9 | 1 | 363 | 100 | 56 | 144 | PFX16388.1 Retrovirus-related Pol polyprotein [Stylophora pistillata] | diamond | 1695 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;