contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544610 | 544610 | PRJNA560932_P_NODE_31701_length_321_cov_1.560484_g31345_i0 | PRJNA560932 | 31701 | 321 | 1.560484 | 5.00915364 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1176112663|ref|XM_020771710.1| | 48498 | g31345 | i0 | 100 | 0.0934579439252336 | 30 | 0 | 9 | 0 | 253 | 282 | 6916 | 6887 | PREDICTED: Orbicella faveolata uncharacterized LOC110064637 (LOC110064637), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 544661 | 544661 | PRJNA560932_P_NODE_39541_length_289_cov_1.615741_g39185_i0 | PRJNA560932 | 39541 | 289 | 1.615741 | 4.66949149 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 198 | 3.25e-46 | NTclustered | gi|1603774355|ref|XM_028559500.1| | 151771 | g39185 | i0 | 79.371 | 54.598615916955 | 286 | 55 | 98 | 4 | 6 | 289 | 836 | 553 | PREDICTED: Dendronephthya gigantea polyubiquitin (LOC114538342), mRNA | blastn | 15779 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 544767 | 544767 | PRJNA560932_P_NODE_55061_length_249_cov_0.875000_g54705_i0 | PRJNA560932 | 55061 | 249 | 0.875 | 2.17875 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 63.9 | 1.04e-5 | NTclustered | gi|2918369539|emb|OZ237721.1| | 317547 | g54705 | i0 | 100 | 0.546184738955823 | 34 | 0 | 14 | 0 | 6 | 39 | 31477158 | 31477191 | Eunicella cavolini genome assembly, chromosome: 5 | blastn | 136 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 1820337 | 1820337 | PRJNA560932_P_NODE_33202_length_315_cov_0.954545_g32846_i0 | PRJNA560932 | 33202 | 315 | 0.954545 | 3.00681675 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 63.9 | 1.36e-5 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g32846 | i0 | 93.182 | 0.13968253968254 | 44 | 1 | 13 | 1 | 232 | 273 | 34358931 | 34358888 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 44 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 1820454 | 1820454 | PRJNA560932_P_NODE_49442_length_258_cov_2.097297_g49086_i0 | PRJNA560932 | 49442 | 258 | 2.097297 | 5.41102626 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 115 | 2.95e-21 | NTclustered | gi|1524861164|ref|XM_027181817.1| | 46731 | g49086 | i0 | 81.752 | 2.14728682170543 | 137 | 25 | 53 | 0 | 41 | 177 | 318 | 182 | PREDICTED: Pocillopora damicornis MOB kinase activator 1B (LOC113666061), mRNA | blastn | 554 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3095714 | 3095714 | PRJNA560932_P_NODE_48143_length_263_cov_1.210526_g47787_i0 | PRJNA560932 | 48143 | 263 | 1.210526 | 3.18368338 | Podocoryna carnea | 6096 | Cnidaria | other_Eukaryota | 195 | 3.77e-45 | NTclustered | gi|396251|emb|X71384.1| | 6096 | g47787 | i0 | 80.632 | 4.39923954372624 | 253 | 47 | 96 | 2 | 7 | 258 | 375 | 124 | P.carnea mRNA for 40S ribosomal protein S14 | blastn | 1157 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Podocoryna | Podocoryna carnea | |
| 6922580 | 6922580 | PRJNA560932_P_NODE_27646_length_341_cov_1.470149_g27290_i0 | PRJNA560932 | 27646 | 341 | 1.470149 | 5.01320809 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 60.2 | 1.93e-4 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g27290 | i0 | 100 | 0.18475073313783 | 32 | 0 | 9 | 0 | 310 | 341 | 380 | 411 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 63 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 9473248 | 9473248 | PRJNA560932_P_NODE_38048_length_295_cov_1.040541_g37692_i0 | PRJNA560932 | 38048 | 295 | 1.040541 | 3.06959595 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2729088135|ref|XM_065206661.1| | 499914 | g37692 | i0 | 100 | 0.196610169491525 | 29 | 0 | 10 | 0 | 23 | 51 | 1742 | 1714 | PREDICTED: Rhopilema esculentum ralA-binding protein 1-like (LOC135689437), transcript variant X2, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 12023663 | 12023663 | PRJNA560932_P_NODE_24590_length_358_cov_2.431579_g24234_i0 | PRJNA560932 | 24590 | 358 | 2.431579 | 8.70505282 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g24234 | i0 | 100 | 0.0782122905027933 | 28 | 0 | 8 | 0 | 165 | 192 | 10785244 | 10785217 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 12023818 | 12023818 | PRJNA560932_P_NODE_43010_length_278_cov_2.473171_g42654_i0 | PRJNA560932 | 43010 | 278 | 2.473171 | 6.87541538 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 150 | 8.82e-32 | NTclustered | gi|2202661671|ref|XM_047003315.1| | 2897299 | g42654 | i0 | 80.513 | 5.75179856115108 | 195 | 38 | 70 | 0 | 82 | 276 | 2908 | 2714 | PREDICTED: Xenia sp. Carnegie-2017 26S proteasome non-ATPase regulatory subunit 2-like (LOC124452719), mRNA | blastn | 1599 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 13298566 | 13298566 | PRJNA560932_P_NODE_18351_length_411_cov_0.937870_g17995_i0 | PRJNA560932 | 18351 | 411 | 0.93787 | 3.8546457 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 67.6 | 1.41e-6 | NTclustered | gi|1619643801|ref|XM_021045130.2| | 2652724 | g17995 | i0 | 85.714 | 0.153284671532847 | 63 | 9 | 15 | 0 | 40 | 102 | 2859 | 2797 | PREDICTED: Exaiptasia diaphana unconventional myosin-VI (LOC110239414), mRNA | blastn | 63 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 13298818 | 13298818 | PRJNA560932_P_NODE_51631_length_252_cov_0.860335_g51275_i0 | PRJNA560932 | 51631 | 252 | 0.860335 | 2.1680442 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 206 | 1.66e-48 | NTclustered | gi|2782871477|ref|XM_067061169.1| | 252671 | g51275 | i0 | 81.6 | 47.5595238095238 | 250 | 44 | 99 | 2 | 2 | 250 | 277 | 525 | PREDICTED: Clytia hemisphaerica ras-related C3 botulinum toxin substrate 1 (LOC136804570), mRNA | blastn | 11985 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 14573723 | 14573723 | PRJNA560932_P_NODE_49092_length_259_cov_15.618280_g48736_i0 | PRJNA560932 | 49092 | 259 | 15.61828 | 40.4513452 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 137 | 6.33e-28 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g48736 | i0 | 86.992 | 49.2200772200772 | 123 | 14 | 47 | 2 | 1 | 123 | 353 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12748 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 15847546 | 15847546 | PRJNA560932_P_NODE_39393_length_290_cov_1.059908_g39037_i0 | PRJNA560932 | 39393 | 290 | 1.059908 | 3.0737332 | Gymnangium hians | 58820 | Cnidaria | other_Eukaryota | 276 | 1.46e-69 | NTclustered | gi|1185380918|gb|KY117129.1| | 58820 | g39037 | i0 | 89.14 | 71.3310344827586 | 221 | 24 | 76 | 0 | 1 | 221 | 221 | 1 | Gymnangium hians isolate DNA927 calmodulin (CAM) gene, partial cds | blastn | 20686 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Aglaopheniidae | Gymnangium | Gymnangium hians | |
| 19671146 | 19671146 | PRJNA560932_P_NODE_33736_length_312_cov_1.945607_g33380_i0 | PRJNA560932 | 33736 | 312 | 1.945607 | 6.07029384 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1619612906|ref|XM_028656889.1| | 2652724 | g33380 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 161 | 188 | 547 | 520 | PREDICTED: Exaiptasia diaphana uncharacterized LOC114574402 (LOC114574402), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 19671153 | 19671153 | PRJNA560932_P_NODE_34776_length_308_cov_1.310638_g34420_i0 | PRJNA560932 | 34776 | 308 | 1.310638 | 4.03676504 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2202608321|ref|XM_046984190.1| | 2897299 | g34420 | i0 | 96.875 | 0.103896103896104 | 32 | 1 | 10 | 0 | 1 | 32 | 1404 | 1373 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124434301 (LOC124434301), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 20946699 | 20946699 | PRJNA560932_P_NODE_21937_length_377_cov_5.273026_g21581_i0 | PRJNA560932 | 21937 | 377 | 5.273026 | 19.87930802 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 276 | 1.96e-69 | NTclustered | gi|2518991437|ref|XM_057446583.1| | 13093 | g21581 | i0 | 83.498 | 73.503978779840807 | 303 | 42 | 79 | 7 | 79 | 377 | 511 | 213 | PREDICTED: Hydractinia symbiolongicarpus ubiquitin-60S ribosomal protein L40 (LOC130636750), mRNA | blastn | 27711 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 20946942 | 20946942 | PRJNA560932_P_NODE_49977_length_257_cov_1.222826_g49621_i0 | PRJNA560932 | 49977 | 257 | 1.222826 | 3.14266282 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1176080626|ref|XM_020754757.1| | 48498 | g49621 | i0 | 100 | 0.217898832684825 | 28 | 0 | 11 | 0 | 229 | 256 | 483 | 510 | PREDICTED: Orbicella faveolata uncharacterized LOC110048990 (LOC110048990), transcript variant X2, mRNA | blastn | 56 | 52.8 | 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);;