RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1143173" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA1143173 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
27038748 27038748 PRJNA1143173_P_NODE_10782_length_310_cov_3.645570_g10756_i0 PRJNA1143173 10782 310 3.64557 11.301267 Timema monikensis 170555 Arthropoda Arthropoda 62.4 9.76e-9   NR CAD7425026.1 170555 g10756 i0 73 0.358064516129032 37 10 35.8 0 15 125 468 504 CAD7425026.1 unnamed protein product [Timema monikensis] diamond 111 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
27133270 27133270 PRJNA1143173_P_NODE_25782_length_270_cov_2.710660_g25756_i0 PRJNA1143173 25782 270 2.71066 7.318782 Coturnix japonica 93934 Chordata Chordata 60.5 2.07e-8   NR XP_015706233.1 93934 g25756 i0 68.3 4.26666666666667 41 12 44.4 1 76 195 102 142 XP_015706233.1 LOW QUALITY PROTEIN: serine/threonine-protein phosphatase 4 catalytic subunit-like [Coturnix japonica] diamond 1152 60.5 1 Eukaryota Opisthokonta Metazoa Chordata Aves Galliformes Phasianidae Coturnix Coturnix japonica
28018104 28018104 PRJNA1143173_P_NODE_36125_length_240_cov_3.970060_g36099_i0 PRJNA1143173 36125 240 3.97006 9.528144 Diceros bicornis minor 77932 Chordata Chordata 50.8 5.01e-5   NR KAF5922147.1 77932 g36099 i0 64.9 0.4625 37 13 46.3 0 122 12 184 220 KAF5922147.1 hypothetical protein HPG69_007033 [Diceros bicornis minor] diamond 111 50.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Perissodactyla Rhinocerotidae Diceros Diceros bicornis
29049063 29049063 PRJNA1143173_P_NODE_28728_length_261_cov_5.223404_g28702_i0 PRJNA1143173 28728 261 5.223404 13.63308444 Metazoa 33208 Arthropoda Arthropoda 77.8 1.09e-14   NR XP_018577102.1 217634 g28702 i0 49.3 2.72413793103448 75 33 86.2 1 260 36 108 177 XP_018577102.1 cathepsin L-like proteinase [Anoplophora glabripennis] diamond 711 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
29407164 29407164 PRJNA1143173_P_NODE_28049_length_263_cov_4.584211_g28023_i0 PRJNA1143173 28049 263 4.584211 12.05647493 Sus scrofa 9823 Chordata Chordata 67 1.36e-10   NR XP_020946894.1 9823 g28023 i0 55.2 0.76425855513308 67 30 76.4 0 48 248 405 471 XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] diamond 201 67 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
29648460 29648460 PRJNA1143173_P_NODE_29950_length_258_cov_2.713514_g29924_i0 PRJNA1143173 29950 258 2.713514 7.00086612 Opisthokonta 33154 Arthropoda Arthropoda 79 4.05e-15   NR KAK8736018.1 27406 g29924 i0 62.7 22.7790697674419 51 19 59.3 0 218 66 264 314 KAK8736018.1 hypothetical protein OTU49_005178, partial [Cherax quadricarinatus] diamond 5877 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
29711633 29711633 PRJNA1143173_P_NODE_14870_length_299_cov_2.867257_g14844_i0 PRJNA1143173 14870 299 2.867257 8.57309843 Philodinidae 44580 Rotifera other_Eukaryota 52.8 1.86e-5   NR CAF1070528.1 392030 g14844 i0 40.6 5.66889632107023 64 38 64.2 0 293 102 230 293 CAF1070528.1 unnamed protein product [Rotaria magnacalcarata] diamond 1695 52.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata
29711636 29711636 PRJNA1143173_P_NODE_27830_length_264_cov_2.937173_g27804_i0 PRJNA1143173 27830 264 2.937173 7.75413672 Trombidiformes 83136 Arthropoda Arthropoda 123 1.02e-30   NR RWS26034.1 299467 g27804 i0 69.4 2.96590909090909 85 25 96.6 1 264 10 174 257 RWS26034.1 target of rapamycin complex 2 subunit MAPKAP1-like protein [Leptotrombidium deliense] diamond 783 124 0.991935483870968 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
30323747 30323747 PRJNA1143173_P_NODE_24732_length_273_cov_3.095000_g24706_i0 PRJNA1143173 24732 273 3.095 8.44935 Brachionus calyciflorus 104777 Rotifera other_Eukaryota 58.5 4.79e-8   NR CAF0898772.1 104777 g24706 i0 45.2 0.681318681318681 62 34 68.1 0 80 265 121 182 CAF0898772.1 unnamed protein product, partial [Brachionus calyciflorus] diamond 186 58.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
30638993 30638993 PRJNA1143173_P_NODE_19713_length_288_cov_2.260465_g19687_i0 PRJNA1143173 19713 288 2.260465 6.5101392 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 64.7 5.94e-10   NR KAJ8017412.1 206669 g19687 i0 37.5 1 96 57 97.9 2 3 284 63 157 KAJ8017412.1 hypothetical protein HOLleu_45208 [Holothuria leucospilota] diamond 288 64.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
30702290 30702290 PRJNA1143173_P_NODE_15354_length_298_cov_5.453333_g15328_i0 PRJNA1143173 15354 298 5.453333 16.25093234 Branchiostoma belcheri 7741 Chordata Chordata 42.4 0.0322   NR KAI8521773.1 7741 g15328 i0 47.4 0.38255033557047 38 20 38.3 0 197 84 22 59 KAI8521773.1 hypothetical protein Bbelb_015270 [Branchiostoma belcheri] diamond 114 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma belcheri
31745459 31745459 PRJNA1143173_P_NODE_37337_length_236_cov_2.546012_g37311_i0 PRJNA1143173 37337 236 2.546012 6.00858832 Polyplax serrata 468196 Arthropoda Arthropoda 43.1 0.0258   NR KAK6616888.1 468196 g37311 i0 91.3 0.584745762711864 23 2 29.2 0 70 2 1382 1404 KAK6616888.1 Dynein heavy chain 8, axonemal [Polyplax serrata] diamond 138 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
31797604 31797604 PRJNA1143173_P_NODE_42337_length_212_cov_7.956835_g42311_i0 PRJNA1143173 42337 212 7.956835 16.8684902 root 1 Root_unresolved Root_unresolved 139 1.21e-36   NR XP_030110853.2 10090 g42311 i0 97.1 11.8584905660377 70 2 99.1 0 1 210 103 172 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 2514 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
31892723 31892723 PRJNA1143173_P_NODE_41377_length_218_cov_7.468966_g41351_i0 PRJNA1143173 41377 218 7.468966 16.28234588 Daphnia 6668 Arthropoda Arthropoda 64.7 4.81e-10   NR EFX79785.1 6669 g41351 i0 48 8.10550458715596 75 34 96.3 1 4 213 187 261 EFX79785.1 hypothetical protein DAPPUDRAFT_304367 [Daphnia pulex] diamond 1767 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
31935239 31935239 PRJNA1143173_P_NODE_33517_length_247_cov_13.500000_g33491_i0 PRJNA1143173 33517 247 13.5 33.345 Amphimedon queenslandica 400682 Porifera other_Eukaryota 42.4 0.0374   NR XP_003384590.1 400682 g33491 i0 64.3 0.340080971659919 28 10 34 0 243 160 53 80 XP_003384590.1 PREDICTED: tubulin polymerization-promoting protein family member 2-like [Amphimedon queenslandica] diamond 84 42.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
31966872 31966872 PRJNA1143173_P_NODE_7358_length_311_cov_3.214286_g7332_i0 PRJNA1143173 7358 311 3.214286 9.99642946 Figites sp. ZJUH 2 2995277 Arthropoda Arthropoda 58.2 2.94e-7   NR UZT67535.1 2995277 g7332 i0 47.4 2.60450160771704 57 30 55 0 294 124 110 166 UZT67535.1 cytochrome b [Figites sp. ZJUH 20220010] diamond 810 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Figites Figites sp. ZJUH 20220010
32315383 32315383 PRJNA1143173_P_NODE_13839_length_299_cov_5.287611_g13813_i0 PRJNA1143173 13839 299 5.287611 15.80995689 Heterodontus francisci 7792 Chordata Chordata 55.1 3.52e-6   NR XP_067914660.1 7792 g13813 i0 31.3 1.92642140468227 96 60 90.3 2 278 9 671 766 XP_067914660.1 uncharacterized protein wu:fj29h11 isoform X2 [Heterodontus francisci] diamond 576 55.1 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Heterodontiformes Heterodontidae Heterodontus Heterodontus francisci
32315384 32315384 PRJNA1143173_P_NODE_15459_length_298_cov_4.724444_g15433_i0 PRJNA1143173 15459 298 4.724444 14.07884312 Clunio marinus 568069 Arthropoda Arthropoda 159 1.1899999999999997e-42   NR CRK93348.1 568069 g15433 i0 80.4 0.976510067114094 97 19 97.7 0 294 4 656 752 CRK93348.1 CLUMA_CG006889, isoform A [Clunio marinus] diamond 291 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
32441910 32441910 PRJNA1143173_P_NODE_19959_length_287_cov_3.799065_g19933_i0 PRJNA1143173 19959 287 3.799065 10.90331655 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 60.8 2.58e-8   NR KAK9875821.1 420089 g19933 i0 49.3 0.721254355400697 69 32 71.1 2 285 82 332 398 KAK9875821.1 hypothetical protein WA026_009608 [Henosepilachna vigintioctopunctata] diamond 207 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
32536747 32536747 PRJNA1143173_P_NODE_41039_length_220_cov_6.857143_g41013_i0 PRJNA1143173 41039 220 6.857143 15.0857146 Pleurodeles waltl 8319 Chordata Chordata 45.4 0.0028   NR KAJ1125738.1 8319 g41013 i0 46.2 0.886363636363636 65 31 85.9 2 30 218 68 130 KAJ1125738.1 hypothetical protein NDU88_004161 [Pleurodeles waltl] diamond 195 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Salamandridae Pleurodeles Pleurodeles waltl

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