contig_metadata
14 rows where bioproject = "PRJNA635874", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2429575 | 2429575 | PRJNA635874_P_NODE_29582_length_304_cov_1.363636_g29435_i0 | PRJNA635874 | 29582 | 304 | 1.363636 | 4.14545344 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g29435 | i0 | 100 | 7.37828947368421 | 29 | 0 | 10 | 0 | 137 | 165 | 10739329 | 10739301 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 2243 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 4435970 | 4435970 | PRJNA635874_P_NODE_71064_length_242_cov_0.911243_g70917_i0 | PRJNA635874 | 71064 | 242 | 0.911243 | 2.20520806 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 63.9 | 1.01e-5 | NTclustered | gi|1778028274|ref|XR_004196220.1| | 6105 | g70917 | i0 | 100 | 0.140495867768595 | 34 | 0 | 14 | 0 | 153 | 186 | 1230 | 1263 | PREDICTED: Actinia tenebrosa uncharacterized LOC116288665 (LOC116288665), ncRNA | blastn | 34 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 5711887 | 5711887 | PRJNA635874_P_NODE_69185_length_242_cov_0.911243_g69038_i0 | PRJNA635874 | 69185 | 242 | 0.911243 | 2.20520806 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2744876968|ref|XR_010640656.1| | 6087 | g69038 | i0 | 96.774 | 0.256198347107438 | 31 | 1 | 13 | 0 | 85 | 115 | 774 | 744 | PREDICTED: Hydra vulgaris uncharacterized LOC136084583 (LOC136084583), transcript variant X2, ncRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15910900 | 15910900 | PRJNA635874_P_NODE_61913_length_245_cov_0.895349_g61766_i0 | PRJNA635874 | 61913 | 245 | 0.895349 | 2.19360505 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g61766 | i0 | 100 | 2.08571428571429 | 28 | 0 | 11 | 0 | 115 | 142 | 8422598 | 8422571 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 511 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26681870 | 26681870 | PRJNA635874_P_NODE_15321_length_390_cov_1.454259_g15174_i0 | PRJNA635874 | 15321 | 390 | 1.454259 | 5.6716101 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 87.4 | 4.74e-17 | NR | XP_068740037.1 | 246305 | g15174 | i0 | 40.2 | 4.9 | 127 | 63 | 91.5 | 3 | 365 | 9 | 353 | 474 | XP_068740037.1 uncharacterized protein [Montipora capricornis] | diamond | 1911 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 28028637 | 28028637 | PRJNA635874_P_NODE_30465_length_301_cov_0.842105_g30318_i0 | PRJNA635874 | 30465 | 301 | 0.842105 | 2.53473605 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 55.8 | 1.78e-6 | NR | XP_022803557.1 | 50429 | g30318 | i0 | 50.8 | 3.03986710963455 | 61 | 30 | 60.8 | 0 | 299 | 117 | 440 | 500 | XP_022803557.1 protein DD3-3-like isoform X2 [Stylophora pistillata] | diamond | 915 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28186146 | 28186146 | PRJNA635874_P_NODE_54486_length_248_cov_0.880000_g54339_i0 | PRJNA635874 | 54486 | 248 | 0.88 | 2.1824 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 55.1 | 5.36e-7 | NR | CAB4018365.1 | 317549 | g54339 | i0 | 61 | 0.495967741935484 | 41 | 16 | 49.6 | 0 | 139 | 17 | 126 | 166 | CAB4018365.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 123 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28325092 | 28325092 | PRJNA635874_P_NODE_53546_length_248_cov_0.880000_g53399_i0 | PRJNA635874 | 53546 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00847 | NR | XP_031564363.1 | 6105 | g53399 | i0 | 46.2 | 5.63709677419355 | 39 | 21 | 47.2 | 0 | 131 | 247 | 666 | 704 | XP_031564363.1 next to BRCA1 gene 1 protein-like [Actinia tenebrosa] | diamond | 1398 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28533893 | 28533893 | PRJNA635874_P_NODE_29827_length_303_cov_1.339130_g29680_i0 | PRJNA635874 | 29827 | 303 | 1.33913 | 4.0575639 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 124 | 2.2599999999999996e-31 | NR | XP_058966796.2 | 203993 | g29680 | i0 | 60 | 1.98019801980198 | 100 | 37 | 99 | 2 | 3 | 302 | 276 | 372 | XP_058966796.2 rab GDP dissociation inhibitor beta-like [Pocillopora verrucosa] | diamond | 600 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 28817549 | 28817549 | PRJNA635874_P_NODE_61308_length_245_cov_0.895349_g61161_i0 | PRJNA635874 | 61308 | 245 | 0.895349 | 2.19360505 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 49.7 | 3.84e-5 | NR | CAH3106800.1 | 46732 | g61161 | i0 | 46.2 | 0.477551020408163 | 39 | 21 | 47.8 | 0 | 128 | 244 | 31 | 69 | CAH3106800.1 unnamed protein product [Pocillopora meandrina] | diamond | 117 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 29228583 | 29228583 | PRJNA635874_P_NODE_8109_length_507_cov_1.064516_g7963_i0 | PRJNA635874 | 8109 | 507 | 1.064516 | 5.39709612 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 62 | 3.18e-8 | NR | XP_022805251.1 | 50429 | g7963 | i0 | 50 | 1.75147928994083 | 74 | 34 | 42 | 2 | 502 | 290 | 136 | 209 | XP_022805251.1 glutathione S-transferase 1-like [Stylophora pistillata] | diamond | 888 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31819296 | 31819296 | PRJNA635874_P_NODE_55397_length_248_cov_0.880000_g55250_i0 | PRJNA635874 | 55397 | 248 | 0.88 | 2.1824 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 43.5 | 0.0209 | NR | XP_020621234.1 | 48498 | g55250 | i0 | 64.5 | 0.713709677419355 | 31 | 11 | 37.5 | 0 | 152 | 244 | 19 | 49 | XP_020621234.1 uncharacterized protein LOC110058905 [Orbicella faveolata] | diamond | 177 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32072506 | 32072506 | PRJNA635874_P_NODE_63358_length_245_cov_0.866279_g63211_i0 | PRJNA635874 | 63358 | 245 | 0.866279 | 2.12238355 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 54.7 | 2.23e-6 | NR | XP_046858927.1 | 2897299 | g63211 | i0 | 41.3 | 1.95918367346939 | 80 | 42 | 98 | 2 | 2 | 241 | 232 | 306 | XP_046858927.1 sec14 cytosolic factor-like [Xenia sp. Carnegie-2017] | diamond | 480 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 32275029 | 32275029 | PRJNA635874_P_NODE_3678_length_693_cov_2.462903_g3539_i0 | PRJNA635874 | 3678 | 693 | 2.462903 | 17.06791779 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 212 | 4.51e-66 | NR | XP_029194650.2 | 45264 | g3539 | i0 | 63.9 | 10.9437229437229 | 158 | 56 | 68 | 1 | 20 | 490 | 19 | 176 | XP_029194650.2 40S ribosomal protein S11-like [Acropora millepora] | diamond | 7584 | 214 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora |
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);;