contig_metadata
23 rows where bioproject = "PRJNA1095825" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1019272 | 1019272 | PRJNA1095825_P_NODE_132721_length_335_cov_1.469466_g129658_i0 | PRJNA1095825 | 132721 | 335 | 1.469466 | 4.9227111 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g129658 | i0 | 100 | 0.516417910447761 | 29 | 0 | 9 | 0 | 240 | 268 | 9386824 | 9386852 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 173 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6578794 | 6578794 | PRJNA1095825_P_NODE_256226_length_248_cov_0.880000_g253163_i0 | PRJNA1095825 | 256226 | 248 | 0.88 | 2.1824 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 309 | 1.21e-79 | NTclustered | gi|2744816405|ref|XM_047280136.2| | 6087 | g253163 | i0 | 92.694 | 2.6491935483871 | 219 | 8 | 85 | 2 | 1 | 211 | 2192 | 1974 | PREDICTED: Hydra vulgaris TNF receptor-associated factor 4 (LOC100203793), transcript variant X3, mRNA | blastn | 657 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13772762 | 13772762 | PRJNA1095825_P_NODE_194391_length_280_cov_2.130435_g191328_i0 | PRJNA1095825 | 194391 | 280 | 2.130435 | 5.965218 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g191328 | i0 | 100 | 2.97857142857143 | 30 | 0 | 11 | 0 | 191 | 220 | 12182145 | 12182116 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 834 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14229575 | 14229575 | PRJNA1095825_P_NODE_260372_length_247_cov_0.885057_g257309_i0 | PRJNA1095825 | 260372 | 247 | 0.885057 | 2.18609079 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 152 | 2.1399999999999998e-32 | NTclustered | gi|2257873693|ref|XM_048726870.1| | 45351 | g257309 | i0 | 86.713 | 3.21862348178138 | 143 | 11 | 56 | 8 | 36 | 173 | 441 | 580 | PREDICTED: Nematostella vectensis uncharacterized LOC5501568 (LOC5501568), mRNA | blastn | 795 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 15503980 | 15503980 | PRJNA1095825_P_NODE_33393_length_681_cov_1.103618_g30393_i0 | PRJNA1095825 | 33393 | 681 | 1.103618 | 7.51563858 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g30393 | i0 | 100 | 0.0455212922173275 | 31 | 0 | 5 | 0 | 328 | 358 | 6589899 | 6589869 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16776991 | 16776991 | PRJNA1095825_P_NODE_154794_length_313_cov_1.529167_g151731_i0 | PRJNA1095825 | 154794 | 313 | 1.529167 | 4.78629271 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 440 | 5.349999999999999e-119 | NTclustered | gi|2744831861|ref|XM_065785009.1| | 6087 | g151731 | i0 | 92.013 | 6 | 313 | 25 | 100 | 0 | 1 | 313 | 2240 | 1928 | PREDICTED: Hydra vulgaris uncharacterized LOC124819170 (LOC124819170), transcript variant X2, mRNA | blastn | 1878 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 18051943 | 18051943 | PRJNA1095825_P_NODE_197155_length_278_cov_2.243902_g194092_i0 | PRJNA1095825 | 197155 | 278 | 2.243902 | 6.23804756 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 71.3 | 7.06e-8 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g194092 | i0 | 95.556 | 28.431654676259 | 45 | 0 | 17 | 1 | 93 | 137 | 10566244 | 10566202 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 7904 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22696404 | 22696404 | PRJNA1095825_P_NODE_228278_length_256_cov_1.683060_g225215_i0 | PRJNA1095825 | 228278 | 256 | 1.68306 | 4.3086336 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g225215 | i0 | 100 | 0.21875 | 28 | 0 | 11 | 0 | 56 | 83 | 412334 | 412307 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23152478 | 23152478 | PRJNA1095825_P_NODE_190179_length_284_cov_1.023697_g187116_i0 | PRJNA1095825 | 190179 | 284 | 1.023697 | 2.90729948 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 436 | 6.2e-118 | NTclustered | gi|2744816405|ref|XM_047280136.2| | 6087 | g187116 | i0 | 94.158 | 4.09859154929577 | 291 | 9 | 99 | 2 | 2 | 284 | 3954 | 3664 | PREDICTED: Hydra vulgaris TNF receptor-associated factor 4 (LOC100203793), transcript variant X3, mRNA | blastn | 1164 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 24427247 | 24427247 | PRJNA1095825_P_NODE_37020_length_640_cov_1.742504_g33992_i0 | PRJNA1095825 | 37020 | 640 | 1.742504 | 11.1520256 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.005 | NTclustered | gi|2918369554|emb|OZ237726.1| | 317547 | g33992 | i0 | 100 | 0.046875 | 30 | 0 | 5 | 0 | 311 | 340 | 8538086 | 8538057 | Eunicella cavolini genome assembly, chromosome: 10 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 26624405 | 26624405 | PRJNA1095825_P_NODE_280021_length_244_cov_0.900585_g276958_i0 | PRJNA1095825 | 280021 | 244 | 0.900585 | 2.1974274 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.2 | 1.45e-7 | NR | KXJ22609.1 | 2652724 | g276958 | i0 | 39.1 | 0.848360655737705 | 69 | 42 | 84.8 | 0 | 225 | 19 | 1366 | 1434 | KXJ22609.1 hypothetical protein AC249_AIPGENE26567 [Exaiptasia diaphana] | diamond | 207 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26963906 | 26963906 | PRJNA1095825_P_NODE_99962_length_381_cov_0.967532_g96899_i0 | PRJNA1095825 | 99962 | 381 | 0.967532 | 3.68629692 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 50.4 | 3.5e-4 | NR | XP_067030033.1 | 159855 | g96899 | i0 | 39.5 | 3.82677165354331 | 81 | 44 | 63.8 | 1 | 245 | 3 | 633 | 708 | XP_067030033.1 uncharacterized protein [Acropora muricata] | diamond | 1458 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 27438471 | 27438471 | PRJNA1095825_P_NODE_236443_length_251_cov_0.865169_g233380_i0 | PRJNA1095825 | 236443 | 251 | 0.865169 | 2.17157419 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 50.1 | 4.37e-5 | NR | KAK2554835.1 | 6130 | g233380 | i0 | 46.9 | 2.34262948207171 | 49 | 26 | 58.6 | 0 | 246 | 100 | 108 | 156 | KAK2554835.1 hypothetical protein P5673_023476 [Acropora cervicornis] | diamond | 588 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28164447 | 28164447 | PRJNA1095825_P_NODE_130425_length_338_cov_1.098113_g127362_i0 | PRJNA1095825 | 130425 | 338 | 1.098113 | 3.71162194 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 113 | 1.87e-26 | NR | XP_065660553.1 | 6087 | g127362 | i0 | 54.7 | 17.7159763313609 | 95 | 43 | 84.3 | 0 | 287 | 3 | 327 | 421 | XP_065660553.1 uncharacterized protein LOC136084481 [Hydra vulgaris] | diamond | 5988 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28362384 | 28362384 | PRJNA1095825_P_NODE_203966_length_274_cov_1.114428_g200903_i0 | PRJNA1095825 | 203966 | 274 | 1.114428 | 3.05353272 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 80.1 | 3.94e-15 | NR | CAB3988038.1 | 317549 | g200903 | i0 | 53.6 | 2.32116788321168 | 69 | 32 | 75.5 | 0 | 267 | 61 | 342 | 410 | CAB3988038.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 636 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28511689 | 28511689 | PRJNA1095825_P_NODE_237187_length_251_cov_0.865169_g234124_i0 | PRJNA1095825 | 237187 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 91.3 | 3.39e-19 | NR | KAK2573141.1 | 6130 | g234124 | i0 | 63.8 | 3.29880478087649 | 69 | 25 | 82.5 | 0 | 29 | 235 | 183 | 251 | KAK2573141.1 RNA-directed DNA polymerase from mobile element jockey [Acropora cervicornis] | diamond | 828 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28772871 | 28772871 | PRJNA1095825_P_NODE_268787_length_246_cov_0.890173_g265724_i0 | PRJNA1095825 | 268787 | 246 | 0.890173 | 2.18982558 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 46.6 | 0.00164 | NR | KAK2562750.1 | 6130 | g265724 | i0 | 61.3 | 2.18292682926829 | 31 | 12 | 37.8 | 0 | 153 | 245 | 379 | 409 | KAK2562750.1 hypothetical protein P5673_014468 [Acropora cervicornis] | diamond | 537 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28962640 | 28962640 | PRJNA1095825_P_NODE_209188_length_270_cov_1.253807_g206125_i0 | PRJNA1095825 | 209188 | 270 | 1.253807 | 3.3852789 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 73.9 | 2.57e-13 | NR | XP_015750100.1 | 70779 | g206125 | i0 | 79.5 | 0.433333333333333 | 39 | 8 | 43.3 | 0 | 2 | 118 | 124 | 162 | XP_015750100.1 PREDICTED: isovaleryl-CoA dehydrogenase, mitochondrial-like [Acropora digitifera] | diamond | 117 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 29624984 | 29624984 | PRJNA1095825_P_NODE_253070_length_248_cov_1.097143_g250007_i0 | PRJNA1095825 | 253070 | 248 | 1.097143 | 2.72091464 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 60.1 | 5.07e-9 | NR | CAB4016813.1 | 317549 | g250007 | i0 | 41.2 | 2.57661290322581 | 68 | 39 | 81 | 1 | 237 | 37 | 9 | 76 | CAB4016813.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 639 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29995937 | 29995937 | PRJNA1095825_P_NODE_263431_length_246_cov_1.780347_g260368_i0 | PRJNA1095825 | 263431 | 246 | 1.780347 | 4.37965362 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 108 | 1.57e-25 | NR | XP_065641469.1 | 6087 | g260368 | i0 | 73.4 | 18.8170731707317 | 64 | 17 | 78 | 0 | 193 | 2 | 483 | 546 | XP_065641469.1 uncharacterized protein LOC124806957 [Hydra vulgaris] | diamond | 4629 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30541531 | 30541531 | PRJNA1095825_P_NODE_267013_length_246_cov_0.890173_g263950_i0 | PRJNA1095825 | 267013 | 246 | 0.890173 | 2.18982558 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 43.1 | 0.0268 | NR | XP_065658045.1 | 6087 | g263950 | i0 | 57.5 | 1.84146341463415 | 40 | 13 | 43.9 | 1 | 2 | 109 | 130 | 169 | XP_065658045.1 zinc finger MYM-type protein 1-like [Hydra vulgaris] | diamond | 453 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31259678 | 31259678 | PRJNA1095825_P_NODE_259735_length_247_cov_0.885057_g256672_i0 | PRJNA1095825 | 259735 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 45.8 | 9.66e-4 | NR | XP_065654593.1 | 6087 | g256672 | i0 | 50 | 7.42105263157895 | 38 | 19 | 46.2 | 0 | 240 | 127 | 65 | 102 | XP_065654593.1 uncharacterized protein LOC136081222 [Hydra vulgaris] | diamond | 1833 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32208700 | 32208700 | PRJNA1095825_P_NODE_78058_length_428_cov_3.692958_g74995_i0 | PRJNA1095825 | 78058 | 428 | 3.692958 | 15.80586024 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.3 | 2e-15 | NR | XP_031549886.1 | 6105 | g74995 | i0 | 43.8 | 5.1518691588785 | 105 | 59 | 73.6 | 0 | 417 | 103 | 125 | 229 | XP_031549886.1 40S ribosomal protein S3a [Actinia tenebrosa] | diamond | 2205 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa |
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);;