contig_metadata
10 rows where bioproject = "PRJEB7799", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25662023 | 25662023 | PRJEB7799a_S_NODE_18850_length_152_cov_166.384615_g18815_i0 | PRJEB7799 | 18850 | 152 | 166.384615 | 252.9046148 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 202 | 1.1699999999999998e-47 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g18815 | i0 | 90.909 | 704.276315789474 | 154 | 9 | 100 | 5 | 1 | 152 | 1432530 | 1432680 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 107050 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25665393 | 25665393 | PRJEB7799q_S_NODE_1698_length_203_cov_4.815476_g1688_i0 | PRJEB7799 | 1698 | 203 | 4.815476 | 9.77541628 | Mytilus californianus | 6549 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2334608986|ref|XM_052206883.1| | 6549 | g1688 | i0 | 94.444 | 0.177339901477833 | 36 | 2 | 18 | 0 | 89 | 124 | 2645 | 2610 | PREDICTED: Mytilus californianus RING finger protein 11-like (LOC127702581), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 25800836 | 25800836 | PRJEB7799o_S_NODE_715_length_243_cov_53.254808_g707_i0 | PRJEB7799 | 715 | 243 | 53.254808 | 129.40918344 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 102 | 2.14e-17 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g707 | i0 | 78.363 | 10.8271604938272 | 171 | 27 | 69 | 8 | 76 | 243 | 3686 | 3523 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 2631 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 25936759 | 25936759 | PRJEB7799n_S_NODE_4748_length_212_cov_14.384181_g4711_i0 | PRJEB7799 | 4748 | 212 | 14.384181 | 30.49446372 | Sinohyriopsis cumingii | 165450 | Mollusca | Mollusca | 117 | 6.52e-22 | NTclustered | gi|144228240|gb|EF492566.1| | 165450 | g4711 | i0 | 87.255 | 25.1320754716981 | 102 | 13 | 48 | 0 | 94 | 195 | 653 | 552 | Hyriopsis cumingii tubulin A mRNA, partial cds | blastn | 5328 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinohyriopsis | Sinohyriopsis cumingii | |
| 25937288 | 25937288 | PRJEB7799p_S_NODE_20060_length_164_cov_2.790698_g20037_i0 | PRJEB7799 | 20060 | 164 | 2.790698 | 4.57674472 | Argopecten irradians | 31199 | Mollusca | Mollusca | 137 | 3.67e-28 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g20037 | i0 | 94.382 | 54.7073170731707 | 89 | 5 | 54 | 0 | 76 | 164 | 1442 | 1354 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 8972 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26025250 | 26025250 | PRJEB7799k_S_NODE_4676_length_185_cov_9.566667_g4670_i0 | PRJEB7799 | 4676 | 185 | 9.566667 | 17.69833395 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g4670 | i0 | 100 | 0.616216216216216 | 29 | 0 | 16 | 0 | 1 | 29 | 24192620 | 24192592 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26207995 | 26207995 | PRJEB7799i_S_NODE_3142_length_256_cov_1.579186_g3112_i0 | PRJEB7799 | 3142 | 256 | 1.579186 | 4.04271616 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 154 | 6.2e-33 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g3112 | i0 | 89.431 | 32.5625 | 123 | 11 | 48 | 2 | 29 | 150 | 202762 | 202883 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 8336 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26209097 | 26209097 | PRJEB7799n_S_NODE_6438_length_190_cov_2.587097_g6401_i0 | PRJEB7799 | 6438 | 190 | 2.587097 | 4.9154843 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 106 | 1.24e-18 | NTclustered | gi|2669145177|ref|XM_062749859.1| | 36930 | g6401 | i0 | 87.097 | 3.08421052631579 | 93 | 12 | 49 | 0 | 39 | 131 | 501 | 409 | PREDICTED: Saccostrea cucullata small ribosomal subunit protein uS9 (LOC134267650), mRNA | blastn | 586 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 26479993 | 26479993 | PRJEB7799i_S_NODE_2288_length_302_cov_2.734082_g2258_i0 | PRJEB7799 | 2288 | 302 | 2.734082 | 8.25692764 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 128 | 4.54e-25 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g2258 | i0 | 85.833 | 3.34437086092715 | 120 | 17 | 40 | 0 | 183 | 302 | 229858 | 229739 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 1010 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 33067299 | 33067299 | PRJEB7799n_S_NODE_6837_length_186_cov_2.384106_g6800_i0 | PRJEB7799 | 6837 | 186 | 2.384106 | 4.43443716 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 52.4 | 6.27e-6 | NR | KAL4219390.1 | 2302425 | g6800 | i0 | 83.9 | 1.54838709677419 | 31 | 5 | 50 | 0 | 33 | 125 | 264 | 294 | KAL4219390.1 ribosomal protein L5 [Mactra antiquata] | diamond | 288 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata |
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);;