RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1215774" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1215774 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
6708756 6708756 PRJNA1215774_P_NODE_35266_length_355_cov_1.563830_g34946_i0 PRJNA1215774 35266 355 1.56383 5.5515965 Euthrix potatoria 624169 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2918370006|emb|OZ237893.1| 624169 g34946 i0 92.308 0.188732394366197 39 2 11 1 1 39 4651331 4651294 Euthrix potatoria genome assembly, chromosome: 21 blastn 67 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
7984556 7984556 PRJNA1215774_P_NODE_49787_length_299_cov_0.836283_g49467_i0 PRJNA1215774 49787 299 0.836283 2.50048617 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g49467 i0 100 0.0936454849498328 28 0 9 0 223 250 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
9973834 9973834 PRJNA1215774_P_NODE_68108_length_251_cov_1.730337_g67788_i0 PRJNA1215774 68108 251 1.730337 4.34314587 Artemia 6660 Arthropoda Arthropoda 446 8.929999999999999e-121   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g67788 i0 98.8 101.95219123506 250 3 99 0 2 251 1026 777 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 25590 446 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10535337 10535337 PRJNA1215774_P_NODE_73929_length_248_cov_0.880000_g73609_i0 PRJNA1215774 73929 248 0.88 2.1824 Culex quinquefasciatus 7176 Arthropoda Arthropoda 453 5.2600000000000005e-123   NTclustered gi|78190082|gb|AC168047.3| 7176 g73609 i0 99.597 30.4879032258065 248 1 100 0 1 248 64854 65101 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 7561 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
13084702 13084702 PRJNA1215774_P_NODE_41731_length_326_cov_1.826087_g41411_i0 PRJNA1215774 41731 326 1.826087 5.95304362 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2919535311|emb|OZ238346.1| 1002887 g41411 i0 100 0.0858895705521472 28 0 9 0 268 295 19071517 19071544 Glaucopsyche melanops genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
13799042 13799042 PRJNA1215774_P_NODE_49851_length_298_cov_2.155556_g49531_i0 PRJNA1215774 49851 298 2.155556 6.42355688 Bombus 28641 Arthropoda Arthropoda 58.4 5.95e-4   NTclustered gi|2304112147|ref|XM_050632747.1| 85661 g49531 i0 89.362 1.48993288590604 47 4 16 1 204 250 472 427 PREDICTED: Bombus huntii arrestin domain-containing protein 17-like (LOC126872643), transcript variant X2, mRNA blastn 444 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
17623337 17623337 PRJNA1215774_P_NODE_36854_length_347_cov_2.795620_g36534_i0 PRJNA1215774 36854 347 2.79562 9.7008014 Artemia 6660 Arthropoda Arthropoda 636 7.13e-178   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g36534 i0 99.712 99.8760806916427 347 1 100 0 1 347 1813 2159 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 34657 636 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
17623514 17623514 PRJNA1215774_P_NODE_78274_length_245_cov_0.895349_g77954_i0 PRJNA1215774 78274 245 0.895349 2.19360505 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1947871660|emb|OD570964.1| 61472 g77954 i0 96.774 0.253061224489796 31 1 13 0 51 81 23697 23667 4_Tbi_b3v08 blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
17623535 17623535 PRJNA1215774_P_NODE_82514_length_242_cov_0.911243_g82194_i0 PRJNA1215774 82514 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 207 4.4e-49   NTclustered gi|83415359|gb|AC167562.5| 7176 g82194 i0 84.259 22.297520661157 216 30 88 4 14 227 86814 86601 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940122D9, complete sequence blastn 5396 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
20732191 20732191 PRJNA1215774_P_NODE_20097_length_480_cov_2.717445_g19777_i0 PRJNA1215774 20097 480 2.717445 13.043736000000001 Agapeta hamana 1100904 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g19777 i0 94.286 0.0729166666666667 35 2 7 0 303 337 16934838 16934804 Agapeta hamana genome assembly, chromosome: 4 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
20733002 20733002 PRJNA1215774_P_NODE_79117_length_244_cov_0.900585_g78797_i0 PRJNA1215774 79117 244 0.900585 2.1974274 Tydeus kochi 2945582 Arthropoda Arthropoda 412 8.759999999999998e-111   NTclustered gi|2240866614|gb|ON555729.1| 2945582 g78797 i0 97.154 26.6188524590164 246 3 100 4 1 244 514 757 Tydeus kochi isolate FP425 small subunit ribosomal RNA gene, partial sequence blastn 6495 412 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae Tydeus Tydeus kochi
20733031 20733031 PRJNA1215774_P_NODE_81717_length_243_cov_0.905882_g81397_i0 PRJNA1215774 81717 243 0.905882 2.20129326 Periplaneta americana 6978 Arthropoda Arthropoda 76.8 1.3e-9   NTclustered gi|2852206841|ref|XR_011332640.1| 6978 g81397 i0 86.111 0.625514403292181 72 9 30 1 110 181 2209 2279 PREDICTED: Periplaneta americana uncharacterized lncRNA (LOC138701618), ncRNA blastn 152 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana

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