contig_metadata
24 rows where bioproject = "PRJNA188516", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1640585 | 1640585 | PRJNA188516_P_NODE_4102_length_169_cov_0.866667_g4052_i0 | PRJNA188516 | 4102 | 169 | 0.866667 | 1.46466723 | Sitta europaea | 50251 | Chordata | Chordata | 52.8 | 0.014 | NTclustered | gi|2917598300|emb|OZ228662.1| | 50251 | g4052 | i0 | 100 | 0.331360946745562 | 28 | 0 | 17 | 0 | 6 | 33 | 27061412 | 27061385 | Sitta europaea genome assembly, chromosome: 8 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sittidae | Sitta | Sitta europaea | |
| 2916488 | 2916488 | PRJNA188516_P_NODE_4583_length_167_cov_0.881356_g4533_i0 | PRJNA188516 | 4583 | 167 | 0.881356 | 1.47186452 | Anser cygnoides | 8845 | Chordata | Chordata | 80.5 | 6.43e-11 | NTclustered | gi|2782202122|ref|XM_048057220.2| | 8845 | g4533 | i0 | 88.06 | 4.94011976047904 | 67 | 8 | 40 | 0 | 2 | 68 | 319 | 253 | PREDICTED: Anser cygnoides ribosomal protein S14 (RPS14), mRNA | blastn | 825 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anser | Anser cygnoides | |
| 3605663 | 3605663 | PRJNA188516_P_NODE_5563_length_164_cov_0.904348_g5513_i0 | PRJNA188516 | 5563 | 164 | 0.904348 | 1.48313072 | Metazoa | 33208 | Chordata | Chordata | 154 | 3.65e-33 | NTclustered | gi|2562894275|ref|XM_058858150.1| | 48891 | g5513 | i0 | 84.277 | 91.140243902439 | 159 | 23 | 96 | 2 | 7 | 164 | 335 | 178 | PREDICTED: Poecile atricapillus ribosomal protein L23 (RPL23), mRNA | blastn | 14947 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Paridae | Poecile | Poecile atricapillus | |
| 5469164 | 5469164 | PRJNA188516_P_NODE_5205_length_165_cov_0.896552_g5155_i0 | PRJNA188516 | 5205 | 165 | 0.896552 | 1.4793108 | Bos indicus | 9915 | Chordata | Chordata | 178 | 2.18e-40 | NTclustered | gi|2878369567|ref|XR_011569285.1| | 9915 | g5155 | i0 | 93.388 | 212.557575757576 | 121 | 6 | 72 | 2 | 47 | 165 | 5201 | 5081 | PREDICTED: Bos indicus uncharacterized lncRNA (LOC109566173), ncRNA | blastn | 35072 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos indicus | |
| 9293916 | 9293916 | PRJNA188516_P_NODE_5248_length_165_cov_0.896552_g5198_i0 | PRJNA188516 | 5248 | 165 | 0.896552 | 1.4793108 | Mus musculus | 10090 | Chordata | Chordata | 305 | 9.59e-79 | NTclustered | gi|26082301|dbj|AK031387.1| | 10090 | g5198 | i0 | 100 | 108.333333333333 | 165 | 0 | 100 | 0 | 1 | 165 | 2112 | 2276 | Mus musculus 13 days embryo male testis cDNA, RIKEN full-length enriched library, clone:6030421A03 product:U3B small nuclear RNA 4, full insert sequence | blastn | 17875 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 9293923 | 9293923 | PRJNA188516_P_NODE_588_length_513_cov_201.730603_g538_i0 | PRJNA188516 | 588 | 513 | 201.730603 | 1034.87799339 | Mus musculus | 10090 | Chordata | Chordata | 922 | 0 | NTclustered | gi|13517973|gb|AF346627.1|AF346627 | 10090 | g538 | i0 | 100 | 97.3898635477583 | 499 | 0 | 97 | 0 | 14 | 512 | 182 | 680 | Mus musculus epithelial membrane protein 2 (Emp2) mRNA, complete cds | blastn | 49961 | 922 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 9293940 | 9293940 | PRJNA188516_P_NODE_948_length_391_cov_1.786550_g898_i0 | PRJNA188516 | 948 | 391 | 1.78655 | 6.9854105 | Mus musculus | 10090 | Chordata | Chordata | 593 | 4.949999999999998e-165 | NTclustered | gi|2548330513|gb|OQ915115.1| | 10090 | g898 | i0 | 94.192 | 81.1764705882353 | 396 | 11 | 100 | 9 | 1 | 391 | 4680 | 5068 | Mus musculus clone BAC JH_40 45S ribosomal RNA and 18S ribosomal RNA genes, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, 3' and 5' external transcribed spacers, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 31740 | 593 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 10569907 | 10569907 | PRJNA188516_P_NODE_5409_length_164_cov_0.904348_g5359_i0 | PRJNA188516 | 5409 | 164 | 0.904348 | 1.48313072 | Myotis daubentonii | 98922 | Chordata | Chordata | 75 | 2.92e-9 | NTclustered | gi|2579778429|ref|XR_009449993.1| | 98922 | g5359 | i0 | 84.81 | 15.8231707317073 | 79 | 7 | 46 | 4 | 1 | 76 | 16 | 92 | PREDICTED: Myotis daubentonii U2 spliceosomal RNA (LOC132221445), ncRNA | blastn | 2595 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis daubentonii | |
| 11844399 | 11844399 | PRJNA188516_P_NODE_5410_length_164_cov_0.904348_g5360_i0 | PRJNA188516 | 5410 | 164 | 0.904348 | 1.48313072 | Cavia porcellus | 10141 | Chordata | Chordata | 303 | 3.42e-78 | NTclustered | gi|2687740325|ref|XM_005005322.4| | 10141 | g5360 | i0 | 100 | 97.640243902439 | 164 | 0 | 100 | 0 | 1 | 164 | 843 | 680 | PREDICTED: Cavia porcellus prosaposin (Psap), transcript variant X4, mRNA | blastn | 16013 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Caviidae | Cavia | Cavia porcellus | |
| 13119614 | 13119614 | PRJNA188516_P_NODE_5131_length_165_cov_0.896552_g5081_i0 | PRJNA188516 | 5131 | 165 | 0.896552 | 1.4793108 | Sus scrofa | 9823 | Chordata | Chordata | 137 | 3.7e-28 | NTclustered | gi|237945933|emb|CU207382.5| | 9823 | g5081 | i0 | 98.701 | 59.7575757575758 | 77 | 1 | 47 | 0 | 89 | 165 | 52421 | 52497 | Pig DNA sequence from clone CH242-409K13 on chromosome X, complete sequence | blastn | 9860 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 14394933 | 14394933 | PRJNA188516_P_NODE_6112_length_162_cov_0.920354_g6062_i0 | PRJNA188516 | 6112 | 162 | 0.920354 | 1.49097348 | Xenopus tropicalis | 8364 | Chordata | Chordata | 283 | 4.39e-72 | NTclustered | gi|51895800|gb|BC080974.1| | 8364 | g6062 | i0 | 98.148 | 99.8888888888889 | 162 | 3 | 100 | 0 | 1 | 162 | 1211 | 1050 | Xenopus tropicalis hypothetical LOC493206, mRNA (cDNA clone IMAGE:6984500), partial cds | blastn | 16182 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 15668593 | 15668593 | PRJNA188516_P_NODE_3173_length_191_cov_1.443662_g3123_i0 | PRJNA188516 | 3173 | 191 | 1.443662 | 2.75739442 | Mus musculus | 10090 | Chordata | Chordata | 315 | 1.9e-81 | NTclustered | gi|74190022|dbj|AK141268.1| | 10090 | g3123 | i0 | 100 | 31.4764397905759 | 170 | 0 | 89 | 0 | 1 | 170 | 348 | 179 | Mus musculus 7 days embryo whole body cDNA, RIKEN full-length enriched library, clone:C430011C24 product:tumor necrosis factor (ligand) superfamily, member 6, full insert sequence | blastn | 6012 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22731951 | 22731951 | PRJNA188516_P_NODE_1638_length_279_cov_0.900000_g1588_i0 | PRJNA188516 | 1638 | 279 | 0.9 | 2.511 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 2e-29 | NR | OCT94035.1 | 8355 | g1588 | i0 | 71.4 | 105.043010752688 | 77 | 22 | 82.8 | 0 | 49 | 279 | 108 | 184 | OCT94035.1 hypothetical protein XELAEV_18011698mg [Xenopus laevis] | diamond | 29307 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 22731959 | 22731959 | PRJNA188516_P_NODE_3958_length_170_cov_1.231405_g3908_i0 | PRJNA188516 | 3958 | 170 | 1.231405 | 2.0933885 | Apteryx | 8821 | Chordata | Chordata | 147 | 6.339999999999999e-31 | NTclustered | gi|1444534300|ref|XM_026088147.1| | 308060 | g3908 | i0 | 82.738 | 7.47647058823529 | 168 | 25 | 98 | 2 | 4 | 169 | 533 | 698 | PREDICTED: Apteryx rowi casein kinase II subunit alpha-like (LOC112976673), transcript variant X1, mRNA | blastn | 1271 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apterygiformes | Apterygidae | Apteryx | Apteryx rowi | |
| 26743182 | 26743182 | PRJNA188516_P_NODE_3201_length_190_cov_1.475177_g3151_i0 | PRJNA188516 | 3201 | 190 | 1.475177 | 2.8028363 | Artiodactyla | 91561 | Chordata | Chordata | 80.5 | 8.87e-16 | NR | TKC36767.1 | 40151 | g3151 | i0 | 66.1 | 8.30526315789474 | 62 | 21 | 97.9 | 0 | 3 | 188 | 732 | 793 | TKC36767.1 hypothetical protein EI555_004718, partial [Monodon monoceros] | diamond | 1578 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 26915717 | 26915717 | PRJNA188516_P_NODE_5802_length_163_cov_0.912281_g5752_i0 | PRJNA188516 | 5802 | 163 | 0.912281 | 1.48701803 | Bufotes viridis | 30338 | Chordata | Chordata | 44.7 | 0.00268 | NR | CAK8639140.1 | 30338 | g5752 | i0 | 53.7 | 1.50920245398773 | 41 | 19 | 75.5 | 0 | 1 | 123 | 522 | 562 | CAK8639140.1 B-cell lymphoma 6 protein homolog [Bufotes viridis] | diamond | 246 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27706150 | 27706150 | PRJNA188516_P_NODE_2564_length_214_cov_1.260606_g2514_i0 | PRJNA188516 | 2564 | 214 | 1.260606 | 2.69769684 | Lepidochelys olivacea | 27788 | Chordata | Chordata | 59.3 | 3.49e-8 | NR | CAJ90462.1 | 27788 | g2514 | i0 | 44.9 | 7.80841121495327 | 69 | 38 | 96.7 | 0 | 212 | 6 | 261 | 329 | CAJ90462.1 NADH dehydrogenase subunit 4 [Lepidochelys olivacea] | diamond | 1671 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys olivacea | ||
| 28179105 | 28179105 | PRJNA188516_P_NODE_6066_length_162_cov_0.920354_g6016_i0 | PRJNA188516 | 6066 | 162 | 0.920354 | 1.49097348 | Taeniopygia guttata | 59729 | Chordata | Chordata | 39.7 | 0.0355 | NR | ACH44493.1 | 59729 | g6016 | i0 | 58.8 | 0.62962962962963 | 34 | 11 | 57.4 | 1 | 147 | 55 | 7 | 40 | ACH44493.1 putative inosine triphosphatase isoform variant 2 [Taeniopygia guttata] | diamond | 102 | 39.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Taeniopygia | Taeniopygia guttata | |
| 29852881 | 29852881 | PRJNA188516_P_NODE_3791_length_174_cov_0.832000_g3741_i0 | PRJNA188516 | 3791 | 174 | 0.832 | 1.44768 | Engystomops pustulosus | 76066 | Chordata | Chordata | 41.6 | 0.0107 | NR | KAG8554186.1 | 76066 | g3741 | i0 | 71.4 | 1.44827586206897 | 28 | 8 | 48.3 | 0 | 167 | 84 | 73 | 100 | KAG8554186.1 hypothetical protein GDO81_003707 [Engystomops pustulosus] | diamond | 252 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30628639 | 30628639 | PRJNA188516_P_NODE_1633_length_279_cov_2.143478_g1583_i0 | PRJNA188516 | 1633 | 279 | 2.143478 | 5.98030362 | Chordata | 7711 | Chordata | Chordata | 42.4 | 0.0295 | NR | CAK8685383.1 | 159417 | g1583 | i0 | 52.5 | 1.33333333333333 | 40 | 19 | 43 | 0 | 189 | 70 | 60 | 99 | CAK8685383.1 unnamed protein product [Clavelina lepadiformis] | diamond | 372 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31116345 | 31116345 | PRJNA188516_P_NODE_5775_length_163_cov_0.912281_g5725_i0 | PRJNA188516 | 5775 | 163 | 0.912281 | 1.48701803 | Oreolalax omeimontis | 445777 | Chordata | Chordata | 57.8 | 5.84e-8 | NR | WDD39345.1 | 445777 | g5725 | i0 | 66.7 | 7.95092024539877 | 54 | 18 | 99.4 | 0 | 163 | 2 | 105 | 158 | WDD39345.1 NADH dehydrogenase subunit 1 [Oreolalax omeimontis] | diamond | 1296 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Megophryidae | Oreolalax | Oreolalax omeimontis | |
| 31369763 | 31369763 | PRJNA188516_P_NODE_6056_length_162_cov_0.920354_g6006_i0 | PRJNA188516 | 6056 | 162 | 0.920354 | 1.49097348 | Polypterus senegalus | 55291 | Chordata | Chordata | 75.1 | 3.19e-14 | NR | KAG2460242.1 | 55291 | g6006 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 3 | 161 | 231 | 283 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 159 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31559495 | 31559495 | PRJNA188516_P_NODE_6196_length_159_cov_3.809091_g6146_i0 | PRJNA188516 | 6196 | 159 | 3.809091 | 6.05645469 | Cavia porcellus | 10141 | Chordata | Chordata | 41.2 | 0.0392 | NR | XP_003470245.2 | 10141 | g6146 | i0 | 83.3 | 1.43396226415094 | 24 | 4 | 45.3 | 0 | 88 | 159 | 69 | 92 | XP_003470245.2 eukaryotic translation initiation factor 1A, X-chromosomal-like [Cavia porcellus] | diamond | 228 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Caviidae | Cavia | Cavia porcellus | |
| 32558149 | 32558149 | PRJNA188516_P_NODE_6119_length_162_cov_0.920354_g6069_i0 | PRJNA188516 | 6119 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Chordata | Chordata | 60.1 | 7.4e-10 | NR | KAG8520360.1 | 202257 | g6069 | i0 | 63 | 59.037037037037 | 54 | 18 | 100 | 1 | 162 | 1 | 10 | 61 | KAG8520360.1 60S ribosomal protein L27 [Galemys pyrenaicus] | diamond | 9564 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Galemys | Galemys pyrenaicus |
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);;