RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB25789 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
1297303 1297303 PRJEB25789_S_NODE_13962_length_269_cov_0.948980_g13883_i0 PRJEB25789 13962 269 0.94898 2.5527562 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 149 1.04e-44   NR XP_032579795.1 7238 g13883 i0 87.1 60.1895910780669 85 11 94.8 0 7 261 1 85 XP_032579795.1 14-3-3 protein zeta-like [Drosophila sechellia] diamond 16191 150 0.993333333333333 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila sechellia
6401284 6401284 PRJEB25789_S_NODE_17246_length_249_cov_0.875000_g17167_i0 PRJEB25789 17246 249 0.875 2.17875 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 139 4.06e-38   NR XP_054275300.1 74068 g17167 i0 98.7 0.903614457831325 75 1 90.4 0 23 247 172 246 XP_054275300.1 uncharacterized protein LOC128994640 [Macrosteles quadrilineatus] diamond 225 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
6401443 6401443 PRJEB25789_S_NODE_6826_length_353_cov_1.100000_g6747_i0 PRJEB25789 6826 353 1.1 3.883 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 230 3.45e-75   NR XP_054262366.1 74068 g6747 i0 93.2 0.994334277620397 117 8 99.4 0 351 1 42 158 XP_054262366.1 muscle-specific protein 20-like [Macrosteles quadrilineatus] diamond 351 230 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
11501199 11501199 PRJEB25789_S_NODE_18370_length_246_cov_0.884393_g18291_i0 PRJEB25789 18370 246 0.884393 2.17560678 Homalodisca vitripennis 197043 Arthropoda Arthropoda 150 2.49e-45   NR XP_046679923.1 197043 g18291 i0 94.7 1.82926829268293 75 4 91.5 0 1 225 9 83 XP_046679923.1 40S ribosomal protein S21-like [Homalodisca vitripennis] diamond 450 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
14051439 14051439 PRJEB25789_S_NODE_5632_length_380_cov_2.159609_g5553_i0 PRJEB25789 5632 380 2.159609 8.2065142 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 180 1.1299999999999999e-52   NR XP_054262026.1 74068 g5553 i0 73.4 0.860526315789474 109 27 84.5 1 380 60 271 379 XP_054262026.1 serine protease snake-like [Macrosteles quadrilineatus] diamond 327 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
16599989 16599989 PRJEB25789_S_NODE_17654_length_248_cov_0.880000_g17575_i0 PRJEB25789 17654 248 0.88 2.1824 Homalodisca vitripennis 197043 Arthropoda Arthropoda 147 1.29e-41   NR AAT01080.1 197043 g17575 i0 88.9 2.92741935483871 81 9 98 0 5 247 66 146 AAT01080.1 putative mitochondrial porin [Homalodisca vitripennis] diamond 726 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
17874725 17874725 PRJEB25789_S_NODE_14435_length_265_cov_1.604167_g14356_i0 PRJEB25789 14435 265 1.604167 4.25104255 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 154 1.28e-44   NR XP_054282118.1 74068 g14356 i0 94.3 0.99622641509434 88 5 99.6 0 264 1 176 263 XP_054282118.1 60S ribosomal protein L6 [Macrosteles quadrilineatus] diamond 264 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
17874822 17874822 PRJEB25789_S_NODE_19055_length_244_cov_0.900585_g18976_i0 PRJEB25789 19055 244 0.900585 2.1974274 Insecta 50557 Arthropoda Arthropoda 104 7.630000000000001e-27   NR PSN31606.1 6973 g18976 i0 100 11.4959016393443 52 0 63.9 0 2 157 73 124 PSN31606.1 40S ribosomal protein S28 [Blattella germanica] diamond 2805 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
19148662 19148662 PRJEB25789_S_NODE_18316_length_246_cov_0.890173_g18237_i0 PRJEB25789 18316 246 0.890173 2.18982558 Opisthokonta 33154 Arthropoda Arthropoda 140 2.88e-40   NR KAG7163974.1 6706 g18237 i0 81 128.207317073171 79 15 96.3 0 241 5 48 126 KAG7163974.1 60S ribosomal protein L11-2-like [Homarus americanus] diamond 31539 141 0.99290780141844 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
20424014 20424014 PRJEB25789_S_NODE_6657_length_356_cov_1.530035_g6578_i0 PRJEB25789 6657 356 1.530035 5.4469246 Insecta 50557 Arthropoda Arthropoda 205 1.08e-63   NR XP_039286565.1 108931 g6578 i0 88.7 5.74719101123596 115 13 96.9 0 11 355 1 115 XP_039286565.1 ADP,ATP carrier protein 1 [Nilaparvata lugens] diamond 2046 207 0.990338164251208 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
21699966 21699966 PRJEB25789_S_NODE_4538_length_416_cov_1.699708_g4459_i0 PRJEB25789 4538 416 1.699708 7.07078528 Homalodisca vitripennis 197043 Arthropoda Arthropoda 164 3.04e-44   NR KAG8294079.1 197043 g4459 i0 59.2 1.02403846153846 142 52 98.1 1 415 8 569 710 KAG8294079.1 hypothetical protein J6590_003249 [Homalodisca vitripennis] diamond 426 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
24248921 24248921 PRJEB25789_S_NODE_13420_length_273_cov_1.155000_g13341_i0 PRJEB25789 13420 273 1.155 3.15315 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 129 4.23e-35   NR XP_014243795.1 79782 g13341 i0 78.6 23.967032967033 84 18 92.3 0 2 253 102 185 XP_014243795.1 40S ribosomal protein S5-like [Cimex lectularius] diamond 6543 130 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
27412666 27412666 PRJEB25789_S_NODE_14183_length_267_cov_1.427835_g14104_i0 PRJEB25789 14183 267 1.427835 3.81231945 Anoplophora glabripennis 217634 Arthropoda Arthropoda 102 1.55e-25   NR XP_018578213.1 217634 g14104 i0 84.1 6.25842696629214 63 10 70.8 0 2 190 71 133 XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis] diamond 1671 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
27823085 27823085 PRJEB25789_S_NODE_2164_length_574_cov_2.115768_g2085_i0 PRJEB25789 2164 574 2.115768 12.14450832 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 212 1.2900000000000001e-59   NR XP_054276644.1 74068 g2085 i0 78.9 0.794425087108014 152 31 79.4 1 516 61 2786 2936 XP_054276644.1 titin-like [Macrosteles quadrilineatus] diamond 456 212 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
28043917 28043917 PRJEB25789_S_NODE_19085_length_244_cov_0.877193_g19006_i0 PRJEB25789 19085 244 0.877193 2.14035092 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 51.2 7.95e-6   NR XP_054286636.1 74068 g19006 i0 56 0.614754098360656 50 6 54.1 2 133 2 74 113 XP_054286636.1 phospholipid scramblase 1-like isoform X2 [Macrosteles quadrilineatus] diamond 150 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
28707085 28707085 PRJEB25789_S_NODE_11167_length_293_cov_1.050000_g11088_i0 PRJEB25789 11167 293 1.05 3.0765 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 186 3.2299999999999988e-55   NR XP_054290546.1 74068 g11088 i0 93.8 0.993174061433447 97 6 99.3 0 3 293 245 341 XP_054290546.1 phosphoglycerate kinase-like [Macrosteles quadrilineatus] diamond 291 186 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
29370086 29370086 PRJEB25789_S_NODE_19969_length_241_cov_1.017857_g19890_i0 PRJEB25789 19969 241 1.017857 2.45303537 Folsomia candida 158441 Arthropoda Arthropoda 59.7 2.97e-8   NR OXA61698.1 158441 g19890 i0 39.7 0.970954356846473 78 44 97.1 2 2 235 78 152 OXA61698.1 Heterogeneous nuclear ribonucleoprotein U [Folsomia candida] diamond 234 59.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
29527979 29527979 PRJEB25789_S_NODE_18690_length_245_cov_0.895349_g18611_i0 PRJEB25789 18690 245 0.895349 2.19360505 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 82 5.62e-16   NR XP_054274031.1 74068 g18611 i0 68.1 0.844897959183673 69 21 84.5 1 245 39 618 685 XP_054274031.1 inter-alpha-trypsin inhibitor heavy chain H3-like isoform X2 [Macrosteles quadrilineatus] diamond 207 82 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
29527981 29527981 PRJEB25789_S_NODE_8550_length_323_cov_1.536000_g8471_i0 PRJEB25789 8550 323 1.536 4.96128 Petrolisthes manimaculis 1843537 Arthropoda Arthropoda 75.1 5.05e-14   NR KAK4289376.1 1843537 g8471 i0 50 0.891640866873065 96 46 87.3 1 1 282 54 149 KAK4289376.1 hypothetical protein Pmani_037644 [Petrolisthes manimaculis] diamond 288 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes manimaculis
29748637 29748637 PRJEB25789_S_NODE_6151_length_368_cov_0.816949_g6072_i0 PRJEB25789 6151 368 0.816949 3.00637232 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 85.9 4.37e-18   NR XP_054290123.1 74068 g6072 i0 86.5 0.423913043478261 52 7 42.4 0 367 212 135 186 XP_054290123.1 transcription factor BTF3 homolog 4-like [Macrosteles quadrilineatus] diamond 156 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
31170367 31170367 PRJEB25789_S_NODE_18055_length_247_cov_0.867816_g17976_i0 PRJEB25789 18055 247 0.867816 2.14350552 Homalodisca vitripennis 197043 Arthropoda Arthropoda 148 2.45e-39   NR KAG8242293.1 197043 g17976 i0 95.1 1.9919028340081 82 4 99.6 0 2 247 408 489 KAG8242293.1 pre-mRNA-splicing factor cwc22 [Homalodisca vitripennis] diamond 492 148 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
31423596 31423596 PRJEB25789_S_NODE_19536_length_242_cov_1.366864_g19457_i0 PRJEB25789 19536 242 1.366864 3.30781088 Homalodisca vitripennis 197043 Arthropoda Arthropoda 160 4.31e-49   NR XP_046665593.1 197043 g19457 i0 98.8 0.991735537190083 80 1 99.2 0 242 3 43 122 XP_046665593.1 60S ribosomal protein L31 [Homalodisca vitripennis] diamond 240 160 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
31898085 31898085 PRJEB25789_S_NODE_17017_length_250_cov_0.870056_g16938_i0 PRJEB25789 17017 250 0.870056 2.17514 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 53.1 8.48e-6   NR XP_054261970.1 74068 g16938 i0 86.2 0.348 29 3 33.6 1 2 85 367 395 XP_054261970.1 nucleosome assembly protein 1-like 1 [Macrosteles quadrilineatus] diamond 87 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
32688363 32688363 PRJEB25789_S_NODE_16000_length_255_cov_1.054945_g15921_i0 PRJEB25789 16000 255 1.054945 2.69010975 Nephotettix cincticeps 94400 Arthropoda Arthropoda 170 1.28e-47   NR BAQ94504.1 94400 g15921 i0 94.1 1 85 5 100 0 1 255 563 647 BAQ94504.1 transferrin [Nephotettix cincticeps] diamond 255 170 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Nephotettix Nephotettix cincticeps

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