RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "blastn", bioproject = "PRJNA1016321" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1016321 · 25 ✖

analysis 1

  • blastn · 25 ✖
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
159406 159406 PRJNA1016321_P_NODE_25941_length_363_cov_1.706897_g25710_i0 PRJNA1016321 25941 363 1.706897 6.19603611 Artemia franciscana 6661 Arthropoda Arthropoda 671 0   NTclustered gi|2006881776|dbj|LC532181.1| 6661 g25710 i0 100 3 363 0 100 0 1 363 1033 1395 Artemia franciscana 114_Af DPD1 mRNA for DNA polymerase delta catalytic subunit, complete cds blastn 1089 671 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
1434439 1434439 PRJNA1016321_P_NODE_39162_length_283_cov_2.571429_g38931_i0 PRJNA1016321 39162 283 2.571429 7.27714407 Henosepilachna vigintioctomaculata 420088 Arthropoda Arthropoda 440 4.769999999999998e-119   NTclustered gi|2678049063|gb|PP238420.1| 420088 g38931 i0 94.7 92.5901060070671 283 15 100 0 1 283 261 543 Henosepilachna vigintioctomaculata Hsp70mA2c mRNA, complete cds blastn 26203 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctomaculata
1434882 1434882 PRJNA1016321_P_NODE_8562_length_694_cov_4.167472_g8354_i0 PRJNA1016321 8562 694 4.167472 28.92225568 Lissorhoptrus oryzophilus 308863 Arthropoda Arthropoda 773 0   NTclustered gi|1236771285|gb|MF441473.1| 308863 g8354 i0 91.213 68.4726224783862 569 49 82 1 96 664 568 1 Lissorhoptrus oryzophilus ribosomal protein L20 mRNA, complete cds blastn 47520 773 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Erirhinidae Lissorhoptrus Lissorhoptrus oryzophilus
2709779 2709779 PRJNA1016321_P_NODE_26783_length_356_cov_1.636042_g26552_i0 PRJNA1016321 26783 356 1.636042 5.82430952 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g26552 i0 100 3.88483146067416 30 0 8 0 240 269 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
5262357 5262357 PRJNA1016321_P_NODE_29525_length_335_cov_2.404580_g29294_i0 PRJNA1016321 29525 335 2.40458 8.055343 Dermatophagoides farinae 6954 Arthropoda Arthropoda 617 2.48e-172   NTclustered gi|2205475243|ref|XM_047061406.1| 6954 g29294 i0 100 1.25373134328358 334 0 99 0 2 335 1453 1120 PREDICTED: Dermatophagoides farinae SH2B adapter protein 3-like (LOC124497726), mRNA blastn 420 617 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
6105948 6105948 PRJNA1016321_P_NODE_47405_length_252_cov_1.290503_g47174_i0 PRJNA1016321 47405 252 1.290503 3.25206756 Insecta 50557 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1685549908|ref|XM_008188619.3| 7029 g47174 i0 100 0.222222222222222 28 0 11 0 37 64 733 706 PREDICTED: Acyrthosiphon pisum developmental protein eyes absent (LOC100167386), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
9087160 9087160 PRJNA1016321_P_NODE_35688_length_299_cov_2.084071_g35457_i0 PRJNA1016321 35688 299 2.084071 6.23137229 Cotesia glomerata 32391 Arthropoda Arthropoda 217 9.32e-52   NTclustered gi|2120569010|ref|XM_044727920.1| 32391 g35457 i0 82.061 27.8361204013378 262 40 86 6 34 291 289 547 PREDICTED: Cotesia glomerata 40S ribosomal protein S15 (LOC123264591), mRNA blastn 8323 217 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
9087199 9087199 PRJNA1016321_P_NODE_37328_length_291_cov_2.082569_g37097_i0 PRJNA1016321 37328 291 2.082569 6.06027579 Artemia franciscana 6661 Arthropoda Arthropoda 501 2.23e-137   NTclustered gi|2743076664|ref|XM_065707556.1| 6661 g37097 i0 100 1.8659793814433 271 0 93 0 1 271 1783 1513 PREDICTED: Artemia franciscana DNA-directed RNA polymerase II subunit RPB1-like (LOC136029296), mRNA blastn 543 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10362879 10362879 PRJNA1016321_P_NODE_39649_length_281_cov_3.331731_g39418_i0 PRJNA1016321 39649 281 3.331731 9.36216411 Aphidius gifuensis 684658 Arthropoda Arthropoda 510 3.56e-140   NTclustered gi|2106754007|ref|XM_044160156.1| 684658 g39418 i0 99.642 43.0249110320285 279 1 99 0 1 279 1589 1311 PREDICTED: Aphidius gifuensis elongation factor 1-alpha (LOC122857783), transcript variant X2, mRNA blastn 12090 510 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
11637887 11637887 PRJNA1016321_P_NODE_18830_length_443_cov_7.318919_g18600_i0 PRJNA1016321 18830 443 7.318919 32.42281117 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g18600 i0 100 0.0632054176072235 28 0 6 0 4 31 5916427 5916400 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
11638163 11638163 PRJNA1016321_P_NODE_33810_length_309_cov_2.059322_g33579_i0 PRJNA1016321 33810 309 2.059322 6.36330498 Dermatophagoides farinae 6954 Arthropoda Arthropoda 566 8.33e-157   NTclustered gi|108946637|gb|DQ641915.1| 6954 g33579 i0 99.676 6.52427184466019 309 1 100 0 1 309 461 769 Dermatophagoides farinae Der f 6 mRNA, partial cds blastn 2016 566 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
12481630 12481630 PRJNA1016321_P_NODE_53390_length_244_cov_1.280702_g53159_i0 PRJNA1016321 53390 244 1.280702 3.12491288 Lepinotus 209980 Arthropoda Arthropoda 427 3.13e-115   NTclustered gi|34368854|gb|AY139967.1| 209981 g53159 i0 98.75 83.6311475409836 240 3 98 0 1 240 264 25 Lepinotus reticulatus 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 20406 429 0.995337995337995 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Trogiidae Lepinotus Lepinotus reticulatus
12481641 12481641 PRJNA1016321_P_NODE_57330_length_230_cov_4.630573_g57099_i0 PRJNA1016321 57330 230 4.630573 10.6503179 Drosophila 7215 Arthropoda Arthropoda 409 1.0600000000000001e-109   NTclustered gi|45332696|ref|NC_005779.1| 7226 g57099 i0 100 96.0869565217391 221 0 96 0 10 230 13028 12808 Drosophila mauritiana mitochondrion, complete genome blastn 22100 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
12913133 12913133 PRJNA1016321_P_NODE_31551_length_322_cov_2.236948_g31320_i0 PRJNA1016321 31551 322 2.236948 7.20297256 Artemia franciscana 6661 Arthropoda Arthropoda 577 4.0299999999999986e-160   NTclustered gi|2743068392|ref|XM_065703280.1| 6661 g31320 i0 99.373 46.9223602484472 319 1 99 1 4 322 482 165 PREDICTED: Artemia franciscana large ribosomal subunit protein eL43 (LOC136026575), mRNA blastn 15109 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12913391 12913391 PRJNA1016321_P_NODE_43391_length_266_cov_2.176166_g43160_i0 PRJNA1016321 43391 266 2.176166 5.78860156 Atrichopogon sp. MAB-2008 560259 Arthropoda Arthropoda 270 6.1699999999999986e-68   NTclustered gi|202070936|gb|FJ040575.1| 560259 g43160 i0 86.508 47.0676691729323 252 27 92 6 22 266 1808 2059 Atrichopogon sp. MAB-2008 28S ribosomal RNA gene, partial sequence blastn 12520 270 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Atrichopogon Atrichopogon sp. MAB-2008
12913715 12913715 PRJNA1016321_P_NODE_7051_length_768_cov_4.628777_g6852_i0 PRJNA1016321 7051 768 4.628777 35.54900736 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 134 2.68e-26   NTclustered gi|1685540238|ref|XM_001951034.5| 7029 g6852 i0 92.473 0.38671875 93 7 12 0 87 179 1317 1409 PREDICTED: Acyrthosiphon pisum glucosamine-6-phosphate isomerase (LOC100168570), mRNA blastn 297 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
13756183 13756183 PRJNA1016321_P_NODE_57411_length_229_cov_3.576923_g57180_i0 PRJNA1016321 57411 229 3.576923 8.19115367 Culicoides 41820 Arthropoda Arthropoda 357 3.87e-94   NTclustered gi|1830685123|gb|MT336012.1| 46212 g57180 i0 98.058 90.117903930131 206 3 90 1 15 220 372 168 Culicoides variipennis isolate 59 small subunit ribosomal RNA gene, partial sequence blastn 20637 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides variipennis
15461957 15461957 PRJNA1016321_P_NODE_18513_length_448_cov_1.613333_g18283_i0 PRJNA1016321 18513 448 1.613333 7.22773184 Pollicipes pollicipes 41117 Arthropoda Arthropoda 60.2 2.59e-4   NTclustered gi|1929167480|ref|XM_037223310.1| 41117 g18283 i0 97.143 1.66964285714286 35 1 8 0 307 341 4694 4660 PREDICTED: Pollicipes pollicipes PH-interacting protein-like (LOC119100201), mRNA blastn 748 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
15461987 15461987 PRJNA1016321_P_NODE_20313_length_423_cov_2.037143_g20082_i0 PRJNA1016321 20313 423 2.037143 8.61711489 Timema monikensis 170555 Arthropoda Arthropoda 52.8 0.041   NTclustered gi|1946393460|emb|OB792636.1| 170555 g20082 i0 100 0.066193853427896 28 0 7 0 396 423 1482815 1482788 3_Tms_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
16736880 16736880 PRJNA1016321_P_NODE_5374_length_878_cov_4.685714_g5186_i0 PRJNA1016321 5374 878 4.685714 41.14056892 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 0.002   NTclustered gi|1048003915|ref|XM_017627148.1| 28612 g5186 i0 100 0.0353075170842825 31 0 4 0 620 650 708 738 PREDICTED: Rhagoletis zephyria uncharacterized LOC108371558 (LOC108371558), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
16736923 16736923 PRJNA1016321_P_NODE_55914_length_241_cov_1.375000_g55683_i0 PRJNA1016321 55914 241 1.375 3.31375 Callophrys avis 700180 Arthropoda Arthropoda 58.4 4.66e-4   NTclustered gi|2918383891|emb|OZ238071.1| 700180 g55683 i0 97.143 0.145228215767635 35 0 14 1 59 92 30656463 30656429 Callophrys avis genome assembly, chromosome: 4 blastn 35 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
21835956 21835956 PRJNA1016321_P_NODE_11238_length_597_cov_2.173664_g11016_i0 PRJNA1016321 11238 597 2.173664 12.97677408 Dermatophagoides farinae 6954 Arthropoda Arthropoda 1086 0   NTclustered gi|2591765770|gb|OR660425.1| 6954 g11016 i0 99.497 81.2345058626466 597 3 100 0 1 597 109 705 Dermatophagoides farinae isolate HZ_3 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial blastn 48497 1086 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
21836246 21836246 PRJNA1016321_P_NODE_26938_length_355_cov_1.592199_g26707_i0 PRJNA1016321 26938 355 1.592199 5.65230645 Artemia franciscana 6661 Arthropoda Arthropoda 617 2.6399999999999996e-172   NTclustered gi|2743021901|ref|XR_010621062.1| 6661 g26707 i0 98.028 3.08450704225352 355 7 100 0 1 355 1030 1384 PREDICTED: Artemia franciscana uncharacterized LOC136041593 (LOC136041593), transcript variant X1, ncRNA blastn 1095 617 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21836655 21836655 PRJNA1016321_P_NODE_46998_length_253_cov_1.711111_g46767_i0 PRJNA1016321 46998 253 1.711111 4.32911083 Artemia franciscana 6661 Arthropoda Arthropoda 462 8.95e-126   NTclustered gi|2743054927|ref|XM_065718691.1| 6661 g46767 i0 99.606 3.01185770750988 254 0 100 1 1 253 789 536 PREDICTED: Artemia franciscana glycine-rich protein GRP33 (LOC136036448), transcript variant X1, mRNA blastn 762 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
25228972 25228972 PRJNA1016321_P_NODE_44080_length_264_cov_1.350785_g43849_i0 PRJNA1016321 44080 264 1.350785 3.5660724 Metazoa 33208 Arthropoda Arthropoda 62.1 4.01e-5   NTclustered gi|2563732572|ref|XM_058950922.1| 108790 g43849 i0 92.857 12.2651515151515 42 3 16 0 129 170 524 483 PREDICTED: Phymastichus coffea glycine, alanine and asparagine-rich protein (LOC131673160), transcript variant X1, mRNA blastn 3238 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea

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