contig_metadata
19 rows where bioproject = "PRJNA642647", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1158570 | 1158570 | PRJNA642647_P_NODE_4441_length_172_cov_1.548148_g4391_i0 | PRJNA642647 | 4441 | 172 | 1.548148 | 2.66281456 | Cyclopoida | 84308 | Arthropoda | Arthropoda | 67.6 | 5.15e-7 | NTclustered | gi|1680763763|gb|MF077854.2| | 2031039 | g4391 | i0 | 97.436 | 22.3779069767442 | 39 | 1 | 23 | 0 | 127 | 165 | 196 | 234 | Cyclopinodes sp. DZMB060 28S ribosomal RNA gene, partial sequence | blastn | 3849 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Cyclopoida | Hemicyclopinidae | Cyclopinodes | Cyclopinodes sp. DZMB060 | |
| 1894188 | 1894188 | PRJNA642647_P_NODE_2222_length_230_cov_2.134715_g2172_i0 | PRJNA642647 | 2222 | 230 | 2.134715 | 4.9098445 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 222 | 1.4799999999999999e-53 | NTclustered | gi|2284206805|ref|XM_049994226.1| | 7010 | g2172 | i0 | 90.116 | 83.795652173913 | 172 | 15 | 74 | 2 | 33 | 203 | 3054 | 3224 | PREDICTED: Schistocerca gregaria uncharacterized LOC126321793 (LOC126321793), mRNA | blastn | 19273 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 1894207 | 1894207 | PRJNA642647_P_NODE_3402_length_192_cov_1.090323_g3352_i0 | PRJNA642647 | 3402 | 192 | 1.090323 | 2.09342016 | Daphnia galeata | 27404 | Arthropoda | Arthropoda | 339 | 1.13e-88 | NTclustered | gi|3265072|gb|AF070102.1|AF070102 | 27404 | g3352 | i0 | 98.942 | 58.2916666666667 | 189 | 2 | 98 | 0 | 4 | 192 | 231 | 419 | Daphnia galeata 18S ribosomal RNA gene, partial sequence | blastn | 11192 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 4445657 | 4445657 | PRJNA642647_P_NODE_1244_length_314_cov_3.888087_g1194_i0 | PRJNA642647 | 1244 | 314 | 3.888087 | 12.20859318 | Daphnia galeata | 27404 | Arthropoda | Arthropoda | 488 | 1.8899999999999996e-133 | NTclustered | gi|189172079|gb|EU595548.1| | 27404 | g1194 | i0 | 94.242 | 105.162420382166 | 330 | 2 | 99 | 3 | 1 | 313 | 623 | 294 | Daphnia galeata 28S ribosomal RNA gene, partial sequence; 28S-18S ribosomal RNA intergenic spacer, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 33021 | 488 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 5721525 | 5721525 | PRJNA642647_P_NODE_3945_length_181_cov_1.187500_g3895_i0 | PRJNA642647 | 3945 | 181 | 1.1875 | 2.149375 | Daphnia galeata | 27404 | Arthropoda | Arthropoda | 309 | 8.26e-80 | NTclustered | gi|22417209|gb|AF532888.1| | 27404 | g3895 | i0 | 97.778 | 91.2541436464088 | 180 | 2 | 98 | 2 | 4 | 181 | 1119 | 940 | Daphnia galeata 28S ribosomal RNA gene, partial sequence | blastn | 16517 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 5721526 | 5721526 | PRJNA642647_P_NODE_4065_length_179_cov_1.056338_g4015_i0 | PRJNA642647 | 4065 | 179 | 1.056338 | 1.89084502 | Penaeus indicus | 29960 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|2695699728|ref|XM_063755067.1| | 29960 | g4015 | i0 | 100 | 0.167597765363128 | 30 | 0 | 17 | 0 | 3 | 32 | 776 | 747 | PREDICTED: Penaeus indicus uncharacterized LOC134784880 (LOC134784880), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus indicus | |
| 5721541 | 5721541 | PRJNA642647_P_NODE_5625_length_160_cov_3.609756_g5575_i0 | PRJNA642647 | 5625 | 160 | 3.609756 | 5.7756096 | Hydrobaenus distinctus | 2675304 | Arthropoda | Arthropoda | 206 | 9.63e-49 | NTclustered | gi|2490581703|gb|OQ834327.1| | 2675304 | g5575 | i0 | 91.083 | 99.65625 | 157 | 7 | 98 | 5 | 3 | 158 | 2042 | 1892 | Hydrobaenus distinctus isolate 44 HYD-GTS1D8-1 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 15945 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Hydrobaenus | Hydrobaenus distinctus | |
| 8271292 | 8271292 | PRJNA642647_P_NODE_4727_length_168_cov_1.618321_g4677_i0 | PRJNA642647 | 4727 | 168 | 1.618321 | 2.71877928 | Daphnia galeata | 27404 | Arthropoda | Arthropoda | 287 | 3.55e-73 | NTclustered | gi|3249663|gb|AF070497.1|AF070497 | 27404 | g4677 | i0 | 97.633 | 66.8690476190476 | 169 | 1 | 99 | 1 | 3 | 168 | 105 | 273 | Daphnia galeata small subunit ribosomal RNA gene, partial sequence | blastn | 11234 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 8271321 | 8271321 | PRJNA642647_P_NODE_967_length_359_cov_3.937888_g917_i0 | PRJNA642647 | 967 | 359 | 3.937888 | 14.13701792 | Paracortinidae sp. B QY-2009 | 595192 | Arthropoda | Arthropoda | 87.9 | 9.32e-13 | NTclustered | gi|222875983|gb|FJ605298.1| | 595192 | g917 | i0 | 76.744 | 31.033426183844 | 172 | 28 | 46 | 11 | 196 | 359 | 3479 | 3312 | Paracortinidae sp. B QY-2009 28S ribosomal RNA gene, partial sequence | blastn | 11141 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Diplopoda | Callipodida | Paracortinidae | Paracortinidae sp. B QY-2009 | ||
| 10087071 | 10087071 | PRJNA642647_P_NODE_4428_length_172_cov_2.407407_g4378_i0 | PRJNA642647 | 4428 | 172 | 2.407407 | 4.14074004 | Insecta | 50557 | Arthropoda | Arthropoda | 154 | 3.84e-33 | NTclustered | gi|302585238|gb|HM802155.1| | 7176 | g4378 | i0 | 100 | 73.6569767441861 | 83 | 0 | 92 | 0 | 90 | 172 | 359 | 441 | Culex quinquefasciatus isolate 05 MDU 28S ribosomal RNA gene, partial sequence | blastn | 12669 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 12637723 | 12637723 | PRJNA642647_P_NODE_2850_length_206_cov_3.384615_g2800_i0 | PRJNA642647 | 2850 | 206 | 3.384615 | 6.9723069 | Chironomidae | 7149 | Arthropoda | Arthropoda | 370 | 4.38e-98 | NTclustered | gi|255760248|gb|GQ371030.1| | 333810 | g2800 | i0 | 99.507 | 98.5339805825243 | 203 | 1 | 99 | 0 | 1 | 203 | 266 | 64 | Chironomidae environmental sample clone Chironomidae13 18S ribosomal RNA gene, partial sequence | blastn | 20298 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomidae environmental sample | ||
| 12637746 | 12637746 | PRJNA642647_P_NODE_5890_length_157_cov_1.700000_g5840_i0 | PRJNA642647 | 5890 | 157 | 1.7 | 2.669 | Daphnia | 6668 | Arthropoda | Arthropoda | 276 | 7.06e-70 | NTclustered | gi|189172079|gb|EU595548.1| | 27404 | g5840 | i0 | 98.718 | 99.3630573248408 | 156 | 0 | 98 | 1 | 4 | 157 | 99 | 254 | Daphnia galeata 28S ribosomal RNA gene, partial sequence; 28S-18S ribosomal RNA intergenic spacer, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 15600 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 20284949 | 20284949 | PRJNA642647_P_NODE_1676_length_268_cov_1.658009_g1626_i0 | PRJNA642647 | 1676 | 268 | 1.658009 | 4.44346412 | Daphnia | 6668 | Arthropoda | Arthropoda | 472 | 1.5899999999999999e-128 | NTclustered | gi|22417209|gb|AF532888.1| | 27404 | g1626 | i0 | 99.612 | 96.1716417910448 | 258 | 1 | 96 | 0 | 4 | 261 | 50 | 307 | Daphnia galeata 28S ribosomal RNA gene, partial sequence | blastn | 25774 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 20284969 | 20284969 | PRJNA642647_P_NODE_4696_length_168_cov_2.801527_g4646_i0 | PRJNA642647 | 4696 | 168 | 2.801527 | 4.70656536 | Artemia | 6660 | Arthropoda | Arthropoda | 226 | 7.859999999999997e-55 | NTclustered | gi|161177|gb|M33097.1|SHRRGBA | 6662 | g4646 | i0 | 92.121 | 48.3035714285714 | 165 | 3 | 98 | 1 | 1 | 165 | 331 | 177 | Artemia sp. 5.8S ribosomal RNA gene, complete sequence | blastn | 8115 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia sp. | |
| 20284971 | 20284971 | PRJNA642647_P_NODE_5716_length_159_cov_3.081967_g5666_i0 | PRJNA642647 | 5716 | 159 | 3.081967 | 4.90032753 | Daphnia | 6668 | Arthropoda | Arthropoda | 276 | 7.18e-70 | NTclustered | gi|57902419|gb|AY730378.1| | 27404 | g5666 | i0 | 98.71 | 95.0691823899371 | 155 | 2 | 97 | 0 | 2 | 156 | 747 | 593 | Daphnia galeata isolate AK1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15116 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 21020358 | 21020358 | PRJNA642647_P_NODE_1237_length_315_cov_2.708633_g1187_i0 | PRJNA642647 | 1237 | 315 | 2.708633 | 8.53219395 | Paracortinidae sp. B QY-2009 | 595192 | Arthropoda | Arthropoda | 87.9 | 8.08e-13 | NTclustered | gi|222875983|gb|FJ605298.1| | 595192 | g1187 | i0 | 76.744 | 35.368253968254 | 172 | 28 | 52 | 11 | 152 | 315 | 3479 | 3312 | Paracortinidae sp. B QY-2009 28S ribosomal RNA gene, partial sequence | blastn | 11141 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Diplopoda | Callipodida | Paracortinidae | Paracortinidae sp. B QY-2009 | ||
| 21020392 | 21020392 | PRJNA642647_P_NODE_3837_length_183_cov_1.335616_g3787_i0 | PRJNA642647 | 3837 | 183 | 1.335616 | 2.44417728 | Daphnia galeata | 27404 | Arthropoda | Arthropoda | 326 | 8.32e-85 | NTclustered | gi|22417209|gb|AF532888.1| | 27404 | g3787 | i0 | 98.907 | 86.9234972677596 | 183 | 1 | 99 | 1 | 2 | 183 | 541 | 723 | Daphnia galeata 28S ribosomal RNA gene, partial sequence | blastn | 15907 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia galeata | |
| 25384934 | 25384934 | PRJNA642647_P_NODE_3440_length_191_cov_1.311688_g3390_i0 | PRJNA642647 | 3440 | 191 | 1.311688 | 2.50532408 | Daphnia | 6668 | Arthropoda | Arthropoda | 283 | 5.35e-72 | NTclustered | gi|48686615|gb|AY630606.1| | 247387 | g3390 | i0 | 93.401 | 103.078534031414 | 197 | 4 | 98 | 7 | 4 | 191 | 226 | 422 | Daphnia pileata 28S ribosomal RNA gene, partial sequence | blastn | 19688 | 285 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pileata | |
| 31389314 | 31389314 | PRJNA642647_P_NODE_1236_length_315_cov_2.996403_g1186_i0 | PRJNA642647 | 1236 | 315 | 2.996403 | 9.43866945 | Metazoa | 33208 | Arthropoda | Arthropoda | 45.8 | 0.00668 | NR | XP_050359582.1 | 171585 | g1186 | i0 | 28.6 | 4.22857142857143 | 91 | 40 | 71.4 | 4 | 296 | 72 | 214 | 295 | XP_050359582.1 myoneurin-like isoform X2 [Nymphalis io] | diamond | 1332 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Nymphalidae | Nymphalis | Nymphalis io |
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);;