RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493244 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
455337 455337 PRJNA493244_P_NODE_1288421_length_300_cov_2.615063_g1265297_i0 PRJNA493244 1288421 300 2.615063 7.845189 Anthoathecata 406427 Cnidaria other_Eukaryota 155 2.3e-46   NR XP_004208537.1 6087 g1265297 i0 76.7 53.31 86 20 86 0 300 43 45 130 XP_004208537.1 small ribosomal subunit protein uS8 [Hydra vulgaris] diamond 15993 156 0.993589743589744 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
26680800 26680800 PRJNA493244_P_NODE_132601_length_1389_cov_5.807982_g123944_i0 PRJNA493244 132601 1389 5.807982 80.67286998 Cnidaria 6073 Cnidaria other_Eukaryota 280 1.72e-85   NR XP_031552717.1 6105 g123944 i0 45.7 1.38444924406048 317 157 67 9 1297 368 47 355 XP_031552717.1 uncharacterized protein LOC116289916 [Actinia tenebrosa] diamond 1923 282 0.99290780141844 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28750200 28750200 PRJNA493244_P_NODE_1421227_length_262_cov_11.950249_g1398102_i0 PRJNA493244 1421227 262 11.950249 31.30965238 Porites lobata 104759 Cnidaria other_Eukaryota 44.3 0.0128   NR CAH3040336.1 104759 g1398102 i0 36 0.572519083969466 50 27 57.3 2 48 197 34 78 CAH3040336.1 unnamed protein product [Porites lobata] diamond 150 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
30424456 30424456 PRJNA493244_P_NODE_787953_length_514_cov_1.695364_g765316_i0 PRJNA493244 787953 514 1.695364 8.71417096 Porites evermanni 104178 Cnidaria other_Eukaryota 107 1.37e-25   NR CAH3029253.1 104178 g765316 i0 37.7 4.72762645914397 162 95 91.1 3 19 486 38 199 CAH3029253.1 unnamed protein product, partial [Porites evermanni] diamond 2430 107 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
31024420 31024420 PRJNA493244_P_NODE_961835_length_424_cov_2.088154_g938786_i0 PRJNA493244 961835 424 2.088154 8.85377296 Nematostella vectensis 45351 Cnidaria other_Eukaryota 59.3 3.92e-7   NR EDO46981.1 45351 g938786 i0 35.7 2.86556603773585 84 44 59.4 1 413 162 324 397 EDO46981.1 predicted protein [Nematostella vectensis] diamond 1215 59.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
32258185 32258185 PRJNA493244_P_NODE_1534798_length_235_cov_1.402299_g1511673_i0 PRJNA493244 1534798 235 1.402299 3.29540265 Montipora foliosa 591990 Cnidaria other_Eukaryota 44.7 0.0066   NR XP_068680545.1 591990 g1511673 i0 52.3 2.2468085106383 44 21 56.2 0 229 98 240 283 XP_068680545.1 uncharacterized protein [Montipora foliosa] diamond 528 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora foliosa

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