contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1134759" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3582389 | 3582389 | PRJNA1134759_P_NODE_38203_length_278_cov_1.721951_g38027_i0 | PRJNA1134759 | 38203 | 278 | 1.721951 | 4.78702378 | Bovidae | 9895 | Chordata | Chordata | 446 | 9.999999999999998e-121 | NTclustered | gi|42433177|gb|AY517903.1| | 9901 | g38027 | i0 | 99.59 | 76.0143884892086 | 244 | 1 | 100 | 0 | 35 | 278 | 285 | 42 | Bison bison isolate bison_c satellite 1.709 sequence | blastn | 21132 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bison | Bison bison | |
| 4111159 | 4111159 | PRJNA1134759_P_NODE_33224_length_294_cov_1.402715_g33048_i0 | PRJNA1134759 | 33224 | 294 | 1.402715 | 4.1239821 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 52.8 | 0.027 | NTclustered | gi|1952530154|ref|XM_038796138.1| | 7830 | g33048 | i0 | 96.774 | 0.105442176870748 | 31 | 1 | 11 | 0 | 119 | 149 | 1166 | 1196 | PREDICTED: Scyliorhinus canicula POU class 4 homeobox 3 (pou4f3), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 6661938 | 6661938 | PRJNA1134759_P_NODE_14806_length_413_cov_4.044118_g14630_i0 | PRJNA1134759 | 14806 | 413 | 4.044118 | 16.70220734 | Polypterus senegalus | 55291 | Chordata | Chordata | 353 | 9.72e-93 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g14630 | i0 | 83.333 | 13.1670702179177 | 402 | 48 | 96 | 11 | 2 | 397 | 1063 | 1451 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 5438 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 7937088 | 7937088 | PRJNA1134759_P_NODE_11287_length_466_cov_4.058524_g11111_i0 | PRJNA1134759 | 11287 | 466 | 4.058524 | 18.91272184 | Polypterus senegalus | 55291 | Chordata | Chordata | 327 | 6.72e-85 | NTclustered | gi|1993892376|ref|XM_039743353.1| | 55291 | g11111 | i0 | 80.667 | 12.8884120171674 | 450 | 64 | 93 | 20 | 34 | 466 | 495 | 938 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120522331), mRNA | blastn | 6006 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 13037903 | 13037903 | PRJNA1134759_P_NODE_54211_length_245_cov_0.906977_g54035_i0 | PRJNA1134759 | 54211 | 245 | 0.906977 | 2.22209365 | Phocoena sinus | 42100 | Chordata | Chordata | 135 | 2.13e-27 | NTclustered | gi|1814449161|ref|XR_004352779.1| | 42100 | g54035 | i0 | 90.385 | 36.2204081632653 | 104 | 9 | 42 | 1 | 45 | 148 | 658 | 760 | PREDICTED: Phocoena sinus UDP-GlcNAc:betaGal beta-1,3-N-acetylglucosaminyltransferase 2 (B3GNT2), transcript variant X18, misc_RNA | blastn | 8874 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Phocoenidae | Phocoena | Phocoena sinus | |
| 16334316 | 16334316 | PRJNA1134759_P_NODE_52833_length_247_cov_0.896552_g52657_i0 | PRJNA1134759 | 52833 | 247 | 0.896552 | 2.21448344 | Petromyzontidae | 7746 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|2815004610|emb|OZ078629.2| | 7748 | g52657 | i0 | 100 | 0.906882591093117 | 28 | 0 | 11 | 0 | 184 | 211 | 3049329 | 3049356 | Lampetra fluviatilis genome assembly, chromosome: 61 | blastn | 224 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 20685590 | 20685590 | PRJNA1134759_P_NODE_52917_length_247_cov_0.896552_g52741_i0 | PRJNA1134759 | 52917 | 247 | 0.896552 | 2.21448344 | Bos taurus | 9913 | Chordata | Chordata | 228 | 3.4599999999999984e-55 | NTclustered | gi|2587918737|tpg|BK064707.1| | 9913 | g52741 | i0 | 96.377 | 261.87044534413 | 138 | 5 | 80 | 0 | 1 | 138 | 2722561 | 2722698 | TPA: Bos taurus breed Hereford TRA/TRD locus | blastn | 64682 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus |
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);;