contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2167964 | 2167964 | PRJNA911178_P_NODE_253322_length_248_cov_4.365714_g250848_i0 | PRJNA911178 | 253322 | 248 | 4.365714 | 10.82697072 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 130 | 1.01e-25 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g250848 | i0 | 87.069 | 48.5483870967742 | 116 | 13 | 47 | 2 | 133 | 248 | 233 | 346 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12040 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 4721135 | 4721135 | PRJNA911178_P_NODE_258504_length_247_cov_2.591954_g256030_i0 | PRJNA911178 | 258504 | 247 | 2.591954 | 6.40212638 | Craspedacusta sowerbii | 128124 | Cnidaria | other_Eukaryota | 412 | 8.89e-111 | NTclustered | gi|213495460|gb|FJ423621.1| | 128124 | g256030 | i0 | 98.298 | 97.1943319838057 | 235 | 4 | 95 | 0 | 4 | 238 | 914 | 1148 | Craspedacusta sowerbyi isolate Cs0Yyy10 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 24007 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Olindiidae | Craspedacusta | Craspedacusta sowerbii | |
| 4721552 | 4721552 | PRJNA911178_P_NODE_306684_length_217_cov_41.916667_g304210_i0 | PRJNA911178 | 306684 | 217 | 41.916667 | 90.95916739 | Ralpharia gorgoniae | 498587 | Cnidaria | other_Eukaryota | 150 | 6.609999999999999e-32 | NTclustered | gi|166407174|gb|EU272590.1| | 498587 | g304210 | i0 | 87.879 | 60.1612903225806 | 132 | 10 | 60 | 6 | 82 | 212 | 2638 | 2512 | Ralpharia gorgoniae voucher KUNHM 2778 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13055 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Tubulariidae | Ralpharia | Ralpharia gorgoniae | |
| 9820919 | 9820919 | PRJNA911178_P_NODE_309328_length_196_cov_7.869919_g306853_i0 | PRJNA911178 | 309328 | 196 | 7.869919 | 15.42504124 | Acropora formosa | 126732 | Cnidaria | other_Eukaryota | 87.9 | 4.65e-13 | NTclustered | gi|692518457|gb|KJ648506.1| | 126732 | g306853 | i0 | 86.42 | 41.7040816326531 | 81 | 9 | 41 | 2 | 11 | 90 | 387 | 466 | Acropora formosa isolate HN14 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 8174 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora formosa | |
| 14003650 | 14003650 | PRJNA911178_P_NODE_143351_length_310_cov_8.810127_g140878_i0 | PRJNA911178 | 143351 | 310 | 8.810127 | 27.3113937 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.1 | 2.86e-12 | NTclustered | gi|2545927690|gb|OR270023.1| | 35589 | g140878 | i0 | 82.653 | 29.2774193548387 | 98 | 15 | 32 | 2 | 213 | 310 | 189 | 284 | Myxobolus sp. voucher Myxobolus sp large subunit ribosomal RNA gene, partial sequence | blastn | 9076 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. | |
| 16196368 | 16196368 | PRJNA911178_P_NODE_80513_length_396_cov_1.405573_g78046_i0 | PRJNA911178 | 80513 | 396 | 1.405573 | 5.56606908 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 82.4 | 4.83e-11 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g78046 | i0 | 87.5 | 0.285353535353535 | 72 | 8 | 18 | 1 | 325 | 396 | 380 | 450 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 113 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 20019746 | 20019746 | PRJNA911178_P_NODE_40496_length_539_cov_13.096567_g38088_i0 | PRJNA911178 | 40496 | 539 | 13.096567 | 70.59049613 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|1176089270|ref|XM_020759344.1| | 48498 | g38088 | i0 | 94.595 | 0.122448979591837 | 37 | 0 | 6 | 2 | 330 | 364 | 2162 | 2126 | PREDICTED: Orbicella faveolata uncharacterized LOC110053151 (LOC110053151), mRNA | blastn | 66 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 21295174 | 21295174 | PRJNA911178_P_NODE_55357_length_467_cov_4.124365_g52920_i0 | PRJNA911178 | 55357 | 467 | 4.124365 | 19.26078455 | Calycella syringa | 314529 | Cnidaria | other_Eukaryota | 122 | 3.4099999999999995e-23 | NTclustered | gi|256674468|gb|FJ550372.1| | 314529 | g52920 | i0 | 86.087 | 21.5546038543897 | 115 | 14 | 24 | 2 | 130 | 243 | 1567 | 1454 | Calycella syringa 28S ribosomal RNA gene, partial sequence | blastn | 10066 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Calycella | Calycella syringa | |
| 22569749 | 22569749 | PRJNA911178_P_NODE_269778_length_245_cov_1.569767_g267304_i0 | PRJNA911178 | 269778 | 245 | 1.569767 | 3.84592915 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 99 | 2.8e-16 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g267304 | i0 | 91.549 | 41.0285714285714 | 71 | 6 | 29 | 0 | 25 | 95 | 9326394 | 9326464 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 10052 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22927954 | 22927954 | PRJNA911178_P_NODE_277058_length_244_cov_0.900585_g274584_i0 | PRJNA911178 | 277058 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1778028076|ref|XM_031695381.1| | 6105 | g274584 | i0 | 100 | 0.745901639344262 | 30 | 0 | 12 | 0 | 55 | 84 | 6550 | 6579 | PREDICTED: Actinia tenebrosa uncharacterized LOC116288579 (LOC116288579), mRNA | blastn | 182 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 25117849 | 25117849 | PRJNA911178_P_NODE_164000_length_293_cov_1.377273_g161527_i0 | PRJNA911178 | 164000 | 293 | 1.377273 | 4.03540989 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 220 | 7.04e-53 | NTclustered | gi|2782890104|ref|XM_067066014.1| | 252671 | g161527 | i0 | 80.623 | 14.4982935153584 | 289 | 52 | 98 | 4 | 6 | 292 | 865 | 1151 | PREDICTED: Clytia hemisphaerica transitional endoplasmic reticulum ATPase-like (LOC136809477), mRNA | blastn | 4248 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;