RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJEB7614" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7614 · 23 ✖
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
1413329 1413329 PRJEB7614_P_NODE_142_length_537_cov_17.259843_g109_i0 PRJEB7614 142 537 17.259843 92.68535691 Satyrium ilicis 876074 Arthropoda Arthropoda 54.7 0.015   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g109 i0 100 0.162011173184358 29 0 5 0 509 537 21475584 21475556 Satyrium ilicis genome assembly, chromosome: 12 blastn 87 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
1413338 1413338 PRJEB7614_P_NODE_5542_length_183_cov_11.863636_g5475_i0 PRJEB7614 5542 183 11.863636 21.71045388 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g5475 i0 100 0.153005464480874 28 0 15 0 77 104 1021 994 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
15441169 15441169 PRJEB7614_P_NODE_4653_length_195_cov_7.740964_g4586_i0 PRJEB7614 4653 195 7.740964 15.0948798 Anarta stigmosa 1869462 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|2918376566|emb|OZ237991.1| 1869462 g4586 i0 100 0.143589743589744 28 0 14 0 88 115 19924871 19924898 Anarta stigmosa genome assembly, chromosome: 15 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
16715386 16715386 PRJEB7614_P_NODE_4494_length_197_cov_85.422619_g4427_i0 PRJEB7614 4494 197 85.422619 168.28255943 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1964798739|emb|OC861788.1| 1979941 g4427 i0 96.875 0.16243654822335 32 1 16 0 17 48 3738 3707 Medioppia subpectinata blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
25525690 25525690 PRJEB7614d_S_NODE_681_length_249_cov_3.864486_g643_i0 PRJEB7614 681 249 3.864486 9.62257014 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1963352837|emb|OE839734.1| 629358 g643 i0 100 0.112449799196787 28 0 11 0 89 116 121538 121565 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
25525703 25525703 PRJEB7614e_S_NODE_729_length_265_cov_33.965217_g721_i0 PRJEB7614 729 265 33.965217 90.00782505 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g721 i0 100 0.105660377358491 28 0 11 0 82 109 1021 994 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
25661645 25661645 PRJEB7614a_S_NODE_70938_length_227_cov_7.265625_g69734_i0 PRJEB7614 70938 227 7.265625 16.49296875 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g69734 i0 94.595 0.651982378854626 37 0 15 2 37 71 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
25752652 25752652 PRJEB7614b_S_NODE_26_length_518_cov_24542.596273_g25_i0 PRJEB7614 26 518 24542.596273 127130.64869414 root 1 Root_unresolved Root_unresolved 93.5 2.99e-14   NTclustered gi|2488168007|emb|OC981435.1| 77745 g25 i0 100 10.7625482625483 50 0 10 0 1 50 9 58 Chydorus sphaericus partial EOG090X0EPT gene for EOG090X0EPT blastn 5575 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Chydoridae Chydorus Chydorus sphaericus
25797693 25797693 PRJEB7614a_S_NODE_10355_length_463_cov_16.098131_g9280_i0 PRJEB7614 10355 463 16.098131 74.53434653 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g9280 i0 90.909 0.0950323974082073 44 1 9 2 87 127 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
25797695 25797695 PRJEB7614a_S_NODE_112587_length_174_cov_2.302158_g111383_i0 PRJEB7614 112587 174 2.302158 4.00575492 Timema poppense 170557 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1946896637|emb|OD014535.1| 170557 g111383 i0 96.97 0.189655172413793 33 1 19 0 46 78 7407 7375 1_Tps_b3v08 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
25797707 25797707 PRJEB7614a_S_NODE_61363_length_245_cov_8.819048_g60159_i0 PRJEB7614 61363 245 8.819048 21.6066676 Chelidura thaleri 2546182 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g60159 i0 100 0.114285714285714 28 0 11 0 64 91 5916427 5916400 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
25797709 25797709 PRJEB7614a_S_NODE_67939_length_232_cov_29.142132_g66735_i0 PRJEB7614 67939 232 29.142132 67.60974624 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g66735 i0 100 0.120689655172414 28 0 12 0 80 107 1021 994 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
25797746 25797746 PRJEB7614d_S_NODE_739_length_243_cov_4.024038_g701_i0 PRJEB7614 739 243 4.024038 9.77841234 Chelidura thaleri 2546182 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g701 i0 100 0.11522633744856 28 0 12 0 37 64 5916427 5916400 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
25933963 25933963 PRJEB7614d_S_NODE_748_length_242_cov_7.884058_g710_i0 PRJEB7614 748 242 7.884058 19.07942036 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1946153605|emb|OD012397.1| 170557 g710 i0 100 0.115702479338843 28 0 12 0 103 130 9121 9148 1_Tps_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
26024652 26024652 PRJEB7614a_S_NODE_105948_length_180_cov_2.841379_g104744_i0 PRJEB7614 105948 180 2.841379 5.1144822 root 1 Root_unresolved Root_unresolved 287 3.85e-73   NTclustered gi|1937914967|emb|OA916119.1| 399045 g104744 i0 95.531 492.261111111111 179 8 99 0 2 180 217 39 Notodromas monacha blastn 88607 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
26069937 26069937 PRJEB7614a_S_NODE_83493_length_207_cov_8.052326_g82289_i0 PRJEB7614 83493 207 8.052326 16.66831482 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|1963352837|emb|OE839734.1| 629358 g82289 i0 100 0.135265700483092 28 0 14 0 90 117 121565 121538 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
26160850 26160850 PRJEB7614c_S_NODE_2485_length_181_cov_5.513699_g2484_i0 PRJEB7614 2485 181 5.513699 9.97979519 root 1 Root_unresolved Root_unresolved 231 1.84e-56   NTclustered gi|1936713461|emb|LR913384.1| 69355 g2484 i0 100 122.988950276243 125 0 69 0 1 125 1822 1698 Darwinula stevensoni blastn 22261 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
26206247 26206247 PRJEB7614e_S_NODE_350_length_325_cov_5.479310_g342_i0 PRJEB7614 350 325 5.47931 17.8077575 Timema douglasi 61478 Arthropoda Arthropoda 508 1.51e-139   NTclustered gi|1936951944|emb|OA671092.1| 61478 g342 i0 97.324 93.5415384615385 299 8 92 0 24 322 7 305 1_Tdi_b3v08 blastn 30401 508 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
26342066 26342066 PRJEB7614d_S_NODE_2055_length_179_cov_5.319444_g2017_i0 PRJEB7614 2055 179 5.319444 9.52180476 Charissa obscurata 204503 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2919559730|emb|OZ238369.1| 204503 g2017 i0 96.875 0.905027932960894 32 1 18 0 143 174 2155597 2155566 Charissa obscurata genome assembly, chromosome: 3 blastn 162 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
26432630 26432630 PRJEB7614c_S_NODE_895_length_215_cov_445.711111_g894_i0 PRJEB7614 895 215 445.711111 958.27888865 root 1 Root_unresolved Root_unresolved 95.3 3.11e-15   NTclustered gi|2488168007|emb|OC981435.1| 77745 g894 i0 96.491 27.4186046511628 57 2 27 0 1 57 4 60 Chydorus sphaericus partial EOG090X0EPT gene for EOG090X0EPT blastn 5895 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Chydoridae Chydorus Chydorus sphaericus
26478306 26478306 PRJEB7614b_S_NODE_608_length_250_cov_87.790698_g606_i0 PRJEB7614 608 250 87.790698 219.476745 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g606 i0 100 0.112 28 0 11 0 160 187 994 1021 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
32981185 32981185 PRJEB7614a_S_NODE_60115_length_248_cov_3.708920_g58911_i0 PRJEB7614 60115 248 3.70892 9.1981216 Lasius niger 67767 Arthropoda Arthropoda 47.4 8.09e-4   NR KMQ86303.1 67767 g58911 i0 45 0.483870967741935 40 22 48.4 0 3 122 206 245 KMQ86303.1 copia protein [Lasius niger] diamond 120 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
33134654 33134654 PRJEB7614a_S_NODE_52103_length_266_cov_4.476190_g50899_i0 PRJEB7614 52103 266 4.47619 11.9066654 Myzus persicae 13164 Arthropoda Arthropoda 42.7 0.0495   NR XP_022163951.1 13164 g50899 i0 55.6 0.406015037593985 36 16 40.6 0 138 245 543 578 XP_022163951.1 uncharacterized protein LOC111029296 [Myzus persicae] diamond 108 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae

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