RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJDB12578" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12578 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
1472 1472 PRJDB12578_S_NODE_129881_length_227_cov_1.151685_g106823_i0 PRJDB12578 129881 227 1.151685 2.61432495 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.02   NTclustered gi|2918369539|emb|OZ237721.1| 317547 g106823 i0 100 0.123348017621145 28 0 12 0 177 204 6849244 6849271 Eunicella cavolini genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
2256031 2256031 PRJDB12578_S_NODE_170142_length_185_cov_1.529412_g147084_i0 PRJDB12578 170142 185 1.529412 2.8294122 Opisthokonta 33154 Cnidaria other_Eukaryota 58.4 3.4e-4   NTclustered gi|66864859|gb|AY920799.1| 6100 g147084 i0 100 16.3405405405405 31 0 17 0 7 37 1711 1741 Aequorea victoria large subunit 28S ribosomal RNA gene, partial sequence blastn 3023 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Aequoreidae Aequorea Aequorea victoria
6381894 6381894 PRJDB12578_S_NODE_186446_length_173_cov_1.669355_g163388_i0 PRJDB12578 186446 173 1.669355 2.88798415 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 3.12e-4   NTclustered gi|2917940696|emb|OZ237557.1| 6108 g163388 i0 100 20.9248554913295 31 0 18 0 130 160 11797820 11797790 Anemonia sulcata genome assembly, chromosome: 3 blastn 3620 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
7660217 7660217 PRJDB12578_S_NODE_85827_length_354_cov_2.275410_g62769_i0 PRJDB12578 85827 354 2.27541 8.0549514 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.003   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g62769 i0 100 0.248587570621469 30 0 8 0 154 183 11041578 11041549 Anemonia sulcata genome assembly, chromosome: 9 blastn 88 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
8929334 8929334 PRJDB12578_S_NODE_152588_length_200_cov_3.562914_g129530_i0 PRJDB12578 152588 200 3.562914 7.125828 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.017   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g129530 i0 96.774 0.155 31 1 16 0 55 85 12795866 12795896 Anemonia sulcata genome assembly, chromosome: 8 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
11478308 11478308 PRJDB12578_S_NODE_101810_length_286_cov_1.312236_g78752_i0 PRJDB12578 101810 286 1.312236 3.75299496 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.026   NTclustered gi|2918369555|emb|OZ237727.1| 317547 g78752 i0 100 0.0979020979020979 28 0 10 0 33 60 16644282 16644309 Eunicella cavolini genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
12459896 12459896 PRJDB12578_S_NODE_137710_length_216_cov_2.886228_g114652_i0 PRJDB12578 137710 216 2.886228 6.23425248 root 1 Root_unresolved Root_unresolved 56.5 0.001   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g114652 i0 100 5.11111111111111 30 0 14 0 131 160 12646963 12646992 Anemonia sulcata genome assembly, chromosome: 14 blastn 1104 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
12761365 12761365 PRJDB12578_S_NODE_83451_length_368_cov_4.084639_g60393_i0 PRJDB12578 83451 368 4.084639 15.03147152 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 7.51e-4   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g60393 i0 100 0.258152173913043 31 0 8 0 46 76 6273230 6273260 Anemonia sulcata genome assembly, chromosome: 1 blastn 95 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
14029287 14029287 PRJDB12578_S_NODE_123632_length_237_cov_1.079787_g100574_i0 PRJDB12578 123632 237 1.079787 2.55909519 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.021   NTclustered gi|2917940731|emb|OZ237564.1| 6108 g100574 i0 100 0.118143459915612 28 0 12 0 33 60 7279601 7279574 Anemonia sulcata genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16283506 16283506 PRJDB12578_S_NODE_165093_length_189_cov_1.964286_g142035_i0 PRJDB12578 165093 189 1.964286 3.71250054 Metazoa 33208 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g142035 i0 100 1.8042328042328 29 0 15 0 1 29 9109291 9109319 Anemonia sulcata genome assembly, chromosome: 1 blastn 341 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16580032 16580032 PRJDB12578_S_NODE_176814_length_180_cov_1.564885_g153756_i0 PRJDB12578 176814 180 1.564885 2.816793 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.015   NTclustered gi|2917940740|emb|OZ237567.1| 6108 g153756 i0 100 0.155555555555556 28 0 16 0 81 108 1014968 1014941 Anemonia sulcata genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
17860059 17860059 PRJDB12578_S_NODE_92855_length_318_cov_2.494424_g69797_i0 PRJDB12578 92855 318 2.494424 7.93226832 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.008   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g69797 i0 96.875 0.188679245283019 32 1 10 0 253 284 4396998 4396967 Anemonia sulcata genome assembly, chromosome: 14 blastn 60 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
18832702 18832702 PRJDB12578_S_NODE_87375_length_345_cov_2.317568_g64317_i0 PRJDB12578 87375 345 2.317568 7.9956096 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.003   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g64317 i0 90.698 5.91304347826087 43 3 12 1 228 269 13188828 13188870 Anemonia sulcata genome assembly, chromosome: 6 blastn 2040 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
20403138 20403138 PRJDB12578_S_NODE_158157_length_195_cov_2.102740_g135099_i0 PRJDB12578 158157 195 2.10274 4.100343 Hydra vulgaris 6087 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2744857891|ref|XM_065796011.1| 6087 g135099 i0 92.308 0.2 39 1 20 2 96 134 3129 3165 PREDICTED: Hydra vulgaris uncharacterized LOC136079738 (LOC136079738), mRNA blastn 39 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
21681017 21681017 PRJDB12578_S_NODE_211118_length_163_cov_0.903509_g188060_i0 PRJDB12578 211118 163 0.903509 1.47271967 Acropora digitifera 70779 Cnidaria other_Eukaryota 63.9 6.28e-6   NTclustered gi|1005436258|ref|XM_015900142.1| 70779 g188060 i0 95 0.650306748466258 40 2 25 0 9 48 1027 988 PREDICTED: Acropora digitifera DDB1- and CUL4-associated factor 8-like (LOC107335156), mRNA blastn 106 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
22956319 22956319 PRJDB12578_S_NODE_209299_length_163_cov_2.052632_g186241_i0 PRJDB12578 209299 163 2.052632 3.34579016 Anemonia sulcata 6108 Cnidaria other_Eukaryota 62.1 2.26e-5   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g186241 i0 100 2.50306748466258 33 0 21 0 94 126 972804 972836 Anemonia sulcata genome assembly, chromosome: 1 blastn 408 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
22960287 22960287 PRJDB12578_S_NODE_95899_length_306_cov_2.007782_g72841_i0 PRJDB12578 95899 306 2.007782 6.14381292 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 52.8 0.029   NTclustered gi|1778036790|ref|XM_031699939.1| 6105 g72841 i0 100 0.0915032679738562 28 0 9 0 212 239 2088 2115 PREDICTED: Actinia tenebrosa ragulator complex protein LAMTOR1-like (LOC116292594), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;