contig_metadata
11 rows where bioproject = "PRJNA929952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909160 | 909160 | PRJNA929952_P_NODE_12461_length_309_cov_2.875000_g11168_i0 | PRJNA929952 | 12461 | 309 | 2.875 | 8.88375 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.72e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g11168 | i0 | 100 | 2.15533980582524 | 32 | 0 | 10 | 0 | 214 | 245 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 3806818 | 3806818 | PRJNA929952_P_NODE_12403_length_310_cov_5.544484_g11110_i0 | PRJNA929952 | 12403 | 310 | 5.544484 | 17.1879004 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g11110 | i0 | 100 | 0.603225806451613 | 28 | 0 | 9 | 0 | 221 | 248 | 1426158 | 1426131 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 187 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8562103 | 8562103 | PRJNA929952_P_NODE_23507_length_163_cov_2.141791_g22213_i0 | PRJNA929952 | 23507 | 163 | 2.141791 | 3.49111933 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 102 | 1.33e-17 | NTclustered | gi|2729095082|ref|XM_065210376.1| | 499914 | g22213 | i0 | 81.538 | 0.797546012269939 | 130 | 18 | 78 | 5 | 37 | 163 | 557 | 431 | PREDICTED: Rhopilema esculentum large ribosomal subunit protein uL16-like (LOC135692277), mRNA | blastn | 130 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 8562117 | 8562117 | PRJNA929952_P_NODE_9427_length_383_cov_3.655367_g8152_i0 | PRJNA929952 | 9427 | 383 | 3.655367 | 14.00005561 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 71.3 | 1.01e-7 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g8152 | i0 | 97.561 | 0.211488250652742 | 41 | 1 | 11 | 0 | 343 | 383 | 380 | 420 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 81 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 16212098 | 16212098 | PRJNA929952_P_NODE_15853_length_256_cov_31.167401_g14559_i0 | PRJNA929952 | 15853 | 256 | 31.167401 | 79.78854656 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 76.8 | 1.38e-9 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g14559 | i0 | 92.453 | 26.8046875 | 53 | 4 | 21 | 0 | 16 | 68 | 3608 | 3556 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 6862 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 18760777 | 18760777 | PRJNA929952_P_NODE_20295_length_205_cov_9.897727_g19001_i0 | PRJNA929952 | 20295 | 205 | 9.897727 | 20.29034035 | Zschokkella sp. M0378 | 650985 | Cnidaria | other_Eukaryota | 58.4 | 3.85e-4 | NTclustered | gi|241911775|gb|FJ417081.1| | 650985 | g19001 | i0 | 94.595 | 0.180487804878049 | 37 | 2 | 18 | 0 | 8 | 44 | 280 | 244 | Zschokkella sp. M0378 28S large subunit ribosomal RNA gene, partial sequence | blastn | 37 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Zschokkella | Zschokkella sp. M0378 | |
| 19106224 | 19106224 | PRJNA929952_P_NODE_22555_length_173_cov_4.763889_g21261_i0 | PRJNA929952 | 22555 | 173 | 4.763889 | 8.24152797 | Anthoathecata | 406427 | Cnidaria | other_Eukaryota | 89.8 | 1.11e-13 | NTclustered | gi|167858114|gb|EU305533.1| | 89461 | g21261 | i0 | 88.889 | 38.878612716763 | 72 | 8 | 42 | 0 | 83 | 154 | 2589 | 2518 | Solanderia secunda large subunit 28S ribosomal RNA gene, partial sequence | blastn | 6726 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Solanderia | Solanderia secunda | |
| 19106227 | 19106227 | PRJNA929952_P_NODE_24015_length_157_cov_6.242188_g22721_i0 | PRJNA929952 | 24015 | 157 | 6.242188 | 9.80023516 | Plumulariidae | 308572 | Cnidaria | other_Eukaryota | 87.9 | 3.55e-13 | NTclustered | gi|256674467|gb|FJ550371.1| | 308574 | g22721 | i0 | 100 | 31.1019108280255 | 47 | 0 | 30 | 0 | 111 | 157 | 1364 | 1410 | Plumularia setacea 28S ribosomal RNA gene, partial sequence | blastn | 4883 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Plumulariidae | Plumularia | Plumularia setacea | |
| 21311225 | 21311225 | PRJNA929952_P_NODE_12537_length_307_cov_17.190647_g11244_i0 | PRJNA929952 | 12537 | 307 | 17.190647 | 52.77528629 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2518956760|ref|XR_008978244.1| | 13093 | g11244 | i0 | 100 | 9.5700325732899 | 29 | 0 | 9 | 0 | 29 | 57 | 2648 | 2676 | PREDICTED: Hydractinia symbiolongicarpus large subunit ribosomal RNA (LOC130617162), rRNA | blastn | 2938 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 22932622 | 22932622 | PRJNA929952_P_NODE_1458_length_959_cov_45.056989_g1045_i0 | PRJNA929952 | 1458 | 959 | 45.056989 | 432.09652451 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 111 | 1.58e-19 | NTclustered | gi|166407165|gb|EU272581.1| | 264068 | g1045 | i0 | 94.444 | 2.61730969760167 | 72 | 4 | 8 | 0 | 772 | 843 | 1513 | 1442 | Pennaria disticha voucher AGC68 28S large subunit ribosomal RNA gene, partial sequence | blastn | 2510 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Pennariidae | Pennaria | Pennaria disticha | |
| 24206391 | 24206391 | PRJNA929952_P_NODE_20119_length_208_cov_81.597765_g18825_i0 | PRJNA929952 | 20119 | 208 | 81.597765 | 169.7233512 | Leptothecata | 500008 | Cnidaria | other_Eukaryota | 115 | 2.29e-21 | NTclustered | gi|66864860|gb|AY920800.1| | 47071 | g18825 | i0 | 84.483 | 3.34615384615385 | 116 | 18 | 56 | 0 | 1 | 116 | 2574 | 2689 | Blackfordia virginica large subunit 28S ribosomal RNA gene, partial sequence | blastn | 696 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Blackfordiidae | Blackfordia | Blackfordia virginica |
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);;