contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA682370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174569 | 1174569 | PRJNA682370_S_NODE_13541_length_195_cov_1.287500_g12929_i0 | PRJNA682370 | 13541 | 195 | 1.2875 | 2.510625 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.017 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g12929 | i0 | 96.774 | 0.58974358974359 | 31 | 1 | 16 | 0 | 15 | 45 | 24894104 | 24894074 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 115 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1940177 | 1940177 | PRJNA682370_S_NODE_13902_length_192_cov_3.222930_g13290_i0 | PRJNA682370 | 13902 | 192 | 3.22293 | 6.1880256 | Argopecten irradians | 31199 | Mollusca | Mollusca | 165 | 2.04e-36 | NTclustered | gi|2835362839|ref|XM_069255417.1| | 31199 | g13290 | i0 | 90.984 | 60.828125 | 122 | 11 | 64 | 0 | 71 | 192 | 1465 | 1344 | PREDICTED: Argopecten irradians tubulin alpha-1A chain (LOC138314838), transcript variant X3, mRNA | blastn | 11679 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 4492074 | 4492074 | PRJNA682370_S_NODE_11704_length_212_cov_1.242938_g11092_i0 | PRJNA682370 | 11704 | 212 | 1.242938 | 2.63502856 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g11092 | i0 | 92.5 | 0.188679245283019 | 40 | 2 | 18 | 1 | 150 | 188 | 39677782 | 39677821 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9593163 | 9593163 | PRJNA682370_S_NODE_7368_length_280_cov_1.877551_g6756_i0 | PRJNA682370 | 7368 | 280 | 1.877551 | 5.2571428 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g6756 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 43 | 70 | 12127837 | 12127810 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12143553 | 12143553 | PRJNA682370_S_NODE_13650_length_194_cov_1.792453_g13038_i0 | PRJNA682370 | 13650 | 194 | 1.792453 | 3.47735882 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g13038 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 116 | 143 | 36324007 | 36324034 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12654036 | 12654036 | PRJNA682370_S_NODE_1730_length_646_cov_2.597381_g1231_i0 | PRJNA682370 | 1730 | 646 | 2.597381 | 16.77908126 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.018 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g1231 | i0 | 100 | 0.0990712074303406 | 29 | 0 | 4 | 0 | 502 | 530 | 44290752 | 44290780 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15966836 | 15966836 | PRJNA682370_S_NODE_11033_length_219_cov_1.527174_g10421_i0 | PRJNA682370 | 11033 | 219 | 1.527174 | 3.34451106 | Argopecten irradians | 31199 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2671790613|gb|PP199154.1| | 31199 | g10421 | i0 | 94.595 | 0.168949771689498 | 37 | 1 | 16 | 1 | 85 | 120 | 23627 | 23663 | Argopecten irradians clone evm.model.58.139.1 spatiotemporal phototransduction pathway protein gene, complete cds | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 22341466 | 22341466 | PRJNA682370_S_NODE_13458_length_195_cov_2.568750_g12846_i0 | PRJNA682370 | 13458 | 195 | 2.56875 | 5.0090625 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g12846 | i0 | 100 | 1.06666666666667 | 29 | 0 | 15 | 0 | 159 | 187 | 50774929 | 50774901 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 208 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23617386 | 23617386 | PRJNA682370_S_NODE_5759_length_328_cov_1.426621_g5147_i0 | PRJNA682370 | 5759 | 328 | 1.426621 | 4.67931688 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g5147 | i0 | 100 | 0.170731707317073 | 28 | 0 | 9 | 0 | 212 | 239 | 24250590 | 24250563 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23617490 | 23617490 | PRJNA682370_S_NODE_9039_length_247_cov_1.599057_g8427_i0 | PRJNA682370 | 9039 | 247 | 1.599057 | 3.94967079 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g8427 | i0 | 94.444 | 0.145748987854251 | 36 | 1 | 14 | 1 | 190 | 224 | 9159878 | 9159913 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 36 | 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);;