contig_metadata
21 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1204913 | 1204913 | PRJNA760976_P_NODE_56401_length_241_cov_0.898810_g56080_i0 | PRJNA760976 | 56401 | 241 | 0.89881 | 2.1661321 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 60.2 | 1.3e-4 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g56080 | i0 | 97.143 | 1.85477178423237 | 35 | 1 | 15 | 0 | 59 | 93 | 26358902 | 26358868 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 447 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 10133666 | 10133666 | PRJNA760976_P_NODE_7548_length_501_cov_1.226636_g7229_i0 | PRJNA760976 | 7548 | 501 | 1.226636 | 6.14544636 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 191 | 1e-56 | NR | KAK2553433.1 | 6130 | g7229 | i0 | 62.3 | 7.19161676646707 | 154 | 58 | 92.2 | 0 | 462 | 1 | 42 | 195 | KAK2553433.1 60S acidic ribosomal protein P0 [Acropora cervicornis] | diamond | 3603 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 12684679 | 12684679 | PRJNA760976_P_NODE_11790_length_422_cov_2.223496_g11470_i0 | PRJNA760976 | 11790 | 422 | 2.223496 | 9.38315312 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 324 | 7.7999999999999995e-84 | NTclustered | gi|2519007092|ref|XM_057455329.1| | 13093 | g11470 | i0 | 81.436 | 99.1232227488152 | 404 | 67 | 95 | 7 | 23 | 422 | 3628 | 3229 | PREDICTED: Hydractinia symbiolongicarpus kelch-like protein 20 (LOC130649111), mRNA | blastn | 41830 | 326 | 0.993865030674847 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 21144894 | 21144894 | PRJNA760976_P_NODE_23837_length_328_cov_1.156863_g23516_i0 | PRJNA760976 | 23837 | 328 | 1.156863 | 3.79451064 | Salacia desmoides | 662031 | Cnidaria | other_Eukaryota | 154 | 8.22e-33 | NTclustered | gi|256674477|gb|FJ550381.1| | 662031 | g23516 | i0 | 84.615 | 24.4878048780488 | 156 | 22 | 48 | 2 | 1 | 156 | 1513 | 1666 | Salacia desmoides 28S ribosomal RNA gene, partial sequence | blastn | 8032 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Salacia | Salacia desmoides | |
| 27779811 | 27779811 | PRJNA760976_P_NODE_50164_length_247_cov_1.425287_g49843_i0 | PRJNA760976 | 50164 | 247 | 1.425287 | 3.52045889 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 49.3 | 1.02e-4 | NR | XP_046857911.1 | 2897299 | g49843 | i0 | 44.6 | 0.680161943319838 | 56 | 31 | 68 | 0 | 170 | 3 | 18 | 73 | XP_046857911.1 uncharacterized protein LOC124451345 [Xenia sp. Carnegie-2017] | diamond | 168 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28063789 | 28063789 | PRJNA760976_P_NODE_33385_length_291_cov_1.302752_g33064_i0 | PRJNA760976 | 33385 | 291 | 1.302752 | 3.79100832 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 63.2 | 4.37e-9 | NR | CAH3154772.1 | 104759 | g33064 | i0 | 40 | 0.77319587628866 | 75 | 44 | 76.3 | 1 | 263 | 42 | 541 | 615 | CAH3154772.1 unnamed protein product [Porites lobata] | diamond | 225 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 28642015 | 28642015 | PRJNA760976_P_NODE_57347_length_235_cov_2.012346_g57026_i0 | PRJNA760976 | 57347 | 235 | 2.012346 | 4.7290131 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 108 | 3.63e-26 | NR | KAK2573205.1 | 6130 | g57026 | i0 | 68.9 | 70.9148936170213 | 74 | 22 | 94.5 | 1 | 12 | 233 | 1 | 73 | KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] | diamond | 16665 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28663824 | 28663824 | PRJNA760976_P_NODE_55227_length_242_cov_0.893491_g54906_i0 | PRJNA760976 | 55227 | 242 | 0.893491 | 2.16224822 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 75.9 | 6.73e-14 | NR | XP_029202026.2 | 45264 | g54906 | i0 | 42.3 | 2.85123966942149 | 78 | 45 | 96.7 | 0 | 234 | 1 | 260 | 337 | XP_029202026.2 gastric triacylglycerol lipase-like [Acropora millepora] | diamond | 690 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28768077 | 28768077 | PRJNA760976_P_NODE_56187_length_241_cov_0.916667_g55866_i0 | PRJNA760976 | 56187 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.4 | 5.37e-6 | NR | NP_001267814.1 | 6087 | g55866 | i0 | 50 | 8.31535269709544 | 42 | 21 | 52.3 | 0 | 1 | 126 | 23 | 64 | NP_001267814.1 kazal-type serine protease inihibitor 5 precursor [Hydra vulgaris] | diamond | 2004 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29241790 | 29241790 | PRJNA760976_P_NODE_22689_length_334_cov_0.885057_g22368_i0 | PRJNA760976 | 22689 | 334 | 0.885057 | 2.95609038 | Porites | 46719 | Cnidaria | other_Eukaryota | 62.4 | 2.99e-9 | NR | CAH3182979.1 | 104178 | g22368 | i0 | 50 | 2.91916167664671 | 52 | 25 | 46.7 | 1 | 185 | 30 | 45 | 95 | CAH3182979.1 unnamed protein product [Porites evermanni] | diamond | 975 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29904995 | 29904995 | PRJNA760976_P_NODE_55011_length_242_cov_1.065089_g54690_i0 | PRJNA760976 | 55011 | 242 | 1.065089 | 2.57751538 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 43.1 | 0.0253 | NR | XP_015747285.1 | 70779 | g54690 | i0 | 46.9 | 5.91322314049587 | 49 | 25 | 60.7 | 1 | 148 | 2 | 62 | 109 | XP_015747285.1 PREDICTED: exonuclease 3'-5' domain-containing protein 1-like [Acropora digitifera] | diamond | 1431 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 30157350 | 30157350 | PRJNA760976_P_NODE_2812_length_768_cov_3.515108_g2519_i0 | PRJNA760976 | 2812 | 768 | 3.515108 | 26.99602944 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 97.4 | 2.83e-19 | NR | XP_044184416.1 | 45264 | g2519 | i0 | 35.7 | 2.14453125 | 171 | 95 | 65.2 | 5 | 80 | 580 | 220 | 379 | XP_044184416.1 protein hedgehog-like isoform X1 [Acropora millepora] | diamond | 1647 | 98.2 | 0.991853360488798 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30473694 | 30473694 | PRJNA760976_P_NODE_49733_length_248_cov_0.880000_g49412_i0 | PRJNA760976 | 49733 | 248 | 0.88 | 2.1824 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 55.1 | 1.99e-7 | NR | XP_028401732.1 | 151771 | g49412 | i0 | 71.4 | 2.9758064516129 | 35 | 10 | 42.3 | 0 | 110 | 6 | 3 | 37 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 738 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30526993 | 30526993 | PRJNA760976_P_NODE_49013_length_249_cov_1.267045_g48692_i0 | PRJNA760976 | 49013 | 249 | 1.267045 | 3.15494205 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 53.9 | 4.53e-7 | NR | XP_020898478.1 | 2652724 | g48692 | i0 | 52.5 | 0.481927710843373 | 40 | 19 | 48.2 | 0 | 18 | 137 | 42 | 81 | XP_020898478.1 RIIa domain-containing protein 1 [Exaiptasia diaphana] | diamond | 120 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30621708 | 30621708 | PRJNA760976_P_NODE_42533_length_265_cov_1.130208_g42212_i0 | PRJNA760976 | 42533 | 265 | 1.130208 | 2.9950512 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 48.9 | 3.16e-4 | NR | XP_047143839.1 | 6087 | g42212 | i0 | 40 | 1.58490566037736 | 70 | 41 | 79.2 | 1 | 55 | 264 | 32 | 100 | XP_047143839.1 uncharacterized protein LOC124817601 [Hydra vulgaris] | diamond | 420 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31158619 | 31158619 | PRJNA760976_P_NODE_53095_length_244_cov_0.871345_g52774_i0 | PRJNA760976 | 53095 | 244 | 0.871345 | 2.1260818 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 45.1 | 0.00524 | NR | KAJ7381415.1 | 174260 | g52774 | i0 | 32.5 | 1.02049180327869 | 83 | 49 | 94.7 | 3 | 235 | 5 | 176 | 257 | KAJ7381415.1 hypothetical protein OS493_001550 [Desmophyllum pertusum] | diamond | 249 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 31759839 | 31759839 | PRJNA760976_P_NODE_24917_length_323_cov_1.204000_g24596_i0 | PRJNA760976 | 24917 | 323 | 1.204 | 3.88892 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 83.2 | 4.79e-18 | NR | XP_028401732.1 | 151771 | g24596 | i0 | 52.3 | 2.65634674922601 | 88 | 38 | 81.7 | 2 | 266 | 3 | 6 | 89 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 858 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 32180988 | 32180988 | PRJNA760976_P_NODE_27278_length_313_cov_1.241667_g26957_i0 | PRJNA760976 | 27278 | 313 | 1.241667 | 3.88641771 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 8.300000000000001e-27 | NR | RMX46178.1 | 46731 | g26957 | i0 | 77.8 | 5.28115015974441 | 72 | 16 | 69 | 0 | 218 | 3 | 607 | 678 | RMX46178.1 hypothetical protein pdam_00007820 [Pocillopora damicornis] | diamond | 1653 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32307759 | 32307759 | PRJNA760976_P_NODE_26479_length_316_cov_1.555556_g26158_i0 | PRJNA760976 | 26479 | 316 | 1.555556 | 4.91555696 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 102 | 2.0299999999999998e-23 | NR | XP_027037461.1 | 46731 | g26158 | i0 | 47.1 | 17.506329113924 | 102 | 48 | 96.8 | 2 | 9 | 314 | 48 | 143 | XP_027037461.1 cathepsin L1-like [Pocillopora damicornis] | diamond | 5532 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32424334 | 32424334 | PRJNA760976_P_NODE_3119_length_735_cov_1.830816_g2825_i0 | PRJNA760976 | 3119 | 735 | 1.830816 | 13.4564976 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 98.6 | 7.86e-20 | NR | XP_020631088.1 | 48498 | g2825 | i0 | 33.3 | 1.53061224489796 | 204 | 117 | 78.8 | 6 | 664 | 86 | 202 | 397 | XP_020631088.1 protein hedgehog-like [Orbicella faveolata] | diamond | 1125 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32654728 | 32654728 | PRJNA760976_P_NODE_47000_length_253_cov_1.633333_g46679_i0 | PRJNA760976 | 47000 | 253 | 1.633333 | 4.13233249 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 127 | 1.43e-32 | NR | XP_065644887.1 | 6087 | g46679 | i0 | 71.1 | 8.85770750988142 | 83 | 24 | 98.4 | 0 | 3 | 251 | 114 | 196 | XP_065644887.1 60S ribosomal export protein NMD3 isoform X2 [Hydra vulgaris] | diamond | 2241 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;