contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1762843 | 1762843 | PRJNA520845_P_NODE_118242_length_343_cov_1.140741_g116743_i0 | PRJNA520845 | 118242 | 343 | 1.140741 | 3.91274163 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g116743 | i0 | 100 | 0.0816326530612245 | 28 | 0 | 8 | 0 | 202 | 229 | 7069975 | 7069948 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1765262 | 1765262 | PRJNA520845_P_NODE_206942_length_256_cov_1.262295_g205443_i0 | PRJNA520845 | 206942 | 256 | 1.262295 | 3.2314752 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 130 | 1.05e-25 | NTclustered | gi|1778057267|ref|XM_031710041.1| | 6105 | g205443 | i0 | 80 | 10.48828125 | 185 | 29 | 71 | 8 | 76 | 256 | 339 | 159 | PREDICTED: Actinia tenebrosa 60S ribosomal protein L44 (LOC116301041), mRNA | blastn | 2685 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 3038902 | 3038902 | PRJNA520845_P_NODE_12803_length_1092_cov_2.058881_g11773_i0 | PRJNA520845 | 12803 | 1092 | 2.058881 | 22.48298052 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 54.7 | 0.031 | NTclustered | gi|1524861564|ref|XM_027182024.1| | 46731 | g11773 | i0 | 100 | 0.0265567765567766 | 29 | 0 | 3 | 0 | 383 | 411 | 475 | 447 | PREDICTED: Pocillopora damicornis basement membrane-specific heparan sulfate proteoglycan core protein-like (LOC113666263), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3040290 | 3040290 | PRJNA520845_P_NODE_178923_length_278_cov_3.004878_g177424_i0 | PRJNA520845 | 178923 | 278 | 3.004878 | 8.35356084 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 82.4 | 3.26e-11 | NTclustered | gi|2744791501|ref|XM_047289847.2| | 6087 | g177424 | i0 | 85.714 | 0.553956834532374 | 77 | 11 | 28 | 0 | 5 | 81 | 943 | 1019 | PREDICTED: Hydra vulgaris cathepsin B (LOC100197952), transcript variant X1, mRNA | blastn | 154 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 3040729 | 3040729 | PRJNA520845_P_NODE_194703_length_266_cov_1.305699_g193204_i0 | PRJNA520845 | 194703 | 266 | 1.305699 | 3.47315934 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2918369563|emb|OZ237729.1| | 317547 | g193204 | i0 | 100 | 3.83458646616541 | 29 | 0 | 12 | 0 | 214 | 242 | 9587171 | 9587199 | Eunicella cavolini genome assembly, chromosome: 13 | blastn | 1020 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 3041817 | 3041817 | PRJNA520845_P_NODE_235883_length_247_cov_0.885057_g234384_i0 | PRJNA520845 | 235883 | 247 | 0.885057 | 2.18609079 | Myxidium gadi | 371546 | Cnidaria | other_Eukaryota | 121 | 6.03e-23 | NTclustered | gi|241911756|gb|FJ417062.1| | 371546 | g234384 | i0 | 86.486 | 46.6275303643725 | 111 | 13 | 45 | 2 | 111 | 221 | 2156 | 2048 | Myxidium gadi isolate M0307 28S large subunit ribosomal RNA gene, partial sequence | blastn | 11517 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium gadi | |
| 6868122 | 6868122 | PRJNA520845_P_NODE_219346_length_250_cov_0.870056_g217847_i0 | PRJNA520845 | 219346 | 250 | 0.870056 | 2.17514 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g217847 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 190 | 217 | 15526323 | 15526296 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6868572 | 6868572 | PRJNA520845_P_NODE_236226_length_247_cov_0.885057_g234727_i0 | PRJNA520845 | 236226 | 247 | 0.885057 | 2.18609079 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2519013294|ref|XM_057458058.1| | 13093 | g234727 | i0 | 100 | 0.352226720647773 | 29 | 0 | 12 | 0 | 25 | 53 | 5568 | 5596 | PREDICTED: Hydractinia symbiolongicarpus dedicator of cytokinesis protein 1-like (LOC130655320), transcript variant X2, mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 8145851 | 8145851 | PRJNA520845_P_NODE_72847_length_435_cov_2.071823_g71348_i0 | PRJNA520845 | 72847 | 435 | 2.071823 | 9.01243005 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 265 | 4.959999999999999e-66 | NTclustered | gi|2744794010|ref|XM_012698561.3| | 6087 | g71348 | i0 | 81.962 | 23.4505747126437 | 316 | 53 | 72 | 4 | 118 | 431 | 217 | 530 | PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA | blastn | 10201 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 9420143 | 9420143 | PRJNA520845_P_NODE_35828_length_633_cov_2.978571_g34370_i0 | PRJNA520845 | 35828 | 633 | 2.978571 | 18.85435443 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.017 | NTclustered | gi|2918369540|emb|OZ237722.1| | 317547 | g34370 | i0 | 100 | 0.0458135860979463 | 29 | 0 | 5 | 0 | 251 | 279 | 5240126 | 5240154 | Eunicella cavolini genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 10692930 | 10692930 | PRJNA520845_P_NODE_172549_length_283_cov_2.833333_g171050_i0 | PRJNA520845 | 172549 | 283 | 2.833333 | 8.01833239 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 209 | 1.46e-49 | NTclustered | gi|2729094237|ref|XM_065209919.1| | 499914 | g171050 | i0 | 80.882 | 6.74558303886926 | 272 | 46 | 95 | 6 | 5 | 273 | 394 | 126 | PREDICTED: Rhopilema esculentum PHD finger-like domain-containing protein 5A (LOC135691916), mRNA | blastn | 1909 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 10694595 | 10694595 | PRJNA520845_P_NODE_233389_length_247_cov_1.522989_g231890_i0 | PRJNA520845 | 233389 | 247 | 1.522989 | 3.76178283 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 60.2 | 1.33e-4 | NTclustered | gi|2751546484|ref|XM_066166122.1| | 203993 | g231890 | i0 | 94.872 | 3.55465587044534 | 39 | 1 | 15 | 1 | 150 | 187 | 2675 | 2713 | PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC131778770), mRNA | blastn | 878 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 13245348 | 13245348 | PRJNA520845_P_NODE_259451_length_242_cov_0.911243_g257952_i0 | PRJNA520845 | 259451 | 242 | 0.911243 | 2.20520806 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1176072172|ref|XM_020750349.1| | 48498 | g257952 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 197 | 224 | 5410 | 5383 | PREDICTED: Orbicella faveolata VWFA and cache domain-containing protein 1-like (LOC110044771), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 14517324 | 14517324 | PRJNA520845_P_NODE_145352_length_310_cov_1.177215_g143853_i0 | PRJNA520845 | 145352 | 310 | 1.177215 | 3.6493665 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2782824474|ref|XM_067054222.1| | 252671 | g143853 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 11 | 38 | 120 | 147 | PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136797633), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 14519799 | 14519799 | PRJNA520845_P_NODE_238012_length_246_cov_2.225434_g236513_i0 | PRJNA520845 | 238012 | 246 | 2.225434 | 5.47456764 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.33e-4 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g236513 | i0 | 88.462 | 5.91463414634146 | 52 | 2 | 21 | 3 | 106 | 157 | 2570164 | 2570117 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 1455 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15794477 | 15794477 | PRJNA520845_P_NODE_3213_length_2033_cov_2.446939_g2809_i0 | PRJNA520845 | 3213 | 2033 | 2.446939 | 49.74626987 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 58.4 | 0.005 | NTclustered | gi|2751561850|ref|XM_066170370.1| | 203993 | g2809 | i0 | 92.5 | 0.0703393999016232 | 40 | 3 | 2 | 0 | 1844 | 1883 | 971 | 1010 | PREDICTED: Pocillopora verrucosa N66 matrix protein-like (LOC136282677), transcript variant X1, mRNA | blastn | 143 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 17066951 | 17066951 | PRJNA520845_P_NODE_195874_length_265_cov_1.380208_g194375_i0 | PRJNA520845 | 195874 | 265 | 1.380208 | 3.6575512 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 204 | 6.32e-48 | NTclustered | gi|2729096388|ref|XM_065211075.1| | 499914 | g194375 | i0 | 84.804 | 27.1509433962264 | 204 | 29 | 77 | 2 | 2 | 204 | 401 | 199 | PREDICTED: Rhopilema esculentum ADP-ribosylation factor 4 (LOC135692777), mRNA | blastn | 7195 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 18340653 | 18340653 | PRJNA520845_P_NODE_168615_length_287_cov_1.079439_g167116_i0 | PRJNA520845 | 168615 | 287 | 1.079439 | 3.09798993 | Orthopyxis integra | 314509 | Cnidaria | other_Eukaryota | 185 | 2.51e-42 | NTclustered | gi|62825409|gb|AY789841.1| | 314509 | g167116 | i0 | 78.472 | 4.33101045296167 | 288 | 58 | 99 | 4 | 2 | 287 | 356 | 71 | Orthopyxis integra voucher 796asymmetrica calmodulin gene, partial cds | blastn | 1243 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Orthopyxis | Orthopyxis integra | |
| 18343682 | 18343682 | PRJNA520845_P_NODE_43375_length_571_cov_3.034137_g41894_i0 | PRJNA520845 | 43375 | 571 | 3.034137 | 17.32492227 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 387 | 1.36e-102 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g41894 | i0 | 87.316 | 61.1068301225919 | 339 | 41 | 59 | 2 | 1 | 338 | 1066 | 1403 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 34892 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 19613968 | 19613968 | PRJNA520845_P_NODE_12856_length_1089_cov_3.474409_g11824_i0 | PRJNA520845 | 12856 | 1089 | 3.474409 | 37.83631401 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 776 | 0 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g11824 | i0 | 82.018 | 241.734618916437 | 912 | 164 | 84 | 0 | 57 | 968 | 305 | 1216 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 263249 | 776 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 24716576 | 24716576 | PRJNA520845_P_NODE_225600_length_249_cov_0.875000_g224101_i0 | PRJNA520845 | 225600 | 249 | 0.875 | 2.17875 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 4.84e-4 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g224101 | i0 | 100 | 3.91967871485944 | 31 | 0 | 12 | 0 | 67 | 97 | 296311 | 296281 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 976 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;