RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA683902 · 7 ✖

analysis 1

  • diamond · 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
27018905 27018905 PRJNA683902_S_NODE_20902_length_230_cov_2.818653_g20458_i0 PRJNA683902 20902 230 2.818653 6.4829019 Erpetoichthys calabaricus 27687 Chordata Chordata 107 6.32e-26   NR XP_051791274.1 27687 g20458 i0 78.9 7.40869565217391 71 14 91.3 1 19 228 115 185 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 1704 107 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
27188462 27188462 PRJNA683902_S_NODE_33302_length_167_cov_1.746154_g32858_i0 PRJNA683902 33302 167 1.746154 2.91607718 Chordata 7711 Chordata Chordata 42.4 0.0185   NR XP_010006472.1 8897 g32858 i0 62.5 10.0419161676647 24 9 43.1 0 1 72 136 159 XP_010006472.1 PREDICTED: zinc finger protein 629-like, partial [Chaetura pelagica] diamond 1677 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Aves Apodiformes Apodidae Chaetura Chaetura pelagica
28755908 28755908 PRJNA683902_S_NODE_13607_length_334_cov_8000.973064_g13163_i0 PRJNA683902 13607 334 8000.973064 26723.25003376 Rangifer tarandus platyrhynchus 3082113 Chordata Chordata 54.7 6.89e-6   NR CAI9150999.1 3082113 g13163 i0 96.6 0.529940119760479 29 1 26 0 17 103 501 529 CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] diamond 177 54.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Rangifer Rangifer tarandus
29387556 29387556 PRJNA683902_S_NODE_15389_length_300_cov_2.927757_g14945_i0 PRJNA683902 15389 300 2.927757 8.783271 Staurois parvus 386267 Chordata Chordata 48.1 6.75e-4   NR CAI9536211.1 386267 g14945 i0 53.2 0.47 47 15 40 3 222 103 179 225 CAI9536211.1 unnamed protein product [Staurois parvus] diamond 141 48.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
29829397 29829397 PRJNA683902_S_NODE_20691_length_232_cov_2.194872_g20247_i0 PRJNA683902 20691 232 2.194872 5.09210304 Staurois parvus 386267 Chordata Chordata 60.1 4.84e-10   NR CAI9620946.1 386267 g20247 i0 70.3 0.478448275862069 37 11 47.8 0 21 131 23 59 CAI9620946.1 unnamed protein product [Staurois parvus] diamond 111 60.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
31156101 31156101 PRJNA683902_S_NODE_15095_length_304_cov_6951.992509_g14651_i0 PRJNA683902 15095 304 6951.992509 21134.05722736 Rangifer tarandus platyrhynchus 3082113 Chordata Chordata 55.8 1.92e-6   NR CAI9150999.1 3082113 g14651 i0 61.5 1.07565789473684 109 29 94.7 2 288 1 501 609 CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] diamond 327 55.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Rangifer Rangifer tarandus
32705720 32705720 PRJNA683902_S_NODE_26680_length_193_cov_3.756410_g26236_i0 PRJNA683902 26680 193 3.75641 7.2498713 Heptranchias perlo 212740 Chordata Chordata 64.3 4.71e-10   NR XP_067841360.1 212740 g26236 i0 56.9 0.901554404145078 58 25 90.2 0 5 178 12 69 XP_067841360.1 LOW QUALITY PROTEIN: S-adenosylmethionine-dependent nucleotide dehydratase RSAD2 [Heptranchias perlo] diamond 174 64.3 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Hexanchiformes Hexanchidae Heptranchias Heptranchias perlo

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