RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1065838 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
1012412 1012412 PRJNA1065838_S_NODE_19621_length_203_cov_1.688312_g19519_i0 PRJNA1065838 19621 203 1.688312 3.42727336 Idotea baltica 82763 Arthropoda Arthropoda 109 8.54e-28   NR MCL4112850.1 82763 g19519 i0 79.1 0.990147783251232 67 13 97.5 1 2 199 72 138 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 201 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
21857005 21857005 PRJNA1065838_S_NODE_9598_length_251_cov_1.995050_g9496_i0 PRJNA1065838 9598 251 1.99505 5.0075755 Idotea baltica 82763 Arthropoda Arthropoda 99 1e-23   NR MCL4113740.1 82763 g9496 i0 61.7 0.968127490039841 81 30 95.6 1 1 240 53 133 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 243 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26782481 26782481 PRJNA1065838_S_NODE_6301_length_297_cov_1.302419_g6199_i0 PRJNA1065838 6301 297 1.302419 3.86818443 Rattus norvegicus 10116 Chordata Chordata 45.8 0.00108   NR EDM09552.1 10116 g6199 i0 37.1 1.97979797979798 62 39 62.6 0 79 264 22 83 EDM09552.1 rCG46366 [Rattus norvegicus] diamond 588 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Rattus Rattus norvegicus
26940466 26940466 PRJNA1065838_S_NODE_23162_length_193_cov_1.444444_g23060_i0 PRJNA1065838 23162 193 1.444444 2.78777692 Procambarus clarkii 6728 Arthropoda Arthropoda 93.2 3.4800000000000006e-21   NR AXR98485.1 6728 g23060 i0 63.5 0.979274611398964 63 23 97.9 0 190 2 130 192 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 189 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
27129926 27129926 PRJNA1065838_S_NODE_18462_length_207_cov_0.974684_g18360_i0 PRJNA1065838 18462 207 0.974684 2.01759588 Idotea baltica 82763 Arthropoda Arthropoda 104 3.36e-24   NR MCL4114215.1 82763 g18360 i0 83.6 0.884057971014493 61 7 88.4 1 187 5 570 627 MCL4114215.1 hypothetical protein [Idotea baltica] diamond 183 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27224972 27224972 PRJNA1065838_S_NODE_33443_length_166_cov_1.256410_g33341_i0 PRJNA1065838 33443 166 1.25641 2.0856406 Brachionus calyciflorus 104777 Rotifera other_Eukaryota 84.7 2.03e-17   NR CAF0779293.1 104777 g33341 i0 76.6 1.80722891566265 47 11 84.9 0 24 164 692 738 CAF0779293.1 unnamed protein product [Brachionus calyciflorus] diamond 300 84.7 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
27446602 27446602 PRJNA1065838_S_NODE_22243_length_195_cov_4.424658_g22141_i0 PRJNA1065838 22243 195 4.424658 8.6280831 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00747   NR CAK9813121.1 597819 g22141 i0 48.6 2.69230769230769 35 18 53.8 0 48 152 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
28425288 28425288 PRJNA1065838_S_NODE_5526_length_313_cov_2.393939_g5424_i0 PRJNA1065838 5526 313 2.393939 7.49302907 Idotea baltica 82763 Arthropoda Arthropoda 156 2.29e-45   NR MCL4112850.1 82763 g5424 i0 71.1 0.929712460063898 97 26 93 1 2 292 142 236 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 291 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28614641 28614641 PRJNA1065838_S_NODE_22407_length_195_cov_1.136986_g22305_i0 PRJNA1065838 22407 195 1.136986 2.2171227 Daphnia pulex 6669 Arthropoda Arthropoda 80.9 1.05e-16   NR EFX61420.1 6669 g22305 i0 83.7 0.661538461538462 43 7 66.2 0 67 195 151 193 EFX61420.1 hypothetical protein DAPPUDRAFT_339680 [Daphnia pulex] diamond 129 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
28701197 28701197 PRJNA1065838_S_NODE_22787_length_194_cov_1.075862_g22685_i0 PRJNA1065838 22787 194 1.075862 2.08717228 Metazoa 33208 Mollusca Mollusca 67 2.77e-11   NR CAG2250983.1 6550 g22685 i0 47 7.0979381443299 66 33 99 1 194 3 5 70 CAG2250983.1 CTSB [Mytilus edulis] diamond 1377 67.4 0.99406528189911 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
28930390 28930390 PRJNA1065838_S_NODE_17308_length_210_cov_4.136646_g17206_i0 PRJNA1065838 17308 210 4.136646 8.6869566 Rotaria sordida 392033 Rotifera other_Eukaryota 43.9 0.00913   NR CAF1236584.1 392033 g17206 i0 77.3 1.2 22 5 31.4 0 205 140 262 283 CAF1236584.1 unnamed protein product [Rotaria sordida] diamond 252 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
29056753 29056753 PRJNA1065838_S_NODE_37508_length_154_cov_2.971429_g37406_i0 PRJNA1065838 37508 154 2.971429 4.57600066 Idotea baltica 82763 Arthropoda Arthropoda 67.4 4.51e-12   NR MCL4113740.1 82763 g37406 i0 60 0.974025974025974 50 20 97.4 0 152 3 12 61 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 150 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29119990 29119990 PRJNA1065838_S_NODE_31529_length_169_cov_1.475000_g31427_i0 PRJNA1065838 31529 169 1.475 2.49275 Bufo gargarizans 30331 Chordata Chordata 42 0.0255   NR XP_044136063.1 30331 g31427 i0 52.6 0.674556213017751 38 15 67.5 1 116 3 20 54 XP_044136063.1 transmembrane channel-like protein 2-A [Bufo gargarizans] diamond 114 42 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufo Bufo gargarizans
29269159 29269159 PRJNA1065838_S_NODE_25389_length_187_cov_0.963768_g25287_i0 PRJNA1065838 25389 187 0.963768 1.80224616 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 91.7 2.48e-21   NR MCL4122626.1 82763 g25287 i0 72.9 1.87700534759358 59 16 94.7 0 179 3 74 132 MCL4122626.1 hypothetical protein [Idotea baltica] diamond 351 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31227741 31227741 PRJNA1065838_S_NODE_18995_length_205_cov_1.871795_g18893_i0 PRJNA1065838 18995 205 1.871795 3.8371797499999998 Opisthokonta 33154 Arthropoda Arthropoda 43.1 0.0166   NR XP_032594159.1 7222 g18893 i0 36.8 3.36585365853659 57 30 74.6 3 51 203 1158 1214 XP_032594159.1 furin-like protease 2 isoform X1 [Drosophila grimshawi] diamond 690 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
31331006 31331006 PRJNA1065838_S_NODE_23316_length_193_cov_1.083333_g23214_i0 PRJNA1065838 23316 193 1.083333 2.09083269 Brachionus calyciflorus 104777 Rotifera other_Eukaryota 103 5.89e-24   NR CAF1004757.1 104777 g23214 i0 75.4 1.89637305699482 61 15 94.8 0 6 188 188 248 CAF1004757.1 unnamed protein product [Brachionus calyciflorus] diamond 366 103 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
31354504 31354504 PRJNA1065838_S_NODE_12336_length_229_cov_942.083333_g12234_i0 PRJNA1065838 12336 229 942.083333 2157.37083257 Gryllus 6998 Arthropoda Arthropoda 58.5 8.12e-8   NR GLG93432.1 6999 g12234 i0 78.8 16.8340611353712 33 7 43.2 0 152 54 230 262 GLG93432.1 Coatomer subunit beta [Gryllus bimaculatus] diamond 3855 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
31362872 31362872 PRJNA1065838_S_NODE_22336_length_195_cov_1.520548_g22234_i0 PRJNA1065838 22336 195 1.520548 2.9650686 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 48.5 2.96e-5   NR CAL4117781.1 48144 g22234 i0 44.7 0.723076923076923 47 26 72.3 0 1 141 54 100 CAL4117781.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 141 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
31733804 31733804 PRJNA1065838_S_NODE_19417_length_204_cov_0.812903_g19315_i0 PRJNA1065838 19417 204 0.812903 1.65832212 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.5 5.61e-7   NR AXR98485.1 6728 g19315 i0 50.9 3.27941176470588 55 23 75 1 197 45 10 64 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 669 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii

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