contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA938397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2188665 | 2188665 | PRJNA938397_S_NODE_34802_length_187_cov_2.933333_g34561_i0 | PRJNA938397 | 34802 | 187 | 2.933333 | 5.48533271 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 58.4 | 3.44e-4 | NTclustered | gi|1397677502|ref|XM_025234711.1| | 400727 | g34561 | i0 | 90.909 | 0.705882352941177 | 44 | 3 | 24 | 1 | 137 | 180 | 4688 | 4646 | PREDICTED: Pomacea canaliculata GATOR complex protein DEPDC5-like (LOC112561883), transcript variant X1, mRNA | blastn | 132 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 4742164 | 4742164 | PRJNA938397_S_NODE_48444_length_157_cov_5.925000_g48203_i0 | PRJNA938397 | 48444 | 157 | 5.925 | 9.30225 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.013 | NTclustered | gi|1914623554|ref|XM_029802429.2| | 2607531 | g48203 | i0 | 100 | 0.178343949044586 | 28 | 0 | 18 | 0 | 86 | 113 | 3445 | 3472 | PREDICTED: Octopus sinensis GTP-binding protein Rhes (LOC115232520), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 6017303 | 6017303 | PRJNA938397_S_NODE_7845_length_367_cov_8.269697_g7604_i0 | PRJNA938397 | 7845 | 367 | 8.269697 | 30.34978799 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 233 | 1.16e-56 | NTclustered | gi|2034294411|ref|XM_041521742.1| | 1735272 | g7604 | i0 | 82.353 | 25.7384196185286 | 272 | 44 | 74 | 4 | 82 | 351 | 414 | 145 | PREDICTED: Gigantopelta aegis dynein light chain 2, cytoplasmic-like (LOC121390037), transcript variant X2, mRNA | blastn | 9446 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 8566258 | 8566258 | PRJNA938397_S_NODE_35887_length_184_cov_2.149660_g35646_i0 | PRJNA938397 | 35887 | 184 | 2.14966 | 3.9553744 | Argopecten irradians | 31199 | Mollusca | Mollusca | 65.8 | 2.02e-6 | NTclustered | gi|2835384318|ref|XM_069266836.1| | 31199 | g35646 | i0 | 88.679 | 0.809782608695652 | 53 | 6 | 29 | 0 | 43 | 95 | 435 | 383 | PREDICTED: Argopecten irradians epsin-2-like (LOC138322751), transcript variant X1, mRNA | blastn | 149 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 13666039 | 13666039 | PRJNA938397_S_NODE_14171_length_290_cov_18.577075_g13930_i0 | PRJNA938397 | 14171 | 290 | 18.577075 | 53.8735175 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 189 | 1.9599999999999993e-43 | NTclustered | gi|2669115674|ref|XM_062734844.1| | 36930 | g13930 | i0 | 80.658 | 3.6448275862069 | 243 | 47 | 84 | 0 | 47 | 289 | 667 | 425 | PREDICTED: Saccostrea cucullata NADH-ubiquinone oxidoreductase subunit 8-like (LOC134252379), mRNA | blastn | 1057 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 16215684 | 16215684 | PRJNA938397_S_NODE_20893_length_242_cov_2.892683_g20652_i0 | PRJNA938397 | 20893 | 242 | 2.892683 | 7.00029286 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g20652 | i0 | 100 | 0.12396694214876 | 30 | 0 | 12 | 0 | 187 | 216 | 27714320 | 27714349 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16216670 | 16216670 | PRJNA938397_S_NODE_4513_length_432_cov_81.762025_g4290_i0 | PRJNA938397 | 4513 | 432 | 81.762025 | 353.211948 | Lottia gigantea | 225164 | Mollusca | Mollusca | 285 | 3.7799999999999995e-72 | NTclustered | gi|676421266|ref|XM_009045548.1| | 225164 | g4290 | i0 | 81.503 | 47.5578703703704 | 346 | 64 | 80 | 0 | 1 | 346 | 841 | 1186 | Lottia gigantea hypothetical protein mRNA | blastn | 20545 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 23866400 | 23866400 | PRJNA938397_S_NODE_5579_length_409_cov_21.779570_g5346_i0 | PRJNA938397 | 5579 | 409 | 21.77957 | 89.0784413 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 233 | 1.3099999999999998e-56 | NTclustered | gi|2616585034|ref|XM_060721976.1| | 129788 | g5346 | i0 | 85.586 | 41.7823960880196 | 222 | 32 | 54 | 0 | 187 | 408 | 1673 | 1452 | PREDICTED: Ruditapes philippinarum calcium-binding protein LPS1-alpha-like (LOC132735073), mRNA | blastn | 17089 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum |
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);;