contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 995299 | 995299 | PRJEB673_P_NODE_13001_length_150_cov_1.391304_g12652_i0 | PRJEB673 | 13001 | 150 | 1.391304 | 2.086956 | Vulpes | 9625 | Chordata | Chordata | 78.7 | 2.02e-10 | NTclustered | gi|1435549343|ref|XM_025991200.1| | 9627 | g12652 | i0 | 80.769 | 12.6666666666667 | 104 | 16 | 68 | 4 | 32 | 133 | 222 | 323 | PREDICTED: Vulpes vulpes 60S ribosomal protein L30-like (LOC112914198), mRNA | blastn | 1900 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Vulpes | Vulpes vulpes | |
| 2684946 | 2684946 | PRJEB673_P_NODE_10323_length_176_cov_1.666667_g9974_i0 | PRJEB673 | 10323 | 176 | 1.666667 | 2.93333392 | Lethenteron reissneri | 7753 | Chordata | Chordata | 178 | 2.35e-40 | NTclustered | gi|2635851083|ref|XM_061560508.1| | 7753 | g9974 | i0 | 86.792 | 70.2727272727273 | 159 | 21 | 90 | 0 | 1 | 159 | 252 | 410 | PREDICTED: Lethenteron reissneri ribosomal protein S9 (RPS9), mRNA | blastn | 12368 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lethenteron | Lethenteron reissneri | |
| 5237423 | 5237423 | PRJEB673_P_NODE_11925_length_157_cov_1.811475_g11576_i0 | PRJEB673 | 11925 | 157 | 1.811475 | 2.84401575 | Mus musculus | 10090 | Chordata | Chordata | 52.8 | 0.013 | NTclustered | gi|1039744595|ref|XR_001780889.1| | 10090 | g11576 | i0 | 100 | 0.356687898089172 | 28 | 0 | 18 | 0 | 112 | 139 | 355 | 328 | PREDICTED: Mus musculus predicted gene, 30127 (Gm30127), ncRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 5237510 | 5237510 | PRJEB673_P_NODE_9685_length_190_cov_1.290323_g9336_i0 | PRJEB673 | 9685 | 190 | 1.290323 | 2.4516137 | Xenopus laevis | 8355 | Chordata | Chordata | 52.8 | 0.016 | NTclustered | gi|2038222965|ref|XM_041565031.1| | 8355 | g9336 | i0 | 100 | 2.50526315789474 | 28 | 0 | 15 | 0 | 148 | 175 | 5263 | 5290 | PREDICTED: Xenopus laevis myelin transcription factor 1-like protein (LOC108718228), transcript variant X5, mRNA | blastn | 476 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 8648449 | 8648449 | PRJEB673_P_NODE_7847_length_305_cov_1.974074_g7498_i0 | PRJEB673 | 7847 | 305 | 1.974074 | 6.0209257 | Lacertidae | 8522 | Chordata | Chordata | 52.8 | 0.028 | NTclustered | gi|1622176963|ref|XM_028710289.1| | 64176 | g7498 | i0 | 100 | 1.00983606557377 | 28 | 0 | 9 | 0 | 190 | 217 | 201 | 174 | PREDICTED: Podarcis muralis beta-keratin-related protein-like (LOC114586635), mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis muralis | |
| 10337906 | 10337906 | PRJEB673_P_NODE_10789_length_169_cov_1.029851_g10440_i0 | PRJEB673 | 10789 | 169 | 1.029851 | 1.74044819 | Chrysemys picta | 8479 | Chordata | Chordata | 108 | 2.97e-19 | NTclustered | gi|2739604710|ref|XM_065551444.1| | 8478 | g10440 | i0 | 78.981 | 1.09467455621302 | 157 | 33 | 93 | 0 | 11 | 167 | 442 | 286 | PREDICTED: Chrysemys picta bellii ADP ribosylation factor 5 (ARF5), mRNA | blastn | 185 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Chrysemys | Chrysemys picta | ||
| 14163274 | 14163274 | PRJEB673_P_NODE_12972_length_150_cov_1.434783_g12623_i0 | PRJEB673 | 12972 | 150 | 1.434783 | 2.1521745 | Ranitomeya imitator | 111125 | Chordata | Chordata | 89.8 | 9.31e-14 | NTclustered | gi|2851959547|ref|XM_069731569.1| | 111125 | g12623 | i0 | 88 | 2.98666666666667 | 75 | 9 | 50 | 0 | 76 | 150 | 1789 | 1715 | PREDICTED: Ranitomeya imitator V-type proton ATPase subunit d 2 (LOC138642939), mRNA | blastn | 448 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 17986456 | 17986456 | PRJEB673_P_NODE_12235_length_155_cov_1.333333_g11886_i0 | PRJEB673 | 12235 | 155 | 1.333333 | 2.06666615 | Spinus spinus | 160760 | Chordata | Chordata | 52.8 | 0.013 | NTclustered | gi|2917663466|emb|OZ228753.1| | 160760 | g11886 | i0 | 100 | 0.361290322580645 | 28 | 0 | 18 | 0 | 38 | 65 | 37205149 | 37205122 | Spinus spinus genome assembly, chromosome: 5 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Spinus | Spinus spinus | |
| 23086656 | 23086656 | PRJEB673_P_NODE_11439_length_161_cov_1.587302_g11090_i0 | PRJEB673 | 11439 | 161 | 1.587302 | 2.55555622 | Erinaceus europaeus | 9365 | Chordata | Chordata | 56.5 | 0.001 | NTclustered | gi|2591557184|ref|XM_060201429.1| | 9365 | g11090 | i0 | 94.595 | 0.919254658385093 | 37 | 1 | 22 | 1 | 72 | 107 | 2229 | 2193 | PREDICTED: Erinaceus europaeus kirre like nephrin family adhesion molecule 1 (KIRREL1), transcript variant X3, mRNA | blastn | 148 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Erinaceidae | Erinaceus | Erinaceus europaeus | |
| 23947823 | 23947823 | PRJEB673_P_NODE_6739_length_334_cov_2.311037_g6390_i0 | PRJEB673 | 6739 | 334 | 2.311037 | 7.71886358 | Rodentia | 9989 | Chordata | Chordata | 54.7 | 0.009 | NTclustered | gi|2599575189|ref|XM_060385522.1| | 10047 | g6390 | i0 | 100 | 0.955089820359281 | 29 | 0 | 9 | 0 | 89 | 117 | 613 | 585 | PREDICTED: Meriones unguiculatus phospholipid scramblase 4 (Plscr4), transcript variant X3, mRNA | blastn | 319 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus |
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);;