RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA1101048" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1101048 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
211203 211203 PRJNA1101048_P_NODE_2281_length_383_cov_1.083871_g2225_i0 PRJNA1101048 2281 383 1.083871 4.15122593 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.037   NTclustered gi|2919606875|emb|OZ238401.1| 2546182 g2225 i0 100 0.0731070496083551 28 0 7 0 41 68 962081 962108 Chelidura thaleri genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
211208 211208 PRJNA1101048_P_NODE_4541_length_297_cov_2.348214_g4485_i0 PRJNA1101048 4541 297 2.348214 6.97419558 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1965352161|emb|OE839429.1| 629358 g4485 i0 100 0.0942760942760943 28 0 9 0 196 223 207360 207387 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
4037926 4037926 PRJNA1101048_P_NODE_4704_length_294_cov_1.339367_g4648_i0 PRJNA1101048 4704 294 1.339367 3.9377389800000002 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 165 3.36e-36   NTclustered gi|1535899122|ref|XM_027348996.1| 6956 g4648 i0 92.92 41.3877551020408 113 8 38 0 9 121 699 587 PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113798455 (LOC113798455), mRNA blastn 12168 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
6589332 6589332 PRJNA1101048_P_NODE_7766_length_249_cov_1.329545_g7710_i0 PRJNA1101048 7766 249 1.329545 3.31056705 Teleiodes vulgella 1594352 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2918369900|emb|OZ237924.1| 1594352 g7710 i0 100 0.112449799196787 28 0 11 0 147 174 6857808 6857835 Teleiodes vulgella genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
7397654 7397654 PRJNA1101048_P_NODE_1946_length_408_cov_34.686567_g1890_i0 PRJNA1101048 1946 408 34.686567 141.52119336 Artemia 6660 Arthropoda Arthropoda 606 6.67e-169   NTclustered gi|2743054335|ref|XR_010620511.1| 6661 g1890 i0 99.698 99.0220588235294 331 1 100 0 52 382 921 591 PREDICTED: Artemia franciscana small subunit ribosomal RNA (LOC136039680), rRNA blastn 40401 606 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7863913 7863913 PRJNA1101048_P_NODE_6987_length_253_cov_0.866667_g6931_i0 PRJNA1101048 6987 253 0.866667 2.19266751 Artemia franciscana 6661 Arthropoda Arthropoda 453 5.39e-123   NTclustered gi|2743078535|ref|XM_065708536.1| 6661 g6931 i0 98.828 2.02766798418972 256 0 100 1 1 253 563 818 PREDICTED: Artemia franciscana eukaryotic translation initiation factor 5A-like (LOC136029971), mRNA blastn 513 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7863918 7863918 PRJNA1101048_P_NODE_8027_length_248_cov_0.891429_g7971_i0 PRJNA1101048 8027 248 0.891429 2.21074392 Artemia franciscana 6661 Arthropoda Arthropoda 459 1.13e-124   NTclustered gi|2743072555|ref|XM_065705418.1| 6661 g7971 i0 100 1 248 0 100 0 1 248 2708 2461 PREDICTED: Artemia franciscana protein abrupt-like (LOC136027947), transcript variant X1, mRNA blastn 248 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10414591 10414591 PRJNA1101048_P_NODE_2729_length_359_cov_1.688811_g2673_i0 PRJNA1101048 2729 359 1.688811 6.06283149 Eriocheir sinensis 95602 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|2312008799|ref|XR_007739227.1| 95602 g2673 i0 88 0.139275766016713 50 2 13 1 305 350 203 154 PREDICTED: Eriocheir sinensis uncharacterized LOC126985979 (LOC126985979), ncRNA blastn 50 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
11689919 11689919 PRJNA1101048_P_NODE_7430_length_251_cov_0.876404_g7374_i0 PRJNA1101048 7430 251 0.876404 2.19977404 Penaeus vannamei 6689 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2864063249|ref|XM_070126200.1| 6689 g7374 i0 100 0.111553784860558 28 0 11 0 46 73 1489 1516 PREDICTED: Penaeus vannamei R-spondin-3-like (LOC113811187), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
12498664 12498664 PRJNA1101048_P_NODE_5170_length_284_cov_1.639810_g5114_i0 PRJNA1101048 5170 284 1.63981 4.6570604 root 1 Root_unresolved Root_unresolved 58.4 5.64e-4   NTclustered gi|2304139023|ref|XM_050623139.1| 85661 g5114 i0 100 5.69014084507042 31 0 11 0 35 65 190 160 PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA blastn 1616 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
12965049 12965049 PRJNA1101048_P_NODE_1111_length_508_cov_1.542529_g1056_i0 PRJNA1101048 1111 508 1.542529 7.83604732 Timema monikensis 170555 Arthropoda Arthropoda 54.7 0.014   NTclustered gi|1946497085|emb|OB795990.1| 170555 g1056 i0 100 0.334645669291339 29 0 6 0 453 481 22210 22182 3_Tms_b3v08 blastn 170 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
12965052 12965052 PRJNA1101048_P_NODE_3251_length_336_cov_2.159696_g3195_i0 PRJNA1101048 3251 336 2.159696 7.25657856 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1963345359|emb|OE839378.1| 629358 g3195 i0 100 0.49702380952381 29 0 9 0 114 142 6940 6912 5_Tge_b3v08 blastn 167 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
12965058 12965058 PRJNA1101048_P_NODE_5711_length_273_cov_3.070000_g5655_i0 PRJNA1101048 5711 273 3.07 8.3811 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|2636206755|emb|OY979781.1| 52344 g5655 i0 100 0.102564102564103 28 0 10 0 174 201 8315215 8315242 Helicoverpa assulta genome assembly, chromosome: 7 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
14239991 14239991 PRJNA1101048_P_NODE_8512_length_246_cov_0.901734_g8456_i0 PRJNA1101048 8512 246 0.901734 2.21826564 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2920020174|emb|OZ239119.1| 3086104 g8456 i0 100 0.113821138211382 28 0 11 0 25 52 50260006 50260033 Leiobunum subalpinum genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
15513843 15513843 PRJNA1101048_P_NODE_553_length_683_cov_22.283607_g504_i0 PRJNA1101048 553 683 22.283607 152.19703581 Artemia franciscana 6661 Arthropoda Arthropoda 1184 0   NTclustered gi|5835051|ref|NC_001620.1| 6661 g504 i0 99.388 78.1112737920937 654 2 96 2 27 679 13980 13328 Artemia franciscana clone pMA-1 & pMA-3 mitochondrion, complete genome blastn 53350 1184 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
15513858 15513858 PRJNA1101048_P_NODE_8533_length_246_cov_0.895954_g8477_i0 PRJNA1101048 8533 246 0.895954 2.20404684 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1964553988|emb|OE849607.1| 629358 g8477 i0 100 0.113821138211382 28 0 11 0 47 74 3077 3104 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
16788355 16788355 PRJNA1101048_P_NODE_7094_length_253_cov_0.866667_g7038_i0 PRJNA1101048 7094 253 0.866667 2.19266751 Artemia franciscana 6661 Arthropoda Arthropoda 289 1.61e-73   NTclustered gi|2743022481|ref|XM_065726603.1| 6661 g7038 i0 100 1.03557312252964 156 0 100 0 1 156 1510 1355 PREDICTED: Artemia franciscana nucleoporin NUP188-like (LOC136041826), mRNA blastn 262 289 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
18871434 18871434 PRJNA1101048_P_NODE_3015_length_345_cov_24.264706_g2959_i0 PRJNA1101048 3015 345 24.264706 83.7132357 Artemia 6660 Arthropoda Arthropoda 532 9.56e-147   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g2959 i0 100 75.831884057971 288 0 99 0 2 289 766 1053 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 26162 532 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21888038 21888038 PRJNA1101048_P_NODE_6238_length_264_cov_1.732984_g6182_i0 PRJNA1101048 6238 264 1.732984 4.57507776 Artemia franciscana 6661 Arthropoda Arthropoda 470 5.62e-128   NTclustered gi|67782284|gb|DQ069923.1| 6661 g6182 i0 99.234 88.9848484848485 261 1 98 1 5 264 900 1160 Artemia franciscana clone 1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence blastn 23492 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
23163541 23163541 PRJNA1101048_P_NODE_5299_length_282_cov_0.942584_g5243_i0 PRJNA1101048 5299 282 0.942584 2.65808688 Zerynthia rumina 132710 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2918376942|emb|OZ238063.1| 132710 g5243 i0 100 0.099290780141844 28 0 10 0 255 282 6644906 6644933 Zerynthia rumina genome assembly, chromosome: 28 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina

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