contig_metadata
9 rows where bioproject = "PRJNA716463", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5021420 | 5021420 | PRJNA716463_P_NODE_84924_length_264_cov_3.832461_g84507_i0 | PRJNA716463 | 84924 | 264 | 3.832461 | 10.11769704 | Brevinucula | 1069100 | Mollusca | Mollusca | 172 | 1.77e-38 | NTclustered | gi|520993225|gb|KC984814.1| | 1069101 | g84507 | i0 | 84.884 | 67.0378787878788 | 172 | 24 | 65 | 2 | 91 | 261 | 941 | 1111 | Brevinucula verrillii voucher UMASS EN_14CC1 28S ribosomal RNA gene, partial sequence | blastn | 17698 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Nuculida | Nuculidae | Brevinucula | Brevinucula verrillii | |
| 10911154 | 10911154 | PRJNA716463_P_NODE_100569_length_251_cov_0.865169_g100152_i0 | PRJNA716463 | 100569 | 251 | 0.865169 | 2.17157419 | Acanthosepion esculentum | 31210 | Mollusca | Mollusca | 433 | 6.95e-117 | NTclustered | gi|83715927|dbj|AB218913.1| | 31210 | g100152 | i0 | 98.008 | 47.2470119521912 | 251 | 2 | 100 | 1 | 1 | 251 | 1109 | 862 | Sepia esculenta se-tm mRNA for tropomyosin, complete cds | blastn | 11859 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion esculentum | |
| 19835105 | 19835105 | PRJNA716463_P_NODE_58676_length_284_cov_3.578199_g58259_i0 | PRJNA716463 | 58676 | 284 | 3.578199 | 10.16208516 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 145 | 4.21e-30 | NTclustered | gi|1914646882|ref|XM_036512833.1| | 2607531 | g58259 | i0 | 89.474 | 40.8239436619718 | 114 | 12 | 40 | 0 | 169 | 282 | 2749 | 2862 | PREDICTED: Octopus sinensis uncharacterized transporter slc-17.2-like (LOC115224008), transcript variant X1, mRNA | blastn | 11594 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 22384924 | 22384924 | PRJNA716463_P_NODE_12398_length_340_cov_3.460674_g11983_i0 | PRJNA716463 | 12398 | 340 | 3.460674 | 11.7662916 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g11983 | i0 | 92.5 | 0.117647058823529 | 40 | 1 | 12 | 1 | 301 | 340 | 44043020 | 44043057 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22385892 | 22385892 | PRJNA716463_P_NODE_72998_length_274_cov_1.920398_g72581_i0 | PRJNA716463 | 72998 | 274 | 1.920398 | 5.26189052 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 117 | 8.8e-22 | NTclustered | gi|2427255067|ref|XM_052970792.1| | 37653 | g72581 | i0 | 90.11 | 2.37956204379562 | 91 | 8 | 33 | 1 | 1 | 90 | 9 | 99 | PREDICTED: Octopus bimaculoides ras GTPase-activating protein 3 (LOC106869760), transcript variant X1, mRNA | blastn | 652 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 23661136 | 23661136 | PRJNA716463_P_NODE_50559_length_290_cov_1.972350_g50142_i0 | PRJNA716463 | 50559 | 290 | 1.97235 | 5.719815 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 239 | 1.92e-58 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g50142 | i0 | 95.425 | 6.83793103448276 | 153 | 2 | 76 | 5 | 135 | 287 | 64064313 | 64064460 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 1983 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24935163 | 24935163 | PRJNA716463_P_NODE_86320_length_263_cov_3.068421_g85903_i0 | PRJNA716463 | 86320 | 263 | 3.068421 | 8.06994723 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g85903 | i0 | 100 | 0.114068441064639 | 30 | 0 | 11 | 0 | 133 | 162 | 38604549 | 38604578 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 30083432 | 30083432 | PRJNA716463_P_NODE_109452_length_243_cov_2.376471_g109034_i0 | PRJNA716463 | 109452 | 243 | 2.376471 | 5.77482453 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 43.5 | 0.0204 | NR | XP_062616057.1 | 36930 | g109034 | i0 | 56.4 | 0.962962962962963 | 39 | 15 | 48.1 | 1 | 119 | 3 | 224 | 260 | XP_062616057.1 LOW QUALITY PROTEIN: NFX1-type zinc finger-containing protein 1-like [Saccostrea cuccullata] | diamond | 234 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 30662805 | 30662805 | PRJNA716463_P_NODE_105093_length_247_cov_1.770115_g104676_i0 | PRJNA716463 | 105093 | 247 | 1.770115 | 4.37218405 | Mollusca | 6447 | Mollusca | Mollusca | 102 | 5.1e-23 | NR | XP_052270353.1 | 45954 | g104676 | i0 | 62.7 | 3.36437246963563 | 67 | 25 | 81.4 | 0 | 47 | 247 | 10 | 76 | XP_052270353.1 opioid growth factor receptor-like protein 1 isoform X3 [Dreissena polymorpha] | diamond | 831 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha |
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);;