RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA610520" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA610520 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1864361 1864361 PRJNA610520_S_NODE_4222_length_505_cov_3.870370_g4137_i0 PRJNA610520 4222 505 3.87037 19.5453685 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.049   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g4137 i0 100 0.0554455445544554 28 0 6 0 195 222 5916427 5916400 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
1864454 1864454 PRJNA610520_S_NODE_60122_length_252_cov_3.564246_g60032_i0 PRJNA610520 60122 252 3.564246 8.98189992 Artemia franciscana 6661 Arthropoda Arthropoda 392 1.1899999999999997e-104   NTclustered gi|2743044318|ref|XM_065718372.1| 6661 g60032 i0 95.528 0.976190476190476 246 9 97 2 8 252 1167 923 PREDICTED: Artemia franciscana serine/threonine-protein phosphatase 2A catalytic subunit beta isoform (LOC136036252), mRNA blastn 246 392 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
9516719 9516719 PRJNA610520_S_NODE_22908_length_347_cov_15.872263_g22818_i0 PRJNA610520 22908 347 15.872263 55.07675261 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g22818 i0 100 3.98559077809798 30 0 9 0 41 70 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
9516916 9516916 PRJNA610520_S_NODE_7288_length_447_cov_47.868984_g7200_i0 PRJNA610520 7288 447 47.868984 213.97435848 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g7200 i0 90.909 0.0984340044742729 44 1 9 2 80 120 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
10792600 10792600 PRJNA610520_S_NODE_34149_length_311_cov_0.970588_g34059_i0 PRJNA610520 34149 311 0.970588 3.01852868 Anarta stigmosa 1869462 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2918376566|emb|OZ237991.1| 1869462 g34059 i0 100 0.090032154340836 28 0 9 0 158 185 19924871 19924898 Anarta stigmosa genome assembly, chromosome: 15 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
10792605 10792605 PRJNA610520_S_NODE_34969_length_308_cov_3.778723_g34879_i0 PRJNA610520 34969 308 3.778723 11.63846684 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 6.18e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g34879 i0 90.698 0.13961038961039 43 4 14 0 162 204 56559237 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
16450159 16450159 PRJNA610520_S_NODE_59613_length_253_cov_2.594444_g59523_i0 PRJNA610520 59613 253 2.594444 6.56394332 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 110 1.34e-19   NTclustered gi|2198822097|ref|XM_046891362.1| 362088 g59523 i0 88.043 33.6403162055336 92 11 36 0 139 230 1479 1388 PREDICTED: Diprion similis tubulin alpha-1 chain-like (LOC124411859), mRNA blastn 8511 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Diprion Diprion similis
20990824 20990824 PRJNA610520_S_NODE_46117_length_280_cov_5.009662_g46027_i0 PRJNA610520 46117 280 5.009662 14.0270536 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g46027 i0 100 0.103571428571429 29 0 10 0 227 255 1610 1638 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
23541005 23541005 PRJNA610520_S_NODE_71439_length_229_cov_2.153846_g71349_i0 PRJNA610520 71439 229 2.153846 4.93230734 Anopheles stephensi 30069 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1899754846|ref|XM_036060791.1| 30069 g71349 i0 96.97 1.1528384279476 33 0 14 1 113 145 2002 1971 PREDICTED: Anopheles stephensi dual specificity tyrosine-phosphorylation-regulated kinase 2 (LOC118514158), transcript variant X2, mRNA blastn 264 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles stephensi
23541015 23541015 PRJNA610520_S_NODE_9459_length_424_cov_2.435897_g9371_i0 PRJNA610520 9459 424 2.435897 10.32820328 Timema douglasi 61478 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1936902707|emb|OA565683.1| 61478 g9371 i0 100 0.0707547169811321 30 0 7 0 329 358 30001 29972 1_Tdi_b3v08 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
24814779 24814779 PRJNA610520_S_NODE_61420_length_250_cov_4.627119_g61330_i0 PRJNA610520 61420 250 4.627119 11.5677975 Timema douglasi 61478 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1936902707|emb|OA565683.1| 61478 g61330 i0 100 0.456 30 0 12 0 56 85 29972 30001 1_Tdi_b3v08 blastn 114 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi

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