RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA390533" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA390533 · 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
27106706 27106706 PRJNA390533_P_NODE_13342_length_522_cov_2.215321_g12377_i0 PRJNA390533 13342 522 2.215321 11.56397562 Staurois parvus 386267 Chordata Chordata 58.5 1.47e-7   NR CAI9533415.1 386267 g12377 i0 40 1.94252873563218 110 47 52.3 4 394 122 1 110 CAI9533415.1 unnamed protein product [Staurois parvus] diamond 1014 58.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
27675780 27675780 PRJNA390533_P_NODE_7564_length_716_cov_7.304284_g6810_i0 PRJNA390533 7564 716 7.304284 52.29867344 Branchiostoma belcheri 7741 Chordata Chordata 220 9.18e-63   NR KAI8516720.1 7741 g6810 i0 55.7 1.60893854748603 192 85 80.4 0 703 128 634 825 KAI8516720.1 hypothetical protein Bbelb_053010 [Branchiostoma belcheri] diamond 1152 220 1 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma belcheri
29222844 29222844 PRJNA390533_P_NODE_42209_length_172_cov_1.203008_g41182_i0 PRJNA390533 42209 172 1.203008 2.06917376 Polypterus senegalus 55291 Chordata Chordata 42.4 0.0189   NR KAG2461631.1 55291 g41182 i0 51.2 2.86046511627907 41 20 71.5 0 146 24 292 332 KAG2461631.1 TCB1 transposase, partial [Polypterus senegalus] diamond 492 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Polypterus Polypterus senegalus
29443417 29443417 PRJNA390533_P_NODE_37210_length_194_cov_2.561290_g36183_i0 PRJNA390533 37210 194 2.56129 4.9689026 Staurois parvus 386267 Chordata Chordata 51.6 6.52e-7   NR CAI9581818.1 386267 g36183 i0 75.9 0.448453608247423 29 7 44.8 0 63 149 29 57 CAI9581818.1 unnamed protein product, partial [Staurois parvus] diamond 87 51.6 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
30612252 30612252 PRJNA390533_P_NODE_32853_length_224_cov_2.621622_g31826_i0 PRJNA390533 32853 224 2.621622 5.87243328 Ranitomeya imitator 111125 Chordata Chordata 43.1 0.0213   NR CAJ0944175.1 111125 g31826 i0 70 1.36607142857143 30 8 38.8 1 224 138 546 575 CAJ0944175.1 unnamed protein product [Ranitomeya imitator] diamond 306 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
32635758 32635758 PRJNA390533_P_NODE_49500_length_152_cov_1.168142_g48473_i0 PRJNA390533 49500 152 1.168142 1.77557584 Schistometopum thomense 420425 Chordata Chordata 50.4 2.03e-5   NR ACS37166.1 420425 g48473 i0 59.6 2.76315789473684 47 19 92.8 0 11 151 206 252 ACS37166.1 NADH dehydrogenase subunit 4 [Schistometopum thomense] diamond 420 50.4 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Gymnophiona Dermophiidae Schistometopum Schistometopum thomense

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