RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA900999 · 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
27308878 27308878 PRJNA900999_S_NODE_6383_length_178_cov_4.731544_g6327_i0 PRJNA900999 6383 178 4.731544 8.42214832 Emydura macquarii macquarii 1129001 Chordata Chordata 46.6 6.03e-4   NR XP_067386244.1 1129001 g6327 i0 80 0.421348314606742 25 5 42.1 0 77 3 8 32 XP_067386244.1 C-signal-like [Emydura macquarii macquarii] diamond 75 46.6 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Chelidae Emydura Emydura macquarii
28319078 28319078 PRJNA900999_S_NODE_4446_length_205_cov_2.159091_g4390_i0 PRJNA900999 4446 205 2.159091 4.42613655 Callorhinchus milii 7868 Chordata Chordata 48.5 2.08e-4   NR XP_042196624.1 7868 g4390 i0 50 3.67317073170732 50 25 73.2 0 2 151 303 352 XP_042196624.1 uncharacterized protein LOC103181325 [Callorhinchus milii] diamond 753 48.5 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Chimaeriformes Callorhinchidae Callorhinchus Callorhinchus milii
29171770 29171770 PRJNA900999_S_NODE_4809_length_199_cov_2.488235_g4753_i0 PRJNA900999 4809 199 2.488235 4.95158765 Cervus elaphus 9860 Chordata Chordata 42 0.0403   NR XP_043749171.1 9860 g4753 i0 62.5 1.44723618090452 40 13 60.3 1 76 195 774 811 XP_043749171.1 inhibitor of nuclear factor kappa-B kinase subunit beta isoform X1 [Cervus elaphus] diamond 288 42 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Cervus Cervus elaphus
30624379 30624379 PRJNA900999_S_NODE_4673_length_201_cov_2.819767_g4617_i0 PRJNA900999 4673 201 2.819767 5.66773167 Muntiacus muntjak 9888 Chordata Chordata 42 0.0391   NR KAB0348442.1 9888 g4617 i0 88 0.373134328358209 25 1 37.3 1 77 3 321 343 KAB0348442.1 hypothetical protein FD754_013299, partial [Muntiacus muntjak] diamond 75 42 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Muntiacus Muntiacus muntjak
31889020 31889020 PRJNA900999_S_NODE_7057_length_171_cov_3.147887_g7001_i0 PRJNA900999 7057 171 3.147887 5.38288677 Ovis aries 9940 Chordata Chordata 58.9 2.59e-8   NR KAG5215760.1 9940 g7001 i0 77.1 0.614035087719298 35 8 61.4 0 119 15 164 198 KAG5215760.1 hypothetical protein JEQ12_001336, partial [Ovis aries] diamond 105 58.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis aries
32805469 32805469 PRJNA900999_S_NODE_6340_length_179_cov_2.566667_g6284_i0 PRJNA900999 6340 179 2.566667 4.59433393 Rangifer tarandus platyrhynchus 3082113 Chordata Chordata 64.7 1.07e-11   NR CAI9181037.1 3082113 g6284 i0 75.8 0.553072625698324 33 8 55.3 0 1 99 52 84 CAI9181037.1 unnamed protein product [Rangifer tarandus platyrhynchus] diamond 99 64.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Rangifer Rangifer tarandus

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