contig_metadata
17 rows where bioproject = "PRJNA493244", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 455337 | 455337 | PRJNA493244_P_NODE_1288421_length_300_cov_2.615063_g1265297_i0 | PRJNA493244 | 1288421 | 300 | 2.615063 | 7.845189 | Anthoathecata | 406427 | Cnidaria | other_Eukaryota | 155 | 2.3e-46 | NR | XP_004208537.1 | 6087 | g1265297 | i0 | 76.7 | 53.31 | 86 | 20 | 86 | 0 | 300 | 43 | 45 | 130 | XP_004208537.1 small ribosomal subunit protein uS8 [Hydra vulgaris] | diamond | 15993 | 156 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 3008072 | 3008072 | PRJNA493244_P_NODE_592163_length_647_cov_3.848123_g570723_i0 | PRJNA493244 | 592163 | 647 | 3.848123 | 24.89735581 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g570723 | i0 | 100 | 0.0479134466769706 | 31 | 0 | 5 | 0 | 53 | 83 | 9959519 | 9959549 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 7477799 | 7477799 | PRJNA493244_P_NODE_1444786_length_256_cov_3.266667_g1421661_i0 | PRJNA493244 | 1444786 | 256 | 3.266667 | 8.36266752 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 87.9 | 6.38e-13 | NTclustered | gi|2257797986|ref|XR_007306929.1| | 45351 | g1421661 | i0 | 78.832 | 2.26171875 | 137 | 24 | 52 | 5 | 83 | 216 | 1596 | 1730 | PREDICTED: Nematostella vectensis large subunit ribosomal RNA (LOC125560852), rRNA | blastn | 579 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 8108259 | 8108259 | PRJNA493244_P_NODE_1203647_length_327_cov_16.477444_g1180523_i0 | PRJNA493244 | 1203647 | 327 | 16.477444 | 53.88124188 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.84e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g1180523 | i0 | 100 | 2.03669724770642 | 32 | 0 | 10 | 0 | 141 | 172 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 10660631 | 10660631 | PRJNA493244_P_NODE_365409_length_882_cov_3.359318_g348044_i0 | PRJNA493244 | 365409 | 882 | 3.359318 | 29.62918476 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 56.5 | 0.007 | NTclustered | gi|2113699879|ref|XM_029324960.2| | 45264 | g348044 | i0 | 100 | 0.0680272108843537 | 30 | 0 | 3 | 0 | 546 | 575 | 1287 | 1258 | PREDICTED: Acropora millepora uncharacterized LOC114948400 (LOC114948400), transcript variant X2, mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 13211313 | 13211313 | PRJNA493244_P_NODE_818291_length_496_cov_12.850575_g795553_i0 | PRJNA493244 | 818291 | 496 | 12.850575 | 63.738852 | Nynantheae gen. sp. | 86627 | Cnidaria | other_Eukaryota | 124 | 1.0099999999999999e-23 | NTclustered | gi|5441269|gb|AF052880.1|AF052880 | 86627 | g795553 | i0 | 80.368 | 26.0745967741935 | 163 | 30 | 33 | 2 | 333 | 495 | 284 | 444 | Nynantheae gen. sp. 18S ribosomal RNA gene, partial sequence | blastn | 12933 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Nynantheae gen. sp. | |||
| 15758625 | 15758625 | PRJNA493244_P_NODE_1554553_length_230_cov_2.402367_g1531428_i0 | PRJNA493244 | 1554553 | 230 | 2.402367 | 5.5254441 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2114281215|ref|XR_006396569.1| | 45264 | g1531428 | i0 | 100 | 0.608695652173913 | 28 | 0 | 12 | 0 | 1 | 28 | 549 | 522 | PREDICTED: Acropora millepora uncharacterized LOC114963031 (LOC114963031), transcript variant X2, ncRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 17033223 | 17033223 | PRJNA493244_P_NODE_1527994_length_236_cov_2.731429_g1504869_i0 | PRJNA493244 | 1527994 | 236 | 2.731429 | 6.44617244 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 86.1 | 2.09e-12 | NTclustered | gi|1270070985|ref|XR_002695435.1| | 50429 | g1504869 | i0 | 89.552 | 1.13135593220339 | 67 | 7 | 28 | 0 | 134 | 200 | 173 | 107 | PREDICTED: Stylophora pistillata uncharacterized LOC111336533 (LOC111336533), ncRNA | blastn | 267 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 20857127 | 20857127 | PRJNA493244_P_NODE_1373737_length_275_cov_18.626168_g1350612_i0 | PRJNA493244 | 1373737 | 275 | 18.626168 | 51.221962 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369563|emb|OZ237729.1| | 317547 | g1350612 | i0 | 100 | 0.109090909090909 | 30 | 0 | 11 | 0 | 69 | 98 | 2245311 | 2245340 | Eunicella cavolini genome assembly, chromosome: 13 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 22131633 | 22131633 | PRJNA493244_P_NODE_1224738_length_320_cov_5.193050_g1201614_i0 | PRJNA493244 | 1224738 | 320 | 5.19305 | 16.61776 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.03 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g1201614 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 223 | 250 | 16207692 | 16207719 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23408080 | 23408080 | PRJNA493244_P_NODE_1510459_length_240_cov_3.139665_g1487334_i0 | PRJNA493244 | 1510459 | 240 | 3.139665 | 7.535196 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1524878826|ref|XM_027191205.1| | 46731 | g1487334 | i0 | 100 | 0.583333333333333 | 28 | 0 | 12 | 0 | 42 | 69 | 1704 | 1731 | PREDICTED: Pocillopora damicornis D(5)-like dopamine receptor (LOC113674721), transcript variant X2, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 25326460 | 25326460 | PRJNA493244_P_NODE_912140_length_447_cov_37.865285_g889166_i0 | PRJNA493244 | 912140 | 447 | 37.865285 | 169.25782395 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.043 | NTclustered | gi|2744789683|ref|XM_065821175.1| | 6087 | g889166 | i0 | 100 | 1.12751677852349 | 28 | 0 | 6 | 0 | 62 | 89 | 4051 | 4078 | PREDICTED: Hydra vulgaris rho GTPase-activating protein 20 (LOC100199718), transcript variant X14, mRNA | blastn | 504 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26680800 | 26680800 | PRJNA493244_P_NODE_132601_length_1389_cov_5.807982_g123944_i0 | PRJNA493244 | 132601 | 1389 | 5.807982 | 80.67286998 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 280 | 1.72e-85 | NR | XP_031552717.1 | 6105 | g123944 | i0 | 45.7 | 1.38444924406048 | 317 | 157 | 67 | 9 | 1297 | 368 | 47 | 355 | XP_031552717.1 uncharacterized protein LOC116289916 [Actinia tenebrosa] | diamond | 1923 | 282 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28750200 | 28750200 | PRJNA493244_P_NODE_1421227_length_262_cov_11.950249_g1398102_i0 | PRJNA493244 | 1421227 | 262 | 11.950249 | 31.30965238 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 44.3 | 0.0128 | NR | CAH3040336.1 | 104759 | g1398102 | i0 | 36 | 0.572519083969466 | 50 | 27 | 57.3 | 2 | 48 | 197 | 34 | 78 | CAH3040336.1 unnamed protein product [Porites lobata] | diamond | 150 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 30424456 | 30424456 | PRJNA493244_P_NODE_787953_length_514_cov_1.695364_g765316_i0 | PRJNA493244 | 787953 | 514 | 1.695364 | 8.71417096 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 107 | 1.37e-25 | NR | CAH3029253.1 | 104178 | g765316 | i0 | 37.7 | 4.72762645914397 | 162 | 95 | 91.1 | 3 | 19 | 486 | 38 | 199 | CAH3029253.1 unnamed protein product, partial [Porites evermanni] | diamond | 2430 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 31024420 | 31024420 | PRJNA493244_P_NODE_961835_length_424_cov_2.088154_g938786_i0 | PRJNA493244 | 961835 | 424 | 2.088154 | 8.85377296 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 59.3 | 3.92e-7 | NR | EDO46981.1 | 45351 | g938786 | i0 | 35.7 | 2.86556603773585 | 84 | 44 | 59.4 | 1 | 413 | 162 | 324 | 397 | EDO46981.1 predicted protein [Nematostella vectensis] | diamond | 1215 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32258185 | 32258185 | PRJNA493244_P_NODE_1534798_length_235_cov_1.402299_g1511673_i0 | PRJNA493244 | 1534798 | 235 | 1.402299 | 3.29540265 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 44.7 | 0.0066 | NR | XP_068680545.1 | 591990 | g1511673 | i0 | 52.3 | 2.2468085106383 | 44 | 21 | 56.2 | 0 | 229 | 98 | 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 |
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);;