RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB55250" 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

  • PRJEB55250 · 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
1396067 1396067 PRJEB55250_P_NODE_12222_length_250_cov_0.870056_g12098_i0 PRJEB55250 12222 250 0.870056 2.17514 Manduca sexta 7130 Arthropoda Arthropoda 71.3 6.25e-8   NTclustered gi|268306473|gb|GU084325.1| 7130 g12098 i0 81.928 1.008 83 15 33 0 3 85 148 230 Manduca sexta ribosomal protein L29 (rpl29) mRNA, complete cds blastn 252 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
3947709 3947709 PRJEB55250_P_NODE_10724_length_256_cov_1.513661_g10600_i0 PRJEB55250 10724 256 1.513661 3.87497216 Diaphorina citri 121845 Arthropoda Arthropoda 468 1.95e-127   NTclustered gi|1494774796|ref|XR_003394590.1| 121845 g10600 i0 99.609 100.5234375 256 1 100 0 1 256 1491 1746 PREDICTED: Diaphorina citri large subunit ribosomal RNA (LOC113472154), rRNA blastn 25734 468 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
3947760 3947760 PRJEB55250_P_NODE_13064_length_248_cov_0.880000_g12940_i0 PRJEB55250 13064 248 0.88 2.1824 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 403 5.38e-108   NTclustered gi|149944780|gb|AC202223.6| 7029 g12940 i0 95.984 3.36290322580645 249 9 100 1 1 248 52244 52492 Acyrthosiphon pisum BAC VMRC38-10-A9 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence blastn 834 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
3947910 3947910 PRJEB55250_P_NODE_5164_length_312_cov_0.962343_g5040_i0 PRJEB55250 5164 312 0.962343 3.00251016 Cybister sp. CYE1 1075885 Arthropoda Arthropoda 577 3.89e-160   NTclustered gi|353169492|gb|JN840674.1| 1075885 g5040 i0 100 99.9423076923077 312 0 100 0 1 312 635 324 Cybister sp. CYE1 voucher BMNH:721669 cytochrome c oxidase subunit 1 (COI) gene, partial cds; mitochondrial blastn 31182 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Cybister Cybister sp. CYE1
5224382 5224382 PRJEB55250_P_NODE_8205_length_275_cov_1.143564_g8081_i0 PRJEB55250 8205 275 1.143564 3.144801 Lysiphlebia japonica 104022 Arthropoda Arthropoda 58.4 5.43e-4   NTclustered gi|1251773062|gb|KY809859.1| 104022 g8081 i0 97.059 0.123636363636364 34 1 12 0 94 127 1869 1836 Lysiphlebia japonica elongation factor 1-alpha mRNA, complete cds blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Lysiphlebia Lysiphlebia japonica
8645015 8645015 PRJEB55250_P_NODE_2107_length_448_cov_1.434667_g1984_i0 PRJEB55250 2107 448 1.434667 6.42730816 root 1 Root_unresolved Root_unresolved 789 0   NTclustered gi|78097481|gb|AC167665.2| 7176 g1984 i0 98.438 98 448 7 100 0 1 448 79185 79632 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940135D9, complete sequence blastn 43904 795 0.992452830188679 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
8645074 8645074 PRJEB55250_P_NODE_8847_length_270_cov_1.289340_g8723_i0 PRJEB55250 8847 270 1.28934 3.481218 root 1 Root_unresolved Root_unresolved 483 7.409999999999998e-132   NTclustered gi|78190082|gb|AC168047.3| 7176 g8723 i0 98.889 32.8296296296296 270 3 100 0 1 270 5038 5307 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 8864 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
12875370 12875370 PRJEB55250_P_NODE_3671_length_354_cov_1.505338_g3547_i0 PRJEB55250 3671 354 1.505338 5.32889652 Timema monikensis 170555 Arthropoda Arthropoda 58.4 7.2e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g3547 i0 97.059 0.254237288135593 34 1 10 0 29 62 168510 168543 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
14150215 14150215 PRJEB55250_P_NODE_6152_length_291_cov_1.766055_g6028_i0 PRJEB55250 6152 291 1.766055 5.13922005 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1535914965|ref|XM_027343730.1| 6956 g6028 i0 100 1.72852233676976 30 0 10 0 108 137 876 905 PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113793668 (LOC113793668), mRNA blastn 503 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
17569685 17569685 PRJEB55250_P_NODE_15354_length_243_cov_1.676471_g15230_i0 PRJEB55250 15354 243 1.676471 4.0738245300000004 root 1 Root_unresolved Root_unresolved 440 4e-119   NTclustered gi|78190082|gb|AC168047.3| 7176 g15230 i0 99.585 94.3868312757202 241 1 99 0 3 243 49999 50239 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 22936 444 0.990990990990991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
19247365 19247365 PRJEB55250_P_NODE_2456_length_419_cov_2.291908_g2333_i0 PRJEB55250 2456 419 2.291908 9.60309452 Euproctis chrysorrhoea 987934 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|2918370018|emb|OZ237905.1| 987934 g2333 i0 96.97 0.0787589498806683 33 0 8 1 156 187 14694390 14694358 Euproctis chrysorrhoea genome assembly, chromosome: 1 blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Euproctis Euproctis chrysorrhoea
20118310 20118310 PRJEB55250_P_NODE_10716_length_256_cov_1.568306_g10592_i0 PRJEB55250 10716 256 1.568306 4.01486336 root 1 Root_unresolved Root_unresolved 468 1.95e-127   NTclustered gi|78190082|gb|AC168047.3| 7176 g10592 i0 99.609 84.18359375 256 1 100 0 1 256 45284 45539 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 21551 468 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
22668826 22668826 PRJEB55250_P_NODE_7718_length_278_cov_1.921951_g7594_i0 PRJEB55250 7718 278 1.921951 5.34302378 Formicidae 36668 Arthropoda Arthropoda 503 5.88e-138   NTclustered gi|1419211181|emb|LT977143.1| 67763 g7594 i0 99.281 99.931654676259 278 2 100 0 1 278 149 426 Lasius flavus partial 28S rRNA gene, specimen voucher MCZ:Ent:654750 blastn 27781 508 0.990157480314961 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius flavus
24347602 24347602 PRJEB55250_P_NODE_15860_length_242_cov_1.609467_g15736_i0 PRJEB55250 15860 242 1.609467 3.89491014 Artemia franciscana 6661 Arthropoda Arthropoda 448 2.3799999999999995e-121   NTclustered gi|2743035377|ref|XM_065713940.1| 6661 g15736 i0 100 1 242 0 100 0 1 242 1113 872 PREDICTED: Artemia franciscana SERPINE1 mRNA-binding protein 1-like (LOC136033227), mRNA blastn 242 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
25217984 25217984 PRJEB55250_P_NODE_5180_length_311_cov_2.289916_g5056_i0 PRJEB55250 5180 311 2.289916 7.12163876 root 1 Root_unresolved Root_unresolved 575 1.3899999999999995e-159   NTclustered gi|78190082|gb|AC168047.3| 7176 g5056 i0 100 25.2347266881029 311 0 100 0 1 311 68174 67864 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 7848 575 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);;