RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA784298 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
765268 765268 PRJNA784298_P_NODE_1281_length_1149_cov_5.571561_g1144_i0 PRJNA784298 1281 1149 5.571561 64.01723589 Notodromas monacha 399045 Arthropoda Arthropoda 1053 0   NTclustered gi|1938066145|emb|OA929085.1| 399045 g1144 i0 98.816 0.514360313315927 591 7 51 0 85 675 1 591 Notodromas monacha blastn 591 1053 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
4593480 4593480 PRJNA784298_P_NODE_11044_length_377_cov_1.223684_g10843_i0 PRJNA784298 11044 377 1.223684 4.61328868 Macdunnoughia confusa 254380 Arthropoda Arthropoda 52.8 0.036   NTclustered gi|2917930332|emb|OZ234930.1| 254380 g10843 i0 100 2.15384615384615 28 0 7 0 34 61 12047424 12047451 Macdunnoughia confusa genome assembly, chromosome: 4 blastn 812 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Macdunnoughia Macdunnoughia confusa
4593679 4593679 PRJNA784298_P_NODE_28604_length_201_cov_4.156250_g28403_i0 PRJNA784298 28604 201 4.15625 8.3540625 Notodromas monacha 399045 Arthropoda Arthropoda 189 1.28e-43   NTclustered gi|1938176357|emb|OA939713.1| 399045 g28403 i0 100 0.507462686567164 102 0 51 0 100 201 1 102 Notodromas monacha blastn 102 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
5041497 5041497 PRJNA784298_P_NODE_15984_length_310_cov_8.443038_g15783_i0 PRJNA784298 15984 310 8.443038 26.1734178 root 1 Root_unresolved Root_unresolved 52.8 0.029   NTclustered gi|1937032749|emb|OA571584.1| 61478 g15783 i0 100 0.361290322580645 28 0 9 0 11 38 8209 8236 1_Tdi_b3v08 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
5868775 5868775 PRJNA784298_P_NODE_14965_length_322_cov_1.124498_g14764_i0 PRJNA784298 14965 322 1.124498 3.62088356 Megaselia scalaris 36166 Arthropoda Arthropoda 484 2.5099999999999994e-132   NTclustered gi|425869822|gb|KC177721.1| 36166 g14764 i0 94.34 102.263975155279 318 14 98 3 8 322 3435 3751 Megaselia scalaris 28S ribosomal RNA gene, partial sequence blastn 32929 484 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Phoridae Megaselia Megaselia scalaris
5868914 5868914 PRJNA784298_P_NODE_27405_length_234_cov_3.850932_g27204_i0 PRJNA784298 27405 234 3.850932 9.01118088 Notodromas monacha 399045 Arthropoda Arthropoda 311 3.13e-80   NTclustered gi|1938179279|emb|OA940082.1| 399045 g27204 i0 100 15.4102564102564 168 0 72 0 67 234 419 252 Notodromas monacha blastn 3606 311 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
7143951 7143951 PRJNA784298_P_NODE_7006_length_477_cov_3.737624_g6805_i0 PRJNA784298 7006 477 3.737624 17.82846648 Notodromas monacha 399045 Arthropoda Arthropoda 215 5.6e-51   NTclustered gi|1938179279|emb|OA940082.1| 399045 g6805 i0 100 0.243186582809224 116 0 24 0 362 477 1 116 Notodromas monacha blastn 116 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
9693740 9693740 PRJNA784298_P_NODE_24668_length_248_cov_0.880000_g24467_i0 PRJNA784298 24668 248 0.88 2.1824 Artemia franciscana 6661 Arthropoda Arthropoda 448 2.4499999999999996e-121   NTclustered gi|2743074315|ref|XM_065706335.1| 6661 g24467 i0 99.197 23.2217741935484 249 1 100 1 1 248 2427 2179 PREDICTED: Artemia franciscana NADH-ubiquinone oxidoreductase chain 5-like (LOC136028491), partial mRNA blastn 5759 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
9693824 9693824 PRJNA784298_P_NODE_6208_length_507_cov_53.258065_g6008_i0 PRJNA784298 6208 507 53.258065 270.01838955 Notodromas monacha 399045 Arthropoda Arthropoda 623 8.379999999999998e-174   NTclustered gi|1938129261|emb|OA935160.1| 399045 g6008 i0 99.417 1.21104536489152 343 2 82 0 1 343 184 526 Notodromas monacha blastn 614 623 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
10969542 10969542 PRJNA784298_P_NODE_27849_length_229_cov_2.301282_g27648_i0 PRJNA784298 27849 229 2.301282 5.26993578 Photinus pyralis 7054 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|1770352382|ref|XM_031489587.1| 7054 g27648 i0 100 0.122270742358079 28 0 12 0 119 146 62 89 PREDICTED: Photinus pyralis 2',5'-phosphodiesterase 12-like (LOC116172379), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
12692888 12692888 PRJNA784298_P_NODE_19810_length_277_cov_3.857843_g19609_i0 PRJNA784298 19810 277 3.857843 10.68622511 Artemia 6660 Arthropoda Arthropoda 512 9.73e-141   NTclustered gi|27461892|gb|AY137143.1| 6661 g19609 i0 100 6.37545126353791 277 0 100 0 1 277 599 323 Artemia franciscana 28S ribosomal RNA gene, partial sequence blastn 1766 512 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
13519167 13519167 PRJNA784298_P_NODE_24711_length_248_cov_0.880000_g24510_i0 PRJNA784298 24711 248 0.88 2.1824 Artemia franciscana 6661 Arthropoda Arthropoda 459 1.13e-124   NTclustered gi|2743054405|ref|XM_065715238.1| 6661 g24510 i0 100 1 248 0 100 0 1 248 721 474 PREDICTED: Artemia franciscana B-box type zinc finger protein ncl-1-like (LOC136034104), mRNA blastn 248 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
13519268 13519268 PRJNA784298_P_NODE_7571_length_458_cov_2.166234_g7370_i0 PRJNA784298 7571 458 2.166234 9.92135172 Notodromas monacha 399045 Arthropoda Arthropoda 643 5.759999999999998e-180   NTclustered gi|1938176357|emb|OA939713.1| 399045 g7370 i0 100 0.759825327510917 348 0 76 0 1 348 80 427 Notodromas monacha blastn 348 643 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
19892203 19892203 PRJNA784298_P_NODE_24676_length_248_cov_0.880000_g24475_i0 PRJNA784298 24676 248 0.88 2.1824 Thrips palmi 161013 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1841808775|ref|XM_034377112.1| 161013 g24475 i0 100 0.112903225806452 28 0 11 0 8 35 563 590 PREDICTED: Thrips palmi uncharacterized LOC117640561 (LOC117640561), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
20339626 20339626 PRJNA784298_P_NODE_20916_length_269_cov_1.653061_g20715_i0 PRJNA784298 20916 269 1.653061 4.44673409 Arthropoda 6656 Arthropoda Arthropoda 453 5.78e-123   NTclustered gi|325989292|gb|HQ882827.1| 289458 g20715 i0 97.026 71.3717472118959 269 8 100 0 1 269 326 594 Fujientomon dicestum cytochrome oxidase subunit I gene, partial cds; mitochondrial blastn 19199 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Protura   Fujientomidae Fujientomon Fujientomon dicestum
21615488 21615488 PRJNA784298_P_NODE_27537_length_233_cov_2.218750_g27336_i0 PRJNA784298 27537 233 2.21875 5.1696875 Timema 61471 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|1946881052|emb|OC317048.1| 61476 g27336 i0 100 0.240343347639485 28 0 12 0 55 82 211089 211062 3_Tce_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
22442717 22442717 PRJNA784298_P_NODE_27558_length_232_cov_5.069182_g27357_i0 PRJNA784298 27558 232 5.069182 11.76050224 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 429 8.2e-116   NTclustered gi|1912461452|gb|MN857506.1| 59818 g27357 i0 100 29.1681034482759 232 0 100 0 1 232 7596 7365 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 6767 429 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
25440014 25440014 PRJNA784298_P_NODE_24740_length_247_cov_3.321839_g24539_i0 PRJNA784298 24740 247 3.321839 8.20494233 Artemia 6660 Arthropoda Arthropoda 457 4.05e-124   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g24539 i0 100 4 247 0 100 0 1 247 701 455 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 988 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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