RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1087264" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1087264 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
11672743 11672743 PRJNA1087264_P_NODE_4690_length_298_cov_2.345382_g4608_i0 PRJNA1087264 4690 298 2.345382 6.98923836 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 132 3.46e-26   NTclustered gi|2519007827|ref|XM_057455710.1| 13093 g4608 i0 93.258 28.4731543624161 89 6 30 0 210 298 1234 1146 PREDICTED: Hydractinia symbiolongicarpus actin, non-muscle 6.2 (LOC130649433), mRNA blastn 8485 132 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
16771082 16771082 PRJNA1087264_P_NODE_9574_length_204_cov_0.929032_g9492_i0 PRJNA1087264 9574 204 0.929032 1.89522528 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 222 1.28e-53   NTclustered gi|2782835665|ref|XM_067053980.1| 252671 g9492 i0 86.275 60.578431372549 204 28 100 0 1 204 1255 1052 PREDICTED: Clytia hemisphaerica tubulin alpha-1A chain-like (LOC136797397), mRNA blastn 12358 222 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
20595120 20595120 PRJNA1087264_P_NODE_21197_length_161_cov_0.910714_g21115_i0 PRJNA1087264 21197 161 0.910714 1.46624954 Nematostella vectensis 45351 Cnidaria other_Eukaryota 204 3.49e-48   NTclustered gi|2257828287|ref|XM_001630533.3| 45351 g21115 i0 89.506 95.2236024844721 162 15 100 2 1 161 383 223 PREDICTED: Nematostella vectensis actin-2 (LOC5510121), mRNA blastn 15331 204 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
21419468 21419468 PRJNA1087264_P_NODE_5357_length_277_cov_1.100877_g5275_i0 PRJNA1087264 5357 277 1.100877 3.04942929 Opisthokonta 33154 Cnidaria other_Eukaryota 226 1.42e-54   NTclustered gi|2519013169|ref|XM_057457998.1| 13093 g5275 i0 81.522 127.353790613718 276 49 99 2 1 275 161 435 PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C (LOC130655264), mRNA blastn 35277 226 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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