contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 310147 | 310147 | PRJNA1160211_S_NODE_262821_length_251_cov_9.735955_g261588_i0 | PRJNA1160211 | 262821 | 251 | 9.735955 | 24.43724705 | Argopecten irradians | 31199 | Mollusca | Mollusca | 158 | 4.69e-34 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g261588 | i0 | 94.175 | 42.0517928286853 | 103 | 6 | 41 | 0 | 149 | 251 | 1442 | 1340 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 10555 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 310279 | 310279 | PRJNA1160211_S_NODE_282441_length_241_cov_1.833333_g281208_i0 | PRJNA1160211 | 282441 | 241 | 1.833333 | 4.41833253 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 5.99e-8 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g281208 | i0 | 86.364 | 0.680497925311203 | 66 | 8 | 27 | 1 | 87 | 151 | 21814849 | 21814784 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 164 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5412650 | 5412650 | PRJNA1160211_S_NODE_191605_length_320_cov_7.000000_g190372_i0 | PRJNA1160211 | 191605 | 320 | 7 | 22.4 | Meghimatium bilineatum | 318265 | Mollusca | Mollusca | 481 | 3.23e-131 | NTclustered | gi|1700712087|gb|MN022678.1| | 318265 | g190372 | i0 | 97.842 | 86.675 | 278 | 6 | 87 | 0 | 21 | 298 | 1409 | 1132 | Meghimatium bilineatum 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 27736 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Philomycidae | Meghimatium | Meghimatium bilineatum | |
| 5412899 | 5412899 | PRJNA1160211_S_NODE_22485_length_693_cov_5.959677_g21458_i0 | PRJNA1160211 | 22485 | 693 | 5.959677 | 41.30056161 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.019 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g21458 | i0 | 94.444 | 0.251082251082251 | 36 | 1 | 5 | 1 | 624 | 658 | 9926607 | 9926642 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7962291 | 7962291 | PRJNA1160211_S_NODE_11887_length_787_cov_28.985994_g11049_i0 | PRJNA1160211 | 11887 | 787 | 28.985994 | 228.11977278 | Burnupia sp. bup | 2664636 | Mollusca | Mollusca | 121 | 2.13e-22 | NTclustered | gi|1772640088|gb|MN644824.1| | 2664636 | g11049 | i0 | 91.86 | 5.92376111817027 | 86 | 7 | 11 | 0 | 21 | 106 | 455 | 540 | Burnupia sp. bup 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence. | blastn | 4662 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Ancylidae | Burnupia | Burnupia sp. bup | ||
| 11788850 | 11788850 | PRJNA1160211_S_NODE_274810_length_245_cov_1.505814_g273577_i0 | PRJNA1160211 | 274810 | 245 | 1.505814 | 3.6892443 | Meghimatium bilineatum | 318265 | Mollusca | Mollusca | 442 | 1.1199999999999994e-119 | NTclustered | gi|61228787|gb|AY841348.1| | 318265 | g273577 | i0 | 99.184 | 100 | 245 | 2 | 100 | 0 | 1 | 245 | 820 | 576 | Meghimatium bilineatum 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 24500 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Philomycidae | Meghimatium | Meghimatium bilineatum | |
| 11789030 | 11789030 | PRJNA1160211_S_NODE_301370_length_196_cov_19.284553_g300137_i0 | PRJNA1160211 | 301370 | 196 | 19.284553 | 37.79772388 | Deroceras reticulatum | 145610 | Mollusca | Mollusca | 268 | 1.5499999999999998e-67 | NTclustered | gi|973291011|gb|KU341314.1| | 145610 | g300137 | i0 | 94.828 | 84.3163265306122 | 174 | 6 | 89 | 3 | 1 | 174 | 1070 | 900 | Deroceras reticulatum isolate N_derr_ci 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16526 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Agriolimacidae | Deroceras | Deroceras reticulatum | |
| 13063532 | 13063532 | PRJNA1160211_S_NODE_231091_length_278_cov_10.780488_g229858_i0 | PRJNA1160211 | 231091 | 278 | 10.780488 | 29.96975664 | Donax cuneatus | 120567 | Mollusca | Mollusca | 71.3 | 7.06e-8 | NTclustered | gi|47496707|dbj|AB126328.1| | 120567 | g229858 | i0 | 73.684 | 0.751798561151079 | 209 | 44 | 72 | 5 | 26 | 224 | 2691 | 2898 | Donax cuneatus gene for ITS2, 28S rRNA, partial sequence, country:Japan:Okinawa, Nago | blastn | 209 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Donacidae | Donax | Donax cuneatus | |
| 15611798 | 15611798 | PRJNA1160211_S_NODE_110693_length_437_cov_6.730769_g109464_i0 | PRJNA1160211 | 110693 | 437 | 6.730769 | 29.41346053 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 60.2 | 2.52e-4 | NTclustered | gi|2911910252|ref|XM_071232738.1| | 6455 | g109464 | i0 | 100 | 0.0732265446224256 | 32 | 0 | 7 | 0 | 136 | 167 | 87 | 118 | PREDICTED: Haliotis cracherodii mucin-2-like (LOC139450912), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 15613683 | 15613683 | PRJNA1160211_S_NODE_95373_length_466_cov_6.806616_g94148_i0 | PRJNA1160211 | 95373 | 466 | 6.806616 | 31.71883056 | Donax cuneatus | 120567 | Mollusca | Mollusca | 69.4 | 4.5e-7 | NTclustered | gi|47496707|dbj|AB126328.1| | 120567 | g94148 | i0 | 77.206 | 7.59871244635193 | 136 | 20 | 27 | 5 | 282 | 407 | 2898 | 2764 | Donax cuneatus gene for ITS2, 28S rRNA, partial sequence, country:Japan:Okinawa, Nago | blastn | 3541 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Donacidae | Donax | Donax cuneatus | |
| 16887095 | 16887095 | PRJNA1160211_S_NODE_234454_length_275_cov_5.599010_g233221_i0 | PRJNA1160211 | 234454 | 275 | 5.59901 | 15.3972775 | Koreoleptoxis friniana | 2582462 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2592710666|gb|OR567887.1| | 2582462 | g233221 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 0 | 190 | 217 | 11553 | 11526 | Koreoleptoxis friniana mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Pleuroceridae | Koreoleptoxis | Koreoleptoxis friniana | ||
| 16887407 | 16887407 | PRJNA1160211_S_NODE_281514_length_242_cov_0.905325_g280281_i0 | PRJNA1160211 | 281514 | 242 | 0.905325 | 2.1908865 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 139 | 1.63e-28 | NTclustered | gi|2034332302|ref|XM_041508297.1| | 1735272 | g280281 | i0 | 83.784 | 0.776859504132231 | 148 | 23 | 61 | 1 | 1 | 147 | 280 | 427 | PREDICTED: Gigantopelta aegis histone-lysine N-methyltransferase SETMAR-like (LOC121379649), mRNA | blastn | 188 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 17616449 | 17616449 | PRJNA1160211_S_NODE_27554_length_664_cov_7.499154_g26470_i0 | PRJNA1160211 | 27554 | 664 | 7.499154 | 49.79438256 | Metazoa | 33208 | Mollusca | Mollusca | 475 | 3.31e-129 | NTclustered | gi|1207963313|ref|XM_021516415.1| | 6573 | g26470 | i0 | 81.915 | 84.835843373494 | 564 | 101 | 85 | 1 | 12 | 574 | 602 | 39 | PREDICTED: Mizuhopecten yessoensis tubulin beta-4B chain-like (LOC110462461), transcript variant X2, mRNA | blastn | 56331 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 17616579 | 17616579 | PRJNA1160211_S_NODE_31974_length_642_cov_43.237258_g30870_i0 | PRJNA1160211 | 31974 | 642 | 43.237258 | 277.58319636 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 2.95e-5 | NTclustered | gi|2913002590|dbj|AP039619.1| | 145626 | g30870 | i0 | 87.273 | 0.685358255451713 | 55 | 7 | 9 | 0 | 588 | 642 | 251269 | 251323 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored10, sequence | blastn | 440 | 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);;