RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA526367 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
496080 496080 PRJNA526367_P_NODE_4161_length_344_cov_4.023729_g3953_i0 PRJNA526367 4161 344 4.023729 13.84162776 Palythoa umbrosa 1565477 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|2771975540|dbj|AP031565.1| 1565477 g3953 i0 100 0.247093023255814 29 0 8 0 316 344 10183 10211 Palythoa umbrosa Pumb_01_1 mitochondrial DNA, complete genome blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Zoantharia Sphenopidae Palythoa Palythoa umbrosa
3047030 3047030 PRJNA526367_P_NODE_4223_length_344_cov_2.572881_g4015_i0 PRJNA526367 4223 344 2.572881 8.85071064 Palythoa umbrosa 1565477 Cnidaria other_Eukaryota 56.5 0.003   NTclustered gi|2771975540|dbj|AP031565.1| 1565477 g4015 i0 100 0.822674418604651 30 0 9 0 1 30 10212 10183 Palythoa umbrosa Pumb_01_1 mitochondrial DNA, complete genome blastn 283 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Zoantharia Sphenopidae Palythoa Palythoa umbrosa
9424147 9424147 PRJNA526367_P_NODE_33488_length_222_cov_5.514451_g33278_i0 PRJNA526367 33488 222 5.514451 12.24208122 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 230 8.48e-56   NTclustered gi|23503507|dbj|AB085641.1| 196280 g33278 i0 87.755 1.76576576576577 196 24 88 0 7 202 114 309 Trachyphyllia geoffroyi mRNA for Kaede, complete cds blastn 392 230 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
13249662 13249662 PRJNA526367_P_NODE_21451_length_324_cov_2.316364_g21242_i0 PRJNA526367 21451 324 2.316364 7.50501936 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 63.9 1.41e-5   NTclustered gi|23503507|dbj|AB085641.1| 196280 g21242 i0 95 0.123456790123457 40 2 12 0 61 100 676 637 Trachyphyllia geoffroyi mRNA for Kaede, complete cds blastn 40 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
20898160 20898160 PRJNA526367_P_NODE_4057_length_345_cov_3.695946_g3849_i0 PRJNA526367 4057 345 3.695946 12.7510137 Palythoa umbrosa 1565477 Cnidaria other_Eukaryota 56.5 0.003   NTclustered gi|2771975540|dbj|AP031565.1| 1565477 g3849 i0 100 0.657971014492754 30 0 9 0 1 30 10212 10183 Palythoa umbrosa Pumb_01_1 mitochondrial DNA, complete genome blastn 227 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Zoantharia Sphenopidae Palythoa Palythoa umbrosa

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