contig_metadata
19 rows where bioproject = "PRJNA797475" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3332517 | 3332517 | PRJNA797475_P_NODE_26943_length_245_cov_0.895349_g26844_i0 | PRJNA797475 | 26943 | 245 | 0.895349 | 2.19360505 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 122 | 1.66e-23 | NTclustered | gi|2782948454|ref|XM_067078050.1| | 252671 | g26844 | i0 | 78.723 | 15.8530612244898 | 188 | 36 | 76 | 4 | 1 | 186 | 200 | 385 | PREDICTED: Clytia hemisphaerica late histone H2A.2.2-like (LOC136821830), mRNA | blastn | 3884 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 5885061 | 5885061 | PRJNA797475_P_NODE_30585_length_240_cov_2.706587_g30486_i0 | PRJNA797475 | 30585 | 240 | 2.706587 | 6.4958088 | Anthopleura buddemeieri | 1566020 | Cnidaria | other_Eukaryota | 337 | 5.32e-88 | NTclustered | gi|1229749024|gb|KY789381.1| | 1566020 | g30486 | i0 | 92.116 | 98.1458333333333 | 241 | 15 | 100 | 4 | 1 | 240 | 583 | 346 | Anthopleura buddemeieri isolate budd 28S ribosomal RNA gene, partial sequence | blastn | 23555 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anthopleura | Anthopleura buddemeieri | |
| 8434611 | 8434611 | PRJNA797475_P_NODE_27767_length_244_cov_0.900585_g27668_i0 | PRJNA797475 | 27767 | 244 | 0.900585 | 2.1974274 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 195 | 3.46e-45 | NTclustered | gi|2744840031|ref|XM_065787835.1| | 6087 | g27668 | i0 | 82.096 | 5.91803278688525 | 229 | 39 | 93 | 2 | 17 | 244 | 839 | 612 | PREDICTED: Hydra vulgaris rRNA 2'-O-methyltransferase fibrillarin (LOC100212665), transcript variant X4, mRNA | blastn | 1444 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 12260955 | 12260955 | PRJNA797475_P_NODE_26810_length_245_cov_0.895349_g26711_i0 | PRJNA797475 | 26810 | 245 | 0.895349 | 2.19360505 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 337 | 5.45e-88 | NTclustered | gi|1778041774|ref|XM_031702547.1| | 6105 | g26711 | i0 | 92.05 | 1.23673469387755 | 239 | 19 | 98 | 0 | 4 | 242 | 4207 | 4445 | PREDICTED: Actinia tenebrosa collagen alpha-1(I) chain-like (LOC116294868), mRNA | blastn | 303 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 16083885 | 16083885 | PRJNA797475_P_NODE_17813_length_269_cov_1.397959_g17714_i0 | PRJNA797475 | 17813 | 269 | 1.397959 | 3.76050971 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 150 | 8.14e-43 | NR | KAK2564131.1 | 6130 | g17714 | i0 | 78.4 | 32.3866171003717 | 88 | 19 | 98.1 | 0 | 267 | 4 | 42 | 129 | KAK2564131.1 60S ribosomal protein L10 [Acropora cervicornis] | diamond | 8712 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 17359679 | 17359679 | PRJNA797475_P_NODE_11834_length_309_cov_1.932203_g11735_i0 | PRJNA797475 | 11834 | 309 | 1.932203 | 5.97050727 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 162 | 7.509999999999999e-48 | NR | XP_065063129.1 | 499914 | g11735 | i0 | 70.6 | 2.97087378640777 | 102 | 30 | 99 | 0 | 307 | 2 | 126 | 227 | XP_065063129.1 large ribosomal subunit protein uL30-like [Rhopilema esculentum] | diamond | 918 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 17359921 | 17359921 | PRJNA797475_P_NODE_30334_length_241_cov_0.916667_g30235_i0 | PRJNA797475 | 30334 | 241 | 0.916667 | 2.20916747 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 204 | 5.66e-48 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g30235 | i0 | 90.323 | 0.643153526970954 | 155 | 15 | 64 | 0 | 8 | 162 | 17552648 | 17552494 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 155 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26736943 | 26736943 | PRJNA797475_P_NODE_15081_length_283_cov_1.466667_g14982_i0 | PRJNA797475 | 15081 | 283 | 1.466667 | 4.15066761 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 63.2 | 9.25e-10 | NR | XP_057306384.1 | 13093 | g14982 | i0 | 40.8 | 0.752650176678445 | 71 | 42 | 75.3 | 0 | 217 | 5 | 17 | 87 | XP_057306384.1 muscle-specific protein 20-like [Hydractinia symbiolongicarpus] | diamond | 213 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26800648 | 26800648 | PRJNA797475_P_NODE_17521_length_270_cov_2.340102_g17422_i0 | PRJNA797475 | 17521 | 270 | 2.340102 | 6.3182754 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 68.9 | 1.01e-12 | NR | NP_001296690.1 | 6087 | g17422 | i0 | 72.7 | 0.977777777777778 | 44 | 12 | 48.9 | 0 | 135 | 4 | 6 | 49 | NP_001296690.1 60S ribosomal protein L35a-like [Hydra vulgaris] | diamond | 264 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27053984 | 27053984 | PRJNA797475_P_NODE_19702_length_259_cov_1.655914_g19603_i0 | PRJNA797475 | 19702 | 259 | 1.655914 | 4.28881726 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 119 | 8.859999999999999e-32 | NR | KAJ7384493.1 | 174260 | g19603 | i0 | 67.1 | 2.95366795366795 | 85 | 28 | 98.5 | 0 | 255 | 1 | 3 | 87 | KAJ7384493.1 60S ribosomal protein L17 [Desmophyllum pertusum] | diamond | 765 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 27211750 | 27211750 | PRJNA797475_P_NODE_28722_length_243_cov_0.905882_g28623_i0 | PRJNA797475 | 28722 | 243 | 0.905882 | 2.20129326 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 42.7 | 0.0346 | NR | XP_066911680.1 | 252671 | g28623 | i0 | 50 | 2.03703703703704 | 42 | 21 | 51.9 | 0 | 129 | 4 | 100 | 141 | XP_066911680.1 squidulin-like isoform X2 [Clytia hemisphaerica] | diamond | 495 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27695101 | 27695101 | PRJNA797475_P_NODE_3524_length_525_cov_1.314159_g3426_i0 | PRJNA797475 | 3524 | 525 | 1.314159 | 6.89933475 | root | 1 | Root_unresolved | Root_unresolved | 116 | 3.5100000000000004e-27 | NR | XP_066918380.1 | 252671 | g3426 | i0 | 52.7 | 3.01142857142857 | 110 | 49 | 62.9 | 1 | 521 | 192 | 3 | 109 | XP_066918380.1 probable phosphoglycerate kinase [Clytia hemisphaerica] | diamond | 1581 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28569731 | 28569731 | PRJNA797475_P_NODE_26767_length_245_cov_0.895349_g26668_i0 | PRJNA797475 | 26767 | 245 | 0.895349 | 2.19360505 | Tetracapsuloides bryosalmonae | 271932 | Cnidaria | other_Eukaryota | 77 | 1.68e-15 | NR | QKY88666.1 | 271932 | g26668 | i0 | 56.7 | 0.73469387755102 | 60 | 26 | 73.5 | 0 | 181 | 2 | 8 | 67 | QKY88666.1 ribosomal protein L-12 [Tetracapsuloides bryosalmonae] | diamond | 180 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Malacovalvulida | Saccosporidae | Tetracapsuloides | Tetracapsuloides bryosalmonae | |
| 30370301 | 30370301 | PRJNA797475_P_NODE_16932_length_273_cov_2.115000_g16833_i0 | PRJNA797475 | 16932 | 273 | 2.115 | 5.77395 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 87 | 1.71e-19 | NR | KAK2556285.1 | 6130 | g16833 | i0 | 59.7 | 1.54945054945055 | 72 | 29 | 79.1 | 0 | 17 | 232 | 25 | 96 | KAK2556285.1 60S acidic ribosomal protein P2 [Acropora cervicornis] | diamond | 423 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30694862 | 30694862 | PRJNA797475_P_NODE_22093_length_250_cov_1.740113_g21994_i0 | PRJNA797475 | 22093 | 250 | 1.740113 | 4.3502825 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 103 | 7.509999999999999e-24 | NR | XP_065656638.1 | 6087 | g21994 | i0 | 62.7 | 3.984 | 83 | 30 | 99.6 | 1 | 249 | 1 | 276 | 357 | XP_065656638.1 obg-like ATPase 1 isoform X2 [Hydra vulgaris] | diamond | 996 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30938728 | 30938728 | PRJNA797475_P_NODE_15254_length_282_cov_1.473684_g15155_i0 | PRJNA797475 | 15254 | 282 | 1.473684 | 4.15578888 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 122 | 8.12e-30 | NR | XP_028404739.1 | 151771 | g15155 | i0 | 60.2 | 2.98936170212766 | 93 | 37 | 98.9 | 0 | 280 | 2 | 703 | 795 | XP_028404739.1 lysosomal alpha-glucosidase-like [Dendronephthya gigantea] | diamond | 843 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31136956 | 31136956 | PRJNA797475_P_NODE_13055_length_296_cov_2.336323_g12956_i0 | PRJNA797475 | 13055 | 296 | 2.336323 | 6.91551608 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 74.3 | 6e-14 | NR | KAF1741123.1 | 59785 | g12956 | i0 | 63.8 | 3.59797297297297 | 58 | 21 | 58.8 | 0 | 296 | 123 | 56 | 113 | KAF1741123.1 hypothetical protein MXB_1517 [Myxobolus squamalis] | diamond | 1065 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 31286075 | 31286075 | PRJNA797475_P_NODE_11495_length_313_cov_1.116667_g11396_i0 | PRJNA797475 | 11495 | 313 | 1.116667 | 3.49516771 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 80.9 | 2.22e-15 | NR | XP_031564934.1 | 6105 | g11396 | i0 | 43.2 | 1.84025559105431 | 95 | 53 | 91.1 | 1 | 297 | 13 | 273 | 366 | XP_031564934.1 gelsolin-like protein 1 [Actinia tenebrosa] | diamond | 576 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32718254 | 32718254 | PRJNA797475_P_NODE_26540_length_245_cov_0.895349_g26441_i0 | PRJNA797475 | 26540 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 110 | 7.490000000000001e-26 | NR | XP_031562421.1 | 6105 | g26441 | i0 | 60.3 | 2.79183673469388 | 78 | 31 | 95.5 | 0 | 1 | 234 | 215 | 292 | XP_031562421.1 ergothioneine biosynthesis protein 1-like isoform X2 [Actinia tenebrosa] | diamond | 684 | 111 | 0.990990990990991 | 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);;