RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA624323" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA624323 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
8249573 8249573 PRJNA624323_P_NODE_9267_length_242_cov_12.857988_g9105_i0 PRJNA624323 9267 242 12.857988 31.11633096 Artemia franciscana 6661 Arthropoda Arthropoda 162 6.62e-50   NR KAK2708227.1 6661 g9105 i0 92.5 3.96694214876033 80 6 99.2 0 240 1 15 94 KAK2708227.1 hypothetical protein QYM36_013979 [Artemia franciscana] diamond 960 162 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27238535 27238535 PRJNA624323_P_NODE_8423_length_248_cov_0.880000_g8261_i0 PRJNA624323 8423 248 0.88 2.1824 Eurosta solidaginis 178769 Arthropoda Arthropoda 47 0.00123   NR XP_067628065.1 178769 g8261 i0 45 0.483870967741935 40 22 48.4 0 2 121 15 54 XP_067628065.1 SCAN domain-containing protein 3-like isoform X2 [Eurosta solidaginis] diamond 120 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Eurosta Eurosta solidaginis
27459930 27459930 PRJNA624323_P_NODE_6423_length_283_cov_1.361905_g6261_i0 PRJNA624323 6423 283 1.361905 3.85419115 Artemia franciscana 6661 Arthropoda Arthropoda 168 4.63e-49   NR KAK2708271.1 6661 g6261 i0 100 4.98233215547703 94 0 99.6 0 283 2 116 209 KAK2708271.1 hypothetical protein QYM36_014016 [Artemia franciscana] diamond 1410 168 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27491428 27491428 PRJNA624323_P_NODE_9083_length_244_cov_0.900585_g8921_i0 PRJNA624323 9083 244 0.900585 2.1974274 Sipha flava 143950 Arthropoda Arthropoda 86.3 3.18e-19   NR XP_025419343.1 143950 g8921 i0 59.7 0.885245901639344 72 28 87.3 1 10 222 29 100 XP_025419343.1 zinc finger BED domain-containing protein 5-like [Sipha flava] diamond 216 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
28091192 28091192 PRJNA624323_P_NODE_9225_length_243_cov_0.905882_g9063_i0 PRJNA624323 9225 243 0.905882 2.20129326 Artemia franciscana 6661 Arthropoda Arthropoda 81.3 1.08e-16   NR XP_065568763.1 6661 g9063 i0 71.2 0.641975308641975 52 15 64.2 0 212 57 30 81 XP_065568763.1 uncharacterized protein LOC136032368 [Artemia franciscana] diamond 156 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28533478 28533478 PRJNA624323_P_NODE_6267_length_287_cov_0.953271_g6105_i0 PRJNA624323 6267 287 0.953271 2.73588777 Bemisia tabaci 7038 Arthropoda Arthropoda 44.3 0.0176   NR XP_018895949.1 7038 g6105 i0 37.7 0.554006968641115 53 29 51.2 1 134 280 132 184 XP_018895949.1 PREDICTED: uncharacterized protein LOC109029778 [Bemisia tabaci] diamond 159 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28659719 28659719 PRJNA624323_P_NODE_8907_length_245_cov_0.895349_g8745_i0 PRJNA624323 8907 245 0.895349 2.19360505 Artemia franciscana 6661 Arthropoda Arthropoda 41.6 0.0412   NR KAK2725845.1 6661 g8745 i0 64.3 0.342857142857143 28 10 34.3 0 40 123 59 86 KAK2725845.1 hypothetical protein QYM36_000350 [Artemia franciscana] diamond 84 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29007246 29007246 PRJNA624323_P_NODE_6428_length_283_cov_1.200000_g6266_i0 PRJNA624323 6428 283 1.2 3.396 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 176 7.97e-49   NR KAH9409314.1 59818 g6266 i0 96.8 0.996466431095406 94 2 98.6 1 281 3 257 350 KAH9409314.1 hypothetical protein TYRP_010317 [Tyrophagus putrescentiae] diamond 282 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29133391 29133391 PRJNA624323_P_NODE_8909_length_245_cov_0.895349_g8747_i0 PRJNA624323 8909 245 0.895349 2.19360505 Artemia franciscana 6661 Arthropoda Arthropoda 75.9 7.82e-14   NR XP_065567285.1 6661 g8747 i0 55.1 0.844897959183673 69 31 84.5 0 242 36 282 350 XP_065567285.1 uncharacterized protein LOC136031543 [Artemia franciscana] diamond 207 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29259288 29259288 PRJNA624323_P_NODE_8609_length_247_cov_0.885057_g8447_i0 PRJNA624323 8609 247 0.885057 2.18609079 Artemia franciscana 6661 Arthropoda Arthropoda 49.3 1.9e-4   NR CAG4635756.1 6661 g8447 i0 53.2 0.57085020242915 47 20 54.7 1 8 142 221 267 CAG4635756.1 EOG090X0EO1 [Artemia franciscana] diamond 141 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30491354 30491354 PRJNA624323_P_NODE_1133_length_672_cov_4.368948_g979_i0 PRJNA624323 1133 672 4.368948 29.35933056 Artemia franciscana 6661 Arthropoda Arthropoda 80.1 2.41e-13   NR KAK2701872.1 6661 g979 i0 39.8 0.4375 98 59 43.8 0 519 226 1 98 KAK2701872.1 hypothetical protein QYM36_019470 [Artemia franciscana] diamond 294 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30965395 30965395 PRJNA624323_P_NODE_9354_length_242_cov_0.911243_g9192_i0 PRJNA624323 9354 242 0.911243 2.20520806 Artemia franciscana 6661 Arthropoda Arthropoda 60.5 2.08e-8   NR KAK2701638.1 6661 g9192 i0 43.7 3.59504132231405 71 40 88 0 27 239 294 364 KAK2701638.1 hypothetical protein QYM36_019721, partial [Artemia franciscana] diamond 870 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31091624 31091624 PRJNA624323_P_NODE_5115_length_321_cov_1.209677_g4953_i0 PRJNA624323 5115 321 1.209677 3.88306317 Artemia franciscana 6661 Arthropoda Arthropoda 91.7 7.34e-20   NR XP_065568792.1 6661 g4953 i0 43.1 0.953271028037383 102 58 95.3 0 320 15 130 231 XP_065568792.1 uncharacterized protein LOC136032410 [Artemia franciscana] diamond 306 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31154447 31154447 PRJNA624323_P_NODE_8855_length_245_cov_1.313953_g8693_i0 PRJNA624323 8855 245 1.313953 3.21918485 Artemia franciscana 6661 Arthropoda Arthropoda 61.6 6.75e-9   NR KAK2722761.1 6661 g8693 i0 44.8 0.820408163265306 67 37 82 0 207 7 18 84 KAK2722761.1 hypothetical protein QYM36_003078, partial [Artemia franciscana] diamond 201 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31281193 31281193 PRJNA624323_P_NODE_9035_length_244_cov_0.900585_g8873_i0 PRJNA624323 9035 244 0.900585 2.1974274 Artemia franciscana 6661 Arthropoda Arthropoda 75.1 3.72e-14   NR XP_065568921.1 6661 g8873 i0 43.7 4.27868852459016 87 42 98.4 1 244 5 85 171 XP_065568921.1 uncharacterized protein LOC136032579 [Artemia franciscana] diamond 1044 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31597788 31597788 PRJNA624323_P_NODE_1056_length_697_cov_2.169872_g904_i0 PRJNA624323 1056 697 2.169872 15.12400784 Artemia franciscana 6661 Arthropoda Arthropoda 236 3.88e-74   NR KAK2720214.1 6661 g904 i0 81.1 0.637015781922525 148 28 63.7 0 2 445 144 291 KAK2720214.1 hypothetical protein QYM36_004193 [Artemia franciscana] diamond 444 236 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32230494 32230494 PRJNA624323_P_NODE_7318_length_262_cov_38.142857_g7156_i0 PRJNA624323 7318 262 38.142857 99.93428534 Artemia franciscana 6661 Arthropoda Arthropoda 139 1.25e-40   NR KAK2709965.1 6661 g7156 i0 77 3.81297709923664 87 20 99.6 0 1 261 4 90 KAK2709965.1 hypothetical protein QYM36_013593 [Artemia franciscana] diamond 999 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32704079 32704079 PRJNA624323_P_NODE_6980_length_270_cov_1.492386_g6818_i0 PRJNA624323 6980 270 1.492386 4.0294422 Artemia franciscana 6661 Arthropoda Arthropoda 183 5.2699999999999984e-55   NR KAK2703652.1 6661 g6818 i0 98.9 0.988888888888889 89 1 98.9 0 269 3 72 160 KAK2703652.1 hypothetical protein QYM36_017948 [Artemia franciscana] diamond 267 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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