RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1009807 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
154811 154811 PRJNA1009807_S_NODE_2081_length_216_cov_1.593220_g2053_i0 PRJNA1009807 2081 216 1.59322 3.4413552 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|1964503389|emb|OE840646.1| 629358 g2053 i0 100 0.12962962962963 28 0 13 0 79 106 115144 115171 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
5257751 5257751 PRJNA1009807_S_NODE_905_length_314_cov_5.334545_g877_i0 PRJNA1009807 905 314 5.334545 16.7504713 Speleorchestes sp. AD1084 2051767 Arthropoda Arthropoda 104 8e-18   NTclustered gi|1282187773|gb|KY921978.1| 2051767 g877 i0 83.478 5.14012738853503 115 16 36 3 128 239 2454 2568 Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence blastn 1614 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1084
6532973 6532973 PRJNA1009807_S_NODE_1406_length_255_cov_2.833333_g1378_i0 PRJNA1009807 1406 255 2.833333 7.22499915 Harbansus paucichelatus 178850 Arthropoda Arthropoda 99 2.93e-16   NTclustered gi|751143631|gb|KM875573.1| 178850 g1378 i0 75.214 10.9333333333333 234 45 89 12 2 227 343 571 Harbansus paucichelatus isolate M1 28S ribosomal RNA gene, partial sequence blastn 2788 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Myodocopida Philomedidae Harbansus Harbansus paucichelatus
10357921 10357921 PRJNA1009807_S_NODE_2469_length_200_cov_11.086957_g2441_i0 PRJNA1009807 2469 200 11.086957 22.173914 Galathea rostrata 1377960 Arthropoda Arthropoda 60.2 1.04e-4   NTclustered gi|527498840|gb|KF182504.1| 1377960 g2441 i0 92.857 3.29 42 2 21 1 139 180 854 814 Galathea rostrata voucher KC4767/ULLZ7681 18S ribosomal RNA gene, partial sequence blastn 658 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Galatheidae Galathea Galathea rostrata
14183465 14183465 PRJNA1009807_S_NODE_3272_length_179_cov_1.442857_g3244_i0 PRJNA1009807 3272 179 1.442857 2.58271403 Timema cristinae 61476 Arthropoda Arthropoda 58.4 3.26e-4   NTclustered gi|1946878153|emb|OC316793.1| 61476 g3244 i0 97.059 0.189944134078212 34 1 19 0 91 124 333653 333620 3_Tce_b3v08 blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
18853104 18853104 PRJNA1009807_S_NODE_3635_length_171_cov_4.439394_g3607_i0 PRJNA1009807 3635 171 4.439394 7.59136374 Artemia 6660 Arthropoda Arthropoda 316 4.6e-82   NTclustered gi|2295022767|gb|OP365120.1| 6661 g3607 i0 100 100.035087719298 171 0 100 0 1 171 756 586 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 17106 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
20127852 20127852 PRJNA1009807_S_NODE_2596_length_196_cov_501.490446_g2568_i0 PRJNA1009807 2596 196 501.490446 982.92127416 root 1 Root_unresolved Root_unresolved 357 3.2099999999999996e-94   NTclustered gi|78097480|gb|AC167666.4| 7176 g2568 i0 100 290.489795918367 193 0 98 0 4 196 1179 987 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 56936 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus

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