contig_metadata
11 rows where bioproject = "PRJNA289590" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1647432 | 1647432 | PRJNA289590_P_NODE_29942_length_164_cov_0.904348_g29718_i0 | PRJNA289590 | 29942 | 164 | 0.904348 | 1.48313072 | Canis lupus | 9612 | Chordata | Chordata | 298 | 1.59e-76 | NTclustered | gi|118601107|gb|AC187010.10| | 9615 | g29718 | i0 | 100 | 134.591463414634 | 161 | 0 | 98 | 0 | 1 | 161 | 14896 | 15056 | Canis Familiaris chromosome 11, clone XX-159O9, complete sequence | blastn | 22073 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 4199846 | 4199846 | PRJNA289590_P_NODE_31284_length_162_cov_0.920354_g31060_i0 | PRJNA289590 | 31284 | 162 | 0.920354 | 1.49097348 | Meleagris gallopavo | 9103 | Chordata | Chordata | 219 | 1.26e-52 | NTclustered | gi|1776485102|ref|XM_010729051.3| | 9103 | g31060 | i0 | 91.358 | 4 | 162 | 10 | 100 | 2 | 1 | 162 | 545 | 702 | PREDICTED: Meleagris gallopavo zinc finger MYM-type containing 5 (ZMYM5), transcript variant X4, mRNA | blastn | 648 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 9300586 | 9300586 | PRJNA289590_P_NODE_21288_length_192_cov_1.349650_g21064_i0 | PRJNA289590 | 21288 | 192 | 1.34965 | 2.591328 | Bos indicus | 9915 | Chordata | Chordata | 298 | 1.92e-76 | NTclustered | gi|2878527438|ref|XM_070789484.1| | 9915 | g21064 | i0 | 98.802 | 1155.61458333333 | 167 | 2 | 87 | 0 | 1 | 167 | 1408 | 1574 | PREDICTED: Bos indicus RNA binding motif single stranded interacting protein 2 (RBMS2), transcript variant X18, mRNA | blastn | 221878 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos indicus | |
| 15675357 | 15675357 | PRJNA289590_P_NODE_26273_length_169_cov_0.866667_g26049_i0 | PRJNA289590 | 26273 | 169 | 0.866667 | 1.46466723 | Sus scrofa | 9823 | Chordata | Chordata | 303 | 3.53e-78 | NTclustered | gi|165931784|emb|AM932511.1| | 9823 | g26049 | i0 | 99.401 | 24.6863905325444 | 167 | 1 | 99 | 0 | 3 | 169 | 308 | 142 | Sus scrofa centromeric satellite repeat, clone Pg11 | blastn | 4172 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 22049139 | 22049139 | PRJNA289590_P_NODE_31458_length_162_cov_0.911504_g31234_i0 | PRJNA289590 | 31458 | 162 | 0.911504 | 1.47663648 | Canis lupus | 9612 | Chordata | Chordata | 217 | 4.5199999999999996e-52 | NTclustered | gi|124378290|gb|AC189803.8| | 9615 | g31234 | i0 | 90.798 | 3.3641975308642 | 163 | 14 | 100 | 1 | 1 | 162 | 187363 | 187201 | Canis Familiaris chromosome 16, clone XX-374K10, complete sequence | blastn | 545 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 26807018 | 26807018 | PRJNA289590_P_NODE_14721_length_235_cov_3.053763_g14497_i0 | PRJNA289590 | 14721 | 235 | 3.053763 | 7.17634305 | Mammalia | 40674 | Chordata | Chordata | 98.6 | 4.279999999999999e-23 | NR | XP_058990340.1 | 9666 | g14497 | i0 | 63.6 | 34.3914893617021 | 77 | 26 | 95.7 | 1 | 10 | 234 | 119 | 195 | XP_058990340.1 large ribosomal subunit protein eL22-like [Mustela lutreola] | diamond | 8082 | 99.4 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela lutreola | |
| 27611382 | 27611382 | PRJNA289590_P_NODE_22144_length_188_cov_0.820144_g21920_i0 | PRJNA289590 | 22144 | 188 | 0.820144 | 1.54187072 | Bufotes viridis | 30338 | Chordata | Chordata | 46.2 | 0.00106 | NR | CAK8609802.1 | 30338 | g21920 | i0 | 55.9 | 1.6595744680851101 | 34 | 15 | 54.3 | 0 | 80 | 181 | 1 | 34 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 312 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28905575 | 28905575 | PRJNA289590_P_NODE_22148_length_187_cov_7.166667_g21924_i0 | PRJNA289590 | 22148 | 187 | 7.166667 | 13.40166729 | Lonchura striata | 40157 | Chordata | Chordata | 41.6 | 0.0473 | NR | XP_031362561.1 | 40157 | g21924 | i0 | 44.2 | 0.689839572192513 | 43 | 24 | 69 | 0 | 163 | 35 | 78 | 120 | XP_031362561.1 LOW QUALITY PROTEIN: lysine-specific demethylase hairless [Lonchura striata] | diamond | 129 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Lonchura | Lonchura striata | |
| 29000867 | 29000867 | PRJNA289590_P_NODE_15308_length_231_cov_0.857143_g15084_i0 | PRJNA289590 | 15308 | 231 | 0.857143 | 1.98000033 | Staurois parvus | 386267 | Chordata | Chordata | 60.1 | 4.84e-10 | NR | CAI9620946.1 | 386267 | g15084 | i0 | 70.3 | 0.480519480519481 | 37 | 11 | 48.1 | 0 | 21 | 131 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31022056 | 31022056 | PRJNA289590_P_NODE_14735_length_235_cov_2.010753_g14511_i0 | PRJNA289590 | 14735 | 235 | 2.010753 | 4.72526955 | Zosterops borbonicus | 364589 | Chordata | Chordata | 44.3 | 0.00425 | NR | TRZ17703.1 | 364589 | g14511 | i0 | 34.4 | 0.778723404255319 | 61 | 37 | 74 | 1 | 211 | 38 | 32 | 92 | TRZ17703.1 hypothetical protein HGM15179_009421 [Zosterops borbonicus] | diamond | 183 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Zosteropidae | Zosterops | Zosterops borbonicus | |
| 31179662 | 31179662 | PRJNA289590_P_NODE_12335_length_260_cov_2.194313_g12111_i0 | PRJNA289590 | 12335 | 260 | 2.194313 | 5.7052138 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 124 | 3.1599999999999997e-32 | NR | XP_051791274.1 | 27687 | g12111 | i0 | 77.4 | 7.76538461538462 | 84 | 18 | 95.8 | 1 | 4 | 252 | 121 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2019 | 124 | 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);;