contig_metadata
15 rows where bioproject = "PRJNA1036688" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169682 | 169682 | PRJNA1036688_P_NODE_8741_length_185_cov_0.878378_g8449_i0 | PRJNA1036688 | 8741 | 185 | 0.878378 | 1.6249993 | Apus apus | 8895 | Chordata | Chordata | 52.8 | 0.016 | NTclustered | gi|2323521672|ref|XM_051632190.1| | 8895 | g8449 | i0 | 100 | 0.756756756756757 | 28 | 0 | 15 | 0 | 20 | 47 | 3274 | 3301 | PREDICTED: Apus apus ankyrin repeat and fibronectin type-III domain-containing protein 1-like (LOC127390480), transcript variant X5, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apodiformes | Apodidae | Apus | Apus apus | |
| 4836117 | 4836117 | PRJNA1036688_P_NODE_11184_length_159_cov_0.934426_g10892_i0 | PRJNA1036688 | 11184 | 159 | 0.934426 | 1.48573734 | Artiodactyla | 91561 | Chordata | Chordata | 230 | 5.67e-56 | NTclustered | gi|2871638751|ref|XM_070463227.1| | 9874 | g10892 | i0 | 93.038 | 735.25786163522 | 158 | 10 | 99 | 1 | 1 | 157 | 1306 | 1149 | PREDICTED: Odocoileus virginianus centrosomal protein of 70 kDa-like (LOC110124377), transcript variant X10, mRNA | blastn | 116906 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 5272523 | 5272523 | PRJNA1036688_P_NODE_6765_length_219_cov_2.120879_g6473_i0 | PRJNA1036688 | 6765 | 219 | 2.120879 | 4.64472501 | Metazoa | 33208 | Chordata | Chordata | 114 | 1.63e-29 | NR | MBZ3884393.1 | 30640 | g6473 | i0 | 76.3 | 3.97260273972603 | 76 | 15 | 100 | 1 | 1 | 219 | 29 | 104 | MBZ3884393.1 40S ribosomal protein S2 [Sciurus carolinensis] | diamond | 870 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 7822313 | 7822313 | PRJNA1036688_P_NODE_9087_length_180_cov_1.636364_g8795_i0 | PRJNA1036688 | 9087 | 180 | 1.636364 | 2.9454552 | Gallus gallus | 9031 | Chordata | Chordata | 333 | 4.87e-87 | NTclustered | gi|2024360878|ref|XR_005840240.1| | 9031 | g8795 | i0 | 100 | 91.5055555555556 | 180 | 0 | 100 | 0 | 1 | 180 | 661 | 840 | PREDICTED: Gallus gallus 28S ribosomal RNA (LOC121106977), rRNA | blastn | 16471 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 9936187 | 9936187 | PRJNA1036688_P_NODE_3228_length_365_cov_2.445122_g2937_i0 | PRJNA1036688 | 3228 | 365 | 2.445122 | 8.9246953 | Fringillidae | 9133 | Chordata | Chordata | 56.5 | 0.003 | NTclustered | gi|2917691352|emb|OZ228803.1| | 37598 | g2937 | i0 | 100 | 2.87123287671233 | 30 | 0 | 8 | 0 | 328 | 357 | 4884895 | 4884866 | Fringilla coelebs genome assembly, chromosome: 24 | blastn | 1048 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Fringilla | Fringilla coelebs | |
| 13761496 | 13761496 | PRJNA1036688_P_NODE_8411_length_189_cov_3.111842_g8119_i0 | PRJNA1036688 | 8411 | 189 | 3.111842 | 5.88138138 | Artiodactyla | 91561 | Chordata | Chordata | 342 | 8.589999999999999e-90 | NTclustered | gi|2871702816|ref|XM_070457416.1| | 9874 | g8119 | i0 | 99.468 | 1428.42328042328 | 188 | 1 | 99 | 0 | 2 | 189 | 472 | 659 | PREDICTED: Odocoileus virginianus zinc finger and BTB domain containing 44 (ZBTB44), transcript variant X2, mRNA | blastn | 269972 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 16746654 | 16746654 | PRJNA1036688_P_NODE_6994_length_214_cov_2.203390_g6702_i0 | PRJNA1036688 | 6994 | 214 | 2.20339 | 4.7152546 | Gallus gallus | 9031 | Chordata | Chordata | 396 | 7.559999999999996e-106 | NTclustered | gi|2024360878|ref|XR_005840240.1| | 9031 | g6702 | i0 | 100 | 107.31308411215 | 214 | 0 | 100 | 0 | 1 | 214 | 4355 | 4142 | PREDICTED: Gallus gallus 28S ribosomal RNA (LOC121106977), rRNA | blastn | 22965 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 20134498 | 20134498 | PRJNA1036688_P_NODE_8516_length_188_cov_1.019868_g8224_i0 | PRJNA1036688 | 8516 | 188 | 1.019868 | 1.91735184 | Lepidosauria | 8504 | Chordata | Chordata | 60.2 | 9.63e-5 | NTclustered | gi|2118978504|ref|XR_006362838.1| | 7888 | g8224 | i0 | 88 | 4.95212765957447 | 50 | 6 | 27 | 0 | 32 | 81 | 1626 | 1577 | PREDICTED: Protopterus annectens 28S ribosomal RNA (LOC122789521), rRNA | blastn | 931 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 21410114 | 21410114 | PRJNA1036688_P_NODE_12037_length_152_cov_1.313043_g11745_i0 | PRJNA1036688 | 12037 | 152 | 1.313043 | 1.99582536 | Bos | 9903 | Chordata | Chordata | 270 | 3.15e-68 | NTclustered | gi|226437713|gb|AC150644.6| | 9913 | g11745 | i0 | 98.684 | 758.381578947368 | 152 | 2 | 100 | 0 | 1 | 152 | 90603 | 90754 | Bos taurus BAC CH240-223I2 (Children's Hospital Oakland Research Institute Bovine BAC Library complete sequence | blastn | 115274 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 28290380 | 28290380 | PRJNA1036688_P_NODE_8226_length_192_cov_1.496774_g7934_i0 | PRJNA1036688 | 8226 | 192 | 1.496774 | 2.87380608 | root | 1 | Root_unresolved | Root_unresolved | 139 | 8.999999999999999e-37 | NR | XP_030110853.2 | 10090 | g7934 | i0 | 100 | 15.75 | 63 | 0 | 98.4 | 0 | 2 | 190 | 170 | 232 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 3024 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28898284 | 28898284 | PRJNA1036688_P_NODE_7148_length_211_cov_1.545977_g6856_i0 | PRJNA1036688 | 7148 | 211 | 1.545977 | 3.26201147 | Polypterus senegalus | 55291 | Chordata | Chordata | 45.8 | 0.00189 | NR | KAG2469876.1 | 55291 | g6856 | i0 | 64.3 | 10.3791469194313 | 28 | 10 | 39.8 | 0 | 209 | 126 | 299 | 326 | KAG2469876.1 TC1A transposase, partial [Polypterus senegalus] | diamond | 2190 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29088026 | 29088026 | PRJNA1036688_P_NODE_9428_length_176_cov_1.676259_g9136_i0 | PRJNA1036688 | 9428 | 176 | 1.676259 | 2.95021584 | Staurois parvus | 386267 | Chordata | Chordata | 44.7 | 3.23e-4 | NR | CAI9580978.1 | 386267 | g9136 | i0 | 56.1 | 0.698863636363636 | 41 | 18 | 69.9 | 0 | 27 | 149 | 1 | 41 | CAI9580978.1 unnamed protein product, partial [Staurois parvus] | diamond | 123 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29308810 | 29308810 | PRJNA1036688_P_NODE_8469_length_188_cov_2.821192_g8177_i0 | PRJNA1036688 | 8469 | 188 | 2.821192 | 5.30384096 | Bufotes viridis | 30338 | Chordata | Chordata | 42.7 | 0.018 | NR | CAK8609802.1 | 30338 | g8177 | i0 | 52.9 | 1.78723404255319 | 34 | 16 | 54.3 | 0 | 107 | 6 | 1 | 34 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 336 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30406681 | 30406681 | PRJNA1036688_P_NODE_11813_length_153_cov_19.672414_g11521_i0 | PRJNA1036688 | 11813 | 153 | 19.672414 | 30.09879342 | Opisthokonta | 33154 | Chordata | Chordata | 40.8 | 0.0169 | NR | NWZ51675.1 | 8969 | g11521 | i0 | 69.2 | 2.54901960784314 | 26 | 8 | 51 | 0 | 153 | 76 | 6 | 31 | NWZ51675.1 ZN252 protein [Haliaeetus albicilla] | diamond | 390 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Accipitridae | Haliaeetus | Haliaeetus albicilla | |
| 32564850 | 32564850 | PRJNA1036688_P_NODE_11419_length_157_cov_0.966667_g11127_i0 | PRJNA1036688 | 11419 | 157 | 0.966667 | 1.51766719 | Tricholaema leucomelas | 240729 | Chordata | Chordata | 43.5 | 9.45e-4 | NR | NXX49186.1 | 240729 | g11127 | i0 | 38.6 | 2.56050955414013 | 44 | 27 | 84.1 | 0 | 134 | 3 | 2 | 45 | NXX49186.1 Z585A protein [Tricholaema leucomelas] | diamond | 402 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Piciformes | Lybiidae | Tricholaema lacrymosa | Tricholaema leucomelas |
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);;