RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB1404" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB1404 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
1295288 1295288 PRJEB1404_S_NODE_802_length_298_cov_101.292776_g782_i0 PRJEB1404 802 298 101.292776 301.85247248 Acropora digitifera 70779 Cnidaria other_Eukaryota 65.8 3.56e-6   NTclustered gi|1005425982|ref|XR_001560996.1| 70779 g782 i0 100 12.4731543624161 35 0 12 0 264 298 11 45 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA blastn 3717 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
2261000 2261000 PRJEB1404_S_NODE_3082_length_184_cov_2.147651_g3062_i0 PRJEB1404 3082 184 2.147651 3.95167784 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.001   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g3062 i0 100 1.01630434782609 30 0 16 0 78 107 455653 455682 Anemonia sulcata genome assembly, chromosome: 9 blastn 187 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
8948073 8948073 PRJEB1404_S_NODE_2568_length_200_cov_312.854545_g2548_i0 PRJEB1404 2568 200 312.854545 625.70909 Acropora digitifera 70779 Cnidaria other_Eukaryota 65.8 2.23e-6   NTclustered gi|1005425978|ref|XR_001560989.1| 70779 g2548 i0 93.333 18.51 45 1 23 2 156 200 28 70 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X5, ncRNA blastn 3702 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
12774691 12774691 PRJEB1404_S_NODE_2951_length_187_cov_148.328947_g2931_i0 PRJEB1404 2951 187 148.328947 277.37513089 Acropora digitifera 70779 Cnidaria other_Eukaryota 65.8 2.06e-6   NTclustered gi|1005425982|ref|XR_001560996.1| 70779 g2931 i0 100 19.8770053475936 35 0 19 0 1 35 45 11 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA blastn 3717 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
13739150 13739150 PRJEB1404_S_NODE_2451_length_205_cov_116.011765_g2431_i0 PRJEB1404 2451 205 116.011765 237.82411825 root 1 Root_unresolved Root_unresolved 86.1 1.77e-12   NTclustered gi|1005425974|ref|XR_001560980.1| 70779 g2431 i0 93.22 28.7170731707317 59 3 28 1 1 58 88 30 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X1, ncRNA blastn 5887 86.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
17563566 17563566 PRJEB1404_S_NODE_274_length_395_cov_343.288889_g254_i0 PRJEB1404 274 395 343.288889 1355.99111155 root 1 Root_unresolved Root_unresolved 73.1 2.9e-8   NTclustered gi|1005425977|ref|XR_001560985.1| 70779 g254 i0 100 10.5949367088608 39 0 10 0 357 395 11 49 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA blastn 4185 73.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
20421769 20421769 PRJEB1404_S_NODE_1177_length_266_cov_418.891775_g1157_i0 PRJEB1404 1177 266 418.891775 1114.2521215 Acropora digitifera 70779 Cnidaria other_Eukaryota 73.1 1.87e-8   NTclustered gi|1005425977|ref|XR_001560985.1| 70779 g1157 i0 100 15.7593984962406 39 0 15 0 1 39 49 11 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA blastn 4192 73.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
22973072 22973072 PRJEB1404_S_NODE_199_length_421_cov_102.409326_g179_i0 PRJEB1404 199 421 102.409326 431.14326246 Acropora digitifera 70779 Cnidaria other_Eukaryota 65.8 5.21e-6   NTclustered gi|1005425978|ref|XR_001560989.1| 70779 g179 i0 93.333 8.40142517814727 45 1 11 2 1 45 70 28 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X5, ncRNA blastn 3537 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera

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