RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1032461" 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

  • PRJNA1032461 · 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
1441843 1441843 PRJNA1032461_S_NODE_5302_length_252_cov_1.280788_g5204_i0 PRJNA1032461 5302 252 1.280788 3.22758576 Insecta 50557 Arthropoda Arthropoda 139 5.1199999999999986e-40   NR XP_017787258.1 110193 g5204 i0 69 3.98809523809524 84 26 100 0 252 1 43 126 XP_017787258.1 PREDICTED: 60S ribosomal protein L27a [Nicrophorus vespilloides] diamond 1005 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
24393093 24393093 PRJNA1032461_S_NODE_12260_length_179_cov_1.192308_g12162_i0 PRJNA1032461 12260 179 1.192308 2.13423132 Euphydryas editha 104508 Arthropoda Arthropoda 92.8 4.74e-22   NR CAH2085183.1 104508 g12162 i0 62.7 2.96648044692737 59 22 98.9 0 2 178 38 96 CAH2085183.1 unnamed protein product [Euphydryas editha] diamond 531 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Euphydryas Euphydryas editha
27604060 27604060 PRJNA1032461_S_NODE_18884_length_164_cov_1.356522_g18786_i0 PRJNA1032461 18884 164 1.356522 2.22469608 Uroleucon formosanum 796250 Arthropoda Arthropoda 43.1 0.00952   NR KAL4105073.1 796250 g18786 i0 46.9 0.896341463414634 49 25 89.6 1 5 151 645 692 KAL4105073.1 hypothetical protein QTP88_020348 [Uroleucon formosanum] diamond 147 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
28740508 28740508 PRJNA1032461_S_NODE_21887_length_161_cov_3.410714_g21789_i0 PRJNA1032461 21887 161 3.410714 5.49124954 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00475   NR CAK9813121.1 597819 g21789 i0 48.6 3.26086956521739 35 18 65.2 0 130 26 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
28961748 28961748 PRJNA1032461_S_NODE_16648_length_167_cov_0.881356_g16550_i0 PRJNA1032461 16648 167 0.881356 1.47186452 Dalotia coriaria 877792 Arthropoda Arthropoda 49.7 4.73e-5   NR XP_065160016.1 877792 g16550 i0 60.5 1.36526946107784 38 15 68.3 0 116 3 362 399 XP_065160016.1 E3 ubiquitin-protein ligase RNF216-like isoform X1 [Dalotia coriaria] diamond 228 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
29182710 29182710 PRJNA1032461_S_NODE_21129_length_162_cov_1.026549_g21031_i0 PRJNA1032461 21129 162 1.026549 1.66300938 Chrysoperla carnea 189513 Arthropoda Arthropoda 100 5.519999999999999e-23   NR XP_044737437.1 189513 g21031 i0 77.4 2.94444444444444 53 12 98.1 0 2 160 521 573 XP_044737437.1 transcription elongation regulator 1 [Chrysoperla carnea] diamond 477 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
29687399 29687399 PRJNA1032461_S_NODE_21470_length_162_cov_0.920354_g21372_i0 PRJNA1032461 21470 162 0.920354 1.49097348 Diaphorina citri 121845 Arthropoda Arthropoda 65.9 6.46e-11   NR KAI5715793.1 121845 g21372 i0 58.5 9.72222222222222 53 22 98.1 0 2 160 192 244 KAI5715793.1 hypothetical protein M8J77_022481 [Diaphorina citri] diamond 1575 65.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
30572038 30572038 PRJNA1032461_S_NODE_21273_length_162_cov_0.920354_g21175_i0 PRJNA1032461 21273 162 0.920354 1.49097348 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 86.3 5.84e-18   NR KFM59342.1 407821 g21175 i0 79.2 1.96296296296296 53 11 98.1 0 162 4 638 690 KFM59342.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94, partial [Stegodyphus mimosarum] diamond 318 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
30983169 30983169 PRJNA1032461_S_NODE_15514_length_168_cov_0.873950_g15416_i0 PRJNA1032461 15514 168 0.87395 1.468236 Drosophila setifemur 2848635 Arthropoda Arthropoda 68.9 7.63e-12   NR KAH8380026.1 2848635 g15416 i0 65 1.07142857142857 60 12 98.2 2 2 166 733 788 KAH8380026.1 hypothetical protein KR009_008538 [Drosophila setifemur] diamond 180 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila setifemur
31101269 31101269 PRJNA1032461_S_NODE_16035_length_167_cov_1.152542_g15937_i0 PRJNA1032461 16035 167 1.152542 1.92474514 Insecta 50557 Arthropoda Arthropoda 60.5 6.54e-9   NR XP_049857660.1 7010 g15937 i0 51.9 3.91616766467066 54 26 97 0 162 1 9 62 XP_049857660.1 uncharacterized protein LOC126340574 [Schistocerca gregaria] diamond 654 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31386115 31386115 PRJNA1032461_S_NODE_21756_length_162_cov_0.920354_g21658_i0 PRJNA1032461 21756 162 0.920354 1.49097348 Palaemonidae 6695 Arthropoda Arthropoda 88.2 6.66e-19   NR XP_064104051.1 159736 g21658 i0 67.9 3.92592592592593 53 17 98.1 0 2 160 265 317 XP_064104051.1 uncharacterized protein LOC135213882 [Macrobrachium nipponense] diamond 636 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
31520602 31520602 PRJNA1032461_S_NODE_13996_length_169_cov_1.300000_g13898_i0 PRJNA1032461 13996 169 1.3 2.197 Halyomorpha halys 286706 Arthropoda Arthropoda 67.8 1.24e-12   NR XP_014286177.1 286706 g13898 i0 75.6 11.7337278106509 41 10 72.8 0 1 123 73 113 XP_014286177.1 small ribosomal subunit protein eS12 [Halyomorpha halys] diamond 1983 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
32469795 32469795 PRJNA1032461_S_NODE_15679_length_168_cov_0.873950_g15581_i0 PRJNA1032461 15679 168 0.87395 1.468236 Halotydeus destructor 2874060 Arthropoda Arthropoda 57.8 6.62e-8   NR KAI1278468.1 2874060 g15581 i0 67.6 0.607142857142857 34 11 60.7 0 12 113 191 224 KAI1278468.1 Phosphatidylinositide phosphatase SAC2 [Halotydeus destructor] diamond 102 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor

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