contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3328408 | 3328408 | PRJNA792582_P_NODE_9143_length_560_cov_1.268994_g8343_i0 | PRJNA792582 | 9143 | 560 | 1.268994 | 7.1063664 | Pecten maximus | 6579 | Mollusca | Mollusca | 135 | 5.33e-27 | NTclustered | gi|1835496000|ref|XM_033879172.1| | 6579 | g8343 | i0 | 76.806 | 1.04107142857143 | 263 | 48 | 46 | 12 | 36 | 291 | 401 | 657 | PREDICTED: Pecten maximus ras-related C3 botulinum toxin substrate 1 (LOC117323741), mRNA | blastn | 583 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 4605143 | 4605143 | PRJNA792582_P_NODE_19324_length_391_cov_2.745283_g18510_i0 | PRJNA792582 | 19324 | 391 | 2.745283 | 10.73405653 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 215 | 4.5e-51 | NTclustered | gi|2868663362|ref|XM_070355825.1| | 31220 | g18510 | i0 | 87.568 | 43.8951406649616 | 185 | 23 | 47 | 0 | 1 | 185 | 1315 | 1499 | PREDICTED: Littorina saxatilis tubulin alpha-1 chain-like (LOC138982521), transcript variant X1, mRNA | blastn | 17163 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 10980765 | 10980765 | PRJNA792582_P_NODE_16149_length_429_cov_1.297753_g15335_i0 | PRJNA792582 | 16149 | 429 | 1.297753 | 5.56736037 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 115 | 5.2e-21 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g15335 | i0 | 79.874 | 0.643356643356643 | 159 | 30 | 37 | 2 | 6 | 163 | 2119560 | 2119403 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 276 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14805579 | 14805579 | PRJNA792582_P_NODE_40592_length_276_cov_1.517241_g39778_i0 | PRJNA792582 | 40592 | 276 | 1.517241 | 4.18758516 | Mytilus californianus | 6549 | Mollusca | Mollusca | 99 | 3.21e-16 | NTclustered | gi|2334779967|ref|XM_052213681.1| | 6549 | g39778 | i0 | 74.494 | 0.894927536231884 | 247 | 53 | 88 | 5 | 6 | 247 | 3298 | 3057 | PREDICTED: Mytilus californianus myosin heavy chain, striated muscle-like (LOC127708640), mRNA | blastn | 247 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 18628558 | 18628558 | PRJNA792582_P_NODE_41535_length_274_cov_0.905473_g40721_i0 | PRJNA792582 | 41535 | 274 | 0.905473 | 2.48099602 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g40721 | i0 | 94.444 | 0.131386861313869 | 36 | 0 | 12 | 1 | 4 | 37 | 48696790 | 48696825 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19903656 | 19903656 | PRJNA792582_P_NODE_25356_length_343_cov_1.711111_g24542_i0 | PRJNA792582 | 25356 | 343 | 1.711111 | 5.86911073 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.032 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g24542 | i0 | 100 | 0.0816326530612245 | 28 | 0 | 8 | 0 | 66 | 93 | 2800657 | 2800684 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21179261 | 21179261 | PRJNA792582_P_NODE_14797_length_446_cov_13.801609_g13984_i0 | PRJNA792582 | 14797 | 446 | 13.801609 | 61.55517614 | Mollusca environmental sample | 653389 | Mollusca | Mollusca | 342 | 2.2899999999999998e-89 | NTclustered | gi|156254524|gb|EF528299.1| | 653389 | g13984 | i0 | 91.837 | 55.1322869955157 | 245 | 20 | 55 | 0 | 201 | 445 | 761 | 1005 | Uncultured mollusc isolate XenLSU7 28S ribosomal RNA gene, partial sequence | blastn | 24589 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Mollusca environmental sample | |||||
| 21179735 | 21179735 | PRJNA792582_P_NODE_60497_length_231_cov_2.436709_g59683_i0 | PRJNA792582 | 60497 | 231 | 2.436709 | 5.62879779 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g59683 | i0 | 100 | 0.121212121212121 | 28 | 0 | 12 | 0 | 141 | 168 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22454503 | 22454503 | PRJNA792582_P_NODE_59998_length_237_cov_2.664634_g59184_i0 | PRJNA792582 | 59998 | 237 | 2.664634 | 6.31518258 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 89.8 | 1.62e-13 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g59184 | i0 | 91.045 | 1.57383966244726 | 67 | 5 | 28 | 1 | 2 | 67 | 22400192 | 22400126 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 373 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22454506 | 22454506 | PRJNA792582_P_NODE_60118_length_236_cov_2.147239_g59304_i0 | PRJNA792582 | 60118 | 236 | 2.147239 | 5.06748404 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 198 | 2.57e-46 | NTclustered | gi|2669131618|ref|XM_062743142.1| | 36930 | g59304 | i0 | 81.974 | 21.5932203389831 | 233 | 42 | 99 | 0 | 1 | 233 | 556 | 788 | PREDICTED: Saccostrea cucullata tubulin alpha-1A chain-like (LOC134260594), mRNA | blastn | 5096 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;