RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1008624" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1008624 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
2704135 2704135 PRJNA1008624_P_NODE_13123_length_231_cov_3.175824_g12935_i0 PRJNA1008624 13123 231 3.175824 7.33615344 Eutima gegenbauri 661993 Cnidaria other_Eukaryota 99 2.61e-16   NTclustered gi|256674552|gb|FJ550456.1| 661993 g12935 i0 78.981 23.0562770562771 157 24 68 8 61 216 1670 1522 Eutima gegenbauri voucher MHNG INVE31748 28S ribosomal RNA gene, partial sequence blastn 5326 99 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Eirenidae Eutima Eutima gegenbauri
23106299 23106299 PRJNA1008624_P_NODE_1639_length_674_cov_1.678400_g1476_i0 PRJNA1008624 1639 674 1.6784 11.312416 Montipora capricornis 246305 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2812114944|ref|XM_068870257.1| 246305 g1476 i0 97.059 0.0504451038575668 34 1 5 0 621 654 178 145 PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
23106642 23106642 PRJNA1008624_P_NODE_27659_length_169_cov_0.866667_g27471_i0 PRJNA1008624 27659 169 0.866667 1.46466723 Nematostella vectensis 45351 Cnidaria other_Eukaryota 62.1 2.34e-5   NTclustered gi|2257873187|ref|XM_048726704.1| 45351 g27471 i0 93.023 0.763313609467456 43 2 25 1 4 46 1638 1679 PREDICTED: Nematostella vectensis uncharacterized LOC125561901 (LOC125561901), mRNA blastn 129 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis

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