RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA385073" 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

  • PRJNA385073 · 8 ✖

analysis 1

  • diamond · 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
16983013 16983013 PRJNA385073_P_NODE_20974_length_313_cov_1.925000_g20812_i0 PRJNA385073 20974 313 1.925 6.02525 Opisthokonta 33154 Cnidaria other_Eukaryota 138 1.9999999999999997e-37   NR XP_001631784.1 45351 g20812 i0 67.8 6.08626198083067 90 29 86.3 0 273 4 3 92 XP_001631784.1 receptor of activated protein C kinase 1 [Nematostella vectensis] diamond 1905 138 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
20808226 20808226 PRJNA385073_P_NODE_8317_length_436_cov_2.093664_g8156_i0 PRJNA385073 8317 436 2.093664 9.12837504 Stylophora pistillata 50429 Cnidaria other_Eukaryota 146 5.499999999999999e-38   NR PFX23400.1 50429 g8156 i0 62.6 0.901376146788991 131 49 90.1 0 3 395 417 547 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 393 146 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
26758595 26758595 PRJNA385073_P_NODE_59761_length_239_cov_4.795181_g59599_i0 PRJNA385073 59761 239 4.795181 11.46048259 Stylophora pistillata 50429 Cnidaria other_Eukaryota 89.7 1.01e-18   NR PFX23400.1 50429 g59599 i0 75.8 0.778242677824268 62 15 77.8 0 237 52 486 547 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 186 89.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
26853919 26853919 PRJNA385073_P_NODE_15601_length_347_cov_3.244526_g15440_i0 PRJNA385073 15601 347 3.244526 11.25850522 Stylophora pistillata 50429 Cnidaria other_Eukaryota 157 1.3899999999999996e-42   NR PFX23400.1 50429 g15440 i0 81.6 0.985590778097983 114 21 98.6 0 343 2 326 439 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 342 157 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
27328181 27328181 PRJNA385073_P_NODE_47523_length_247_cov_3.551724_g47361_i0 PRJNA385073 47523 247 3.551724 8.77275828 Stylophora pistillata 50429 Cnidaria other_Eukaryota 88.6 2.78e-18   NR PFX23400.1 50429 g47361 i0 70.6 0.825910931174089 68 20 82.6 0 3 206 480 547 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 204 88.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28955506 28955506 PRJNA385073_P_NODE_56808_length_242_cov_0.911243_g56646_i0 PRJNA385073 56808 242 0.911243 2.20520806 Metazoa 33208 Cnidaria other_Eukaryota 47 0.001   NR XP_020626096.1 48498 g56646 i0 81 0.78099173553719 21 4 26 0 235 173 212 232 XP_020626096.1 L-rhamnose-binding lectin CSL3-like [Orbicella faveolata] diamond 189 47 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
31971714 31971714 PRJNA385073_P_NODE_23218_length_303_cov_1.339130_g23056_i0 PRJNA385073 23218 303 1.33913 4.0575639 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 147 1.56e-40   NR XP_020915026.1 2652724 g23056 i0 69.1 1.91089108910891 97 30 96 0 293 3 5 101 XP_020915026.1 peptidyl-prolyl cis-trans isomerase D [Exaiptasia diaphana] diamond 579 147 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
32541588 32541588 PRJNA385073_P_NODE_33419_length_269_cov_4.010204_g33257_i0 PRJNA385073 33419 269 4.010204 10.78744876 Stylophora pistillata 50429 Cnidaria other_Eukaryota 119 6.77e-29   NR PFX23400.1 50429 g33257 i0 76.4 0.992565055762082 89 21 99.3 0 1 267 332 420 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 267 119 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata

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