contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8024436 | 8024436 | PRJNA278119_P_NODE_18127_length_240_cov_1.633508_g17878_i0 | PRJNA278119 | 18127 | 240 | 1.633508 | 3.9204192 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 444 | 3.05e-120 | NTclustered | gi|28415639|dbj|AB103394.1| | 6573 | g17878 | i0 | 100 | 13.070833333333301 | 240 | 0 | 100 | 0 | 1 | 240 | 472 | 233 | Mizuhopecten yessoensis mitochondrial gene for 16S rRNA, partial sequence | blastn | 3137 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 9299333 | 9299333 | PRJNA278119_P_NODE_2688_length_745_cov_2.063218_g2465_i0 | PRJNA278119 | 2688 | 745 | 2.063218 | 15.3709741 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 54.7 | 0.021 | NTclustered | gi|2442051363|ref|XM_045339644.2| | 6596 | g2465 | i0 | 94.444 | 0.14496644295302 | 36 | 0 | 5 | 2 | 33 | 66 | 7714 | 7679 | PREDICTED: Mercenaria mercenaria PR domain zinc finger protein 1-like (LOC123551033), transcript variant X2, mRNA | blastn | 108 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 13124832 | 13124832 | PRJNA278119_P_NODE_11211_length_345_cov_42.652027_g10964_i0 | PRJNA278119 | 11211 | 345 | 42.652027 | 147.14949315 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 230 | 1.4099999999999995e-55 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g10964 | i0 | 81.72 | 5.31594202898551 | 279 | 48 | 81 | 3 | 43 | 321 | 55579207 | 55579482 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 1834 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14399986 | 14399986 | PRJNA278119_P_NODE_11272_length_344_cov_2.267797_g11025_i0 | PRJNA278119 | 11272 | 344 | 2.267797 | 7.80122168 | Ostrea edulis | 37623 | Mollusca | Mollusca | 176 | 1.85e-39 | NTclustered | gi|2507342384|ref|XM_048896550.2| | 37623 | g11025 | i0 | 80 | 6.92441860465116 | 250 | 40 | 71 | 9 | 99 | 343 | 137 | 381 | PREDICTED: Ostrea edulis serine/threonine-protein phosphatase 4 catalytic subunit (LOC125664049), transcript variant X1, mRNA | blastn | 2382 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 20772825 | 20772825 | PRJNA278119_P_NODE_35357_length_169_cov_0.866667_g35108_i0 | PRJNA278119 | 35357 | 169 | 0.866667 | 1.46466723 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 255 | 1e-63 | NTclustered | gi|1207982408|ref|XM_021485099.1| | 6573 | g35108 | i0 | 94.083 | 10.4023668639053 | 169 | 9 | 100 | 1 | 1 | 169 | 975 | 808 | PREDICTED: Mizuhopecten yessoensis putative uncharacterized protein YghX (LOC110441835), transcript variant X1, mRNA | blastn | 1758 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 20772899 | 20772899 | PRJNA278119_P_NODE_41297_length_165_cov_1.344828_g41048_i0 | PRJNA278119 | 41297 | 165 | 1.344828 | 2.2189662 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g41048 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 15 | 42 | 25718586 | 25718559 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20772954 | 20772954 | PRJNA278119_P_NODE_4577_length_562_cov_1.475634_g4334_i0 | PRJNA278119 | 4577 | 562 | 1.475634 | 8.29306308 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 1033 | 0 | NTclustered | gi|2088231943|ref|NC_056622.1| | 6573 | g4334 | i0 | 99.822 | 53.9928825622776 | 562 | 1 | 100 | 0 | 1 | 562 | 5378 | 5939 | Mizuhopecten yessoensis mitochondrion, complete genome | blastn | 30344 | 1033 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 22047541 | 22047541 | PRJNA278119_P_NODE_13578_length_303_cov_1.090551_g13330_i0 | PRJNA278119 | 13578 | 303 | 1.090551 | 3.3043695300000002 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 1.01e-6 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g13330 | i0 | 95.238 | 6.0990099009901 | 42 | 2 | 14 | 0 | 40 | 81 | 47316734 | 47316693 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 1848 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22047996 | 22047996 | PRJNA278119_P_NODE_47378_length_162_cov_0.920354_g47129_i0 | PRJNA278119 | 47378 | 162 | 0.920354 | 1.49097348 | Perna viridis | 73031 | Mollusca | Mollusca | 147 | 6.009999999999999e-31 | NTclustered | gi|56967588|gb|AY850128.1| | 73031 | g47129 | i0 | 94.681 | 0.580246913580247 | 94 | 5 | 58 | 0 | 68 | 161 | 307 | 214 | Perna viridis clone GM8 microsatellite sequence | blastn | 94 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Perna | Perna viridis | |
| 23323137 | 23323137 | PRJNA278119_P_NODE_19099_length_231_cov_1.076923_g18850_i0 | PRJNA278119 | 19099 | 231 | 1.076923 | 2.48769213 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g18850 | i0 | 100 | 0.125541125541126 | 29 | 0 | 13 | 0 | 106 | 134 | 28741211 | 28741239 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;