RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 5

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA688655 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
1943160 1943160 PRJNA688655_P_NODE_2762_length_356_cov_2.166078_g2697_i0 PRJNA688655 2762 356 2.166078 7.71123768 root 1 Root_unresolved Root_unresolved 204 5.6199999999999995e-61   NR CAI5795825.1 74358 g2697 i0 77.8 2.95786516853933 117 26 98.6 0 355 5 282 398 CAI5795825.1 endogenous retrovirus group K member 11 Pol protein-like [Podarcis lilfordi] diamond 1053 204 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Lacertidae Podarcis Podarcis lilfordi
4495141 4495141 PRJNA688655_P_NODE_244_length_1051_cov_2.003067_g202_i0 PRJNA688655 244 1051 2.003067 21.05223417 Metazoa 33208 Chordata Chordata 475 2.96e-156   NR CAI7935364.1 74358 g202 i0 64.4 2.98287345385347 348 122 99.3 1 4 1047 363 708 CAI7935364.1 endogenous retrovirus group K member 11 Pol protein-like [Podarcis lilfordi] diamond 3135 475 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Lacertidae Podarcis Podarcis lilfordi
26924104 26924104 PRJNA688655_P_NODE_11222_length_247_cov_0.885057_g11157_i0 PRJNA688655 11222 247 0.885057 2.18609079 Idotea baltica 82763 Arthropoda Arthropoda 114 1.14e-28   NR MCL4125753.1 82763 g11157 i0 67.1 0.959514170040486 79 23 96 1 247 11 229 304 MCL4125753.1 hypothetical protein [Idotea baltica] diamond 237 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26998761 26998761 PRJNA688655_P_NODE_4022_length_317_cov_0.942623_g3957_i0 PRJNA688655 4022 317 0.942623 2.98811491 Drosophila 7215 Arthropoda Arthropoda 80.5 4.83e-15   NR NP_001162772.1 7227 g3957 i0 40.8 6.47318611987382 98 53 89.9 2 292 8 14 109 NP_001162772.1 transducer of ERBB2, isoform F [Drosophila melanogaster] diamond 2052 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
27378529 27378529 PRJNA688655_P_NODE_10063_length_248_cov_0.891429_g9998_i0 PRJNA688655 10063 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 42.7 0.0392   NR KAH7709764.1 70226 g9998 i0 38.6 1.42741935483871 57 34 67.7 1 12 179 353 409 KAH7709764.1 Protein KIN-9 c [Aphelenchoides avenae] diamond 354 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Aphelenchoides Aphelenchoides avenae
27840158 27840158 PRJNA688655_P_NODE_8804_length_250_cov_0.870056_g8739_i0 PRJNA688655 8804 250 0.870056 2.17514 Trypoxylus dichotomus 273928 Arthropoda Arthropoda 57.8 1.83e-7   NR GJQ76753.1 273928 g8739 i0 48.2 0.672 56 29 67.2 0 181 14 236 291 GJQ76753.1 hypothetical protein Trydic_g15596 [Trypoxylus dichotomus] diamond 168 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Trypoxylus Trypoxylus dichotomus
27935155 27935155 PRJNA688655_P_NODE_16105_length_241_cov_0.916667_g16040_i0 PRJNA688655 16105 241 0.916667 2.20916747 Halotydeus destructor 2874060 Arthropoda Arthropoda 60.5 2.1e-8   NR KAI1295348.1 2874060 g16040 i0 41.9 1.89211618257261 74 42 92.1 1 5 226 354 426 KAI1295348.1 Crossover junction endonuclease MUS81 [Halotydeus destructor] diamond 456 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
28977172 28977172 PRJNA688655_P_NODE_8748_length_250_cov_0.870056_g8683_i0 PRJNA688655 8748 250 0.870056 2.17514 Emydura macquarii macquarii 1129001 Chordata Chordata 50.1 1.03e-4   NR XP_067417499.1 1129001 g8683 i0 69.7 0.396 33 10 39.6 0 2 100 27 59 XP_067417499.1 olfactory receptor 10AG1-like isoform X1 [Emydura macquarii macquarii] diamond 99 50.1 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Chelidae Emydura Emydura macquarii
29071913 29071913 PRJNA688655_P_NODE_11668_length_246_cov_1.526012_g11603_i0 PRJNA688655 11668 246 1.526012 3.75398952 Mauremys mutica 74926 Chordata Chordata 95.9 2.58e-23   NR KAH1173910.1 74926 g11603 i0 83.9 0.682926829268293 56 9 68.3 0 78 245 52 107 KAH1173910.1 hypothetical protein KIL84_017749 [Mauremys mutica] diamond 168 95.9 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Geoemydidae Mauremys Mauremys mutica
29671286 29671286 PRJNA688655_P_NODE_4690_length_301_cov_2.368421_g4625_i0 PRJNA688655 4690 301 2.368421 7.12894721 Passer domesticus 48849 Chordata Chordata 73.9 8.25e-13   NR XP_064267235.1 48849 g4625 i0 57.4 1.08637873754153 54 23 53.8 0 166 5 10 63 XP_064267235.1 endogenous retrovirus group K member 6 Pol protein [Passer domesticus] diamond 327 73.9 1 Eukaryota Opisthokonta Metazoa Chordata Aves Passeriformes Passeridae Passer Passer domesticus
29682873 29682873 PRJNA688655_P_NODE_16570_length_241_cov_0.916667_g16505_i0 PRJNA688655 16570 241 0.916667 2.20916747 Metazoa 33208 Nematoda Nematoda 50.1 1.65e-5   NR EYC04280.1 53326 g16505 i0 42.9 4.7551867219917 56 32 69.7 0 2 169 40 95 EYC04280.1 hypothetical protein Y032_0089g2326 [Ancylostoma ceylanicum] diamond 1146 50.1 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Ancylostomatidae Ancylostoma Ancylostoma ceylanicum
29829471 29829471 PRJNA688655_P_NODE_16391_length_241_cov_0.916667_g16326_i0 PRJNA688655 16391 241 0.916667 2.20916747 Mus musculus 10090 Chordata Chordata 42.7 0.00898   NR BAE42973.1 10090 g16326 i0 70.4 0.336099585062241 27 8 33.6 0 8 88 40 66 BAE42973.1 unnamed protein product [Mus musculus] diamond 81 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
30019253 30019253 PRJNA688655_P_NODE_8671_length_250_cov_0.870056_g8606_i0 PRJNA688655 8671 250 0.870056 2.17514 Brachionus plicatilis 10195 Rotifera other_Eukaryota 68.9 1.63e-11   NR RNA35075.1 10195 g8606 i0 67.4 2.772 46 15 55.2 0 54 191 272 317 RNA35075.1 KRAB-A domain-containing 2-like [Brachionus plicatilis] diamond 693 68.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
30208353 30208353 PRJNA688655_P_NODE_1812_length_414_cov_1.000000_g1747_i0 PRJNA688655 1812 414 1 4.14 Mauremys reevesii 260615 Chordata Chordata 115 2.4800000000000003e-27   NR XP_039352353.1 260615 g1747 i0 73.3 0.543478260869565 75 20 54.3 0 184 408 78 152 XP_039352353.1 uncharacterized protein LOC120375641 [Mauremys reevesii] diamond 225 115 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Geoemydidae Mauremys Mauremys reevesii
30367025 30367025 PRJNA688655_P_NODE_11252_length_247_cov_0.885057_g11187_i0 PRJNA688655 11252 247 0.885057 2.18609079 Chrysemys picta bellii 8478 Chordata Chordata 107 3.84e-26   NR XP_065415084.1 8478 g11187 i0 78.1 0.777327935222672 64 14 77.7 0 1 192 226 289 XP_065415084.1 uncharacterized protein LOC135973847 [Chrysemys picta bellii] diamond 192 107 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Emydidae Chrysemys Chrysemys picta
30998580 30998580 PRJNA688655_P_NODE_13794_length_244_cov_0.900585_g13729_i0 PRJNA688655 13794 244 0.900585 2.1974274 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 80.5 1.96e-15   NR KAJ7385059.1 174260 g13729 i0 45 0.983606557377049 80 42 97.1 2 1 237 116 194 KAJ7385059.1 NFX1-type zinc finger-containing protein 1 [Desmophyllum pertusum] diamond 240 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
32137160 32137160 PRJNA688655_P_NODE_18_length_2637_cov_7.782761_g12_i0 PRJNA688655 18 2637 7.782761 205.23140757 Portunus trituberculatus 210409 Arthropoda Arthropoda 70.1 1.27e-10   NR MPC39078.1 210409 g12 i0 48.4 0.10580204778157 93 45 10.5 3 1266 1541 1 91 MPC39078.1 hypothetical protein [Portunus trituberculatus] diamond 279 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus

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