contig_metadata
9 rows where bioproject = "PRJNA229468", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2917900 | 2917900 | PRJNA229468_S_NODE_163_length_378_cov_1.683891_g150_i0 | PRJNA229468 | 163 | 378 | 1.683891 | 6.36510798 | Lottia gigantea | 225164 | Mollusca | Mollusca | 226 | 1.9999999999999998e-54 | NTclustered | gi|676456588|ref|XM_009056125.1| | 225164 | g150 | i0 | 83.065 | 7.94708994708995 | 248 | 42 | 66 | 0 | 25 | 272 | 386 | 139 | Lottia gigantea hypothetical protein mRNA | blastn | 3004 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 6744941 | 6744941 | PRJNA229468_S_NODE_426_length_240_cov_1.198953_g413_i0 | PRJNA229468 | 426 | 240 | 1.198953 | 2.8774872 | Physella acuta | 109671 | Mollusca | Mollusca | 154 | 5.75e-33 | NTclustered | gi|2572306679|ref|XM_059294357.1| | 109671 | g413 | i0 | 82.065 | 28.5208333333333 | 184 | 30 | 76 | 3 | 1 | 183 | 305 | 486 | PREDICTED: Physella acuta large ribosomal subunit protein uL14 (LOC131937156), mRNA | blastn | 6845 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 10571341 | 10571341 | PRJNA229468_S_NODE_749_length_190_cov_1.517730_g736_i0 | PRJNA229468 | 749 | 190 | 1.51773 | 2.883687 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 5.28e-26 | NR | XP_052775540.1 | 6604 | g736 | i0 | 78 | 44.8578947368421 | 59 | 13 | 93.2 | 0 | 13 | 189 | 166 | 224 | XP_052775540.1 peroxiredoxin-1-like [Mya arenaria] | diamond | 8523 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 14396334 | 14396334 | PRJNA229468_S_NODE_1032_length_168_cov_1.285714_g1019_i0 | PRJNA229468 | 1032 | 168 | 1.285714 | 2.15999952 | Haliotis rubra | 36100 | Mollusca | Mollusca | 107 | 2.66e-26 | NR | XP_046577959.1 | 36100 | g1019 | i0 | 87.3 | 7.85714285714286 | 55 | 7 | 98.2 | 0 | 2 | 166 | 120 | 174 | XP_046577959.1 LOW QUALITY PROTEIN: glyceraldehyde-3-phosphate dehydrogenase 2-like [Haliotis rubra] | diamond | 1320 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 19493241 | 19493241 | PRJNA229468_S_NODE_1156_length_164_cov_0.886957_g1143_i0 | PRJNA229468 | 1156 | 164 | 0.886957 | 1.45460948 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2669042795|ref|XM_062758970.1| | 36930 | g1143 | i0 | 96.774 | 0.378048780487805 | 31 | 1 | 19 | 0 | 99 | 129 | 2414 | 2384 | PREDICTED: Saccostrea cucullata MAM and LDL-receptor class A domain-containing protein 2-like (LOC134276709), mRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 27755398 | 27755398 | PRJNA229468_S_NODE_704_length_196_cov_1.319728_g691_i0 | PRJNA229468 | 704 | 196 | 1.319728 | 2.58666688 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 9.89e-5 | NR | XP_053394748.1 | 6596 | g691 | i0 | 45.2 | 9.79591836734694 | 73 | 29 | 98 | 2 | 196 | 5 | 496 | 566 | XP_053394748.1 sterol carrier protein 2-like isoform X4 [Mercenaria mercenaria] | diamond | 1920 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 28305690 | 28305690 | PRJNA229468_S_NODE_1186_length_163_cov_0.894737_g1173_i0 | PRJNA229468 | 1186 | 163 | 0.894737 | 1.45842131 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 44.7 | 0.0027 | NR | XP_061173563.1 | 191078 | g1173 | i0 | 58.3 | 2.3558282208589 | 36 | 15 | 66.3 | 0 | 7 | 114 | 522 | 557 | XP_061173563.1 fibropellin-1-like [Saccostrea echinata] | diamond | 384 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 29744040 | 29744040 | PRJNA229468_S_NODE_390_length_251_cov_1.405941_g377_i0 | PRJNA229468 | 390 | 251 | 1.405941 | 3.52891191 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 1.02e-29 | NR | XP_070174385.1 | 31220 | g377 | i0 | 70 | 6.72908366533865 | 80 | 24 | 95.6 | 0 | 242 | 3 | 1336 | 1415 | XP_070174385.1 multidrug resistance-associated protein 1-like [Littorina saxatilis] | diamond | 1689 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31970534 | 31970534 | PRJNA229468_S_NODE_1098_length_166_cov_0.871795_g1085_i0 | PRJNA229468 | 1098 | 166 | 0.871795 | 1.4471797 | Physella acuta | 109671 | Mollusca | Mollusca | 42.7 | 0.0119 | NR | XP_059150767.1 | 109671 | g1085 | i0 | 37.3 | 2.7289156626506 | 59 | 32 | 97.6 | 1 | 3 | 164 | 129 | 187 | XP_059150767.1 S-crystallin SL11-like isoform X1 [Physella acuta] | diamond | 453 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta |
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);;