contig_metadata
19 rows where bioproject = "PRJNA801875", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1221748 | 1221748 | PRJNA801875_P_NODE_4261_length_158_cov_2.821138_g4158_i0 | PRJNA801875 | 4261 | 158 | 2.821138 | 4.45739804 | Metazoa | 33208 | Chordata | Chordata | 63.9 | 6.03e-6 | NTclustered | gi|1835613316|ref|XM_033917946.1| | 260995 | g4158 | i0 | 93.023 | 2.6012658227848098 | 43 | 3 | 27 | 0 | 66 | 108 | 388 | 346 | PREDICTED: Geotrypetes seraphini ribosomal protein S25 (RPS25), mRNA | blastn | 411 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 3351962 | 3351962 | PRJNA801875_P_NODE_1363_length_338_cov_2.759076_g1260_i0 | PRJNA801875 | 1363 | 338 | 2.759076 | 9.32567688 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 7.22e-37 | NR | CAJ0958198.1 | 111125 | g1260 | i0 | 61.9 | 60.9230769230769 | 118 | 38 | 98.5 | 1 | 337 | 5 | 34 | 151 | CAJ0958198.1 unnamed protein product [Ranitomeya imitator] | diamond | 20592 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 3773513 | 3773513 | PRJNA801875_P_NODE_2663_length_208_cov_1.352601_g2560_i0 | PRJNA801875 | 2663 | 208 | 1.352601 | 2.81341008 | Metazoa | 33208 | Chordata | Chordata | 54.7 | 0.005 | NTclustered | gi|57863195|gb|AC108908.16| | 10090 | g2560 | i0 | 100 | 2.0625 | 29 | 0 | 14 | 0 | 26 | 54 | 175613 | 175641 | Mus musculus chromosome 7, clone RP23-179K7, complete sequence | blastn | 429 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 7179413 | 7179413 | PRJNA801875_P_NODE_4046_length_163_cov_1.156250_g3943_i0 | PRJNA801875 | 4046 | 163 | 1.15625 | 1.8846875 | Mus musculus | 10090 | Chordata | Chordata | 58.4 | 2.92e-4 | NTclustered | gi|52839791|gb|AC108393.10| | 10090 | g3943 | i0 | 100 | 22.6503067484663 | 31 | 0 | 19 | 0 | 59 | 89 | 90361 | 90391 | Mus musculus chromosome 3, clone RP23-388A19, complete sequence | blastn | 3692 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 8454072 | 8454072 | PRJNA801875_P_NODE_4147_length_161_cov_0.849206_g4044_i0 | PRJNA801875 | 4147 | 161 | 0.849206 | 1.36722166 | Apodemus sylvaticus | 10129 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|2330874509|ref|XM_052191938.1| | 10129 | g4044 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 1 | 29 | 608 | 580 | PREDICTED: Apodemus sylvaticus nucleolin (Ncl), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus sylvaticus | |
| 12280542 | 12280542 | PRJNA801875_P_NODE_1750_length_283_cov_2.245968_g1647_i0 | PRJNA801875 | 1750 | 283 | 2.245968 | 6.35608944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 8.480000000000001e-44 | NR | XP_069481112.1 | 8296 | g1647 | i0 | 84.9 | 92.5123674911661 | 93 | 13 | 97.5 | 1 | 278 | 3 | 16 | 108 | XP_069481112.1 large ribosomal subunit protein uL4 [Ambystoma mexicanum] | diamond | 26181 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 16103601 | 16103601 | PRJNA801875_P_NODE_3173_length_186_cov_1.165563_g3070_i0 | PRJNA801875 | 3173 | 186 | 1.165563 | 2.16794718 | Sitta europaea | 50251 | Chordata | Chordata | 52.8 | 0.016 | NTclustered | gi|2917598300|emb|OZ228662.1| | 50251 | g3070 | i0 | 100 | 0.150537634408602 | 28 | 0 | 15 | 0 | 90 | 117 | 9505584 | 9505611 | Sitta europaea genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sittidae | Sitta | Sitta europaea | |
| 19073452 | 19073452 | PRJNA801875_P_NODE_2295_length_231_cov_1.979592_g2192_i0 | PRJNA801875 | 2295 | 231 | 1.979592 | 4.57285752 | Aves | 8782 | Chordata | Chordata | 98.2 | 7.39e-23 | NR | XP_009995761.1 | 8897 | g2192 | i0 | 61.8 | 17.7662337662338 | 76 | 28 | 98.7 | 1 | 1 | 228 | 145 | 219 | XP_009995761.1 PREDICTED: dnaJ homolog subfamily A member 2 [Chaetura pelagica] | diamond | 4104 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apodiformes | Apodidae | Chaetura | Chaetura pelagica | |
| 26610785 | 26610785 | PRJNA801875_P_NODE_2541_length_214_cov_1.955307_g2438_i0 | PRJNA801875 | 2541 | 214 | 1.955307 | 4.18435698 | Gekko japonicus | 146911 | Chordata | Chordata | 83.6 | 1.06e-16 | NR | XP_015284848.1 | 146911 | g2438 | i0 | 66.1 | 1.68224299065421 | 59 | 20 | 82.7 | 0 | 2 | 178 | 51 | 109 | XP_015284848.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Gekko japonicus] | diamond | 360 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 26927574 | 26927574 | PRJNA801875_P_NODE_2042_length_252_cov_2.875576_g1939_i0 | PRJNA801875 | 2042 | 252 | 2.875576 | 7.24645152 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 44.7 | 0.00563 | NR | XP_038674818.1 | 7830 | g1939 | i0 | 36.7 | 0.94047619047619 | 79 | 48 | 92.9 | 2 | 1 | 234 | 15 | 92 | XP_038674818.1 selenoprotein J [Scyliorhinus canicula] | diamond | 237 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 27726882 | 27726882 | PRJNA801875_P_NODE_2544_length_214_cov_1.776536_g2441_i0 | PRJNA801875 | 2544 | 214 | 1.776536 | 3.80178704 | Opisthokonta | 33154 | Chordata | Chordata | 101 | 3.49e-24 | NR | CAH1273146.1 | 7740 | g2441 | i0 | 71.9 | 1.79439252336449 | 64 | 18 | 89.7 | 0 | 8 | 199 | 204 | 267 | CAH1273146.1 RPS2 [Branchiostoma lanceolatum] | diamond | 384 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 28285679 | 28285679 | PRJNA801875_P_NODE_1666_length_293_cov_1.271318_g1563_i0 | PRJNA801875 | 1666 | 293 | 1.271318 | 3.72496174 | Oikopleura dioica | 34765 | Chordata | Chordata | 44.7 | 0.0144 | NR | CBY09951.1 | 34765 | g1563 | i0 | 42.2 | 1.47440273037543 | 45 | 26 | 46.1 | 0 | 136 | 2 | 323 | 367 | CBY09951.1 unnamed protein product [Oikopleura dioica] | diamond | 432 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 28570003 | 28570003 | PRJNA801875_P_NODE_2107_length_246_cov_1.507109_g2004_i0 | PRJNA801875 | 2107 | 246 | 1.507109 | 3.70748814 | Marmota monax | 9995 | Chordata | Chordata | 70.1 | 8.58e-12 | NR | VTJ75047.1 | 9995 | g2004 | i0 | 53.2 | 1.51219512195122 | 62 | 29 | 75.6 | 0 | 60 | 245 | 51 | 112 | VTJ75047.1 Hypothetical predicted protein, partial [Marmota monax] | diamond | 372 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 29588956 | 29588956 | PRJNA801875_P_NODE_2610_length_210_cov_2.188571_g2507_i0 | PRJNA801875 | 2610 | 210 | 2.188571 | 4.5959991 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0455 | NR | KAB0373609.1 | 9886 | g2507 | i0 | 43.6 | 1.8 | 39 | 22 | 55.7 | 0 | 70 | 186 | 273 | 311 | KAB0373609.1 hypothetical protein FD755_015268 [Muntiacus reevesi] | diamond | 378 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 30180444 | 30180444 | PRJNA801875_P_NODE_1112_length_384_cov_2.183381_g1009_i0 | PRJNA801875 | 1112 | 384 | 2.183381 | 8.38418304 | Mycteria americana | 33587 | Chordata | Chordata | 65.9 | 1.26e-10 | NR | KAK4816150.1 | 33587 | g1009 | i0 | 38.2 | 0.796875 | 102 | 54 | 78.9 | 4 | 42 | 344 | 27 | 120 | KAK4816150.1 hypothetical protein QYF61_011532 [Mycteria americana] | diamond | 306 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 30433664 | 30433664 | PRJNA801875_P_NODE_2333_length_229_cov_1.072165_g2230_i0 | PRJNA801875 | 2333 | 229 | 1.072165 | 2.45525785 | Bufotes viridis | 30338 | Chordata | Chordata | 60.5 | 1.77e-8 | NR | CAK8660862.1 | 30338 | g2230 | i0 | 48.6 | 2.80349344978166 | 72 | 34 | 94.3 | 2 | 13 | 228 | 242 | 310 | CAK8660862.1 Ribosome biogenesis protein BMS1 homolog [Bufotes viridis] | diamond | 642 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30505427 | 30505427 | PRJNA801875_P_NODE_1893_length_269_cov_1.888889_g1790_i0 | PRJNA801875 | 1893 | 269 | 1.888889 | 5.08111141 | Branchiostoma | 7737 | Chordata | Chordata | 136 | 5.48e-38 | NR | XP_035673387.1 | 7739 | g1790 | i0 | 68.2 | 5.8996282527881 | 88 | 28 | 98.1 | 0 | 3 | 266 | 41 | 128 | XP_035673387.1 ras-related protein Rab-24-like isoform X1 [Branchiostoma floridae] | diamond | 1587 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31832861 | 31832861 | PRJNA801875_P_NODE_1937_length_263_cov_3.662281_g1834_i0 | PRJNA801875 | 1937 | 263 | 3.662281 | 9.63179903 | Metazoa | 33208 | Chordata | Chordata | 118 | 2.24e-29 | NR | KAJ7415991.1 | 371930 | g1834 | i0 | 64.6 | 5.63498098859316 | 82 | 29 | 93.5 | 0 | 249 | 4 | 169 | 250 | KAJ7415991.1 DnaJ subfamily A member 2 [Pitangus sulphuratus] | diamond | 1482 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Tyrannidae | Pitangus | Pitangus sulphuratus | |
| 32561046 | 32561046 | PRJNA801875_P_NODE_3579_length_173_cov_2.210145_g3476_i0 | PRJNA801875 | 3579 | 173 | 2.210145 | 3.82355085 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.1 | 1.11e-8 | NR | XP_069061992.1 | 8319 | g3476 | i0 | 50.9 | 24.606936416185 | 55 | 26 | 95.4 | 1 | 3 | 167 | 4930 | 4983 | XP_069061992.1 probable E3 ubiquitin-protein ligase HERC1 [Pleurodeles waltl] | diamond | 4257 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl |
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);;