RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1054617" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1054617 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
1451173 1451173 PRJNA1054617_S_NODE_8902_length_192_cov_1.838926_g8814_i0 PRJNA1054617 8902 192 1.838926 3.53073792 Timema californicum 61474 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|1964387546|emb|OE370042.1| 61474 g8814 i0 100 0.145833333333333 28 0 15 0 104 131 161 188 2_Tcm_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
3561943 3561943 PRJNA1054617_S_NODE_143_length_931_cov_79.325450_g95_i0 PRJNA1054617 143 931 79.32545 738.5199395 Timema 61471 Arthropoda Arthropoda 54.7 0.026   NTclustered gi|1947819235|emb|OD566261.1| 61472 g95 i0 100 0.0622986036519871 29 0 3 0 541 569 111505 111477 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
4002966 4002966 PRJNA1054617_S_NODE_4724_length_248_cov_3.746341_g4636_i0 PRJNA1054617 4724 248 3.746341 9.29092568 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g4636 i0 100 0.116935483870968 29 0 12 0 168 196 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
6554430 6554430 PRJNA1054617_S_NODE_2506_length_320_cov_4.552347_g2418_i0 PRJNA1054617 2506 320 4.552347 14.5675104 Demodex folliculorum 481310 Arthropoda Arthropoda 586 6.65e-163   NTclustered gi|746000042|ref|NC_026102.1| 481310 g2418 i0 99.688 33.275 320 1 100 0 1 320 12013 11694 Demodex folliculorum mitochondrion, complete genome blastn 10648 586 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex folliculorum
9104112 9104112 PRJNA1054617_S_NODE_1528_length_383_cov_4.464706_g1440_i0 PRJNA1054617 1528 383 4.464706 17.09982398 Demodex folliculorum 481310 Arthropoda Arthropoda 708 0   NTclustered gi|360047396|gb|HQ728004.1| 481310 g1440 i0 100 35.6135770234987 383 0 100 0 1 383 770 1152 Demodex folliculorum isolate 3-S6-Df2 28S ribosomal RNA gene, partial sequence blastn 13640 708 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex folliculorum
10379806 10379806 PRJNA1054617_S_NODE_4969_length_243_cov_10.545000_g4881_i0 PRJNA1054617 4969 243 10.545 25.62435 Lutzomyia longipalpis 7200 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2500595551|ref|XM_055826452.1| 7200 g4881 i0 100 0.238683127572016 30 0 12 0 4 33 4217 4188 PREDICTED: Lutzomyia longipalpis uncharacterized LOC129789572 (LOC129789572), transcript variant X1, mRNA blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
11214660 11214660 PRJNA1054617_S_NODE_14149_length_158_cov_2.782609_g14061_i0 PRJNA1054617 14149 158 2.782609 4.39652222 Euwallacea 124011 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2753860062|ref|XM_066295923.1| 995702 g14061 i0 94.444 0.911392405063291 36 1 23 1 112 147 3298 3264 PREDICTED: Euwallacea fornicatus Mitochondrial assembly regulatory factor (Marf), transcript variant X1, mRNA blastn 144 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
11655064 11655064 PRJNA1054617_S_NODE_4190_length_261_cov_2.110092_g4102_i0 PRJNA1054617 4190 261 2.110092 5.50734012 Melanaphis sacchari 742174 Arthropoda Arthropoda 113 1.08e-20   NTclustered gi|1411014246|ref|XM_025346740.1| 742174 g4102 i0 82.308 0.498084291187739 130 23 50 0 1 130 642 771 PREDICTED: Melanaphis sacchari NADH-quinone oxidoreductase subunit B 2-like (LOC112599712), mRNA blastn 130 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Melanaphis Melanaphis sacchari
14205197 14205197 PRJNA1054617_S_NODE_5692_length_230_cov_3.721925_g5604_i0 PRJNA1054617 5692 230 3.721925 8.5604275 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1962536607|emb|OC867504.1| 1979941 g5604 i0 100 0.126086956521739 29 0 13 0 1 29 716 744 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
14205218 14205218 PRJNA1054617_S_NODE_9452_length_187_cov_5.736111_g9364_i0 PRJNA1054617 9452 187 5.736111 10.72652757 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1044897043|gb|KT223635.1| 354439 g9364 i0 100 0.149732620320856 28 0 15 0 160 187 59 32 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
15038937 15038937 PRJNA1054617_S_NODE_5812_length_228_cov_7.789189_g5724_i0 PRJNA1054617 5812 228 7.789189 17.75935092 Timema 61471 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1964637562|emb|OE179771.1| 61474 g5724 i0 94.444 0.842105263157895 36 2 16 0 123 158 66744 66779 2_Tcm_b3v08 blastn 192 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
19302221 19302221 PRJNA1054617_S_NODE_2056_length_343_cov_9.330000_g1968_i0 PRJNA1054617 2056 343 9.33 32.0019 Penaeus monodon 6687 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1832334880|gb|MK599468.1| 6687 g1968 i0 100 0.416909620991254 30 0 9 0 1 30 87 116 Penaeus monodon C-type lectin mRNA, complete cds blastn 143 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
20577591 20577591 PRJNA1054617_S_NODE_5077_length_241_cov_3.484848_g4989_i0 PRJNA1054617 5077 241 3.484848 8.39848368 Centruroides edwardsii 2565419 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1761173678|gb|MK932020.1| 2565419 g4989 i0 100 0.116182572614108 28 0 12 0 214 241 58 31 Centruroides edwardsii antimicrobial non-disulfide-bridged peptide (CR13_25) mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides edwardsii
21853384 21853384 PRJNA1054617_S_NODE_898_length_463_cov_17.014286_g812_i0 PRJNA1054617 898 463 17.014286 78.77614418 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.045   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g812 i0 100 0.060475161987041 28 0 6 0 317 344 23317818 23317845 Satyrium ilicis genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
23128800 23128800 PRJNA1054617_S_NODE_14879_length_155_cov_2.223214_g14791_i0 PRJNA1054617 14879 155 2.223214 3.4459817 Tribolium castaneum 7070 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2733082035|emb|OX465953.1| 7070 g14791 i0 100 0.367741935483871 29 0 19 0 23 51 3403 3375 Tribolium castaneum genome assembly, segment: tig00000304 blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum

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