contig_metadata
6 rows where bioproject = "PRJNA309466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4204014 | 4204014 | PRJNA309466_P_NODE_19744_length_152_cov_2.990291_g19687_i0 | PRJNA309466 | 19744 | 152 | 2.990291 | 4.54524232 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 176 | 7.07e-40 | NTclustered | gi|2628615720|ref|XR_009719673.1| | 191078 | g19687 | i0 | 93.277 | 77.6381578947368 | 119 | 8 | 78 | 0 | 27 | 145 | 3110 | 2992 | PREDICTED: Saccostrea echinata large subunit ribosomal RNA (LOC133177405), rRNA | blastn | 11801 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 5480246 | 5480246 | PRJNA309466_P_NODE_15305_length_169_cov_181364.866667_g15248_i0 | PRJNA309466 | 15305 | 169 | 181364.866667 | 306506.62466723 | Taylorina solomonensis | 2891524 | Mollusca | Mollusca | 76.8 | 8.37e-10 | NTclustered | gi|2127706952|gb|OL339378.1| | 2891524 | g15248 | i0 | 97.727 | 26.0236686390533 | 44 | 1 | 26 | 0 | 41 | 84 | 2447 | 2404 | Taylorina solomonensis voucher MNHN IM-2013-46005 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 4398 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Taylorina | Taylorina solomonensis | |
| 9304874 | 9304874 | PRJNA309466_P_NODE_3448_length_320_cov_5.560886_g3392_i0 | PRJNA309466 | 3448 | 320 | 5.560886 | 17.7948352 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.39e-5 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g3392 | i0 | 77.778 | 0.86875 | 108 | 21 | 33 | 2 | 127 | 233 | 8051560 | 8051665 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 278 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15090943 | 15090943 | PRJNA309466_P_NODE_9552_length_202_cov_248375.895425_g9495_i0 | PRJNA309466 | 9552 | 202 | 248375.895425 | 501719.3087585 | Mollusca | 6447 | Mollusca | Mollusca | 113 | 7.95e-21 | NTclustered | gi|31790025|gb|AY296874.1| | 40252 | g9495 | i0 | 98.438 | 31.6089108910891 | 64 | 1 | 32 | 0 | 44 | 107 | 308 | 245 | Trichomya hirsuta voucher C203203 28S ribosomal RNA gene, partial sequence | blastn | 6385 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Trichomya | Trichomya hirsuta | |
| 19502867 | 19502867 | PRJNA309466_P_NODE_6416_length_232_cov_23.912568_g6359_i0 | PRJNA309466 | 6416 | 232 | 23.912568 | 55.47715776 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 108 | 4.37e-19 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g6359 | i0 | 78.409 | 48.8620689655172 | 176 | 30 | 75 | 5 | 4 | 178 | 53749174 | 53749342 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 11336 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27422110 | 27422110 | PRJNA309466_P_NODE_17903_length_162_cov_6.699115_g17846_i0 | PRJNA309466 | 17903 | 162 | 6.699115 | 10.8525663 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 44.7 | 0.00223 | NR | CAE1281722.1 | 158019 | g17846 | i0 | 55.8 | 0.962962962962963 | 52 | 15 | 90.7 | 3 | 13 | 159 | 4 | 50 | CAE1281722.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 156 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis |
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);;