contig_metadata
16 rows where bioproject = "PRJNA917598" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8548570 | 8548570 | PRJNA917598_P_NODE_27067_length_444_cov_1.070081_g26123_i0 | PRJNA917598 | 27067 | 444 | 1.070081 | 4.75115964 | Catablema vesicarium | 1732519 | Cnidaria | other_Eukaryota | 281 | 5.03e-71 | NTclustered | gi|952952498|gb|KT809324.1| | 1732519 | g26123 | i0 | 80.506 | 86.1554054054054 | 395 | 54 | 86 | 20 | 4 | 386 | 6673 | 6290 | Catablema vesicarium mitochondrion, partial genome | blastn | 38253 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Pandeidae | Catablema | Catablema vesicarium | |
| 8550052 | 8550052 | PRJNA917598_P_NODE_86887_length_246_cov_3.092486_g85943_i0 | PRJNA917598 | 86887 | 246 | 3.092486 | 7.60751556 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2114135399|ref|XM_029355121.2| | 45264 | g85943 | i0 | 100 | 0.341463414634146 | 28 | 0 | 11 | 0 | 17 | 44 | 578 | 605 | PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 12374915 | 12374915 | PRJNA917598_P_NODE_32070_length_406_cov_1.624625_g31126_i0 | PRJNA917598 | 32070 | 406 | 1.624625 | 6.5959775 | root | 1 | Root_unresolved | Root_unresolved | 129 | 3.5999999999999997e-33 | NR | AAX09920.1 | 6145 | g31126 | i0 | 60.7 | 10.3965517241379 | 117 | 45 | 86.5 | 1 | 2 | 352 | 171 | 286 | AAX09920.1 heat shock protein Hsp70, partial [Aurelia aurita] | diamond | 4221 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Semaeostomeae | Ulmaridae | Aurelia | Aurelia aurita | |
| 16198813 | 16198813 | PRJNA917598_P_NODE_39393_length_366_cov_1.139932_g38449_i0 | PRJNA917598 | 39393 | 366 | 1.139932 | 4.17215112 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 156 | 2.49e-41 | NR | XP_031551790.1 | 6105 | g38449 | i0 | 56.7 | 9.72131147540984 | 120 | 52 | 98.4 | 0 | 5 | 364 | 254 | 373 | XP_031551790.1 lysosomal alpha-mannosidase-like isoform X2 [Actinia tenebrosa] | diamond | 3558 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 17828616 | 17828616 | PRJNA917598_P_NODE_15894_length_589_cov_1.507752_g14960_i0 | PRJNA917598 | 15894 | 589 | 1.507752 | 8.88065928 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 166 | 3.79e-49 | NR | XP_068702776.1 | 591990 | g14960 | i0 | 65.7 | 11.5670628183362 | 134 | 45 | 68.3 | 1 | 564 | 163 | 1 | 133 | XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa] | diamond | 6813 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 18747590 | 18747590 | PRJNA917598_P_NODE_41195_length_358_cov_0.929825_g40251_i0 | PRJNA917598 | 41195 | 358 | 0.929825 | 3.3287735 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 136 | 1.13e-34 | NR | NP_001296624.1 | 6087 | g40251 | i0 | 57.3 | 12.7625698324022 | 117 | 50 | 98 | 0 | 358 | 8 | 506 | 622 | NP_001296624.1 heat shock 70 kDa protein [Hydra vulgaris] | diamond | 4569 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27845792 | 27845792 | PRJNA917598_P_NODE_67944_length_276_cov_1.512315_g67000_i0 | PRJNA917598 | 67944 | 276 | 1.512315 | 4.1739894 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 50.8 | 8.13e-5 | NR | XP_031557393.1 | 6105 | g67000 | i0 | 37.7 | 1.58695652173913 | 77 | 44 | 83.7 | 1 | 5 | 235 | 1984 | 2056 | XP_031557393.1 uncharacterized protein LOC116294015 [Actinia tenebrosa] | diamond | 438 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29172211 | 29172211 | PRJNA917598_P_NODE_70789_length_270_cov_1.563452_g69845_i0 | PRJNA917598 | 70789 | 270 | 1.563452 | 4.2213204 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 101 | 1.8499999999999998e-23 | NR | XP_065070275.1 | 499914 | g69845 | i0 | 57.7 | 0.866666666666667 | 78 | 33 | 86.7 | 0 | 11 | 244 | 39 | 116 | XP_065070275.1 delta(3,5)-Delta(2,4)-dienoyl-CoA isomerase, mitochondrial-like [Rhopilema esculentum] | diamond | 234 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 29298378 | 29298378 | PRJNA917598_P_NODE_73749_length_264_cov_1.366492_g72805_i0 | PRJNA917598 | 73749 | 264 | 1.366492 | 3.60753888 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 59.3 | 7.22e-8 | NR | CAH3191484.1 | 104178 | g72805 | i0 | 39.2 | 0.897727272727273 | 79 | 48 | 89.8 | 0 | 262 | 26 | 2321 | 2399 | CAH3191484.1 unnamed protein product [Porites evermanni] | diamond | 237 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29487602 | 29487602 | PRJNA917598_P_NODE_72150_length_267_cov_1.917526_g71206_i0 | PRJNA917598 | 72150 | 267 | 1.917526 | 5.11979442 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 47.4 | 9.55e-4 | NR | XP_031555019.1 | 6105 | g71206 | i0 | 35.2 | 2.65168539325843 | 88 | 42 | 82 | 2 | 225 | 7 | 4 | 91 | XP_031555019.1 60S ribosomal protein L6-like [Actinia tenebrosa] | diamond | 708 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29582190 | 29582190 | PRJNA917598_P_NODE_88390_length_246_cov_0.890173_g87446_i0 | PRJNA917598 | 88390 | 246 | 0.890173 | 2.18982558 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 76.3 | 6.09e-14 | NR | XP_044178605.1 | 45264 | g87446 | i0 | 42.5 | 3.90243902439024 | 80 | 46 | 97.6 | 0 | 6 | 245 | 898 | 977 | XP_044178605.1 uncharacterized protein LOC114952318 [Acropora millepora] | diamond | 960 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30758667 | 30758667 | PRJNA917598_P_NODE_51254_length_320_cov_1.093117_g50310_i0 | PRJNA917598 | 51254 | 320 | 1.093117 | 3.4979744 | root | 1 | Root_unresolved | Root_unresolved | 107 | 6.83e-25 | NR | XP_015749807.1 | 70779 | g50310 | i0 | 51.9 | 6.95625 | 106 | 45 | 99.4 | 1 | 3 | 320 | 268 | 367 | XP_015749807.1 PREDICTED: RNA-directed DNA polymerase from mobile element jockey-like [Acropora digitifera] | diamond | 2226 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 31580640 | 31580640 | PRJNA917598_P_NODE_84896_length_248_cov_0.880000_g83952_i0 | PRJNA917598 | 84896 | 248 | 0.88 | 2.1824 | Acropora | 6127 | Cnidaria | other_Eukaryota | 89.7 | 8.2e-21 | NR | KAK2571400.1 | 6130 | g83952 | i0 | 60 | 4.48790322580645 | 70 | 28 | 84.7 | 0 | 2 | 211 | 41 | 110 | KAK2571400.1 Intraflagellar transport protein 122-like protein [Acropora cervicornis] | diamond | 1113 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 32181698 | 32181698 | PRJNA917598_P_NODE_47238_length_334_cov_1.045977_g46294_i0 | PRJNA917598 | 47238 | 334 | 1.045977 | 3.49356318 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 50.1 | 2.83e-4 | NR | XP_031560684.1 | 6105 | g46294 | i0 | 38.1 | 1.67065868263473 | 63 | 36 | 53.9 | 1 | 267 | 88 | 451 | 513 | XP_031560684.1 lipoxygenase homology domain-containing protein 1-like [Actinia tenebrosa] | diamond | 558 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32554327 | 32554327 | PRJNA917598_P_NODE_86439_length_247_cov_0.885057_g85495_i0 | PRJNA917598 | 86439 | 247 | 0.885057 | 2.18609079 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 79.3 | 8.16e-17 | NR | XP_004206070.1 | 6087 | g85495 | i0 | 55.6 | 2.35627530364372 | 72 | 27 | 87.4 | 1 | 32 | 247 | 1 | 67 | XP_004206070.1 large ribosomal subunit protein eL31 [Hydra vulgaris] | diamond | 582 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32687139 | 32687139 | PRJNA917598_P_NODE_53400_length_312_cov_3.096234_g52456_i0 | PRJNA917598 | 53400 | 312 | 3.096234 | 9.66025008 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 136 | 3.1e-37 | NR | XP_028397699.1 | 151771 | g52456 | i0 | 63.5 | 11 | 104 | 38 | 100 | 0 | 312 | 1 | 102 | 205 | XP_028397699.1 40S ribosomal protein S3a-like [Dendronephthya gigantea] | diamond | 3432 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;