contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA453567" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3644390 | 3644390 | PRJNA453567_P_NODE_14943_length_234_cov_1.365482_g14706_i0 | PRJNA453567 | 14943 | 234 | 1.365482 | 3.19522788 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g14706 | i0 | 100 | 2.11111111111111 | 30 | 0 | 13 | 0 | 81 | 110 | 2305939 | 2305968 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 494 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 4268855 | 4268855 | PRJNA453567_P_NODE_16944_length_217_cov_2.127778_g16707_i0 | PRJNA453567 | 16944 | 217 | 2.127778 | 4.61727826 | Anthosactis janmayeni | 856770 | Cnidaria | other_Eukaryota | 106 | 1.45e-18 | NTclustered | gi|636577257|gb|KJ483091.1| | 856770 | g16707 | i0 | 76.606 | 30.1336405529954 | 218 | 36 | 99 | 11 | 2 | 215 | 1295 | 1089 | Anthosactis janmayeni isolate jan 28S large subunit ribosomal RNA gene and external transcribed spacer, partial sequence | blastn | 6539 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Anthosactis | Anthosactis janmayeni | |
| 4921495 | 4921495 | PRJNA453567_P_NODE_10364_length_292_cov_5.811765_g10127_i0 | PRJNA453567 | 10364 | 292 | 5.811765 | 16.9703538 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g10127 | i0 | 100 | 2.68835616438356 | 30 | 0 | 10 | 0 | 143 | 172 | 11275236 | 11275207 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 785 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6819513 | 6819513 | PRJNA453567_P_NODE_23006_length_183_cov_1.609589_g22769_i0 | PRJNA453567 | 23006 | 183 | 1.609589 | 2.94554787 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 202 | 1.46e-47 | NTclustered | gi|2729084447|ref|XM_065204729.1| | 499914 | g22769 | i0 | 88.166 | 25.7431693989071 | 169 | 20 | 92 | 0 | 5 | 173 | 188 | 356 | PREDICTED: Rhopilema esculentum calmodulin (LOC135688040), mRNA | blastn | 4711 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 18293595 | 18293595 | PRJNA453567_P_NODE_8395_length_334_cov_2.101010_g8158_i0 | PRJNA453567 | 8395 | 334 | 2.10101 | 7.0173734 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 60.2 | 1.88e-4 | NTclustered | gi|2257859302|ref|XM_032366284.2| | 45351 | g8158 | i0 | 100 | 0.191616766467066 | 32 | 0 | 10 | 0 | 47 | 78 | 478 | 447 | PREDICTED: Nematostella vectensis inverted formin-2 (LOC116604246), transcript variant X2, mRNA | blastn | 64 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 18944905 | 18944905 | PRJNA453567_P_NODE_4115_length_523_cov_1.370370_g3882_i0 | PRJNA453567 | 4115 | 523 | 1.37037 | 7.1670351 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 62.1 | 8.52e-5 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g3882 | i0 | 100 | 14.5066921606119 | 33 | 0 | 6 | 0 | 137 | 169 | 1530751 | 1530719 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 7587 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 21495216 | 21495216 | PRJNA453567_P_NODE_21037_length_192_cov_1.761290_g20800_i0 | PRJNA453567 | 21037 | 192 | 1.76129 | 3.3816768 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g20800 | i0 | 100 | 8.5625 | 29 | 0 | 15 | 0 | 3 | 31 | 15247990 | 15247962 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 1644 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 21495227 | 21495227 | PRJNA453567_P_NODE_29777_length_160_cov_2.219512_g29540_i0 | PRJNA453567 | 29777 | 160 | 2.219512 | 3.5512192 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 145 | 2.13e-30 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g29540 | i0 | 87.402 | 82.23125 | 127 | 14 | 79 | 2 | 1 | 127 | 357 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 13157 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis |
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);;