contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137021 | 137021 | PRJEB75230_P_NODE_33841_length_340_cov_1.153558_g33659_i0 | PRJEB75230 | 33841 | 340 | 1.153558 | 3.9220972 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1176104155|ref|XM_020767223.1| | 48498 | g33659 | i0 | 100 | 0.0823529411764706 | 28 | 0 | 8 | 0 | 158 | 185 | 81 | 108 | PREDICTED: Orbicella faveolata uncharacterized LOC110060441 (LOC110060441), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 1411336 | 1411336 | PRJEB75230_P_NODE_177902_length_242_cov_0.905325_g177720_i0 | PRJEB75230 | 177902 | 242 | 0.905325 | 2.1908865 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g177720 | i0 | 94.444 | 0.148760330578512 | 36 | 1 | 14 | 1 | 153 | 187 | 16497831 | 16497866 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1412055 | 1412055 | PRJEB75230_P_NODE_56762_length_303_cov_1.560870_g56580_i0 | PRJEB75230 | 56762 | 303 | 1.56087 | 4.7294361 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g56580 | i0 | 100 | 0.099009900990099 | 30 | 0 | 10 | 0 | 5 | 34 | 12366985 | 12366956 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3962214 | 3962214 | PRJEB75230_P_NODE_128104_length_250_cov_0.870056_g127922_i0 | PRJEB75230 | 128104 | 250 | 0.870056 | 2.17514 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g127922 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 201 | 228 | 49218723 | 49218696 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 7789374 | 7789374 | PRJEB75230_P_NODE_32307_length_343_cov_1.711111_g32125_i0 | PRJEB75230 | 32307 | 343 | 1.711111 | 5.86911073 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2744795244|ref|XM_047267635.2| | 6087 | g32125 | i0 | 100 | 0.0845481049562682 | 29 | 0 | 8 | 0 | 295 | 323 | 1271 | 1299 | PREDICTED: Hydra vulgaris uncharacterized LOC124806568 (LOC124806568), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 9923911 | 9923911 | PRJEB75230_P_NODE_153488_length_245_cov_1.343023_g153306_i0 | PRJEB75230 | 153488 | 245 | 1.343023 | 3.29040635 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g153306 | i0 | 100 | 0.228571428571429 | 28 | 0 | 11 | 0 | 207 | 234 | 190948 | 190975 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 10339902 | 10339902 | PRJEB75230_P_NODE_19789_length_385_cov_1.637821_g19607_i0 | PRJEB75230 | 19789 | 385 | 1.637821 | 6.30561085 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2519006349|ref|XM_057454938.1| | 13093 | g19607 | i0 | 100 | 0.0727272727272727 | 28 | 0 | 7 | 0 | 311 | 338 | 689 | 716 | PREDICTED: Hydractinia symbiolongicarpus nucleosome-remodeling factor subunit BPTF-like (LOC130648836), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 11615881 | 11615881 | PRJEB75230_P_NODE_49110_length_313_cov_1.650000_g48928_i0 | PRJEB75230 | 49110 | 313 | 1.65 | 5.1645 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2518990769|ref|XM_057446221.1| | 13093 | g48928 | i0 | 100 | 0.0894568690095847 | 28 | 0 | 9 | 0 | 189 | 216 | 306 | 333 | PREDICTED: Hydractinia symbiolongicarpus ribonuclease P protein subunit p38-like (LOC130636484), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 14164924 | 14164924 | PRJEB75230_P_NODE_161152_length_244_cov_0.900585_g160970_i0 | PRJEB75230 | 161152 | 244 | 0.900585 | 2.1974274 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2729067450|ref|XM_065195683.1| | 499914 | g160970 | i0 | 96.875 | 0.262295081967213 | 32 | 0 | 13 | 1 | 5 | 36 | 2109 | 2139 | PREDICTED: Rhopilema esculentum uncharacterized LOC135681299 (LOC135681299), transcript variant X1, mRNA | blastn | 64 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 14165459 | 14165459 | PRJEB75230_P_NODE_30392_length_348_cov_1.400000_g30210_i0 | PRJEB75230 | 30392 | 348 | 1.4 | 4.872 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g30210 | i0 | 100 | 0.0833333333333333 | 29 | 0 | 8 | 0 | 137 | 165 | 5968073 | 5968045 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15439211 | 15439211 | PRJEB75230_P_NODE_18153_length_394_cov_1.199377_g17971_i0 | PRJEB75230 | 18153 | 394 | 1.199377 | 4.72554538 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.038 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g17971 | i0 | 96.774 | 0.0786802030456853 | 31 | 1 | 8 | 0 | 239 | 269 | 15464470 | 15464440 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15439996 | 15439996 | PRJEB75230_P_NODE_63373_length_296_cov_1.004484_g63191_i0 | PRJEB75230 | 63373 | 296 | 1.004484 | 2.97327264 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 58.4 | 5.91e-4 | NTclustered | gi|2202599513|ref|XM_046983629.1| | 2897299 | g63191 | i0 | 100 | 0.418918918918919 | 31 | 0 | 10 | 0 | 114 | 144 | 1361 | 1391 | PREDICTED: Xenia sp. Carnegie-2017 calpain-7-like (LOC124433819), transcript variant X3, mRNA | blastn | 124 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15440104 | 15440104 | PRJEB75230_P_NODE_70113_length_289_cov_0.907407_g69931_i0 | PRJEB75230 | 70113 | 289 | 0.907407 | 2.62240623 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1603782155|ref|XM_028538504.1| | 151771 | g69931 | i0 | 100 | 0.401384083044983 | 29 | 0 | 10 | 0 | 220 | 248 | 313 | 285 | PREDICTED: Dendronephthya gigantea dynein assembly factor 1, axonemal-like (LOC114518499), transcript variant X1, mRNA | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 16298432 | 16298432 | PRJEB75230_P_NODE_121733_length_251_cov_0.865169_g121551_i0 | PRJEB75230 | 121733 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 62.1 | 3.78e-5 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g121551 | i0 | 93.023 | 8.48207171314741 | 43 | 1 | 17 | 2 | 62 | 103 | 13791032 | 13790991 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 2129 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17989190 | 17989190 | PRJEB75230_P_NODE_69655_length_289_cov_1.245370_g69473_i0 | PRJEB75230 | 69655 | 289 | 1.24537 | 3.5991193 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1524866753|ref|XM_027184770.1| | 46731 | g69473 | i0 | 100 | 0.100346020761246 | 29 | 0 | 10 | 0 | 179 | 207 | 1190 | 1162 | PREDICTED: Pocillopora damicornis uncharacterized LOC113668813 (LOC113668813), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 19261383 | 19261383 | PRJEB75230_P_NODE_10936_length_457_cov_1.005208_g10754_i0 | PRJEB75230 | 10936 | 457 | 1.005208 | 4.59380056 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.044 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g10754 | i0 | 100 | 0.0612691466083151 | 28 | 0 | 6 | 0 | 111 | 138 | 3948035 | 3948062 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 21397941 | 21397941 | PRJEB75230_P_NODE_126997_length_250_cov_0.870056_g126815_i0 | PRJEB75230 | 126997 | 250 | 0.870056 | 2.17514 | Montipora | 46703 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2812175639|ref|XM_068900728.1| | 246305 | g126815 | i0 | 96.875 | 0.384 | 32 | 1 | 13 | 0 | 13 | 44 | 284 | 315 | PREDICTED: Montipora capricornis nucleobindin-1-like (LOC138054239), mRNA | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 23087846 | 23087846 | PRJEB75230_P_NODE_123039_length_250_cov_1.344633_g122857_i0 | PRJEB75230 | 123039 | 250 | 1.344633 | 3.3615825 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g122857 | i0 | 100 | 1.924 | 30 | 0 | 12 | 0 | 84 | 113 | 4410436 | 4410407 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 481 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24361590 | 24361590 | PRJEB75230_P_NODE_10720_length_460_cov_0.994832_g10538_i0 | PRJEB75230 | 10720 | 460 | 0.994832 | 4.5762272 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.045 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g10538 | i0 | 100 | 0.0608695652173913 | 28 | 0 | 6 | 0 | 151 | 178 | 11210999 | 11211026 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24362765 | 24362765 | PRJEB75230_P_NODE_27300_length_357_cov_1.207746_g27118_i0 | PRJEB75230 | 27300 | 357 | 1.207746 | 4.31165322 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 243 | 1.8700000000000001e-59 | NTclustered | gi|2782943885|ref|XM_067076883.1| | 252671 | g27118 | i0 | 79.769 | 113.095238095238 | 346 | 60 | 96 | 10 | 16 | 356 | 464 | 124 | PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eL40 fusion protein (LOC136820684), mRNA | blastn | 40375 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 24363812 | 24363812 | PRJEB75230_P_NODE_93800_length_268_cov_1.579487_g93618_i0 | PRJEB75230 | 93800 | 268 | 1.579487 | 4.23302516 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2729065388|ref|XM_065216054.1| | 499914 | g93618 | i0 | 100 | 0.111940298507463 | 30 | 0 | 11 | 0 | 91 | 120 | 5588 | 5617 | PREDICTED: Rhopilema esculentum uncharacterized LOC135696605 (LOC135696605), transcript variant X6, mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;