contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916625 | 2916625 | PRJNA195897_P_NODE_1463_length_437_cov_1.265464_g1430_i0 | PRJNA195897 | 1463 | 437 | 1.265464 | 5.53007768 | Platynereis dumerilii | 6359 | Annelida | Annelida | 171 | 1.12e-37 | NTclustered | gi|613484554|gb|KJ405466.1| | 6359 | g1430 | i0 | 78.214 | 0.640732265446224 | 280 | 52 | 63 | 9 | 107 | 381 | 3148 | 2873 | Platynereis dumerilii isolate PlduMyo2 myosin mRNA, complete cds | blastn | 280 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 4193061 | 4193061 | PRJNA195897_P_NODE_2584_length_311_cov_0.916031_g2551_i0 | PRJNA195897 | 2584 | 311 | 0.916031 | 2.84885641 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 150 | 1e-31 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g2551 | i0 | 82.759 | 15.5787781350482 | 174 | 25 | 55 | 5 | 78 | 249 | 2296170 | 2296000 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 4845 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5469300 | 5469300 | PRJNA195897_P_NODE_185_length_1126_cov_17.654596_g169_i0 | PRJNA195897 | 185 | 1126 | 17.654596 | 198.79075096 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 359 | 6.029999999999998e-94 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g169 | i0 | 81.21 | 16.8152753108348 | 463 | 72 | 40 | 10 | 137 | 588 | 472 | 14 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18934 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 5469383 | 5469383 | PRJNA195897_P_NODE_9765_length_168_cov_0.873950_g9732_i0 | PRJNA195897 | 9765 | 168 | 0.87395 | 1.468236 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 130 | 6.34e-26 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g9732 | i0 | 81.529 | 0.93452380952381 | 157 | 29 | 93 | 0 | 1 | 157 | 18585434 | 18585278 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 157 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 7433193 | 7433193 | PRJNA195897_P_NODE_726_length_637_cov_2.267007_g696_i0 | PRJNA195897 | 726 | 637 | 2.267007 | 14.44083459 | Mesenchytraeus | 223747 | Annelida | Annelida | 416 | 1.95e-111 | NTclustered | gi|1068288652|gb|KU728818.1| | 223748 | g696 | i0 | 81.025 | 66.5400313971743 | 527 | 96 | 82 | 4 | 113 | 637 | 1376 | 852 | Mesenchytraeus solifugus elongation factor 1-alpha mRNA, complete cds | blastn | 42386 | 416 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Mesenchytraeus | Mesenchytraeus solifugus | |
| 8019347 | 8019347 | PRJNA195897_P_NODE_2647_length_306_cov_1.280156_g2614_i0 | PRJNA195897 | 2647 | 306 | 1.280156 | 3.91727736 | Phragmatopoma californica | 13208 | Annelida | Annelida | 191 | 5.799999999999998e-44 | NTclustered | gi|74145747|gb|DQ172686.1| | 13208 | g2614 | i0 | 78.694 | 73.1960784313726 | 291 | 58 | 94 | 4 | 14 | 302 | 8 | 296 | Phragmatopoma californica strain PC clone 5 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 22398 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Phragmatopoma | Phragmatopoma californica | |
| 9294100 | 9294100 | PRJNA195897_P_NODE_8128_length_176_cov_1.464567_g8095_i0 | PRJNA195897 | 8128 | 176 | 1.464567 | 2.57763792 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 296 | 6.21e-76 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g8095 | i0 | 97.143 | 88.2159090909091 | 175 | 5 | 99 | 0 | 2 | 176 | 3436 | 3262 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 15526 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 10570099 | 10570099 | PRJNA195897_P_NODE_8089_length_176_cov_1.984252_g8056_i0 | PRJNA195897 | 8089 | 176 | 1.984252 | 3.49228352 | Aeolosoma viride | 394736 | Annelida | Annelida | 231 | 1.78e-56 | NTclustered | gi|1151119859|gb|KY079093.1| | 394736 | g8056 | i0 | 90.341 | 99.5227272727273 | 176 | 17 | 100 | 0 | 1 | 176 | 222 | 397 | Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds | blastn | 17516 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma viride | |
| 13119749 | 13119749 | PRJNA195897_P_NODE_2031_length_359_cov_1.480645_g1998_i0 | PRJNA195897 | 2031 | 359 | 1.480645 | 5.31551555 | Platynereis dumerilii | 6359 | Annelida | Annelida | 263 | 1.44e-65 | NTclustered | gi|83307011|emb|CT032985.1| | 6359 | g1998 | i0 | 81.288 | 64.4428969359331 | 326 | 60 | 91 | 1 | 3 | 328 | 691 | 367 | Platynereis dumerilii EST IB0AAA28BH01EM1 | blastn | 23135 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 22732059 | 22732059 | PRJNA195897_P_NODE_2818_length_294_cov_1.742857_g2785_i0 | PRJNA195897 | 2818 | 294 | 1.742857 | 5.1239995800000004 | Polynoidae | 46593 | Annelida | Annelida | 86.1 | 2.69e-12 | NTclustered | gi|2054260827|gb|MZ131647.1| | 862921 | g2785 | i0 | 77.564 | 13.0340136054422 | 156 | 26 | 52 | 8 | 50 | 202 | 10170 | 10319 | Arctonoe vittata mitochondrion, complete genome | blastn | 3832 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Polynoidae | Arctonoe | Arctonoe vittata | |
| 24007278 | 24007278 | PRJNA195897_P_NODE_4639_length_223_cov_0.896552_g4606_i0 | PRJNA195897 | 4639 | 223 | 0.896552 | 1.99931096 | Aeolosoma | 55816 | Annelida | Annelida | 187 | 5.1999999999999984e-43 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g4606 | i0 | 96.491 | 44.0179372197309 | 114 | 2 | 51 | 2 | 1 | 113 | 2696 | 2808 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 9816 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 |
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);;