RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA782235 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
17341423 17341423 PRJNA782235_P_NODE_11694_length_278_cov_1.502439_g11505_i0 PRJNA782235 11694 278 1.502439 4.17678042 Ceratitis capitata 7213 Arthropoda Arthropoda 150 2.02e-40   NR CAD7015493.1 7213 g11505 i0 89.5 2.46043165467626 76 8 82 0 276 49 205 280 CAD7015493.1 unnamed protein product [Ceratitis capitata] diamond 684 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
27496065 27496065 PRJNA782235_P_NODE_17543_length_250_cov_0.870056_g17354_i0 PRJNA782235 17543 250 0.870056 2.17514 Camponotus floridanus 104421 Arthropoda Arthropoda 45.1 0.0062   NR XP_025265271.1 104421 g17354 i0 45.5 0.66 55 29 64.8 1 187 26 50 104 XP_025265271.1 uncharacterized protein LOC112638231 [Camponotus floridanus] diamond 165 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Camponotus Camponotus floridanus
27843127 27843127 PRJNA782235_P_NODE_10244_length_288_cov_1.148837_g10055_i0 PRJNA782235 10244 288 1.148837 3.30865056 Trichonephila clavipes 2585209 Arthropoda Arthropoda 41.6 0.0447   NR GFW39564.1 2585209 g10055 i0 30.8 0.8125 78 47 75 2 275 60 29 105 GFW39564.1 hypothetical protein TNCV_2530081 [Trichonephila clavipes] diamond 234 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
27969553 27969553 PRJNA782235_P_NODE_11965_length_277_cov_0.995098_g11776_i0 PRJNA782235 11965 277 0.995098 2.75642146 Euwallacea fornicatus 995702 Arthropoda Arthropoda 135 1.05e-35   NR XP_066152325.1 995702 g11776 i0 66.3 1.02888086642599 95 28 98.6 1 275 3 330 424 XP_066152325.1 G protein-activated inward rectifier potassium channel 4-like isoform X2 [Euwallacea fornicatus] diamond 285 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
27978881 27978881 PRJNA782235_P_NODE_23565_length_245_cov_0.895349_g23376_i0 PRJNA782235 23565 245 0.895349 2.19360505 Opisthokonta 33154 Arthropoda Arthropoda 80.9 1.19e-15   NR XP_008550924.1 69319 g23376 i0 56.3 2.91428571428571 80 34 98 1 240 1 336 414 XP_008550924.1 aminomethyltransferase, mitochondrial [Microplitis demolitor] diamond 714 81.6 0.991421568627451 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
28042129 28042129 PRJNA782235_P_NODE_22185_length_246_cov_0.890173_g21996_i0 PRJNA782235 22185 246 0.890173 2.18982558 Insecta 50557 Arthropoda Arthropoda 115 2.43e-28   NR XP_024223007.1 132113 g21996 i0 65.4 20.7439024390244 81 28 98.8 0 246 4 309 389 XP_024223007.1 probable hydroxyacid-oxoacid transhydrogenase, mitochondrial isoform X2 [Bombus impatiens] diamond 5103 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus impatiens
28695980 28695980 PRJNA782235_P_NODE_27627_length_241_cov_0.916667_g27438_i0 PRJNA782235 27627 241 0.916667 2.20916747 Aphis craccivora 307492 Arthropoda Arthropoda 50.4 9.11e-6   NR KAF0759511.1 307492 g27438 i0 100 0.29875518672199203 24 0 29.9 0 169 240 1 24 KAF0759511.1 Uncharacterized protein FWK35_00006063 [Aphis craccivora] diamond 72 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
29011881 29011881 PRJNA782235_P_NODE_15848_length_253_cov_1.127778_g15659_i0 PRJNA782235 15848 253 1.127778 2.85327834 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 47.4 9.98e-4   NR RWS02945.1 1965070 g15659 i0 31.3 1.9802371541502 83 57 98.4 0 2 250 369 451 RWS02945.1 hypothetical protein B4U79_10363 [Dinothrombium tinctorium] diamond 501 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
29715148 29715148 PRJNA782235_P_NODE_12570_length_273_cov_1.330000_g12381_i0 PRJNA782235 12570 273 1.33 3.6309 Trombidiformes 83136 Arthropoda Arthropoda 179 2.95e-53   NR XP_015792934.1 32264 g12381 i0 92.2 4.94505494505495 90 7 98.9 0 2 271 153 242 XP_015792934.1 pre-mRNA-splicing factor RBM22 [Tetranychus urticae] diamond 1350 179 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30179848 30179848 PRJNA782235_P_NODE_19092_length_249_cov_0.875000_g18903_i0 PRJNA782235 19092 249 0.875 2.17875 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 76.6 2.62e-14   NR XP_027202866.1 6956 g18903 i0 57.3 0.987951807228916 82 1 98.8 1 2 247 225 272 XP_027202866.1 ATPase ASNA1 homolog [Dermatophagoides pteronyssinus] diamond 246 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
32086024 32086024 PRJNA782235_P_NODE_14038_length_264_cov_1.246073_g13849_i0 PRJNA782235 14038 264 1.246073 3.28963272 root 1 Root_unresolved Root_unresolved 52.4 1.82e-5   NR KAK9874503.1 420089 g13849 i0 36.8 1.68181818181818 76 39 76.1 2 39 239 139 214 KAK9874503.1 hypothetical protein WA026_002854 [Henosepilachna vigintioctopunctata] diamond 444 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
32171850 32171850 PRJNA782235_P_NODE_13278_length_269_cov_0.852041_g13089_i0 PRJNA782235 13278 269 0.852041 2.29199029 Nasutitermes takasagoensis 62960 Arthropoda Arthropoda 48.9 3.34e-4   NR BAM38487.2 62960 g13089 i0 37.3 0.925650557620818 83 45 92.6 2 16 264 386 461 BAM38487.2 3-hydroxy-3-methylglutaryl coenzyme A synthase-2 [Nasutitermes takasagoensis] diamond 249 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termitidae Nasutitermes Nasutitermes takasagoensis
32843988 32843988 PRJNA782235_P_NODE_21240_length_247_cov_0.885057_g21051_i0 PRJNA782235 21240 247 0.885057 2.18609079 Diptera 7147 Arthropoda Arthropoda 157 2.85e-44   NR XP_002071678.1 7260 g21051 i0 89 18.8380566801619 82 9 99.6 0 246 1 167 248 XP_002071678.1 bystin [Drosophila willistoni] diamond 4653 158 0.993670886075949 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila willistoni

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