RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB75017" 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

  • PRJEB75017 · 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
3961433 3961433 PRJEB75017_P_NODE_14484_length_251_cov_2.421348_g14355_i0 PRJEB75017 14484 251 2.421348 6.07758348 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 152 2.18e-32   NTclustered gi|1603783844|ref|XM_028539416.1| 151771 g14355 i0 92.453 26.2788844621514 106 8 42 0 1 106 1118 1223 PREDICTED: Dendronephthya gigantea actin, cytoplasmic (LOC114519299), transcript variant X2, mRNA blastn 6596 152 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
19260941 19260941 PRJEB75017_P_NODE_1696_length_664_cov_1.397631_g1570_i0 PRJEB75017 1696 664 1.397631 9.28026984 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 54.7 0.018   NTclustered gi|1603818482|ref|XM_028557847.1| 151771 g1570 i0 96.875 0.0481927710843374 32 1 5 0 465 496 765 796 PREDICTED: Dendronephthya gigantea collagen alpha-1(II) chain-like (LOC114536502), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
23087180 23087180 PRJEB75017_P_NODE_3319_length_480_cov_3.115479_g3190_i0 PRJEB75017 3319 480 3.115479 14.9542992 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 237 1.2e-57   NTclustered gi|2782956407|ref|XM_067080111.1| 252671 g3190 i0 77.863 56.3479166666667 393 79 81 8 6 394 507 119 PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eS31 fusion protein (LOC136823954), mRNA blastn 27047 237 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
24361159 24361159 PRJEB75017_P_NODE_1640_length_675_cov_5.129568_g1515_i0 PRJEB75017 1640 675 5.129568 34.624584 Hydra vulgaris 6087 Cnidaria other_Eukaryota 292 3.64e-74   NTclustered gi|2744794010|ref|XM_012698561.3| 6087 g1515 i0 80.407 10.2044444444444 393 69 58 8 106 494 184 572 PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA blastn 6888 292 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris

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