contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 960718 | 960718 | PRJNA980839_P_NODE_99761_length_363_cov_1.324138_g95977_i0 | PRJNA980839 | 99761 | 363 | 1.324138 | 4.80662094 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 93.5 | 2.03e-14 | NTclustered | gi|2442016429|ref|XR_008367939.1| | 6596 | g95977 | i0 | 98.113 | 84.129476584022 | 53 | 1 | 15 | 0 | 311 | 363 | 1096 | 1148 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123541009 (LOC123541009), ncRNA | blastn | 30539 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 6061905 | 6061905 | PRJNA980839_P_NODE_209465_length_248_cov_0.880000_g205681_i0 | PRJNA980839 | 209465 | 248 | 0.88 | 2.1824 | Mytilus californianus | 6549 | Mollusca | Mollusca | 58.4 | 4.82e-4 | NTclustered | gi|2334651268|ref|XM_052230318.1| | 6549 | g205681 | i0 | 92.5 | 0.161290322580645 | 40 | 3 | 16 | 0 | 135 | 174 | 189 | 150 | PREDICTED: Mytilus californianus uncharacterized LOC127723618 (LOC127723618), mRNA | blastn | 40 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 8611943 | 8611943 | PRJNA980839_P_NODE_229727_length_243_cov_0.905882_g225943_i0 | PRJNA980839 | 229727 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g225943 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 159 | 187 | 1436319 | 1436291 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9886708 | 9886708 | PRJNA980839_P_NODE_209608_length_248_cov_0.880000_g205824_i0 | PRJNA980839 | 209608 | 248 | 0.88 | 2.1824 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g205824 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 85 | 112 | 1064979 | 1064952 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17535343 | 17535343 | PRJNA980839_P_NODE_149394_length_287_cov_3.971963_g145610_i0 | PRJNA980839 | 149394 | 287 | 3.971963 | 11.39953381 | Elysia crispata | 231223 | Mollusca | Mollusca | 531 | 2.799999999999999e-146 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g145610 | i0 | 100 | 4.39024390243902 | 287 | 0 | 100 | 0 | 1 | 287 | 8385 | 8671 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 1260 | 531 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 18808743 | 18808743 | PRJNA980839_P_NODE_124155_length_318_cov_1.608163_g120371_i0 | PRJNA980839 | 124155 | 318 | 1.608163 | 5.11395834 | Elysia crispata | 231223 | Mollusca | Mollusca | 582 | 8.549999999999998e-162 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g120371 | i0 | 99.686 | 53.9591194968553 | 318 | 1 | 100 | 0 | 1 | 318 | 13155 | 13472 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 17159 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 20086249 | 20086249 | PRJNA980839_P_NODE_48836_length_618_cov_6.196330_g45105_i0 | PRJNA980839 | 48836 | 618 | 6.19633 | 38.2933194 | Elysia crispata | 231223 | Mollusca | Mollusca | 1125 | 0 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g45105 | i0 | 99.515 | 72.5388349514563 | 618 | 3 | 100 | 0 | 1 | 618 | 8644 | 9261 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 44829 | 1125 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata |
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);;