contig_metadata
10 rows where bioproject = "PRJNA356682", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1072113 | 1072113 | PRJNA356682_P_NODE_15321_length_362_cov_2.152249_g14631_i0 | PRJNA356682 | 15321 | 362 | 2.152249 | 7.79114138 | Ostreidae | 6563 | Mollusca | Mollusca | 664 | 0 | NTclustered | gi|2087356261|dbj|LC648604.1| | 29159 | g14631 | i0 | 99.724 | 100.091160220994 | 362 | 1 | 100 | 0 | 1 | 362 | 441 | 80 | Crassostrea gigas IDEA_Shell201 gene for 28S rRNA, partial sequence | blastn | 36233 | 664 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 2948427 | 2948427 | PRJNA356682_P_NODE_39383_length_247_cov_0.885057_g38692_i0 | PRJNA356682 | 39383 | 247 | 0.885057 | 2.18609079 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g38692 | i0 | 96.875 | 0.37246963562753 | 32 | 1 | 13 | 0 | 147 | 178 | 42336707 | 42336738 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 92 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21474275 | 21474275 | PRJNA356682_P_NODE_9077_length_464_cov_1.966752_g8388_i0 | PRJNA356682 | 9077 | 464 | 1.966752 | 9.12572928 | Metazoa | 33208 | Mollusca | Mollusca | 243 | 2.49e-59 | NTclustered | gi|2669130458|ref|XM_062742568.1| | 36930 | g8388 | i0 | 81.169 | 63.5474137931034 | 308 | 52 | 65 | 5 | 62 | 364 | 483 | 177 | PREDICTED: Saccostrea cucullata histone H2B-like (LOC134259977), mRNA | blastn | 29486 | 244 | 0.995901639344262 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 22749359 | 22749359 | PRJNA356682_P_NODE_45918_length_233_cov_3.268750_g45227_i0 | PRJNA356682 | 45918 | 233 | 3.26875 | 7.6161875 | Magallana | 147004 | Mollusca | Mollusca | 422 | 1.38e-113 | NTclustered | gi|28375710|dbj|AB102757.1| | 29159 | g45227 | i0 | 99.142 | 101.871244635193 | 233 | 2 | 100 | 0 | 1 | 233 | 2523 | 2291 | Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea) | blastn | 23736 | 425 | 0.992941176470588 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 23349338 | 23349338 | PRJNA356682_P_NODE_21699_length_311_cov_2.352941_g21008_i0 | PRJNA356682 | 21699 | 311 | 2.352941 | 7.31764651 | Pecten maximus | 6579 | Mollusca | Mollusca | 143 | 1.6799999999999999e-29 | NTclustered | gi|1835500577|ref|XM_033901340.1| | 6579 | g21008 | i0 | 89.381 | 21.064308681672 | 113 | 12 | 36 | 0 | 2 | 114 | 1434 | 1546 | PREDICTED: Pecten maximus tubulin alpha-1A chain (LOC117339638), mRNA | blastn | 6551 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 24623666 | 24623666 | PRJNA356682_P_NODE_24940_length_293_cov_1.972727_g24249_i0 | PRJNA356682 | 24940 | 293 | 1.972727 | 5.78009011 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 86.3 | 2.27e-19 | NR | KAL3856705.1 | 1069815 | g24249 | i0 | 67.2 | 0.686006825938567 | 67 | 22 | 68.6 | 0 | 274 | 74 | 1 | 67 | KAL3856705.1 hypothetical protein ACJMK2_011428 [Sinanodonta woodiana] | diamond | 201 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 26758207 | 26758207 | PRJNA356682_P_NODE_37541_length_249_cov_0.875000_g36850_i0 | PRJNA356682 | 37541 | 249 | 0.875 | 2.17875 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 43.5 | 0.0214 | NR | XP_070173911.1 | 31220 | g36850 | i0 | 40.9 | 0.91566265060241 | 44 | 26 | 53 | 0 | 218 | 87 | 95 | 138 | XP_070173911.1 cilium assembly protein DZIP1L-like isoform X2 [Littorina saxatilis] | diamond | 228 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 26839054 | 26839054 | PRJNA356682_P_NODE_37061_length_250_cov_0.870056_g36370_i0 | PRJNA356682 | 37061 | 250 | 0.870056 | 2.17514 | Mollusca | 6447 | Mollusca | Mollusca | 123 | 9.88e-31 | NR | XP_048254535.1 | 6454 | g36370 | i0 | 76.2 | 19.152 | 84 | 19 | 99.6 | 1 | 249 | 1 | 109 | 192 | XP_048254535.1 cystathionine beta-synthase-like isoform X4 [Haliotis rufescens] | diamond | 4788 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29113127 | 29113127 | PRJNA356682_P_NODE_42288_length_244_cov_0.900585_g41597_i0 | PRJNA356682 | 42288 | 244 | 0.900585 | 2.1974274 | Bivalvia | 6544 | Mollusca | Mollusca | 57 | 3.55e-7 | NR | XP_045210652.2 | 6596 | g41597 | i0 | 63.2 | 2.32377049180328 | 38 | 14 | 46.7 | 0 | 243 | 130 | 142 | 179 | XP_045210652.2 uncharacterized protein K02A2.6-like [Mercenaria mercenaria] | diamond | 567 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29159252 | 29159252 | PRJNA356682_P_NODE_41349_length_245_cov_0.895349_g40658_i0 | PRJNA356682 | 41349 | 245 | 0.895349 | 2.19360505 | Aplysia californica | 6500 | Mollusca | Mollusca | 73.2 | 7.28e-13 | NR | XP_005095267.2 | 6500 | g40658 | i0 | 52.7 | 2.74285714285714 | 74 | 35 | 90.6 | 0 | 232 | 11 | 186 | 259 | XP_005095267.2 uncharacterized protein LOC101861943 [Aplysia californica] | diamond | 672 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;