contig_metadata
13 rows where bioproject = "PRJNA784298", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 765425 | 765425 | PRJNA784298_P_NODE_26921_length_241_cov_0.916667_g26720_i0 | PRJNA784298 | 26921 | 241 | 0.916667 | 2.20916747 | Canis lupus | 9612 | Chordata | Chordata | 357 | 4.1099999999999997e-94 | NTclustered | gi|169118886|gb|AC186972.16| | 9615 | g26720 | i0 | 93.697 | 14.2780082987552 | 238 | 15 | 99 | 0 | 1 | 238 | 90548 | 90785 | Canis familiaris chromosome 25, clone XX-239F12, complete sequence | blastn | 3441 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 3316664 | 3316664 | PRJNA784298_P_NODE_26223_length_243_cov_0.905882_g26022_i0 | PRJNA784298 | 26223 | 243 | 0.905882 | 2.20129326 | Phocoena sinus | 42100 | Chordata | Chordata | 139 | 1.63e-28 | NTclustered | gi|1814745512|ref|XM_032645097.1| | 42100 | g26022 | i0 | 81.503 | 6.86008230452675 | 173 | 29 | 70 | 3 | 5 | 175 | 6538 | 6709 | PREDICTED: Phocoena sinus transcription factor 20 (TCF20), transcript variant X1, mRNA | blastn | 1667 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Phocoenidae | Phocoena | Phocoena sinus | |
| 3316685 | 3316685 | PRJNA784298_P_NODE_28583_length_201_cov_12.070312_g28382_i0 | PRJNA784298 | 28583 | 201 | 12.070312 | 24.26132712 | Ciona intestinalis | 7719 | Chordata | Chordata | 363 | 7.109999999999999e-96 | NTclustered | gi|11494226|gb|AF212177.1|AF212177 | 7719 | g28382 | i0 | 99.005 | 13.7512437810945 | 201 | 2 | 100 | 0 | 1 | 201 | 3583 | 3383 | Ciona intestinalis 28S ribosomal RNA gene, partial sequence | blastn | 2764 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 5868926 | 5868926 | PRJNA784298_P_NODE_28405_length_211_cov_12.268116_g28204_i0 | PRJNA784298 | 28405 | 211 | 12.268116 | 25.88572476 | Ciona intestinalis | 7719 | Chordata | Chordata | 390 | 3.459999999999999e-104 | NTclustered | gi|11494226|gb|AF212177.1|AF212177 | 7719 | g28204 | i0 | 100 | 81.1848341232227 | 211 | 0 | 100 | 0 | 1 | 211 | 1927 | 1717 | Ciona intestinalis 28S ribosomal RNA gene, partial sequence | blastn | 17130 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 8418436 | 8418436 | PRJNA784298_P_NODE_19967_length_276_cov_2.339901_g19766_i0 | PRJNA784298 | 19967 | 276 | 2.339901 | 6.45812676 | Mus musculus | 10090 | Chordata | Chordata | 52.8 | 0.025 | NTclustered | gi|76362865|gb|AC159225.4| | 10090 | g19766 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 49 | 76 | 127371 | 127344 | Mus musculus chromosome 1, clone RP24-306F17, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 9693680 | 9693680 | PRJNA784298_P_NODE_19668_length_278_cov_11.790244_g19467_i0 | PRJNA784298 | 19668 | 278 | 11.790244 | 32.77687832 | Mus musculus | 10090 | Chordata | Chordata | 237 | 6.58e-58 | NTclustered | gi|2904935057|gb|PQ737980.1| | 10090 | g19467 | i0 | 84.553 | 0.884892086330935 | 246 | 31 | 87 | 7 | 26 | 268 | 58 | 299 | Mus musculus lncRNA390 lncRNA, complete sequence | blastn | 246 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22442672 | 22442672 | PRJNA784298_P_NODE_23558_length_251_cov_2.595506_g23357_i0 | PRJNA784298 | 23558 | 251 | 2.595506 | 6.51472006 | Mus musculus | 10090 | Chordata | Chordata | 54.7 | 0.006 | NTclustered | gi|40809684|emb|AL844528.13| | 10090 | g23357 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 175 | 203 | 120965 | 120937 | Mouse DNA sequence from clone RP23-139H14 on chromosome 2, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22442719 | 22442719 | PRJNA784298_P_NODE_27978_length_227_cov_4.259740_g27777_i0 | PRJNA784298 | 27978 | 227 | 4.25974 | 9.6696098 | Ranitomeya imitator | 111125 | Chordata | Chordata | 97.1 | 9.21e-16 | NTclustered | gi|2851923300|ref|XM_069756950.1| | 111125 | g27777 | i0 | 82.301 | 0.784140969162996 | 113 | 18 | 49 | 2 | 44 | 155 | 5177 | 5066 | PREDICTED: Ranitomeya imitator mitochondrial fission regulator 1 like (MTFR1L), mRNA | blastn | 178 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 24164938 | 24164938 | PRJNA784298_P_NODE_6419_length_500_cov_2.128806_g6219_i0 | PRJNA784298 | 6419 | 500 | 2.128806 | 10.64403 | Orectolobiformes | 30503 | Chordata | Chordata | 54.7 | 0.014 | NTclustered | gi|2250633359|ref|XM_048598961.1| | 259920 | g6219 | i0 | 96.875 | 1.64 | 32 | 1 | 6 | 0 | 98 | 129 | 1935 | 1904 | PREDICTED: Rhincodon typus bromodomain adjacent to zinc finger domain, 2Ba (baz2ba), transcript variant X2, mRNA | blastn | 820 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Rhincodontidae | Rhincodon | Rhincodon typus | |
| 24991842 | 24991842 | PRJNA784298_P_NODE_26160_length_243_cov_0.905882_g25959_i0 | PRJNA784298 | 26160 | 243 | 0.905882 | 2.20129326 | Ciona intestinalis | 7719 | Chordata | Chordata | 388 | 1.47e-103 | NTclustered | gi|193788571|ref|NM_001129860.1| | 7719 | g25959 | i0 | 95.473 | 1.7119341563786 | 243 | 11 | 100 | 0 | 1 | 243 | 1055 | 813 | Ciona intestinalis zinc finger protein ZF(C3H/RING)-1 (zf(c3h/ring)-1), mRNA | blastn | 416 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 28190437 | 28190437 | PRJNA784298_P_NODE_6806_length_485_cov_2.669903_g6606_i0 | PRJNA784298 | 6806 | 485 | 2.669903 | 12.94902955 | Rattus norvegicus | 10116 | Chordata | Chordata | 50.8 | 6.94e-4 | NR | AAS66221.1 | 10116 | g6606 | i0 | 31.4 | 0.865979381443299 | 140 | 70 | 79.8 | 9 | 425 | 39 | 1070 | 1194 | AAS66221.1 LRRG00130 [Rattus norvegicus] | diamond | 420 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 29273251 | 29273251 | PRJNA784298_P_NODE_22269_length_260_cov_1.625668_g22068_i0 | PRJNA784298 | 22269 | 260 | 1.625668 | 4.2267368 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 2e-36 | NR | XP_069097964.1 | 8319 | g22068 | i0 | 73.3 | 95.0307692307692 | 86 | 23 | 99.2 | 0 | 3 | 260 | 24 | 109 | XP_069097964.1 large ribosomal subunit protein uL18B-like [Pleurodeles waltl] | diamond | 24708 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29895791 | 29895791 | PRJNA784298_P_NODE_6911_length_481_cov_3.426471_g6710_i0 | PRJNA784298 | 6911 | 481 | 3.426471 | 16.48132551 | Ranitomeya imitator | 111125 | Chordata | Chordata | 65.9 | 3.31e-9 | NR | CAJ0925002.1 | 111125 | g6710 | i0 | 52.7 | 0.923076923076923 | 74 | 29 | 42.4 | 1 | 205 | 2 | 288 | 361 | CAJ0925002.1 unnamed protein product, partial [Ranitomeya imitator] | diamond | 444 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator |
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);;