RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA454503 · 6 ✖

analysis 1

  • blastn · 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
3644562 3644562 PRJNA454503_P_NODE_1703_length_924_cov_3914.676709_g1442_i0 PRJNA454503 1703 924 3914.676709 36171.61279116 Malacalcyonacea 3028843 Cnidaria other_Eukaryota 154 2.49e-32   NTclustered gi|8101942|gb|AF262347.1| 51768 g1442 i0 95.789 11.0064935064935 95 4 10 0 6 100 675 769 Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10170 154 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Alcyoniidae Alcyonium Alcyonium digitatum
8746525 8746525 PRJNA454503_P_NODE_1767_length_910_cov_3978.122497_g1503_i0 PRJNA454503 1767 910 3978.122497 36200.9147227 Malacalcyonacea 3028843 Cnidaria other_Eukaryota 154 2.45e-32   NTclustered gi|8101942|gb|AF262347.1| 51768 g1503 i0 95.789 11.1758241758242 95 4 10 0 811 905 769 675 Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10170 154 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Alcyoniidae Alcyonium Alcyonium digitatum
13847419 13847419 PRJNA454503_P_NODE_5811_length_474_cov_6974.731235_g5483_i0 PRJNA454503 5811 474 6974.731235 33060.2260539 Malacalcyonacea 3028843 Cnidaria other_Eukaryota 154 1.23e-32   NTclustered gi|8101942|gb|AF262347.1| 51768 g5483 i0 95.789 21.4556962025316 95 4 20 0 375 469 769 675 Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10170 154 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Alcyoniidae Alcyonium Alcyonium digitatum
19568746 19568746 PRJNA454503_P_NODE_87556_length_198_cov_2.459854_g87227_i0 PRJNA454503 87556 198 2.459854 4.87051092 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 115 2.16e-21   NTclustered gi|2782945195|ref|XM_067077207.1| 252671 g87227 i0 80.795 1.96969696969697 151 25 75 4 18 166 1615 1763 PREDICTED: Clytia hemisphaerica 26S proteasome non-ATPase regulatory subunit 1-like (LOC136820975), mRNA blastn 390 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
24668367 24668367 PRJNA454503_P_NODE_24420_length_251_cov_5.505263_g24091_i0 PRJNA454503 24420 251 5.505263 13.81821013 Sinuolinea arctica 1483224 Cnidaria other_Eukaryota 80.5 1.04e-10   NTclustered gi|605060087|gb|KF874227.1| 1483224 g24091 i0 80.374 0.549800796812749 107 19 42 2 35 140 1378 1273 Sinuolinea arctica 28S ribosomal RNA gene, partial sequence blastn 138 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Sinuolineidae Sinuolinea Sinuolinea arctica
24668376 24668376 PRJNA454503_P_NODE_25380_length_249_cov_1.026596_g25051_i0 PRJNA454503 25380 249 1.026596 2.55622404 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 134 7.82e-27   NTclustered gi|2782891151|ref|XM_067066273.1| 252671 g25051 i0 80.226 42.1044176706827 177 35 71 0 27 203 808 984 PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136809726), mRNA blastn 10484 134 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica

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