contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2087891 | 2087891 | PRJNA812715_P_NODE_120602_length_241_cov_1.375000_g118801_i0 | PRJNA812715 | 120602 | 241 | 1.375 | 3.31375 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g118801 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 38 | 65 | 60624127 | 60624100 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4641463 | 4641463 | PRJNA812715_P_NODE_32224_length_524_cov_2.793792_g30451_i0 | PRJNA812715 | 32224 | 524 | 2.793792 | 14.63947008 | Aplysia californica | 6500 | Mollusca | Mollusca | 289 | 3.6e-73 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g30451 | i0 | 78.889 | 81.7977099236641 | 450 | 77 | 84 | 17 | 71 | 511 | 502 | 62 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 42862 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 5916410 | 5916410 | PRJNA812715_P_NODE_34965_length_494_cov_1.059382_g33181_i0 | PRJNA812715 | 34965 | 494 | 1.059382 | 5.23334708 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.004 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g33181 | i0 | 100 | 0.0607287449392713 | 30 | 0 | 6 | 0 | 311 | 340 | 46322434 | 46322405 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9740176 | 9740176 | PRJNA812715_P_NODE_117248_length_243_cov_0.905882_g115447_i0 | PRJNA812715 | 117248 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g115447 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 90 | 117 | 3230307 | 3230280 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16115892 | 16115892 | PRJNA812715_P_NODE_44553_length_414_cov_1.354839_g42757_i0 | PRJNA812715 | 44553 | 414 | 1.354839 | 5.60903346 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|1207961858|ref|XM_021515645.1| | 6573 | g42757 | i0 | 100 | 0.140096618357488 | 29 | 0 | 7 | 0 | 203 | 231 | 12225 | 12197 | PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110461911 (LOC110461911), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 17390585 | 17390585 | PRJNA812715_P_NODE_121374_length_241_cov_0.916667_g119573_i0 | PRJNA812715 | 121374 | 241 | 0.916667 | 2.20916747 | Argopecten irradians | 31199 | Mollusca | Mollusca | 150 | 7.48e-32 | NTclustered | gi|2835372062|ref|XM_069260327.1| | 31199 | g119573 | i0 | 78.788 | 10.9792531120332 | 231 | 43 | 95 | 5 | 5 | 232 | 912 | 1139 | PREDICTED: Argopecten irradians 26S proteasome regulatory subunit 6B (LOC138318169), transcript variant X2, mRNA | blastn | 2646 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 22490306 | 22490306 | PRJNA812715_P_NODE_47938_length_393_cov_4.375000_g46141_i0 | PRJNA812715 | 47938 | 393 | 4.375 | 17.19375 | Magallana angulata | 2784310 | Mollusca | Mollusca | 69.4 | 3.73e-7 | NTclustered | gi|2416977037|ref|XM_052828112.1| | 2784310 | g46141 | i0 | 84.932 | 0.987277353689567 | 73 | 5 | 17 | 4 | 296 | 362 | 2186 | 2258 | PREDICTED: Crassostrea angulata fibroin heavy chain-like (LOC128164320), mRNA | blastn | 388 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 23767427 | 23767427 | PRJNA812715_P_NODE_96879_length_258_cov_1.335135_g95078_i0 | PRJNA812715 | 96879 | 258 | 1.335135 | 3.4446483 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.08e-5 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g95078 | i0 | 100 | 122.821705426357 | 34 | 0 | 14 | 0 | 1 | 34 | 45637449 | 45637482 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 31688 | 63.9 | 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);;