contig_metadata
13 rows where bioproject = "PRJNA763718" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020230 | 2020230 | PRJNA763718_S_NODE_8042_length_156_cov_0.941176_g7834_i0 | PRJNA763718 | 8042 | 156 | 0.941176 | 1.46823456 | Ovis aries | 9940 | Chordata | Chordata | 272 | 9.059999999999999e-69 | NTclustered | gi|2606963008|ref|XR_009599067.1| | 9940 | g7834 | i0 | 98.077 | 43.1538461538462 | 156 | 3 | 100 | 0 | 1 | 156 | 188 | 343 | PREDICTED: Ovis aries uncharacterized LOC132659100 (LOC132659100), ncRNA | blastn | 6732 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 2480871 | 2480871 | PRJNA763718_S_NODE_7902_length_157_cov_0.966667_g7694_i0 | PRJNA763718 | 7902 | 157 | 0.966667 | 1.51766719 | Bos | 9903 | Chordata | Chordata | 291 | 2.52e-74 | NTclustered | gi|381342543|gb|JQ437479.1| | 9909 | g7694 | i0 | 100 | 100 | 157 | 0 | 100 | 0 | 1 | 157 | 7293 | 7137 | Bos primigenius mitochondrion, complete genome | blastn | 15700 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos primigenius | |
| 5033684 | 5033684 | PRJNA763718_S_NODE_5064_length_195_cov_1.455696_g4856_i0 | PRJNA763718 | 5064 | 195 | 1.455696 | 2.8386072 | Metazoa | 33208 | Chordata | Chordata | 361 | 2.46e-95 | NTclustered | gi|2158466365|gb|MZ901501.1| | 9913 | g4856 | i0 | 100 | 100 | 195 | 0 | 100 | 0 | 1 | 195 | 2734 | 2540 | Bos taurus isolate CCHF_155 haplogroup T3 mitochondrion, complete genome | blastn | 19500 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 5847743 | 5847743 | PRJNA763718_S_NODE_6545_length_171_cov_1.432836_g6337_i0 | PRJNA763718 | 6545 | 171 | 1.432836 | 2.45014956 | Opisthokonta | 33154 | Chordata | Chordata | 101 | 1.1199999999999999e-23 | NR | XP_067890277.1 | 7792 | g6337 | i0 | 76.9 | 52.7719298245614 | 52 | 12 | 91.2 | 0 | 170 | 15 | 84 | 135 | XP_067890277.1 probable cysteine--tRNA ligase, mitochondrial isoform X4 [Heterodontus francisci] | diamond | 9024 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 6309451 | 6309451 | PRJNA763718_S_NODE_4025_length_219_cov_3.362637_g3817_i0 | PRJNA763718 | 4025 | 219 | 3.362637 | 7.36417503 | Bos | 9903 | Chordata | Chordata | 405 | 1.29e-108 | NTclustered | gi|2158466365|gb|MZ901501.1| | 9913 | g3817 | i0 | 100 | 100 | 219 | 0 | 100 | 0 | 1 | 219 | 1277 | 1059 | Bos taurus isolate CCHF_155 haplogroup T3 mitochondrion, complete genome | blastn | 21900 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 7122920 | 7122920 | PRJNA763718_S_NODE_5926_length_179_cov_3.781690_g5718_i0 | PRJNA763718 | 5926 | 179 | 3.78169 | 6.7692251 | Pyrrhula murina | 928672 | Chordata | Chordata | 58.4 | 3.26e-4 | NTclustered | gi|2920008274|emb|OZ239007.1| | 928672 | g5718 | i0 | 97.059 | 0.513966480446927 | 34 | 1 | 19 | 0 | 146 | 179 | 7535564 | 7535531 | Pyrrhula murina genome assembly, chromosome: 12 | blastn | 92 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Pyrrhula | Pyrrhula murina | |
| 8858500 | 8858500 | PRJNA763718_S_NODE_1967_length_335_cov_56.778523_g1759_i0 | PRJNA763718 | 1967 | 335 | 56.778523 | 190.20805205 | Cheloniidae | 8465 | Chordata | Chordata | 52.8 | 0.032 | NTclustered | gi|2911500576|emb|OZ223607.1| | 8472 | g1759 | i0 | 100 | 0.250746268656716 | 28 | 0 | 8 | 0 | 304 | 331 | 10181252 | 10181279 | Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 21 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii | ||
| 10134016 | 10134016 | PRJNA763718_S_NODE_4468_length_207_cov_10.123529_g4260_i0 | PRJNA763718 | 4468 | 207 | 10.123529 | 20.95570503 | Metazoa | 33208 | Chordata | Chordata | 152 | 1.7399999999999998e-32 | NTclustered | gi|1981790840|ref|XM_039406968.1| | 7725 | g4260 | i0 | 90.435 | 60.5797101449275 | 115 | 11 | 56 | 0 | 93 | 207 | 1300 | 1186 | PREDICTED: Styela clava actin, muscle-type (LOC120338943), mRNA | blastn | 12540 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 12685087 | 12685087 | PRJNA763718_S_NODE_4810_length_200_cov_1.245399_g4602_i0 | PRJNA763718 | 4810 | 200 | 1.245399 | 2.490798 | root | 1 | Root_unresolved | Root_unresolved | 359 | 9.14e-95 | NTclustered | gi|117582301|gb|EF057751.1| | 9940 | g4602 | i0 | 99 | 110.765 | 200 | 2 | 100 | 0 | 1 | 200 | 1 | 200 | Ovis ares 1.714 satellite sequence | blastn | 22153 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 12685096 | 12685096 | PRJNA763718_S_NODE_6230_length_175_cov_1.557971_g6022_i0 | PRJNA763718 | 6230 | 175 | 1.557971 | 2.72644925 | Chordata | 7711 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|354783148|gb|JN947649.1| | 10090 | g6022 | i0 | 100 | 2.24 | 28 | 0 | 16 | 0 | 148 | 175 | 36922 | 36895 | Mus musculus targeted non-conditional, lacZ-tagged mutant allele Tex261:tm1e(EUCOMM)Hmgu tm1e(EUCOMM)Wtsi; transgenic | blastn | 392 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 21607595 | 21607595 | PRJNA763718_S_NODE_7457_length_161_cov_1.975806_g7249_i0 | PRJNA763718 | 7457 | 161 | 1.975806 | 3.18104766 | Bos | 9903 | Chordata | Chordata | 298 | 1.56e-76 | NTclustered | gi|1398977718|gb|MF169213.1| | 9909 | g7249 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 2164 | 2004 | Bos primigenius isolate Horn_CMLIX mitochondrion, partial genome | blastn | 16100 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos primigenius | |
| 26958077 | 26958077 | PRJNA763718_S_NODE_7002_length_165_cov_5.281250_g6794_i0 | PRJNA763718 | 7002 | 165 | 5.28125 | 8.7140625 | Staurois parvus | 386267 | Chordata | Chordata | 56.2 | 1.95e-8 | NR | CAI9547784.1 | 386267 | g6794 | i0 | 65 | 1.45454545454545 | 40 | 14 | 72.7 | 0 | 120 | 1 | 52 | 91 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 240 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28547379 | 28547379 | PRJNA763718_S_NODE_8007_length_156_cov_1.605042_g7799_i0 | PRJNA763718 | 8007 | 156 | 1.605042 | 2.50386552 | Polypteridae | 8289 | Chordata | Chordata | 78.6 | 1.51e-15 | NR | XP_051791274.1 | 27687 | g7799 | i0 | 80.4 | 9.80769230769231 | 51 | 9 | 96.2 | 1 | 2 | 151 | 127 | 177 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 1530 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus |
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);;