contig_metadata
23 rows where bioproject = "PRJNA784298" and tax_phylum = "Arthropoda"
This data as json, CSV (advanced)
| 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 | |
| 4593750 | 4593750 | PRJNA784298_P_NODE_8144_length_441_cov_2.008152_g7943_i0 | PRJNA784298 | 8144 | 441 | 2.008152 | 8.85595032 | Darwinula stevensoni | 69355 | Arthropoda | Arthropoda | 149 | 5.76e-41 | NR | CAD7255224.1 | 69355 | g7943 | i0 | 54.8 | 0.993197278911565 | 146 | 40 | 99.3 | 2 | 439 | 2 | 84 | 203 | CAD7255224.1 unnamed protein product, partial [Darwinula stevensoni] | diamond | 438 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 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 | |
| 19892125 | 19892125 | PRJNA784298_P_NODE_1696_length_983_cov_2.086813_g1536_i0 | PRJNA784298 | 1696 | 983 | 2.086813 | 20.51337179 | Idotea baltica | 82763 | Arthropoda | Arthropoda | 372 | 5.34e-125 | NR | MCL4166761.1 | 82763 | g1536 | i0 | 60.6 | 0.991861648016277 | 325 | 124 | 99.2 | 1 | 1 | 975 | 23 | 343 | MCL4166761.1 hypothetical protein [Idotea baltica] | diamond | 975 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 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 | |
| 23718288 | 23718288 | PRJNA784298_P_NODE_59_length_4639_cov_8.504380_g50_i0 | PRJNA784298 | 59 | 4639 | 8.50438 | 394.5181882 | root | 1 | Root_unresolved | Root_unresolved | 960 | 0 | NR | CAG4649328.1 | 202097 | g50 | i0 | 47.9 | 1.11230868721707 | 1223 | 428 | 78.6 | 13 | 3649 | 2 | 3 | 1023 | CAG4649328.1 EOG090X067V, partial [Scapholeberis mucronata] | diamond | 5160 | 960 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Scapholeberis | Scapholeberis mucronata | |
| 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 | |
| 28578926 | 28578926 | PRJNA784298_P_NODE_23727_length_251_cov_0.865169_g23526_i0 | PRJNA784298 | 23727 | 251 | 0.865169 | 2.17157419 | Arthropoda | 6656 | Arthropoda | Arthropoda | 52 | 1.68e-5 | NR | XP_017462234.1 | 28612 | g23526 | i0 | 41.3 | 1.91235059760956 | 80 | 47 | 95.6 | 0 | 8 | 247 | 94 | 173 | XP_017462234.1 PREDICTED: E3 ubiquitin-protein ligase Bre1-like [Rhagoletis zephyria] | diamond | 480 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Rhagoletis | Rhagoletis zephyria | |
| 30505330 | 30505330 | PRJNA784298_P_NODE_25593_length_245_cov_0.895349_g25392_i0 | PRJNA784298 | 25593 | 245 | 0.895349 | 2.19360505 | Amphipoda | 6821 | Arthropoda | Arthropoda | 64.7 | 3.72e-10 | NR | XP_018026009.1 | 294128 | g25392 | i0 | 75 | 2.71836734693878 | 44 | 11 | 53.9 | 0 | 245 | 114 | 217 | 260 | XP_018026009.1 40S ribosomal protein S4 [Hyalella azteca] | diamond | 666 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Amphipoda | Hyalellidae | Hyalella | Hyalella azteca |
Advanced export
JSON shape: default, array, newline-delimited
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);;