RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA314497" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA314497 · 23 ✖
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
1655373 1655373 PRJNA314497_P_NODE_942_length_572_cov_6.685083_g813_i0 PRJNA314497 942 572 6.685083 38.23867476 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1965181363|emb|OE475415.1| 61474 g813 i0 90.909 0.0769230769230769 44 1 7 2 247 287 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
2931235 2931235 PRJNA314497_P_NODE_2583_length_326_cov_2.430976_g2432_i0 PRJNA314497 2583 326 2.430976 7.92498176 Stelis punctulatissima 549116 Arthropoda Arthropoda 597 3.139999999999999e-166   NTclustered gi|684191151|gb|KJ839336.1| 549116 g2432 i0 99.693 99.6840490797546 326 1 100 0 1 326 189 514 Stelis punctulatissima voucher BC ZSM HYM 05943 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial blastn 32497 597 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megachilidae Stelis Stelis punctulatissima
4893051 4893051 PRJNA314497_S_NODE_1004_length_232_cov_11.029557_g981_i0 PRJNA314497 1004 232 11.029557 25.58857224 Culicoides 41820 Arthropoda Arthropoda 424 3.82e-114   NTclustered gi|914843|emb|X89639.1| 41821 g981 i0 99.569 85.9396551724138 232 1 100 0 1 232 232 1 C.punctatus DNA for 28S ribosomal RNA gene blastn 19938 424 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides punctatus
4893052 4893052 PRJNA314497_S_NODE_324_length_430_cov_4.284289_g301_i0 PRJNA314497 324 430 4.284289 18.4224427 Culicoides 41820 Arthropoda Arthropoda 784 0   NTclustered gi|1830685122|gb|MT335893.1| 1890933 g301 i0 99.535 92.2069767441861 430 2 100 0 1 430 563 134 Culicoides biguttatus isolate 7 small subunit ribosomal RNA gene, partial sequence blastn 39649 789 0.993662864385298 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides biguttatus
5484080 5484080 PRJNA314497_P_NODE_885_length_590_cov_6.775401_g757_i0 PRJNA314497 885 590 6.775401 39.9748659 Dipogon subintermedius 1124880 Arthropoda Arthropoda 824 0   NTclustered gi|359843855|gb|JN934366.1| 1124880 g757 i0 99.778 72 450 0 81 1 1 449 502 53 Dipogon subintermedius isolate DS98 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 42480 824 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pompilidae Dipogon Dipogon subintermedius
5484084 5484084 PRJNA314497_S_NODE_505_length_338_cov_26.203883_g482_i0 PRJNA314497 505 338 26.203883 88.56912454 Culicoides brevitarsis 469753 Arthropoda Arthropoda 592 1.5199999999999999e-164   NTclustered gi|2701292674|ref|XR_010162285.1| 469753 g482 i0 98.512 78.5828402366864 336 4 99 1 3 338 1836 2170 PREDICTED: Culicoides brevitarsis large subunit ribosomal RNA (LOC134836404), rRNA blastn 26561 592 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
5484088 5484088 PRJNA314497_S_NODE_885_length_251_cov_24.896396_g862_i0 PRJNA314497 885 251 24.896396 62.48995396 Culicoides brevitarsis 469753 Arthropoda Arthropoda 353 5.569999999999998e-93   NTclustered gi|2701292674|ref|XR_010162285.1| 469753 g862 i0 94.068 67.9641434262948 236 9 94 4 1 235 2223 2454 PREDICTED: Culicoides brevitarsis large subunit ribosomal RNA (LOC134836404), rRNA blastn 17059 353 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
5484089 5484089 PRJNA314497_S_NODE_985_length_235_cov_5.524272_g962_i0 PRJNA314497 985 235 5.524272 12.982039199999999 Culicoides sp. LJH-2002 210014 Arthropoda Arthropoda 307 4.07e-79   NTclustered gi|24251127|gb|AY140904.1| 210014 g962 i0 95.337 87.6978723404255 193 9 82 0 41 233 534 342 Culicoides sp. LJH-2002 16S ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product blastn 20609 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides sp. LJH-2002
6168019 6168019 PRJNA314497_P_NODE_2425_length_338_cov_6.721683_g2274_i0 PRJNA314497 2425 338 6.721683 22.71928854 Odonata 6961 Arthropoda Arthropoda 102 3.12e-17   NTclustered gi|1891019513|gb|MT410843.1| 52612 g2274 i0 100 16.2721893491124 55 0 16 0 1 55 6450 6504 Calopteryx splendens isolate DM1226 mitochondrion blastn 5500 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Calopterygidae Calopteryx Calopteryx splendens
8033845 8033845 PRJNA314497_P_NODE_2327_length_347_cov_11.188679_g2176_i0 PRJNA314497 2327 347 11.188679 38.82471613 Stelis punctulatissima 549116 Arthropoda Arthropoda 453 7.710000000000001e-123   NTclustered gi|684191151|gb|KJ839336.1| 549116 g2176 i0 99.597 73.7118155619597 248 1 71 0 1 248 189 436 Stelis punctulatissima voucher BC ZSM HYM 05943 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial blastn 25578 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megachilidae Stelis Stelis punctulatissima
9308613 9308613 PRJNA314497_S_NODE_1848_length_161_cov_4.613636_g1825_i0 PRJNA314497 1848 161 4.613636 7.42795396 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|1963352837|emb|OE839734.1| 629358 g1825 i0 100 0.173913043478261 28 0 17 0 92 119 121538 121565 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
9993353 9993353 PRJNA314497_S_NODE_1348_length_193_cov_3.884146_g1325_i0 PRJNA314497 1348 193 3.884146 7.49640178 Ceratopogonidae 41819 Arthropoda Arthropoda 357 3.1499999999999996e-94   NTclustered gi|1830685180|gb|MT335942.1| 46212 g1325 i0 100 100.108808290155 193 0 100 0 1 193 761 569 Culicoides variipennis isolate 56 small subunit ribosomal RNA gene, partial sequence blastn 19321 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides variipennis
10584456 10584456 PRJNA314497_P_NODE_429_length_824_cov_3.659119_g343_i0 PRJNA314497 429 824 3.659119 30.15114056 Conostigmus sp. MM-2013 1357450 Arthropoda Arthropoda 119 8.05e-22   NTclustered gi|523582254|gb|KF015227.1| 1357450 g343 i0 78.049 13.1529126213592 205 33 33 11 3 203 11749 11945 Conostigmus sp. MM-2013 mitochondrion, complete genome blastn 10838 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megaspilidae Conostigmus Conostigmus sp. MM-2013
13134333 13134333 PRJNA314497_S_NODE_1051_length_226_cov_3.568528_g1028_i0 PRJNA314497 1051 226 3.568528 8.06487328 Steatoda grossa 256750 Arthropoda Arthropoda 409 1.04e-109   NTclustered gi|1389546474|gb|MF955770.1| 256750 g1028 i0 99.554 0.991150442477876 224 1 99 0 3 226 454 231 Steatoda grossa major ampullate spidroin 1 variant 1 (MaSp1) gene, partial cds blastn 224 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Steatoda Steatoda grossa
13134337 13134337 PRJNA314497_S_NODE_651_length_294_cov_6.113208_g628_i0 PRJNA314497 651 294 6.113208 17.97283152 Culicoides variipennis 46212 Arthropoda Arthropoda 527 3.719999999999999e-145   NTclustered gi|1230594|gb|U48380.1|CVU48380 46212 g628 i0 99.313 100.387755102041 291 2 99 0 1 291 291 1 Culicoides variipennis 5.8S ribosomal RNA gene, complete sequence, 18S ribosomal RNA and 28S ribosomal RNA genes, partial sequence, and internal transcribed spacers 1 and 2 blastn 29514 527 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides variipennis
13134339 13134339 PRJNA314497_S_NODE_791_length_265_cov_22.542373_g768_i0 PRJNA314497 791 265 22.542373 59.73728845 Culicoides scoticus 289302 Arthropoda Arthropoda 457 4.39e-124   NTclustered gi|225735829|emb|FN263322.1| 289302 g768 i0 97.744 96.3962264150943 266 5 100 1 1 265 331 66 Culicoides scoticus partial 18S rRNA gene, isolate P from Kreis Mettmann, Germany blastn 25545 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides scoticus
16958012 16958012 PRJNA314497_S_NODE_1634_length_171_cov_9.859155_g1611_i0 PRJNA314497 1634 171 9.859155 16.85915505 Culicoides chiopterus 375138 Arthropoda Arthropoda 316 4.6e-82   NTclustered gi|576938194|gb|KF826476.1| 375138 g1611 i0 100 99.9941520467836 171 0 100 0 1 171 336 506 Culicoides chiopterus isolate N387 28S ribosomal RNA gene, partial sequence blastn 17099 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides chiopterus
16958014 16958014 PRJNA314497_S_NODE_474_length_349_cov_8.743750_g451_i0 PRJNA314497 474 349 8.74375 30.5156875 Culicoides brevitarsis 469753 Arthropoda Arthropoda 187 1.84e-59   NR XP_063703218.1 469753 g451 i0 89.9 0.851002865329513 99 10 85.1 0 14 310 1 99 XP_063703218.1 ATP synthase subunit g, mitochondrial [Culicoides brevitarsis] diamond 297 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
20782112 20782112 PRJNA314497_P_NODE_4717_length_166_cov_2.277372_g4565_i0 PRJNA314497 4717 166 2.277372 3.78043752 Condylostylus longicornis 2530218 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2496071103|ref|XM_055516902.1| 2530218 g4565 i0 100 0.698795180722892 29 0 17 0 27 55 6350 6322 PREDICTED: Condylostylus longicornis putative uncharacterized protein DDB_G0282133 (LOC129606536), transcript variant X2, mRNA blastn 116 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
20782119 20782119 PRJNA314497_S_NODE_1677_length_170_cov_2.021277_g1654_i0 PRJNA314497 1677 170 2.021277 3.4361709 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1965181363|emb|OE475415.1| 61474 g1654 i0 90.909 0.258823529411765 44 1 24 2 50 90 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
25291343 25291343 PRJNA314497_S_NODE_660_length_291_cov_26.538168_g637_i0 PRJNA314497 660 291 26.538168 77.22606888 Culicoides 41820 Arthropoda Arthropoda 529 1.0199999999999996e-145   NTclustered gi|630320300|gb|KF286358.1| 41821 g637 i0 99.654 99.9690721649485 289 1 99 0 1 289 289 1 Culicoides punctatus isolate FR-pun1-D327 28S ribosomal RNA gene, partial sequence blastn 29091 532 0.994360902255639 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides punctatus
30105808 30105808 PRJNA314497_S_NODE_372_length_397_cov_6.013587_g349_i0 PRJNA314497 372 397 6.013587 23.87394039 Culicoides sonorensis 179676 Arthropoda Arthropoda 150 1.55e-44   NR AAU06505.1 179676 g349 i0 84.4 0.581863979848867 77 12 58.2 0 352 122 1 77 AAU06505.1 unknown salivary protein [Culicoides sonorensis] diamond 231 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides sonorensis
31306593 31306593 PRJNA314497_S_NODE_455_length_356_cov_6.348624_g432_i0 PRJNA314497 455 356 6.348624 22.60110144 Thrips palmi 161013 Arthropoda Arthropoda 48.1 0.00175   NR XP_034240145.1 161013 g432 i0 33.3 0.758426966292135 90 55 74.2 2 83 346 805 891 XP_034240145.1 uncharacterized protein LOC117644643 [Thrips palmi] diamond 270 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi

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