contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA857857" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2120685 | 2120685 | PRJNA857857_P_NODE_44142_length_246_cov_0.890173_g43693_i0 | PRJNA857857 | 44142 | 246 | 0.890173 | 2.18982558 | Mus musculus | 10090 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|46931410|gb|AC124662.10| | 10090 | g43693 | i0 | 100 | 0.227642276422764 | 28 | 0 | 11 | 0 | 171 | 198 | 9820 | 9847 | Mus musculus chromosome 9, clone RP24-409K22, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 2120794 | 2120794 | PRJNA857857_P_NODE_49542_length_242_cov_0.911243_g49093_i0 | PRJNA857857 | 49542 | 242 | 0.911243 | 2.20520806 | Mus musculus | 10090 | Chordata | Chordata | 62.1 | 3.62e-5 | NTclustered | gi|58036719|gb|AC150277.2| | 10090 | g49093 | i0 | 92.857 | 0.776859504132231 | 42 | 3 | 25 | 0 | 1 | 42 | 102046 | 102005 | Mus musculus BAC clone RP23-97E12 from 18, complete sequence | blastn | 188 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 4673601 | 4673601 | PRJNA857857_P_NODE_37724_length_251_cov_0.865169_g37275_i0 | PRJNA857857 | 37724 | 251 | 0.865169 | 2.17157419 | Lampetra planeri | 7750 | Chordata | Chordata | 52.8 | 0.023 | NTclustered | gi|2805724034|emb|OZ078501.1| | 7750 | g37275 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 1 | 28 | 1070259 | 1070232 | Lampetra planeri genome assembly, chromosome: 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra planeri | |
| 7223367 | 7223367 | PRJNA857857_P_NODE_39526_length_249_cov_0.875000_g39077_i0 | PRJNA857857 | 39526 | 249 | 0.875 | 2.17875 | Meleagris gallopavo | 9103 | Chordata | Chordata | 56.5 | 0.002 | NTclustered | gi|2721460928|emb|HG999701.4| | 9103 | g39077 | i0 | 100 | 0.120481927710843 | 30 | 0 | 12 | 0 | 16 | 45 | 2677439 | 2677410 | Meleagris gallopavo genome assembly, chromosome: 21 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 7613726 | 7613726 | PRJNA857857_P_NODE_32726_length_269_cov_0.714286_g32277_i0 | PRJNA857857 | 32726 | 269 | 0.714286 | 1.92142934 | Opisthokonta | 33154 | Chordata | Chordata | 60.2 | 1.47e-4 | NTclustered | gi|2815003689|emb|OZ078618.2| | 7748 | g32277 | i0 | 100 | 3.48327137546468 | 32 | 0 | 12 | 0 | 14 | 45 | 5413233 | 5413202 | Lampetra fluviatilis genome assembly, chromosome: 50 | blastn | 937 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 9773513 | 9773513 | PRJNA857857_P_NODE_52008_length_241_cov_0.916667_g51559_i0 | PRJNA857857 | 52008 | 241 | 0.916667 | 2.20916747 | Pyrrhula murina | 928672 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|2920008266|emb|OZ238999.1| | 928672 | g51559 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 44 | 71 | 37886182 | 37886155 | Pyrrhula murina genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Pyrrhula | Pyrrhula murina | |
| 9773517 | 9773517 | PRJNA857857_P_NODE_52328_length_236_cov_2.527607_g51879_i0 | PRJNA857857 | 52328 | 236 | 2.527607 | 5.96515252 | Mus musculus | 10090 | Chordata | Chordata | 56.5 | 0.002 | NTclustered | gi|354796471|gb|JN960972.1| | 10090 | g51879 | i0 | 100 | 0.76271186440678 | 30 | 0 | 13 | 0 | 57 | 86 | 11138 | 11167 | Mus musculus targeted non-conditional, lacZ-tagged mutant allele Gpr182:tm2e(KOMP)Wtsi; transgenic | blastn | 180 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 10164149 | 10164149 | PRJNA857857_P_NODE_27068_length_298_cov_1.177778_g26619_i0 | PRJNA857857 | 27068 | 298 | 1.177778 | 3.50977844 | Cheloniidae | 8465 | Chordata | Chordata | 69.4 | 2.75e-7 | NTclustered | gi|2911503638|emb|OZ223614.1| | 8472 | g26619 | i0 | 95.455 | 8.2248322147651 | 44 | 1 | 14 | 1 | 68 | 110 | 3311249 | 3311292 | Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 28 | blastn | 2451 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii | ||
| 10164343 | 10164343 | PRJNA857857_P_NODE_44108_length_246_cov_0.890173_g43659_i0 | PRJNA857857 | 44108 | 246 | 0.890173 | 2.18982558 | Canis | 9611 | Chordata | Chordata | 213 | 9.63e-51 | NTclustered | gi|148800006|gb|AC189709.15| | 9615 | g43659 | i0 | 93.103 | 72.6544715447154 | 145 | 10 | 59 | 0 | 97 | 241 | 15009 | 15153 | Canis familiaris chromosome X, clone XX-272C1, complete sequence | blastn | 17873 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 12324208 | 12324208 | PRJNA857857_P_NODE_29930_length_282_cov_1.473684_g29481_i0 | PRJNA857857 | 29930 | 282 | 1.473684 | 4.15578888 | Anas platyrhynchos | 8839 | Chordata | Chordata | 516 | 7.67e-142 | NTclustered | gi|1944862811|ref|XM_038181708.1| | 8839 | g29481 | i0 | 99.645 | 98.5992907801418 | 282 | 1 | 100 | 0 | 1 | 282 | 2078 | 1797 | PREDICTED: Anas platyrhynchos microsomal triglyceride transfer protein-like (LOC101805352), mRNA | blastn | 27805 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas platyrhynchos | |
| 14873206 | 14873206 | PRJNA857857_P_NODE_40632_length_248_cov_1.760000_g40183_i0 | PRJNA857857 | 40632 | 248 | 1.76 | 4.3648 | Rhea pennata | 8795 | Chordata | Chordata | 174 | 4.59e-39 | NTclustered | gi|2664001638|ref|XM_062583343.1| | 8795 | g40183 | i0 | 80.426 | 29.9556451612903 | 235 | 40 | 94 | 5 | 17 | 248 | 409 | 178 | PREDICTED: Rhea pennata RAB11A, member RAS oncogene family (RAB11A), transcript variant X2, mRNA | blastn | 7429 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Rheiformes | Rheidae | Rhea | Rhea pennata | |
| 18696612 | 18696612 | PRJNA857857_P_NODE_41615_length_248_cov_0.880000_g41166_i0 | PRJNA857857 | 41615 | 248 | 0.88 | 2.1824 | Cairina moschata | 8855 | Chordata | Chordata | 320 | 5.57e-83 | NTclustered | gi|2921976101|gb|CP130420.1| | 8855 | g41166 | i0 | 97.34 | 0.923387096774194 | 188 | 5 | 92 | 0 | 61 | 248 | 59897806 | 59897619 | Cairina moschata breed yongchun chromosome 5 | blastn | 229 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cairina | Cairina moschata | |
| 19971754 | 19971754 | PRJNA857857_P_NODE_39656_length_249_cov_0.875000_g39207_i0 | PRJNA857857 | 39656 | 249 | 0.875 | 2.17875 | Gallus gallus | 9031 | Chordata | Chordata | 455 | 1.47e-123 | NTclustered | gi|2201786186|ref|XM_040666916.2| | 9031 | g39207 | i0 | 99.598 | 98.8674698795181 | 249 | 1 | 100 | 0 | 1 | 249 | 1405 | 1653 | PREDICTED: Gallus gallus consortin, connexin sorting protein (CNST), transcript variant X1, mRNA | blastn | 24618 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 20362129 | 20362129 | PRJNA857857_P_NODE_39336_length_249_cov_1.113636_g38887_i0 | PRJNA857857 | 39336 | 249 | 1.113636 | 2.77295364 | Opisthokonta | 33154 | Chordata | Chordata | 56.5 | 0.002 | NTclustered | gi|1003751488|ref|XM_015854266.1| | 93934 | g38887 | i0 | 96.97 | 2.99196787148594 | 33 | 1 | 13 | 0 | 182 | 214 | 2043 | 2075 | PREDICTED: Coturnix japonica zinc finger protein 830-like (LOC107309444), mRNA | blastn | 745 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Coturnix | Coturnix japonica | |
| 21247234 | 21247234 | PRJNA857857_P_NODE_34017_length_262_cov_1.222222_g33568_i0 | PRJNA857857 | 34017 | 262 | 1.222222 | 3.20222164 | Lonchura striata | 40157 | Chordata | Chordata | 63.9 | 1.1e-5 | NTclustered | gi|1209976941|ref|XM_021525831.1| | 40157 | g33568 | i0 | 95.122 | 5.00381679389313 | 41 | 0 | 15 | 2 | 10 | 49 | 1223 | 1262 | PREDICTED: Lonchura striata checkpoint kinase 1 (CHEK1), mRNA | blastn | 1311 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Lonchura | Lonchura striata | |
| 21637879 | 21637879 | PRJNA857857_P_NODE_46197_length_245_cov_0.895349_g45748_i0 | PRJNA857857 | 46197 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Chordata | Chordata | 54.7 | 0.006 | NTclustered | gi|57470750|gb|AC131338.4| | 10090 | g45748 | i0 | 100 | 0.726530612244898 | 29 | 0 | 12 | 0 | 89 | 117 | 11843 | 11871 | Mus musculus BAC clone RP23-29O10 from 18, complete sequence | blastn | 178 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22913247 | 22913247 | PRJNA857857_P_NODE_23638_length_321_cov_1.241935_g23189_i0 | PRJNA857857 | 23638 | 321 | 1.241935 | 3.98661135 | Aves | 8782 | Chordata | Chordata | 84.2 | 1.07e-11 | NTclustered | gi|2499815549|ref|XR_003555283.2| | 8954 | g23189 | i0 | 85.185 | 24.9750778816199 | 81 | 12 | 25 | 0 | 241 | 321 | 793 | 713 | PREDICTED: Falco peregrinus zinc finger DHHC-type palmitoyltransferase 20 (ZDHHC20), transcript variant X2, misc_RNA | blastn | 8017 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Falconiformes | Falconidae | Falco | Falco peregrinus | |
| 23797559 | 23797559 | PRJNA857857_P_NODE_47059_length_244_cov_0.900585_g46610_i0 | PRJNA857857 | 47059 | 244 | 0.900585 | 2.1974274 | Cairina moschata | 8855 | Chordata | Chordata | 259 | 1.21e-64 | NTclustered | gi|2921976101|gb|CP130420.1| | 8855 | g46610 | i0 | 95.652 | 1 | 161 | 7 | 100 | 0 | 84 | 244 | 59887193 | 59887033 | Cairina moschata breed yongchun chromosome 5 | blastn | 244 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cairina | Cairina moschata | |
| 23797611 | 23797611 | PRJNA857857_P_NODE_49399_length_242_cov_1.479290_g48950_i0 | PRJNA857857 | 49399 | 242 | 1.47929 | 3.5798818 | Meriones unguiculatus | 10047 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|2599573951|ref|XM_021634657.2| | 10047 | g48950 | i0 | 100 | 1.15702479338843 | 28 | 0 | 12 | 0 | 86 | 113 | 7473 | 7446 | PREDICTED: Meriones unguiculatus RNA binding motif single stranded interacting protein 3 (Rbms3), transcript variant X12, mRNA | blastn | 280 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus | |
| 24187238 | 24187238 | PRJNA857857_P_NODE_30559_length_279_cov_1.427184_g30110_i0 | PRJNA857857 | 30559 | 279 | 1.427184 | 3.98184336 | Phyllostomus | 9422 | Chordata | Chordata | 52.8 | 0.026 | NTclustered | gi|2177209624|ref|XM_045847513.1| | 9423 | g30110 | i0 | 100 | 0.301075268817204 | 28 | 0 | 10 | 0 | 15 | 42 | 1509 | 1482 | PREDICTED: Phyllostomus hastatus WASP like actin nucleation promoting factor (WASL), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus hastatus |
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);;