RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1022139 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
4831614 4831614 PRJNA1022139_P_NODE_34584_length_251_cov_0.865169_g34479_i0 PRJNA1022139 34584 251 0.865169 2.17157419 Metazoa 33208 Cnidaria other_Eukaryota 58.4 4.89e-4   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g34479 i0 100 2.1593625498008 31 0 12 0 127 157 3013367 3013337 Anemonia sulcata genome assembly, chromosome: 6 blastn 542 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6539867 6539867 PRJNA1022139_P_NODE_29006_length_270_cov_2.000000_g28901_i0 PRJNA1022139 29006 270 2 5.4 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.025   NTclustered gi|2917940759|emb|OZ237572.1| 6108 g28901 i0 100 0.103703703703704 28 0 10 0 54 81 7069948 7069975 Anemonia sulcata genome assembly, chromosome: 18 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
10364900 10364900 PRJNA1022139_P_NODE_35909_length_249_cov_1.642045_g35804_i0 PRJNA1022139 35909 249 1.642045 4.08869205 Anemonia sulcata 6108 Cnidaria other_Eukaryota 67.6 8.05e-7   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g35804 i0 100 3.59036144578313 36 0 14 0 104 139 2173263 2173228 Anemonia sulcata genome assembly, chromosome: 2 blastn 894 67.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15031313 15031313 PRJNA1022139_P_NODE_34172_length_251_cov_1.601124_g34067_i0 PRJNA1022139 34172 251 1.601124 4.01882124 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g34067 i0 100 1.00398406374502 28 0 11 0 21 48 8469358 8469385 Anemonia sulcata genome assembly, chromosome: 4 blastn 252 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
18013416 18013416 PRJNA1022139_P_NODE_20275_length_310_cov_2.430380_g20170_i0 PRJNA1022139 20275 310 2.43038 7.534178 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 52.8 0.029   NTclustered gi|1778040743|ref|XM_031702008.1| 6105 g20170 i0 100 0.0903225806451613 28 0 9 0 106 133 870 843 PREDICTED: Actinia tenebrosa uncharacterized LOC116294417 (LOC116294417), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
18013575 18013575 PRJNA1022139_P_NODE_40035_length_244_cov_1.666667_g39930_i0 PRJNA1022139 40035 244 1.666667 4.06666748 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g39930 i0 100 0.114754098360656 28 0 11 0 76 103 4382200 4382173 Anemonia sulcata genome assembly, chromosome: 19 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23113834 23113834 PRJNA1022139_P_NODE_14839_length_355_cov_1.503546_g14734_i0 PRJNA1022139 14839 355 1.503546 5.3375883 Anemonia sulcata 6108 Cnidaria other_Eukaryota 159 1.9199999999999999e-34   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g14734 i0 80.374 71.1464788732394 214 38 60 4 139 350 3009544 3009755 Anemonia sulcata genome assembly, chromosome: 14 blastn 25257 159 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23114040 23114040 PRJNA1022139_P_NODE_42179_length_242_cov_0.911243_g42074_i0 PRJNA1022139 42179 242 0.911243 2.20520806 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 76.8 1.29e-9   NTclustered gi|1619644761|ref|XM_021045705.2| 2652724 g42074 i0 89.831 6.05785123966942 59 6 24 0 144 202 520 578 PREDICTED: Exaiptasia diaphana eukaryotic peptide chain release factor GTP-binding subunit ERF3A (LOC110239944), mRNA blastn 1466 76.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
23114113 23114113 PRJNA1022139_P_NODE_9479_length_431_cov_2.544693_g9374_i0 PRJNA1022139 9479 431 2.544693 10.96762683 Eunicella cavolini 317547 Cnidaria other_Eukaryota 207 8.390000000000001e-49   NTclustered gi|2918369552|emb|OZ237724.1| 317547 g9374 i0 82.627 4.60324825986079 236 39 55 2 98 332 198087 197853 Eunicella cavolini genome assembly, chromosome: 8 blastn 1984 207 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini

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