contig_metadata
24 rows where bioproject = "PRJNA529224" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1773182 | 1773182 | PRJNA529224_S_NODE_82_length_478_cov_729.004454_g77_i0 | PRJNA529224 | 82 | 478 | 729.004454 | 3484.64129012 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 872 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g77 | i0 | 99.789 | 42.6506276150628 | 475 | 1 | 99 | 0 | 3 | 477 | 3711 | 3237 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 20387 | 872 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 2389981 | 2389981 | PRJNA529224_S_NODE_1342_length_182_cov_40.385621_g1335_i0 | PRJNA529224 | 1342 | 182 | 40.385621 | 73.50183022 | Artemia | 6660 | Arthropoda | Arthropoda | 329 | 6.39e-86 | NTclustered | gi|5835051|ref|NC_001620.1| | 6661 | g1335 | i0 | 100 | 15.5054945054945 | 178 | 0 | 98 | 0 | 1 | 178 | 13823 | 14000 | Artemia franciscana clone pMA-1 & pMA-3 mitochondrion, complete genome | blastn | 2822 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 3048988 | 3048988 | PRJNA529224_S_NODE_223_length_364_cov_26.844776_g216_i0 | PRJNA529224 | 223 | 364 | 26.844776 | 97.71498464 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 662 | 0 | NTclustered | gi|5835051|ref|NC_001620.1| | 6661 | g216 | i0 | 99.724 | 84.7472527472527 | 362 | 0 | 99 | 1 | 1 | 362 | 13486 | 13846 | Artemia franciscana clone pMA-1 & pMA-3 mitochondrion, complete genome | blastn | 30848 | 662 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 3665716 | 3665716 | PRJNA529224_S_NODE_1623_length_164_cov_8.955556_g1616_i0 | PRJNA529224 | 1623 | 164 | 8.955556 | 14.68711184 | Artemia | 6660 | Arthropoda | Arthropoda | 303 | 3.42e-78 | NTclustered | gi|288551058|gb|GU323293.1| | 6661 | g1616 | i0 | 100 | 99.719512195122 | 164 | 0 | 100 | 0 | 1 | 164 | 481 | 644 | Artemia franciscana isolate GNM 002 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 16354 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 6875668 | 6875668 | PRJNA529224_S_NODE_1566_length_168_cov_59.021583_g1559_i0 | PRJNA529224 | 1566 | 168 | 59.021583 | 99.15625944 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 298 | 1.64e-76 | NTclustered | gi|2743030216|ref|XR_010619008.1| | 6661 | g1559 | i0 | 99.39 | 88.0416666666667 | 164 | 1 | 98 | 0 | 3 | 166 | 164 | 1 | PREDICTED: Artemia franciscana U1 spliceosomal RNA (LOC136033747), ncRNA | blastn | 14791 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 6875672 | 6875672 | PRJNA529224_S_NODE_1706_length_160_cov_9.938931_g1699_i0 | PRJNA529224 | 1706 | 160 | 9.938931 | 15.9022896 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 296 | 5.55e-76 | NTclustered | gi|288551058|gb|GU323293.1| | 6661 | g1699 | i0 | 100 | 100 | 160 | 0 | 100 | 0 | 1 | 160 | 310 | 469 | Artemia franciscana isolate GNM 002 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 16000 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7492554 | 7492554 | PRJNA529224_S_NODE_146_length_412_cov_575.953003_g139_i0 | PRJNA529224 | 146 | 412 | 575.953003 | 2372.92637236 | Artemia | 6660 | Arthropoda | Arthropoda | 749 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g139 | i0 | 99.513 | 46.7572815533981 | 411 | 2 | 99 | 0 | 2 | 412 | 355 | 765 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 19264 | 749 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7492572 | 7492572 | PRJNA529224_S_NODE_346_length_314_cov_754.807018_g339_i0 | PRJNA529224 | 346 | 314 | 754.807018 | 2370.09403652 | Artemia | 6660 | Arthropoda | Arthropoda | 566 | 8.489999999999998e-157 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g339 | i0 | 99.359 | 88.703821656051 | 312 | 2 | 99 | 0 | 3 | 314 | 766 | 1077 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 27853 | 566 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 8767489 | 8767489 | PRJNA529224_S_NODE_1927_length_151_cov_11.631148_g1920_i0 | PRJNA529224 | 1927 | 151 | 11.631148 | 17.56303348 | Calanoida | 6833 | Arthropoda | Arthropoda | 243 | 6.81e-60 | NTclustered | gi|13877160|gb|AF367719.1|AF367719 | 6837 | g1920 | i0 | 97.872 | 92.7218543046358 | 141 | 2 | 93 | 1 | 11 | 151 | 1399 | 1538 | Calanus finmarchicus 18S small subunit ribosomal RNA gene, partial sequence | blastn | 14001 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Calanoida | Calanidae | Calanus | Calanus finmarchicus | |
| 10701989 | 10701989 | PRJNA529224_S_NODE_1069_length_201_cov_7.191860_g1062_i0 | PRJNA529224 | 1069 | 201 | 7.19186 | 14.4556386 | Neoleptoneta serena | 1124203 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|373502653|gb|JN378385.1| | 1124203 | g1062 | i0 | 81.69 | 0.960199004975124 | 71 | 10 | 34 | 2 | 133 | 201 | 554 | 485 | Neoleptoneta serena voucher 9040724 28S ribosomal RNA gene, partial sequence | blastn | 193 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Leptonetidae | Neoleptoneta | Neoleptoneta serena | |
| 11317679 | 11317679 | PRJNA529224_S_NODE_489_length_277_cov_671.572581_g482_i0 | PRJNA529224 | 489 | 277 | 671.572581 | 1860.25604937 | Artemia | 6660 | Arthropoda | Arthropoda | 501 | 2.11e-137 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g482 | i0 | 99.278 | 37.5379061371841 | 277 | 2 | 100 | 0 | 1 | 277 | 67 | 343 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 10398 | 501 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 11317691 | 11317691 | PRJNA529224_S_NODE_9_length_871_cov_547.194774_g6_i0 | PRJNA529224 | 9 | 871 | 547.194774 | 4766.06648154 | Artemia | 6660 | Arthropoda | Arthropoda | 1539 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g6 | i0 | 98.621 | 65.150401836969 | 870 | 11 | 99 | 1 | 1 | 869 | 2493 | 1624 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 56746 | 1539 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 15800608 | 15800608 | PRJNA529224_S_NODE_1013_length_205_cov_584.352273_g1006_i0 | PRJNA529224 | 1013 | 205 | 584.352273 | 1197.92215965 | Bactrocera neohumeralis | 98809 | Arthropoda | Arthropoda | 372 | 1.21e-98 | NTclustered | gi|2293659406|ref|XR_007669052.1| | 98809 | g1006 | i0 | 99.51 | 105.482926829268 | 204 | 1 | 99 | 0 | 1 | 204 | 2616 | 2819 | PREDICTED: Bactrocera neohumeralis large subunit ribosomal RNA (LOC126767288), rRNA | blastn | 21624 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Bactrocera | Bactrocera neohumeralis | |
| 16417252 | 16417252 | PRJNA529224_S_NODE_533_length_265_cov_555.813559_g526_i0 | PRJNA529224 | 533 | 265 | 555.813559 | 1472.90593135 | Artemia | 6660 | Arthropoda | Arthropoda | 479 | 9.38e-131 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g526 | i0 | 99.248 | 101.588679245283 | 266 | 1 | 100 | 1 | 1 | 265 | 2664 | 2929 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 26921 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 16417261 | 16417261 | PRJNA529224_S_NODE_813_length_223_cov_442.530928_g806_i0 | PRJNA529224 | 813 | 223 | 442.530928 | 986.84396944 | Artemia | 6660 | Arthropoda | Arthropoda | 396 | 7.939999999999995e-106 | NTclustered | gi|2295022767|gb|OP365120.1| | 6661 | g806 | i0 | 98.655 | 99.9865470852018 | 223 | 3 | 100 | 0 | 1 | 223 | 1273 | 1495 | Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence | blastn | 22297 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 17075291 | 17075291 | PRJNA529224_S_NODE_114_length_444_cov_16.809639_g107_i0 | PRJNA529224 | 114 | 444 | 16.809639 | 74.63479716 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 440 | 7.849999999999997e-119 | NTclustered | gi|2743049377|ref|XM_065720999.1| | 6661 | g107 | i0 | 95.652 | 1.39414414414414 | 276 | 9 | 62 | 2 | 162 | 437 | 3717 | 3445 | PREDICTED: Artemia franciscana lachesin-like (LOC136038049), transcript variant X2, mRNA | blastn | 619 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 18966057 | 18966057 | PRJNA529224_S_NODE_1115_length_197_cov_519.523810_g1108_i0 | PRJNA529224 | 1115 | 197 | 519.52381 | 1023.4619057 | Artemia | 6660 | Arthropoda | Arthropoda | 353 | 4.18e-93 | NTclustered | gi|2295022767|gb|OP365120.1| | 6661 | g1108 | i0 | 98.985 | 100.081218274112 | 197 | 2 | 100 | 0 | 1 | 197 | 805 | 1001 | Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence | blastn | 19716 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 20240950 | 20240950 | PRJNA529224_S_NODE_1156_length_194_cov_11.854545_g1149_i0 | PRJNA529224 | 1156 | 194 | 11.854545 | 22.9978173 | Artemia | 6660 | Arthropoda | Arthropoda | 359 | 8.809999999999999e-95 | NTclustered | gi|288551058|gb|GU323293.1| | 6661 | g1149 | i0 | 100 | 100.005154639175 | 194 | 0 | 100 | 0 | 1 | 194 | 264 | 71 | Artemia franciscana isolate GNM 002 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 19401 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 20240954 | 20240954 | PRJNA529224_S_NODE_1496_length_174_cov_7.558621_g1489_i0 | PRJNA529224 | 1496 | 174 | 7.558621 | 13.15200054 | Entomobryomorpha | 730330 | Arthropoda | Arthropoda | 316 | 4.7e-82 | NTclustered | gi|472455904|gb|KC236258.1| | 187695 | g1489 | i0 | 99.425 | 100.436781609195 | 174 | 1 | 100 | 0 | 1 | 174 | 141 | 314 | Sinella curviseta 18S ribosomal RNA gene, partial sequence | blastn | 17476 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Entomobryomorpha | Entomobryidae | Sinella | Sinella curviseta | |
| 21516460 | 21516460 | PRJNA529224_S_NODE_537_length_264_cov_510.570213_g530_i0 | PRJNA529224 | 537 | 264 | 510.570213 | 1347.90536232 | Artemia | 6660 | Arthropoda | Arthropoda | 473 | 4.3399999999999986e-129 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g530 | i0 | 99.237 | 99.905303030303 | 262 | 2 | 99 | 0 | 1 | 262 | 1452 | 1191 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 26375 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 22174786 | 22174786 | PRJNA529224_S_NODE_658_length_242_cov_8.657277_g651_i0 | PRJNA529224 | 658 | 242 | 8.657277 | 20.95061034 | Microvelia longipes | 1101180 | Arthropoda | Arthropoda | 176 | 1.24e-39 | NTclustered | gi|1591624019|gb|MH591927.1| | 1101180 | g651 | i0 | 98.98 | 0.40495867768595 | 98 | 1 | 40 | 0 | 1 | 98 | 2872 | 2969 | Microvelia longipes 28S ribosomal RNA gene, partial sequence | blastn | 98 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Veliidae | Microvelia | Microvelia longipes | |
| 24066418 | 24066418 | PRJNA529224_S_NODE_699_length_236_cov_581.714976_g692_i0 | PRJNA529224 | 699 | 236 | 581.714976 | 1372.84734336 | Artemia | 6660 | Arthropoda | Arthropoda | 424 | 3.89e-114 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g692 | i0 | 99.149 | 104.228813559322 | 235 | 2 | 99 | 0 | 2 | 236 | 1410 | 1644 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 24598 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 24723992 | 24723992 | PRJNA529224_S_NODE_1060_length_201_cov_823.540698_g1053_i0 | PRJNA529224 | 1060 | 201 | 823.540698 | 1655.31680298 | Artemia sp. | 6662 | Arthropoda | Arthropoda | 350 | 5.539999999999999e-92 | NTclustered | gi|161177|gb|M33097.1|SHRRGBA | 6662 | g1053 | i0 | 98.01 | 56.5273631840796 | 201 | 4 | 100 | 0 | 1 | 201 | 368 | 168 | Artemia sp. 5.8S ribosomal RNA gene, complete sequence | blastn | 11362 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia sp. | |
| 25340843 | 25340843 | PRJNA529224_S_NODE_1200_length_189_cov_38.700000_g1193_i0 | PRJNA529224 | 1200 | 189 | 38.7 | 73.143 | root | 1 | Root_unresolved | Root_unresolved | 350 | 5.14e-92 | NTclustered | gi|83281396|gb|AC167967.6| | 7176 | g1193 | i0 | 100 | 163 | 189 | 0 | 100 | 0 | 1 | 189 | 126 | 314 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence | blastn | 30807 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus |
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);;