RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1136957" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1136957 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
4111562 4111562 PRJNA1136957_S_NODE_1044_length_568_cov_152.799607_g957_i0 PRJNA1136957 1044 568 152.799607 867.90176776 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 259 3.08e-64   NTclustered gi|1752371225|ref|XM_030989638.1| 7668 g957 i0 78.66 46.1161971830986 403 76 70 9 120 517 540 143 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L27a (LOC580148), mRNA blastn 26194 259 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
4111658 4111658 PRJNA1136957_S_NODE_7704_length_300_cov_7.141079_g7607_i0 PRJNA1136957 7704 300 7.141079 21.423237 Diadema antillarum 105358 Echinodermata other_Eukaryota 156 2.07e-33   NTclustered gi|2919496863|ref|XM_071648857.1| 105358 g7607 i0 82.486 16.8066666666667 177 31 59 0 124 300 387 211 PREDICTED: Diadema antillarum U6 snRNA-associated Sm-like protein LSm6 (LOC139738197), mRNA blastn 5042 156 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
5387763 5387763 PRJNA1136957_S_NODE_1485_length_517_cov_84.403930_g1390_i0 PRJNA1136957 1485 517 84.40393 436.3683181 Lytechinus pictus 7653 Echinodermata other_Eukaryota 296 2.12e-75   NTclustered gi|2707444401|ref|XM_064105648.1| 7653 g1390 i0 82.979 63.6479690522244 329 54 63 2 25 352 876 1203 PREDICTED: Lytechinus pictus small ribosomal subunit protein uS5 (LOC129269342), mRNA blastn 32906 296 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
6662476 6662476 PRJNA1136957_S_NODE_8306_length_291_cov_4.306034_g8209_i0 PRJNA1136957 8306 291 4.306034 12.53055894 Diadema antillarum 105358 Echinodermata other_Eukaryota 119 2.62e-22   NTclustered gi|2919450780|ref|XM_071640769.1| 105358 g8209 i0 85.714 0.384879725085911 112 16 38 0 3 114 1403 1514 PREDICTED: Diadema antillarum dynein regulatory complex subunit 2-like (LOC139729846), mRNA blastn 112 119 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
11763255 11763255 PRJNA1136957_S_NODE_5750_length_336_cov_8.231047_g5653_i0 PRJNA1136957 5750 336 8.231047 27.65631792 Diadema antillarum 105358 Echinodermata other_Eukaryota 134 1.1e-26   NTclustered gi|2919456096|ref|XM_071641670.1| 105358 g5653 i0 88.393 23.6279761904762 112 11 33 2 1 111 1206 1316 PREDICTED: Diadema antillarum long-chain specific acyl-CoA dehydrogenase, mitochondrial-like (LOC139730801), mRNA blastn 7939 134 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
13038346 13038346 PRJNA1136957_S_NODE_6831_length_316_cov_1.661479_g6734_i0 PRJNA1136957 6831 316 1.661479 5.25027364 Anneissia japonica 1529436 Echinodermata other_Eukaryota 104 8.05e-18   NTclustered gi|1826622061|ref|XM_033244085.1| 1529436 g6734 i0 86.957 1.42405063291139 92 12 29 0 3 94 1218 1309 PREDICTED: Anneissia japonica testis-expressed protein 9-like (LOC117103516), transcript variant X3, mRNA blastn 450 104 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
24510578 24510578 PRJNA1136957_S_NODE_960_length_580_cov_143.163148_g873_i0 PRJNA1136957 960 580 143.163148 830.3462584 Diadema antillarum 105358 Echinodermata other_Eukaryota 259 3.14e-64   NTclustered gi|2919420483|ref|XM_071635166.1| 105358 g873 i0 77.828 44.2293103448276 442 82 75 12 86 519 505 72 PREDICTED: Diadema antillarum large ribosomal subunit protein uL15-like (LOC139723966), mRNA blastn 25653 259 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum

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