contig_metadata
8 rows where bioproject = "PRJNA642647", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1158544 | 1158544 | PRJNA642647_P_NODE_1381_length_297_cov_5.615385_g1331_i0 | PRJNA642647 | 1381 | 297 | 5.615385 | 16.67769345 | Metazoa | 33208 | Mollusca | Mollusca | 409 | 1.42e-109 | NTclustered | gi|34369194|gb|AY145400.1| | 6565 | g1331 | i0 | 91.892 | 98.1481481481482 | 296 | 18 | 99 | 5 | 3 | 297 | 1850 | 2140 | Crassostrea virginica 28S ribosomal RNA gene, partial sequence | blastn | 29150 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 9546552 | 9546552 | PRJNA642647_P_NODE_1488_length_285_cov_6.661290_g1438_i0 | PRJNA642647 | 1488 | 285 | 6.66129 | 18.9846765 | Magallana angulata | 2784310 | Mollusca | Mollusca | 372 | 1.78e-98 | NTclustered | gi|2416874841|ref|XR_008241671.1| | 2784310 | g1438 | i0 | 91.822 | 69.8491228070176 | 269 | 19 | 94 | 2 | 3 | 271 | 3517 | 3782 | PREDICTED: Crassostrea angulata large subunit ribosomal RNA (LOC128170120), rRNA | blastn | 19907 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 19010052 | 19010052 | PRJNA642647_P_NODE_3515_length_189_cov_1.697368_g3465_i0 | PRJNA642647 | 3515 | 189 | 1.697368 | 3.20802552 | Octopoda | 6638 | Mollusca | Mollusca | 58.4 | 3.49e-4 | NTclustered | gi|2239696596|gb|ON524397.1| | 61709 | g3465 | i0 | 81.081 | 5.54497354497355 | 74 | 13 | 39 | 1 | 94 | 167 | 5237 | 5165 | Bolitaena pygmaea isolate A200083 internal transcribed spacer 2, and large subunit ribosomal RNA gene, region | blastn | 1048 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Bolitaenidae | Bolitaena | Bolitaena pygmaea | |
| 19744844 | 19744844 | PRJNA642647_P_NODE_2976_length_203_cov_1.692771_g2926_i0 | PRJNA642647 | 2976 | 203 | 1.692771 | 3.43632513 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 368 | 1.55e-97 | NTclustered | gi|194594396|gb|EU660792.1| | 6565 | g2926 | i0 | 100 | 98.0394088669951 | 199 | 0 | 98 | 0 | 5 | 203 | 162 | 360 | Crassostrea virginica isolate CvirI1 18S ribosomal RNA gene, partial sequence | blastn | 19902 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 22836013 | 22836013 | PRJNA642647_P_NODE_3238_length_195_cov_4.208861_g3188_i0 | PRJNA642647 | 3238 | 195 | 4.208861 | 8.20727895 | Metazoa | 33208 | Mollusca | Mollusca | 198 | 2.05e-46 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g3188 | i0 | 88.166 | 82.1846153846154 | 169 | 17 | 86 | 3 | 1 | 168 | 2517 | 2683 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 16026 | 200 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 22836029 | 22836029 | PRJNA642647_P_NODE_5938_length_156_cov_2.865546_g5888_i0 | PRJNA642647 | 5938 | 156 | 2.865546 | 4.47025176 | Crassostrea | 6564 | Mollusca | Mollusca | 283 | 4.1899999999999994e-72 | NTclustered | gi|662170012|gb|KF370409.1| | 6565 | g5888 | i0 | 100 | 96.4038461538462 | 153 | 0 | 98 | 0 | 4 | 156 | 112 | 264 | Crassostrea virginica isolate Cv02 28S ribosomal RNA gene, partial sequence | blastn | 15039 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 23570745 | 23570745 | PRJNA642647_P_NODE_699_length_427_cov_9.317949_g650_i0 | PRJNA642647 | 699 | 427 | 9.317949 | 39.78764223 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 453 | 9.66e-123 | NTclustered | gi|662170012|gb|KF370409.1| | 6565 | g650 | i0 | 86.588 | 87.192037470726 | 425 | 40 | 96 | 12 | 14 | 424 | 759 | 338 | Crassostrea virginica isolate Cv02 28S ribosomal RNA gene, partial sequence | blastn | 37231 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 24110433 | 24110433 | PRJNA642647_P_NODE_1799_length_258_cov_3.918552_g1749_i0 | PRJNA642647 | 1799 | 258 | 3.918552 | 10.10986416 | Metazoa | 33208 | Mollusca | Mollusca | 115 | 2.95e-21 | NTclustered | gi|2245728077|ref|XR_006860449.2| | 6454 | g1749 | i0 | 90 | 35.3100775193798 | 90 | 8 | 35 | 1 | 1 | 90 | 2181 | 2093 | PREDICTED: Haliotis rufescens large subunit ribosomal RNA (LOC124129793), rRNA | blastn | 9110 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;