contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 571616 | 571616 | PRJNA599026_S_NODE_35401_length_190_cov_1.205674_g34945_i0 | PRJNA599026 | 35401 | 190 | 1.205674 | 2.2907806 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|2507375411|ref|XM_048910264.2| | 37623 | g34945 | i0 | 100 | 0.294736842105263 | 28 | 0 | 15 | 0 | 147 | 174 | 377 | 404 | PREDICTED: Ostrea edulis uncharacterized LOC125673629 (LOC125673629), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 1847239 | 1847239 | PRJNA599026_S_NODE_26602_length_210_cov_1.776398_g26146_i0 | PRJNA599026 | 26602 | 210 | 1.776398 | 3.7304358 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|1897932986|ref|XM_035971234.1| | 6500 | g26146 | i0 | 96.774 | 0.147619047619048 | 31 | 1 | 15 | 0 | 11 | 41 | 709 | 739 | PREDICTED: Aplysia californica vacuolar protein sorting-associated protein 16 homolog (LOC101855205), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 3122883 | 3122883 | PRJNA599026_S_NODE_59223_length_164_cov_1.773913_g58767_i0 | PRJNA599026 | 59223 | 164 | 1.773913 | 2.90921732 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g58767 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 87 | 114 | 8953122 | 8953149 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6949682 | 6949682 | PRJNA599026_S_NODE_17406_length_245_cov_3.719388_g16950_i0 | PRJNA599026 | 17406 | 245 | 3.719388 | 9.1125006 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g16950 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 162 | 189 | 2800684 | 2800657 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6950348 | 6950348 | PRJNA599026_S_NODE_70906_length_161_cov_0.910714_g70450_i0 | PRJNA599026 | 70906 | 161 | 0.910714 | 1.46624954 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 215 | 1.61e-51 | NTclustered | gi|2616656598|ref|XM_060746348.1| | 129788 | g70450 | i0 | 99.16 | 38.8198757763975 | 119 | 1 | 74 | 0 | 43 | 161 | 3911 | 4029 | PREDICTED: Ruditapes philippinarum pyridine nucleotide-disulfide oxidoreductase domain-containing protein 2-like (LOC132755474), mRNA | blastn | 6250 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 6950397 | 6950397 | PRJNA599026_S_NODE_9686_length_313_cov_62.045455_g9230_i0 | PRJNA599026 | 9686 | 313 | 62.045455 | 194.20227415 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 58.4 | 6.29e-4 | NTclustered | gi|2427236072|ref|XR_008263788.1| | 37653 | g9230 | i0 | 94.737 | 0.485623003194888 | 38 | 1 | 12 | 1 | 202 | 238 | 51 | 88 | PREDICTED: Octopus bimaculoides uncharacterized LOC106869889 (LOC106869889), transcript variant X3, ncRNA | blastn | 152 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 7519251 | 7519251 | PRJNA599026_S_NODE_7146_length_359_cov_99.870968_g6690_i0 | PRJNA599026 | 7146 | 359 | 99.870968 | 358.53677512 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g6690 | i0 | 100 | 1.50696378830084 | 28 | 0 | 8 | 0 | 76 | 103 | 5126 | 5153 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 541 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 9500465 | 9500465 | PRJNA599026_S_NODE_63968_length_163_cov_0.894737_g63512_i0 | PRJNA599026 | 63968 | 163 | 0.894737 | 1.45842131 | Lottia gigantea | 225164 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|676455747|ref|XM_009055859.1| | 225164 | g63512 | i0 | 100 | 0.171779141104294 | 28 | 0 | 17 | 0 | 41 | 68 | 657 | 630 | Lottia gigantea hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 10775726 | 10775726 | PRJNA599026_S_NODE_15809_length_254_cov_363.600000_g15353_i0 | PRJNA599026 | 15809 | 254 | 363.6 | 923.544 | Optediceros sp. h HC-2024 | 3127693 | Mollusca | Mollusca | 100 | 8.12e-17 | NTclustered | gi|2695323868|gb|PP438319.1| | 3127693 | g15353 | i0 | 91.892 | 12.507874015748 | 74 | 3 | 28 | 3 | 1 | 72 | 142 | 70 | Optediceros sp. h HC-2024 mitochondrion, complete genome | blastn | 3177 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Assimineidae | Optediceros | Optediceros sp. h HC-2024 | |
| 13326063 | 13326063 | PRJNA599026_S_NODE_74811_length_152_cov_5.941748_g74355_i0 | PRJNA599026 | 74811 | 152 | 5.941748 | 9.03145696 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 2.67e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g74355 | i0 | 97.059 | 0.223684210526316 | 34 | 1 | 22 | 0 | 17 | 50 | 10542472 | 10542505 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17149010 | 17149010 | PRJNA599026_S_NODE_11414_length_291_cov_6.185950_g10958_i0 | PRJNA599026 | 11414 | 291 | 6.18595 | 18.0011145 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|1242736601|ref|XM_022440247.1| | 6565 | g10958 | i0 | 96.97 | 0.11340206185567 | 33 | 0 | 11 | 1 | 91 | 122 | 2708 | 2740 | PREDICTED: Crassostrea virginica hypermethylated in cancer 2 protein-like (LOC111105807), transcript variant X1, mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 19697994 | 19697994 | PRJNA599026_S_NODE_22976_length_221_cov_2.162791_g22520_i0 | PRJNA599026 | 22976 | 221 | 2.162791 | 4.77976811 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g22520 | i0 | 97.059 | 0.153846153846154 | 34 | 0 | 15 | 1 | 88 | 120 | 10695198 | 10695165 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19698026 | 19698026 | PRJNA599026_S_NODE_25156_length_214_cov_1.521212_g24700_i0 | PRJNA599026 | 25156 | 214 | 1.521212 | 3.25539368 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g24700 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 70 | 97 | 33892630 | 33892603 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22248801 | 22248801 | PRJNA599026_S_NODE_39058_length_183_cov_1.932836_g38602_i0 | PRJNA599026 | 39058 | 183 | 1.932836 | 3.53708988 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|2669155244|ref|XM_062754907.1| | 36930 | g38602 | i0 | 100 | 0.153005464480874 | 28 | 0 | 15 | 0 | 59 | 86 | 1225 | 1252 | PREDICTED: Saccostrea cucullata MFS-type transporter SLC18B1-like (LOC134272701), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;