RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJEB50765" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50765 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
1393949 1393949 PRJEB50765_P_NODE_1442_length_252_cov_2.013953_g1418_i0 PRJEB50765 1442 252 2.013953 5.07516156 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 89.4 4.94e-20   NR KAG1671722.1 424472 g1418 i0 61.3 7.63095238095238 75 28 89.3 1 248 24 94 167 KAG1671722.1 60S ribosomal protein L17 [Nymphon striatum] diamond 1923 89.7 0.996655518394649 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
9919538 9919538 PRJEB50765_P_NODE_1808_length_217_cov_1.877778_g1784_i0 PRJEB50765 1808 217 1.877778 4.07477826 Idotea baltica 82763 Arthropoda Arthropoda 115 1.9e-30   NR MCL4120794.1 82763 g1784 i0 73.6 0.995391705069124 72 19 99.5 0 216 1 60 131 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 216 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
23071563 23071563 PRJEB50765_P_NODE_2039_length_201_cov_1.530488_g2015_i0 PRJEB50765 2039 201 1.530488 3.07628088 Nymphon striatum 424472 Arthropoda Arthropoda 99 3.53e-24   NR KAG1673498.1 424472 g2015 i0 76.6 1.91044776119403 64 15 95.5 0 1 192 116 179 KAG1673498.1 60S ribosomal protein L23a [Nymphon striatum] diamond 384 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
28139277 28139277 PRJEB50765_P_NODE_1305_length_268_cov_2.043290_g1281_i0 PRJEB50765 1305 268 2.04329 5.4760172 Coptotermes formosanus 36987 Arthropoda Arthropoda 60.1 1.67e-8   NR AEW67351.1 36987 g1281 i0 56.5 0.514925373134328 46 20 51.5 0 267 130 105 150 AEW67351.1 carbohydrate binding module, partial [Coptotermes formosanus] diamond 138 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
29433228 29433228 PRJEB50765_P_NODE_850_length_358_cov_1.311526_g826_i0 PRJEB50765 850 358 1.311526 4.69526308 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 77.8 6.3e-15   NR ADD38186.1 72036 g826 i0 37.3 0.988826815642458 118 69 98.9 1 355 2 1 113 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 354 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29742322 29742322 PRJEB50765_P_NODE_830_length_365_cov_3.951220_g806_i0 PRJEB50765 830 365 3.95122 14.421953 Metazoa 33208 Arthropoda Arthropoda 49.7 4.91e-4   NR XP_023015979.1 7539 g806 i0 59 2.22739726027397 39 15 31.2 1 151 264 292 330 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 813 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
30437835 30437835 PRJEB50765_P_NODE_2913_length_162_cov_1.248000_g2889_i0 PRJEB50765 2913 162 1.248 2.02176 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.1 4.26e-21   NR CAB3374981.1 197152 g2889 i0 78.8 6.81481481481481 52 11 96.3 0 3 158 88 139 CAB3374981.1 Hypothetical predicted protein [Cloeon dipterum] diamond 1104 95.5 0.995811518324607 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
30633670 30633670 PRJEB50765_P_NODE_3173_length_154_cov_1.418803_g3149_i0 PRJEB50765 3173 154 1.418803 2.18495662 Acartia pacifica 335913 Arthropoda Arthropoda 61.2 3.8e-10   NR ALS04298.1 335913 g3149 i0 69 2.61038961038961 42 13 81.8 0 28 153 2 43 ALS04298.1 60S ribosomal protein L27 [Acartia pacifica] diamond 402 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Acartiidae Acartia Acartia pacifica
30785085 30785085 PRJEB50765_P_NODE_1934_length_209_cov_0.889535_g1910_i0 PRJEB50765 1934 209 0.889535 1.85912815 Caerostris 172845 Arthropoda Arthropoda 95.1 7.1e-23   NR GIY27871.1 172846 g1910 i0 75.4 3.60287081339713 61 12 87.6 1 26 208 1 58 GIY27871.1 40S ribosomal protein S18 [Caerostris extrusa] diamond 753 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
32214950 32214950 PRJEB50765_P_NODE_2918_length_162_cov_1.208000_g2894_i0 PRJEB50765 2918 162 1.208 1.95696 Idotea baltica 82763 Arthropoda Arthropoda 68.2 8.48e-13   NR MCL4135713.1 82763 g2894 i0 64.7 11.2407407407407 51 18 94.4 0 158 6 64 114 MCL4135713.1 hypothetical protein [Idotea baltica] diamond 1821 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica

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