contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1113956" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221868 | 221868 | PRJNA1113956_P_NODE_17541_length_279_cov_1.121359_g17201_i0 | PRJNA1113956 | 17541 | 279 | 1.121359 | 3.12859161 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 121 | 6.94e-23 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g17201 | i0 | 89.583 | 0.344086021505376 | 96 | 9 | 34 | 1 | 64 | 158 | 58894405 | 58894310 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 96 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 221941 | 221941 | PRJNA1113956_P_NODE_3021_length_1060_cov_1.779129_g2791_i0 | PRJNA1113956 | 3021 | 1060 | 1.779129 | 18.8587674 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 104 | 2.93e-17 | NTclustered | gi|1207908411|ref|XM_021506535.1| | 6573 | g2791 | i0 | 75.829 | 6.58867924528302 | 211 | 47 | 20 | 4 | 534 | 742 | 991 | 1199 | PREDICTED: Mizuhopecten yessoensis Krueppel-like factor 6 (LOC110456019), mRNA | blastn | 6984 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 1496602 | 1496602 | PRJNA1113956_P_NODE_1202_length_1614_cov_14.957171_g1102_i0 | PRJNA1113956 | 1202 | 1614 | 14.957171 | 241.40873994 | Ostrea edulis | 37623 | Mollusca | Mollusca | 86.1 | 1.64e-11 | NTclustered | gi|2507356719|ref|XM_048922008.2| | 37623 | g1102 | i0 | 80.469 | 0.219950433705081 | 128 | 12 | 13 | 11 | 511 | 636 | 2640 | 2756 | PREDICTED: Ostrea edulis uncharacterized LOC125681791 (LOC125681791), mRNA | blastn | 355 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 1496745 | 1496745 | PRJNA1113956_P_NODE_23002_length_228_cov_2.735484_g22662_i0 | PRJNA1113956 | 23002 | 228 | 2.735484 | 6.23690352 | Patella vulgata | 6465 | Mollusca | Mollusca | 158 | 4.189999999999999e-34 | NTclustered | gi|2506322087|ref|XM_050547997.2| | 6465 | g22662 | i0 | 79.913 | 3.81578947368421 | 229 | 35 | 98 | 10 | 6 | 228 | 1670 | 1893 | PREDICTED: Patella vulgata DNA repair and recombination protein RAD54-like (LOC126819775), mRNA | blastn | 870 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 1496767 | 1496767 | PRJNA1113956_P_NODE_7582_length_552_cov_1.258873_g7249_i0 | PRJNA1113956 | 7582 | 552 | 1.258873 | 6.94897896 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 534 | 4.43e-147 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g7249 | i0 | 84.182 | 0.996376811594203 | 550 | 87 | 99 | 0 | 1 | 550 | 54020415 | 54020964 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 550 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4048801 | 4048801 | PRJNA1113956_P_NODE_12604_length_364_cov_1.185567_g12264_i0 | PRJNA1113956 | 12604 | 364 | 1.185567 | 4.31546388 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 58.4 | 7.42e-4 | NTclustered | gi|2628378382|ref|XM_061339954.1| | 191078 | g12264 | i0 | 94.595 | 0.101648351648352 | 37 | 2 | 10 | 0 | 131 | 167 | 1012 | 1048 | PREDICTED: Saccostrea echinata cilia- and flagella-associated protein 251-like (LOC133204205), mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 7874875 | 7874875 | PRJNA1113956_P_NODE_2367_length_1210_cov_17.187335_g1102_i1 | PRJNA1113956 | 2367 | 1210 | 17.187335 | 207.9667535 | Ostrea edulis | 37623 | Mollusca | Mollusca | 86.1 | 1.22e-11 | NTclustered | gi|2507356719|ref|XM_048922008.2| | 37623 | g1102 | i1 | 80.469 | 0.146280991735537 | 128 | 12 | 10 | 11 | 711 | 836 | 2756 | 2640 | PREDICTED: Ostrea edulis uncharacterized LOC125681791 (LOC125681791), mRNA | blastn | 177 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 9149754 | 9149754 | PRJNA1113956_P_NODE_8628_length_499_cov_1.129108_g8290_i0 | PRJNA1113956 | 8628 | 499 | 1.129108 | 5.63424892 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 374 | 9.159999999999999e-99 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g8290 | i0 | 80.691 | 147.685370741483 | 492 | 85 | 98 | 9 | 1 | 486 | 20623232 | 20623719 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 73695 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11700669 | 11700669 | PRJNA1113956_P_NODE_15850_length_304_cov_1.333333_g15510_i0 | PRJNA1113956 | 15850 | 304 | 1.333333 | 4.05333232 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 255 | 2.01e-63 | NTclustered | gi|1697381098|ref|XM_029799679.1| | 2607531 | g15510 | i0 | 85.2 | 12.9407894736842 | 250 | 35 | 82 | 2 | 57 | 304 | 442 | 193 | PREDICTED: Octopus sinensis uncharacterized LOC115229305 (LOC115229305), mRNA | blastn | 3934 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 16799168 | 16799168 | PRJNA1113956_P_NODE_8434_length_509_cov_1.149083_g8096_i0 | PRJNA1113956 | 8434 | 509 | 1.149083 | 5.84883247 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 486 | 1.15e-132 | NTclustered | gi|2502143854|ref|XM_056017726.1| | 6526 | g8096 | i0 | 89.947 | 2.80157170923379 | 378 | 37 | 74 | 1 | 33 | 410 | 1654 | 1278 | PREDICTED: Biomphalaria glabrata uncharacterized LOC106065353 (LOC106065353), transcript variant X1, mRNA | blastn | 1426 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 18073676 | 18073676 | PRJNA1113956_P_NODE_9295_length_468_cov_2.230380_g8956_i0 | PRJNA1113956 | 9295 | 468 | 2.23038 | 10.4381784 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 132 | 5.68e-26 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g8956 | i0 | 73.723 | 1.57051282051282 | 411 | 76 | 83 | 20 | 80 | 467 | 47932472 | 47932071 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 735 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21898931 | 21898931 | PRJNA1113956_P_NODE_838_length_1844_cov_12.159797_g762_i0 | PRJNA1113956 | 838 | 1844 | 12.159797 | 224.22665668 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 213 | 8.24e-50 | NTclustered | gi|1242769886|ref|XM_022468655.1| | 6565 | g762 | i0 | 78.261 | 1.34544468546638 | 345 | 65 | 21 | 8 | 30 | 372 | 2544 | 2208 | PREDICTED: Crassostrea virginica flocculation protein FLO11-like (LOC111125150), mRNA | blastn | 2481 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica |
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);;