contig_metadata
18 rows where bioproject = "PRJNA550047", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6896394 | 6896394 | PRJNA550047_P_NODE_68226_length_345_cov_12.735294_g66266_i0 | PRJNA550047 | 68226 | 345 | 12.735294 | 43.9367643 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g66266 | i0 | 94.286 | 0.101449275362319 | 35 | 1 | 10 | 1 | 31 | 65 | 16590595 | 16590628 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11324933 | 11324933 | PRJNA550047_P_NODE_502009_length_230_cov_2.273885_g500036_i0 | PRJNA550047 | 502009 | 230 | 2.273885 | 5.2299355 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 86.1 | 2.02e-12 | NTclustered | gi|1573349586|gb|MK519645.1| | 6118 | g500036 | i0 | 88.571 | 31.5 | 70 | 8 | 30 | 0 | 64 | 133 | 421 | 352 | Entacmaea quadricolor voucher E_quadricolor_TGEQ9 large subunit ribosomal RNA gene, partial sequence | blastn | 7245 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Entacmaea | Entacmaea quadricolor | |
| 14542479 | 14542479 | PRJNA550047_P_NODE_203552_length_337_cov_2.837121_g201590_i0 | PRJNA550047 | 203552 | 337 | 2.837121 | 9.56109777 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2744838618|ref|XM_065787177.1| | 6087 | g201590 | i0 | 100 | 0.249258160237389 | 28 | 0 | 8 | 0 | 131 | 158 | 1302 | 1275 | PREDICTED: Hydra vulgaris uncharacterized LOC136074994 (LOC136074994), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15815861 | 15815861 | PRJNA550047_P_NODE_159693_length_345_cov_4.091912_g157733_i0 | PRJNA550047 | 159693 | 345 | 4.091912 | 14.1170964 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g157733 | i0 | 96.97 | 0.257971014492754 | 33 | 1 | 10 | 0 | 310 | 342 | 4577865 | 4577833 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19639828 | 19639828 | PRJNA550047_P_NODE_201376_length_342_cov_3.877323_g199415_i0 | PRJNA550047 | 201376 | 342 | 3.877323 | 13.26044466 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1691426760|gb|MK253652.1| | 45351 | g199415 | i0 | 100 | 0.409356725146199 | 28 | 0 | 8 | 0 | 121 | 148 | 12945 | 12918 | Nematostella vectensis cadherin 3 mRNA, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 23467260 | 23467260 | PRJNA550047_P_NODE_317359_length_295_cov_3.918919_g315390_i0 | PRJNA550047 | 317359 | 295 | 3.918919 | 11.56081105 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 512 | 1.04e-140 | NTclustered | gi|2744886754|ref|XM_065809437.1| | 6087 | g315390 | i0 | 97.966 | 14.7830508474576 | 295 | 6 | 100 | 0 | 1 | 295 | 46 | 340 | PREDICTED: Hydra vulgaris uncharacterized LOC136086936 (LOC136086936), mRNA | blastn | 4361 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 23471038 | 23471038 | PRJNA550047_P_NODE_74279_length_345_cov_11.602941_g72319_i0 | PRJNA550047 | 74279 | 345 | 11.602941 | 40.03014645 | Umbellula sp. 2 RH-2019 | 2598118 | Cnidaria | other_Eukaryota | 196 | 1.43e-45 | NTclustered | gi|2160785911|gb|OL741705.1| | 2598118 | g72319 | i0 | 91.034 | 46.3159420289855 | 145 | 13 | 42 | 0 | 197 | 341 | 4944 | 4800 | Umbellula sp. NMS.Z.2019.25.13 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15979 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Umbellulidae | Umbellula | Umbellula sp. 2 RH-2019 | |
| 24745059 | 24745059 | PRJNA550047_P_NODE_94160_length_345_cov_9.007353_g92200_i0 | PRJNA550047 | 94160 | 345 | 9.007353 | 31.07536785 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 89.8 | 2.49e-13 | NTclustered | gi|2519013169|ref|XM_057457998.1| | 13093 | g92200 | i0 | 89.855 | 4.0463768115942 | 69 | 7 | 20 | 0 | 277 | 345 | 301 | 369 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C (LOC130655264), mRNA | blastn | 1396 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26712726 | 26712726 | PRJNA550047_P_NODE_481541_length_236_cov_17.294479_g479568_i0 | PRJNA550047 | 481541 | 236 | 17.294479 | 40.81497044 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 72 | 1.63e-12 | NR | CAB4044065.1 | 317549 | g479568 | i0 | 44.6 | 1.91949152542373 | 74 | 41 | 94.1 | 0 | 222 | 1 | 122 | 195 | CAB4044065.1 Transposon Ty3-G Gag-Pol poly [Paramuricea clavata] | diamond | 453 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27583476 | 27583476 | PRJNA550047_P_NODE_334084_length_291_cov_5.619266_g332114_i0 | PRJNA550047 | 334084 | 291 | 5.619266 | 16.35206406 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 49.3 | 2.1e-4 | NR | PFX22390.1 | 50429 | g332114 | i0 | 29.8 | 0.969072164948454 | 94 | 58 | 88.7 | 2 | 258 | 1 | 78 | 171 | PFX22390.1 Tigger transposable element-derived protein 6 [Stylophora pistillata] | diamond | 282 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28467880 | 28467880 | PRJNA550047_P_NODE_495166_length_232_cov_6.257862_g493193_i0 | PRJNA550047 | 495166 | 232 | 6.257862 | 14.51823984 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 62.4 | 1.3e-10 | NR | CAB4018876.1 | 317549 | g493193 | i0 | 43.8 | 0.943965517241379 | 73 | 39 | 93.1 | 2 | 15 | 230 | 9 | 80 | CAB4018876.1 Sel1 repeat-containing 1A [Paramuricea clavata] | diamond | 219 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28909299 | 28909299 | PRJNA550047_P_NODE_147548_length_345_cov_4.871324_g145588_i0 | PRJNA550047 | 147548 | 345 | 4.871324 | 16.8060678 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 47.8 | 0.00203 | NR | XP_029186312.2 | 45264 | g145588 | i0 | 49 | 0.426086956521739 | 49 | 25 | 42.6 | 0 | 3 | 149 | 87 | 135 | XP_029186312.2 gamma-tubulin complex component 4-like [Acropora millepora] | diamond | 147 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29036097 | 29036097 | PRJNA550047_P_NODE_161388_length_345_cov_3.981618_g159428_i0 | PRJNA550047 | 161388 | 345 | 3.981618 | 13.7365821 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 77.8 | 3.86e-14 | NR | XP_067026538.1 | 159855 | g159428 | i0 | 67.4 | 0.4 | 46 | 15 | 40 | 0 | 334 | 197 | 208 | 253 | XP_067026538.1 uncharacterized protein [Acropora muricata] | diamond | 138 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 32052668 | 32052668 | PRJNA550047_P_NODE_402938_length_264_cov_3.094241_g400966_i0 | PRJNA550047 | 402938 | 264 | 3.094241 | 8.16879624 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 48.5 | 4.58e-4 | NR | RMX46056.1 | 46731 | g400966 | i0 | 48.8 | 2.86363636363636 | 43 | 22 | 48.9 | 0 | 8 | 136 | 2519 | 2561 | RMX46056.1 hypothetical protein pdam_00002040 [Pocillopora damicornis] | diamond | 756 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32481208 | 32481208 | PRJNA550047_P_NODE_71839_length_345_cov_12.033088_g69879_i0 | PRJNA550047 | 71839 | 345 | 12.033088 | 41.5141536 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 42 | 0.0375 | NR | CAB3987432.1 | 317549 | g69879 | i0 | 45.2 | 0.365217391304348 | 42 | 23 | 36.5 | 0 | 344 | 219 | 7 | 48 | CAB3987432.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32607313 | 32607313 | PRJNA550047_P_NODE_50160_length_345_cov_22.566176_g48200_i0 | PRJNA550047 | 50160 | 345 | 22.566176 | 77.8533072 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 51.2 | 1.33e-4 | NR | XP_065056493.1 | 499914 | g48200 | i0 | 24.2 | 1.89565217391304 | 120 | 76 | 91.3 | 1 | 342 | 28 | 540 | 659 | XP_065056493.1 importin-5-like [Rhopilema esculentum] | diamond | 654 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 32764631 | 32764631 | PRJNA550047_P_NODE_332460_length_291_cov_12.972477_g330490_i0 | PRJNA550047 | 332460 | 291 | 12.972477 | 37.74990807 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 43.9 | 0.0262 | NR | XP_057310690.1 | 13093 | g330490 | i0 | 40.5 | 0.43298969072165 | 42 | 25 | 43.3 | 0 | 131 | 6 | 1098 | 1139 | XP_057310690.1 uncharacterized protein LOC130648651 [Hydractinia symbiolongicarpus] | diamond | 126 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32890448 | 32890448 | PRJNA550047_P_NODE_244440_length_300_cov_12.568282_g242471_i0 | PRJNA550047 | 244440 | 300 | 12.568282 | 37.704846 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 43.9 | 0.0282 | NR | KAK3707093.1 | 3060491 | g242471 | i0 | 46.3 | 0.54 | 54 | 23 | 49 | 2 | 296 | 150 | 67 | 119 | KAK3707093.1 hypothetical protein QZH41_004166 [Actinostola sp. cb2023] | diamond | 162 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;