RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA672101" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA672101 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
1917982 1917982 PRJNA672101_S_NODE_16562_length_302_cov_4.606987_g16531_i0 PRJNA672101 16562 302 4.606987 13.91310074 Coccinella septempunctata 41139 Arthropoda Arthropoda 311 4.2e-80   NTclustered gi|2125250080|ref|XM_044892109.1| 41139 g16531 i0 86.159 0.956953642384106 289 38 95 2 16 302 580 292 PREDICTED: Coccinella septempunctata muscle LIM protein 1 (LOC123309150), transcript variant X6, mRNA blastn 289 311 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
2440802 2440802 PRJNA672101_S_NODE_14342_length_316_cov_2.967078_g14311_i0 PRJNA672101 14342 316 2.967078 9.37596648 Drosophila 7215 Arthropoda Arthropoda 58.4 6.36e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g14311 i0 100 1.70569620253165 31 0 10 0 243 273 107 77 PREDICTED: Drosophila nasuta potassium voltage-gated channel protein Shaker (LOC132796862), transcript variant X2, mRNA blastn 539 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
3192682 3192682 PRJNA672101_S_NODE_16043_length_305_cov_4.538793_g16012_i0 PRJNA672101 16043 305 4.538793 13.84331865 Armadillidium vulgare 13347 Arthropoda Arthropoda 544 3.85e-150   NTclustered gi|1220106000|gb|MF187613.1| 13347 g16012 i0 99.01 64.4262295081967 303 3 99 0 1 303 5661 5359 Armadillidium vulgare strain WXf mitochondrion blastn 19650 544 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
5745529 5745529 PRJNA672101_S_NODE_33605_length_240_cov_5.922156_g33574_i0 PRJNA672101 33605 240 5.922156 14.2131744 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1184387702|emb|LT835105.1| 85552 g33574 i0 100 0.2375 29 0 12 0 212 240 34 6 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
9570621 9570621 PRJNA672101_S_NODE_4168_length_424_cov_15.646724_g4137_i0 PRJNA672101 4168 424 15.646724 66.34210976 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g4137 i0 100 3.26179245283019 30 0 7 0 136 165 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
10094155 10094155 PRJNA672101_S_NODE_19208_length_289_cov_1.907407_g19177_i0 PRJNA672101 19208 289 1.907407 5.51240623 Aphididae 27482 Arthropoda Arthropoda 435 2.27e-117   NTclustered gi|28629120|gb|AF487719.1| 40932 g19177 i0 93.793 31.0173010380623 290 16 100 2 1 289 223 511 Rhopalosiphum padi 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 8964 435 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
12121033 12121033 PRJNA672101_S_NODE_17550_length_297_cov_2.156250_g17519_i0 PRJNA672101 17550 297 2.15625 6.4040625 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 102 2.7e-17   NTclustered gi|2237324038|ref|XM_048149352.1| 1035111 g17519 i0 96.721 20.2828282828283 61 2 21 0 4 64 369 429 PREDICTED: Leguminivora glycinivorella 60S acidic ribosomal protein P1 (LOC125241060), mRNA blastn 6024 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
12121045 12121045 PRJNA672101_S_NODE_18710_length_291_cov_4.669725_g18679_i0 PRJNA672101 18710 291 4.669725 13.58889975 Artemia franciscana 6661 Arthropoda Arthropoda 381 3.029999999999999e-101   NTclustered gi|2743069846|ref|XM_065704016.1| 6661 g18679 i0 90.345 0.996563573883162 290 28 99 0 2 291 6779 7068 PREDICTED: Artemia franciscana histone-lysine N-methyltransferase trithorax-like (LOC136027077), mRNA blastn 290 381 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12644834 12644834 PRJNA672101_S_NODE_28750_length_250_cov_5.559322_g28719_i0 PRJNA672101 28750 250 5.559322 13.898305 Timema 61471 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1947616272|emb|OD657499.1| 61472 g28719 i0 100 0.336 28 0 11 0 185 212 396 423 4_Tbi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
14671070 14671070 PRJNA672101_S_NODE_31692_length_244_cov_2.210526_g31661_i0 PRJNA672101 31692 244 2.210526 5.39368344 Penaeus monodon 6687 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1832334880|gb|MK599468.1| 6687 g31661 i0 100 0.586065573770492 30 0 12 0 215 244 116 87 Penaeus monodon C-type lectin mRNA, complete cds blastn 143 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
14671114 14671114 PRJNA672101_S_NODE_35272_length_208_cov_4.800000_g35241_i0 PRJNA672101 35272 208 4.8 9.984 Timema bartmani 61472 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|1946279845|emb|OD564767.1| 61472 g35241 i0 100 0.134615384615385 28 0 13 0 173 200 18306 18279 4_Tbi_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
15944820 15944820 PRJNA672101_S_NODE_7213_length_376_cov_1.778878_g7182_i0 PRJNA672101 7213 376 1.778878 6.68858128 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1184387702|emb|LT835105.1| 85552 g7182 i0 100 0.151595744680851 29 0 8 0 1 29 6 34 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
17220160 17220160 PRJNA672101_S_NODE_7334_length_374_cov_5.196013_g7303_i0 PRJNA672101 7334 374 5.196013 19.43308862 Metopolophium dirhodum 44670 Arthropoda Arthropoda 473 6.409999999999999e-129   NTclustered gi|2621248383|ref|XM_061016724.1| 44670 g7303 i0 89.894 5.14705882352941 376 27 99 7 6 374 629 1000 PREDICTED: Metopolophium dirhodum single-pass membrane and coiled-coil domain-containing protein 4 (LOC132946678), transcript variant X1, mRNA blastn 1925 473 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
18494312 18494312 PRJNA672101_S_NODE_23375_length_270_cov_4.299492_g23344_i0 PRJNA672101 23375 270 4.299492 11.6086284 Anopheles nili 185578 Arthropoda Arthropoda 174 5.06e-39   NTclustered gi|2449486003|ref|XM_053824234.1| 185578 g23344 i0 84.884 4.91111111111111 172 26 64 0 91 262 219 48 PREDICTED: Anopheles nili 40S ribosomal protein S29 (LOC128731137), mRNA blastn 1326 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
19017203 19017203 PRJNA672101_S_NODE_12675_length_327_cov_3.098425_g12644_i0 PRJNA672101 12675 327 3.098425 10.13184975 Varroa 62624 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|1268019421|ref|XR_002683577.1| 62625 g12644 i0 100 0.599388379204893 28 0 9 0 3 30 8295 8322 PREDICTED: Varroa jacobsoni protein Tob1-like (LOC111265680), transcript variant X3, misc_RNA blastn 196 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa jacobsoni
23594730 23594730 PRJNA672101_S_NODE_21939_length_276_cov_5.689655_g21908_i0 PRJNA672101 21939 276 5.689655 15.7034478 Timema californicum 61474 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1962683356|emb|OE185345.1| 61474 g21908 i0 100 0.101449275362319 28 0 10 0 89 116 6361 6388 2_Tcm_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
23594790 23594790 PRJNA672101_S_NODE_25679_length_261_cov_3.845745_g25648_i0 PRJNA672101 25679 261 3.845745 10.03739445 Limnephilus lunatus 1218281 Arthropoda Arthropoda 62.1 3.95e-5   NTclustered gi|2752247056|tpg|BK062803.1| 1218281 g25648 i0 100 1.52490421455939 33 0 13 0 227 259 198250 198282 TPA_exp: Limnephilus lunatus cadhesin 1 (Caz1), cadhesin 2A (Caz2A), cadhesin 2B (Caz2B), cadhesin 3A (Caz3A), cadhesin 3B (Caz3B), TSAG-rich 18kDa protein (TSAG18), cadhesin 4 (Caz4), cadhesin 5 (Caz5), cadhesin 6 (Caz6), cadhesin 7 (Caz7), cadhesin 8 (Caz8), and cadhesin 9 (Caz9) genes, complete cds blastn 398 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Trichoptera Limnephilidae Limnephilus Limnephilus lunatus
24868182 24868182 PRJNA672101_S_NODE_26720_length_257_cov_5.907609_g26689_i0 PRJNA672101 26720 257 5.907609 15.18255513 Linepithema humile 83485 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2788948857|ref|XR_010888252.1| 83485 g26689 i0 100 0.108949416342412 28 0 11 0 77 104 327 300 PREDICTED: Linepithema humile uncharacterized lncRNA (LOC136997530), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Linepithema Linepithema humile
25391947 25391947 PRJNA672101_S_NODE_30580_length_247_cov_0.885057_g30549_i0 PRJNA672101 30580 247 0.885057 2.18609079 Artemia 6660 Arthropoda Arthropoda 451 1.88e-122   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g30549 i0 99.595 101.080971659919 247 1 100 0 1 247 1695 1449 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 24967 451 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);;