contig_metadata
8 rows where analysis = "blastn", 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 | |
| 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 |
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);;