RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA694557 · 32 ✖

analysis 1

  • blastn · 32 ✖
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
1949124 1949124 PRJNA694557_P_NODE_11522_length_395_cov_4.518634_g11302_i0 PRJNA694557 11522 395 4.518634 17.8486043 Tapinoma melanocephalum 219810 Arthropoda Arthropoda 531 3.9799999999999996e-146   NTclustered gi|1800328879|gb|MN397938.1| 219810 g11302 i0 91.451 89.5645569620253 386 33 98 0 1 386 3806 3421 Tapinoma melanocephalum mitochondrion, complete genome blastn 35378 531 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Tapinoma Tapinoma melanocephalum
2454849 2454849 PRJNA694557_P_NODE_21802_length_263_cov_8.031579_g21582_i0 PRJNA694557 21802 263 8.031579 21.12305277 Insecta 50557 Arthropoda Arthropoda 134 8.34e-27   NTclustered gi|741985872|gb|KJ461315.1| 280162 g21582 i0 95.238 32.6730038022814 84 4 32 0 6 89 2363 2280 Ochterus marginatus 28S ribosomal RNA gene, partial sequence blastn 8593 135 0.992592592592593 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Ochteridae Ochterus Ochterus marginatus
3224230 3224230 PRJNA694557_P_NODE_17663_length_303_cov_1.434783_g17443_i0 PRJNA694557 17663 303 1.434783 4.34739249 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1963351516|emb|OE839663.1| 629358 g17443 i0 100 0.0924092409240924 28 0 9 0 87 114 120624 120651 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
3224294 3224294 PRJNA694557_P_NODE_21603_length_265_cov_2.333333_g21383_i0 PRJNA694557 21603 265 2.333333 6.18333245 Micropygomyia chassigneti 1807774 Arthropoda Arthropoda 182 2.96e-41   NTclustered gi|1128619226|gb|KX356027.1| 1807774 g21383 i0 79.478 41.411320754717 268 45 100 7 1 265 2363 2103 Micropygomyia chassigneti 28S ribosomal RNA gene, partial sequence blastn 10974 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Micropygomyia Micropygomyia chassigneti
3731343 3731343 PRJNA694557_P_NODE_17983_length_299_cov_3.668142_g17763_i0 PRJNA694557 17983 299 3.668142 10.96774458 Euwallacea 124011 Arthropoda Arthropoda 521 1.7599999999999996e-143   NTclustered gi|1858736252|gb|MT628494.1| 321055 g17763 i0 100 99.0401337792642 282 0 94 0 18 299 1667 1948 Euwallacea interjectus isolate OG-2 large subunit ribosomal RNA gene, partial sequence blastn 29613 521 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea interjectus
5776792 5776792 PRJNA694557_P_NODE_18745_length_291_cov_2.114679_g18525_i0 PRJNA694557 18745 291 2.114679 6.15371589 Mythimna separata 271217 Arthropoda Arthropoda 490 4.819999999999998e-134   NTclustered gi|1303718459|gb|MG654666.1| 271217 g18525 i0 99.265 320.168384879725 272 1 93 1 10 281 2333 2603 Mythimna separata clone a2 large subunit ribosomal RNA gene, partial sequence blastn 93169 490 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna separata
7051800 7051800 PRJNA694557_P_NODE_12586_length_373_cov_3.260000_g12366_i0 PRJNA694557 12586 373 3.26 12.1598 Scylla paramamosain 85552 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1026137028|emb|LT560377.1| 85552 g12366 i0 96.97 0.64343163538874 33 1 9 0 341 373 38 6 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 240 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
7051831 7051831 PRJNA694557_P_NODE_14486_length_342_cov_3.985130_g14266_i0 PRJNA694557 14486 342 3.98513 13.6291446 Artemia franciscana 6661 Arthropoda Arthropoda 191 6.57e-44   NTclustered gi|2743022784|ref|XR_010621135.1| 6661 g14266 i0 86.264 34.4883040935673 182 18 77 5 23 201 38475 38298 PREDICTED: Artemia franciscana uncharacterized LOC136041949 (LOC136041949), transcript variant X1, ncRNA blastn 11795 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
8326410 8326410 PRJNA694557_P_NODE_19767_length_281_cov_5.129808_g19547_i0 PRJNA694557 19767 281 5.129808 14.41476048 Coptotermes formosanus 36987 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|506965362|gb|KC632258.1| 36987 g19547 i0 100 0.206405693950178 30 0 11 0 25 54 4 33 Coptotermes formosanus clone CFSNI2475 hypothetical protein mRNA, complete cds blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
8326450 8326450 PRJNA694557_P_NODE_21847_length_263_cov_2.431579_g21627_i0 PRJNA694557 21847 263 2.431579 6.39505277 Vollenhovia emeryi 411798 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|795015790|ref|XM_012002877.1| 411798 g21627 i0 100 0.212927756653992 28 0 11 0 64 91 113 140 PREDICTED: Vollenhovia emeryi classical arabinogalactan protein 9-like (LOC105555836), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi
12152384 12152384 PRJNA694557_P_NODE_13650_length_355_cov_7.514184_g13430_i0 PRJNA694557 13650 355 7.514184 26.6753532 Euwallacea similis 1736056 Arthropoda Arthropoda 436 7.94e-118   NTclustered gi|2770087546|ref|XR_010753072.1| 1736056 g13430 i0 90.141 103.047887323944 355 8 100 13 1 355 2574 2901 PREDICTED: Euwallacea similis large subunit ribosomal RNA (LOC136419106), rRNA blastn 36582 436 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea similis
12152431 12152431 PRJNA694557_P_NODE_17130_length_309_cov_1.851695_g16910_i0 PRJNA694557 17130 309 1.851695 5.72173755 Artemia franciscana 6661 Arthropoda Arthropoda 298 3.36e-76   NTclustered gi|2743068965|ref|XM_065703558.1| 6661 g16910 i0 93.103 0.656957928802589 203 14 66 0 46 248 695 897 PREDICTED: Artemia franciscana ATP-dependent RNA helicase glh-2-like (LOC136026846), mRNA blastn 203 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
14702199 14702199 PRJNA694557_P_NODE_14652_length_340_cov_2.041199_g14432_i0 PRJNA694557 14652 340 2.041199 6.9400766 Mycetomoellerius zeteki 64791 Arthropoda Arthropoda 106 2.43e-18   NTclustered gi|1069678299|ref|XM_018445628.1| 64791 g14432 i0 85.859 0.582352941176471 99 14 29 0 65 163 427 525 PREDICTED: Trachymyrmex zeteki 40S ribosomal protein S16 (LOC108721215), mRNA blastn 198 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Mycetomoellerius Mycetomoellerius zeteki
14702530 14702530 PRJNA694557_P_NODE_9132_length_456_cov_7.853786_g8912_i0 PRJNA694557 9132 456 7.853786 35.81326416 Centruroides edwardsii 2565419 Arthropoda Arthropoda 52.8 0.044   NTclustered gi|1761173678|gb|MK932020.1| 2565419 g8912 i0 100 0.0614035087719298 28 0 6 0 429 456 60 33 Centruroides edwardsii antimicrobial non-disulfide-bridged peptide (CR13_25) mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides edwardsii
15208049 15208049 PRJNA694557_P_NODE_14212_length_347_cov_2.956204_g13992_i0 PRJNA694557 14212 347 2.956204 10.25802788 Tapinoma 29038 Arthropoda Arthropoda 479 1.2699999999999996e-130   NTclustered gi|1196578271|gb|KY837778.1| 1996482 g13992 i0 93.252 92.2103746397695 326 20 94 2 1 325 584 260 Tapinoma sp. BIOUG17817-D12 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial blastn 31997 479 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Tapinoma Tapinoma sp. BIOUG17817-D12
15208075 15208075 PRJNA694557_P_NODE_16252_length_319_cov_2.146341_g16032_i0 PRJNA694557 16252 319 2.146341 6.84682779 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.03   NTclustered gi|2637447123|ref|XM_311289.6| 7165 g16032 i0 91.892 1.57680250783699 37 3 12 0 201 237 539 503 PREDICTED: Anopheles gambiae PHD finger protein 14 (LOC1272343), mRNA blastn 503 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles gambiae
15975912 15975912 PRJNA694557_P_NODE_11953_length_386_cov_2.629393_g11733_i0 PRJNA694557 11953 386 2.629393 10.14945698 Artemia franciscana 6661 Arthropoda Arthropoda 641 1.72e-179   NTclustered gi|2743022559|ref|XM_065726642.1| 6661 g11733 i0 96.632 1 386 13 100 0 1 386 4948 5333 PREDICTED: Artemia franciscana collagen alpha-1(V) chain-like (LOC136041863), mRNA blastn 386 641 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
17251211 17251211 PRJNA694557_P_NODE_20394_length_276_cov_1.517241_g20174_i0 PRJNA694557 20394 276 1.517241 4.18758516 Euplatamus sp. BYU CO760 1619737 Arthropoda Arthropoda 239 1.82e-58   NTclustered gi|763550798|gb|KP134032.1| 1619737 g20174 i0 82.784 99.25 273 42 99 4 3 275 1872 2139 Euplatamus sp. BYU CO760 18S ribosomal RNA gene, partial sequence blastn 27393 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silvanidae Euplatamus Euplatamus sp. BYU CO760
17757521 17757521 PRJNA694557_P_NODE_4734_length_688_cov_3.824390_g4520_i0 PRJNA694557 4734 688 3.82439 26.3118032 Artemia 6660 Arthropoda Arthropoda 1212 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g4520 i0 98.968 77.2267441860465 678 6 99 1 4 681 2472 1796 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 53132 1212 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
18525124 18525124 PRJNA694557_P_NODE_10415_length_421_cov_2.655172_g10195_i0 PRJNA694557 10415 421 2.655172 11.17827412 Periplaneta americana 6978 Arthropoda Arthropoda 296 1.6999999999999996e-75   NTclustered gi|2852208426|ref|XM_069829509.1| 6978 g10195 i0 87.023 5.11163895486936 262 34 62 0 1 262 1374 1635 PREDICTED: Periplaneta americana signal recognition particle 54k (Srp54k), mRNA blastn 2152 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
18525141 18525141 PRJNA694557_P_NODE_11655_length_392_cov_19.968652_g11435_i0 PRJNA694557 11655 392 19.968652 78.27711584 Coccinella septempunctata 41139 Arthropoda Arthropoda 69.4 3.72e-7   NTclustered gi|2125266636|ref|XR_006537940.1| 41139 g11435 i0 85.938 0.979591836734694 64 9 16 0 26 89 140 203 PREDICTED: Coccinella septempunctata uncharacterized LOC123315318 (LOC123315318), ncRNA blastn 384 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
18525441 18525441 PRJNA694557_P_NODE_5195_length_650_cov_4.324090_g4978_i0 PRJNA694557 5195 650 4.32409 28.106585 Battus philenor 42288 Arthropoda Arthropoda 54.7 0.018   NTclustered gi|2809182681|ref|XM_068770751.1| 42288 g4978 i0 100 0.0446153846153846 29 0 4 0 531 559 258 286 PREDICTED: Battus philenor secreted acidic protein 2-like (LOC137926983), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Battus Battus philenor
19800084 19800084 PRJNA694557_P_NODE_12676_length_371_cov_16.177852_g12456_i0 PRJNA694557 12676 371 16.177852 60.01983092 Blattella germanica 6973 Arthropoda Arthropoda 680 0   NTclustered gi|56261166|gb|AF005243.2| 6973 g12456 i0 99.73 78.5929919137466 371 1 100 0 1 371 5625 5995 Blattella germanica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and intergenic spacer and external transcribed spacer regions blastn 29158 680 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
19800138 19800138 PRJNA694557_P_NODE_15756_length_325_cov_2.301587_g15536_i0 PRJNA694557 15756 325 2.301587 7.48015775 Coptotermes formosanus 36987 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|506965362|gb|KC632258.1| 36987 g15536 i0 100 0.175384615384615 29 0 9 0 1 29 5 33 Coptotermes formosanus clone CFSNI2475 hypothetical protein mRNA, complete cds blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
19800145 19800145 PRJNA694557_P_NODE_16136_length_320_cov_5.453441_g15916_i0 PRJNA694557 16136 320 5.453441 17.4510112 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|2636206763|emb|OY979789.1| 52344 g15916 i0 100 0.0875 28 0 9 0 240 267 12978788 12978761 Helicoverpa assulta genome assembly, chromosome: 15 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
19800293 19800293 PRJNA694557_P_NODE_24376_length_247_cov_0.885057_g24156_i0 PRJNA694557 24376 247 0.885057 2.18609079 Aedes albopictus 7160 Arthropoda Arthropoda 451 1.88e-122   NTclustered gi|2669884492|ref|XR_009995940.1| 7160 g24156 i0 99.595 63.0647773279352 247 1 100 0 1 247 2382 2628 PREDICTED: Aedes albopictus large subunit ribosomal RNA (LOC115265922), rRNA blastn 15577 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
20305846 20305846 PRJNA694557_P_NODE_13576_length_356_cov_5.477032_g13356_i0 PRJNA694557 13576 356 5.477032 19.49823392 Opisthokonta 33154 Arthropoda Arthropoda 198 4.09e-46   NTclustered gi|1590297266|ref|XM_028317213.1| 93504 g13356 i0 81.2 44.5533707865169 250 43 70 3 5 252 447 694 PREDICTED: Ostrinia furnacalis NADH-ubiquinone oxidoreductase subunit 8-like (LOC114361977), mRNA blastn 15861 200 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia furnacalis
21581803 21581803 PRJNA694557_P_NODE_21737_length_264_cov_1.937173_g21517_i0 PRJNA694557 21737 264 1.937173 5.11413672 Mymar 326710 Arthropoda Arthropoda 424 4.44e-114   NTclustered gi|63095147|gb|AY949822.1| 326711 g21517 i0 95.817 99.6439393939394 263 9 99 2 2 263 2 263 Mymar sp. ZLS-2005 18S ribosomal RNA gene gene, partial sequence blastn 26306 424 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Mymaridae Mymar Mymar sp. ZLS-2005
22350584 22350584 PRJNA694557_P_NODE_15598_length_327_cov_2.488189_g15378_i0 PRJNA694557 15598 327 2.488189 8.13637803 Cartodere constricta 1531405 Arthropoda Arthropoda 178 4.86e-40   NTclustered gi|2620251915|gb|OR799814.1| 1531405 g15378 i0 94.068 36.9418960244648 118 6 36 1 210 327 186 302 Cartodere constricta isolate CcT1 large subunit ribosomal RNA gene, partial sequence blastn 12080 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Latridiidae Cartodere Cartodere constricta
22350596 22350596 PRJNA694557_P_NODE_16178_length_320_cov_2.101215_g15958_i0 PRJNA694557 16178 320 2.101215 6.723888 Artemia franciscana 6661 Arthropoda Arthropoda 479 1.1599999999999999e-130   NTclustered gi|2743028041|ref|XM_065704200.1| 6661 g15958 i0 95.082 1.128125 305 13 95 2 1 304 487 184 PREDICTED: Artemia franciscana small ribosomal subunit protein uS19-like (LOC136027187), mRNA blastn 361 479 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
24131346 24131346 PRJNA694557_P_NODE_16559_length_315_cov_4.714876_g16339_i0 PRJNA694557 16559 315 4.714876 14.8518594 Blattella 6972 Arthropoda Arthropoda 577 3.9299999999999986e-160   NTclustered gi|56261166|gb|AF005243.2| 6973 g16339 i0 99.684 99.8222222222222 316 0 100 1 1 315 5224 5539 Blattella germanica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and intergenic spacer and external transcribed spacer regions blastn 31444 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
25405852 25405852 PRJNA694557_P_NODE_11340_length_399_cov_3.567485_g11120_i0 PRJNA694557 11340 399 3.567485 14.23426515 Curculionidae 7042 Arthropoda Arthropoda 553 8.589999999999998e-153   NTclustered gi|2770087546|ref|XR_010753072.1| 1736056 g11120 i0 93.767 99.6967418546366 369 22 92 1 1 369 2569 2202 PREDICTED: Euwallacea similis large subunit ribosomal RNA (LOC136419106), rRNA blastn 39779 553 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea similis

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