RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14175 · 6 ✖

analysis 1

  • diamond · 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
32942803 32942803 PRJEB14175_P_NODE_141514_length_287_cov_7.292035_g139247_i0 PRJEB14175 141514 287 7.292035 20.92814045 Sycon ciliatum 27933 Porifera other_Eukaryota 43.5 0.0134   NR XP_065195667.1 27933 g139247 i0 63 0.282229965156794 27 10 28.2 0 245 165 65 91 XP_065195667.1 uncharacterized protein LOC135827071 [Sycon ciliatum] diamond 81 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32956688 32956688 PRJEB14175_P_NODE_108130_length_341_cov_3.189286_g105864_i0 PRJEB14175 108130 341 3.189286 10.87546526 Metazoa 33208 Porifera other_Eukaryota 85.1 2.7e-17   NR XP_065908667.1 196820 g105864 i0 67.2 2.50733137829912 58 19 51 0 319 146 197 254 XP_065908667.1 uncharacterized protein [Dysidea avara] diamond 855 85.9 0.990686845168801 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32956720 32956720 PRJEB14175_P_NODE_124906_length_311_cov_11.572000_g122639_i0 PRJEB14175 124906 311 11.572 35.98892 Metazoa 33208 Porifera other_Eukaryota 136 9.91e-39   NR XP_065197478.1 27933 g122639 i0 79.7 6.54983922829582 74 15 71.4 0 27 248 63 136 XP_065197478.1 nucleoside diphosphate kinase B-like [Sycon ciliatum] diamond 2037 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32960902 32960902 PRJEB14175_P_NODE_236938_length_207_cov_0.876712_g234670_i0 PRJEB14175 236938 207 0.876712 1.81479384 Oscarella lobularis 121494 Porifera other_Eukaryota 76.6 2.55e-14   NR XP_065830259.1 121494 g234670 i0 70 0.72463768115942 50 15 72.5 0 12 161 430 479 XP_065830259.1 tripeptidyl-peptidase 1-like [Oscarella lobularis] diamond 150 76.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
33025040 33025040 PRJEB14175_P_NODE_156268_length_269_cov_3.947115_g154001_i0 PRJEB14175 156268 269 3.947115 10.61773935 Metazoa 33208 Porifera other_Eukaryota 54.7 3.12e-6   NR XP_065175755.1 27933 g154001 i0 65.7 2.20817843866171 35 12 39 0 191 87 37 71 XP_065175755.1 T-complex protein 1 subunit gamma-like [Sycon ciliatum] diamond 594 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
33110325 33110325 PRJEB14175_P_NODE_205974_length_223_cov_52.635802_g203707_i0 PRJEB14175 205974 223 52.635802 117.37783846 Metazoa 33208 Porifera other_Eukaryota 47.8 4.74e-4   NR XP_065887696.1 196820 g203707 i0 65.6 0.780269058295964 32 10 43 1 27 122 499 529 XP_065887696.1 beta-hexosaminidase subunit beta-like [Dysidea avara] diamond 174 47.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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