contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA816527" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 819467 | 819467 | PRJNA816527_P_NODE_19081_length_245_cov_0.895349_g19031_i0 | PRJNA816527 | 19081 | 245 | 0.895349 | 2.19360505 | Gallus gallus | 9031 | Chordata | Chordata | 431 | 2.4299999999999996e-116 | NTclustered | gi|2099395462|ref|NM_001004393.2| | 9031 | g19031 | i0 | 98.367 | 40.6367346938775 | 245 | 4 | 100 | 0 | 1 | 245 | 2578 | 2822 | Gallus gallus stathmin 3 (STMN3), mRNA | blastn | 9956 | 431 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 819508 | 819508 | PRJNA816527_P_NODE_20501_length_241_cov_0.916667_g20451_i0 | PRJNA816527 | 20501 | 241 | 0.916667 | 2.20916747 | Sus scrofa | 9823 | Chordata | Chordata | 440 | 3.959999999999999e-119 | NTclustered | gi|371913089|dbj|AK392746.1| | 9823 | g20451 | i0 | 99.585 | 95.4190871369295 | 241 | 1 | 100 | 0 | 1 | 241 | 252 | 12 | Sus scrofa mRNA, clone: HTMT10097H06, expressed in hypothalamus | blastn | 22996 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 3370294 | 3370294 | PRJNA816527_P_NODE_18543_length_247_cov_0.885057_g18493_i0 | PRJNA816527 | 18543 | 247 | 0.885057 | 2.18609079 | Mus musculus | 10090 | Chordata | Chordata | 457 | 4.05e-124 | NTclustered | gi|53378864|gb|AC134601.4| | 10090 | g18493 | i0 | 100 | 68.6761133603239 | 247 | 0 | 100 | 0 | 1 | 247 | 102704 | 102458 | Mus musculus BAC clone RP23-242M10 from 12, complete sequence | blastn | 16963 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 3370360 | 3370360 | PRJNA816527_P_NODE_20663_length_241_cov_0.916667_g20613_i0 | PRJNA816527 | 20663 | 241 | 0.916667 | 2.20916747 | Sus scrofa | 9823 | Chordata | Chordata | 429 | 8.58e-116 | NTclustered | gi|1191816966|ref|XM_021065444.1| | 9823 | g20613 | i0 | 98.755 | 3 | 241 | 3 | 100 | 0 | 1 | 241 | 627 | 387 | PREDICTED: Sus scrofa spindle and kinetochore associated complex subunit 3 (SKA3), transcript variant X1, mRNA | blastn | 723 | 429 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 4647678 | 4647678 | PRJNA816527_P_NODE_13264_length_288_cov_1.423256_g13214_i0 | PRJNA816527 | 13264 | 288 | 1.423256 | 4.09897728 | Mus musculus | 10090 | Chordata | Chordata | 532 | 7.8e-147 | NTclustered | gi|74146689|dbj|AK169739.1| | 10090 | g13214 | i0 | 100 | 4.6875 | 288 | 0 | 100 | 0 | 1 | 288 | 3049 | 2762 | Mus musculus 2 days neonate thymus thymic cells cDNA, RIKEN full-length enriched library, clone:E430016D15 product:hypothetical protein, full insert sequence | blastn | 1350 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 4647715 | 4647715 | PRJNA816527_P_NODE_14724_length_273_cov_1.525000_g14674_i0 | PRJNA816527 | 14724 | 273 | 1.525 | 4.16325 | Mus musculus | 10090 | Chordata | Chordata | 505 | 1.6e-138 | NTclustered | gi|66268044|gb|AC149085.6| | 10090 | g14674 | i0 | 100 | 23.0769230769231 | 273 | 0 | 100 | 0 | 1 | 273 | 172185 | 171913 | Mus musculus BAC clone RP23-191I16 from chromosome 7, complete sequence | blastn | 6300 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 8472393 | 8472393 | PRJNA816527_P_NODE_18907_length_246_cov_0.890173_g18857_i0 | PRJNA816527 | 18907 | 246 | 0.890173 | 2.18982558 | Dama dama | 30532 | Chordata | Chordata | 364 | 2.509999999999999e-96 | NTclustered | gi|2625313545|ref|XM_061119993.1| | 30532 | g18857 | i0 | 93.469 | 585.467479674797 | 245 | 16 | 99 | 0 | 1 | 245 | 1801 | 2045 | PREDICTED: Dama dama uncharacterized LOC133040257 (LOC133040257), mRNA | blastn | 144025 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Dama | Dama dama | |
| 9747476 | 9747476 | PRJNA816527_P_NODE_17508_length_249_cov_0.875000_g17458_i0 | PRJNA816527 | 17508 | 249 | 0.875 | 2.17875 | Sus scrofa | 9823 | Chordata | Chordata | 460 | 3.16e-125 | NTclustered | gi|1191809130|ref|XM_001926818.5| | 9823 | g17458 | i0 | 100 | 104.240963855422 | 249 | 0 | 100 | 0 | 1 | 249 | 2986 | 2738 | PREDICTED: Sus scrofa L-2-hydroxyglutarate dehydrogenase (L2HGDH), transcript variant X1, mRNA | blastn | 25956 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 12298474 | 12298474 | PRJNA816527_P_NODE_12330_length_299_cov_3.088496_g12280_i0 | PRJNA816527 | 12330 | 299 | 3.088496 | 9.23460304 | Mus musculus | 10090 | Chordata | Chordata | 278 | 4.21e-70 | NTclustered | gi|28376830|gb|AC123851.4| | 10090 | g12280 | i0 | 100 | 2.29765886287625 | 150 | 0 | 100 | 0 | 150 | 299 | 43038 | 42889 | Mus musculus BAC clone RP23-323K4 from chromosome 16, complete sequence | blastn | 687 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 16121957 | 16121957 | PRJNA816527_P_NODE_14733_length_273_cov_1.460000_g14683_i0 | PRJNA816527 | 14733 | 273 | 1.46 | 3.9858 | Bos taurus | 9913 | Chordata | Chordata | 95.3 | 4.11e-15 | NTclustered | gi|2587629958|ref|XM_059892232.1| | 9913 | g14683 | i0 | 95 | 22.3846153846154 | 60 | 3 | 22 | 0 | 1 | 60 | 8837 | 8896 | PREDICTED: Bos taurus uncharacterized protein (LOC132346751), mRNA | blastn | 6111 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 18670669 | 18670669 | PRJNA816527_P_NODE_13475_length_286_cov_1.145540_g13425_i0 | PRJNA816527 | 13475 | 286 | 1.14554 | 3.2762444 | Mus musculus | 10090 | Chordata | Chordata | 512 | 1.01e-140 | NTclustered | gi|28201754|gb|AC127290.3| | 10090 | g13425 | i0 | 98.955 | 2.00699300699301 | 287 | 2 | 100 | 1 | 1 | 286 | 176507 | 176221 | Mus musculus BAC clone RP23-364F13 from chromosome 5, complete sequence | blastn | 574 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 21221553 | 21221553 | PRJNA816527_P_NODE_20137_length_242_cov_0.911243_g20087_i0 | PRJNA816527 | 20137 | 242 | 0.911243 | 2.20520806 | Mus musculus | 10090 | Chordata | Chordata | 436 | 5.1499999999999985e-118 | NTclustered | gi|24158582|gb|AC121571.4| | 10090 | g20087 | i0 | 99.174 | 1 | 242 | 2 | 100 | 0 | 1 | 242 | 107388 | 107629 | Mus musculus BAC clone RP23-231J6 from 3, complete sequence | blastn | 242 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 23771785 | 23771785 | PRJNA816527_P_NODE_15299_length_267_cov_1.386598_g15249_i0 | PRJNA816527 | 15299 | 267 | 1.386598 | 3.70221666 | Mus musculus | 10090 | Chordata | Chordata | 257 | 4.82e-64 | NTclustered | gi|354783987|gb|JN948488.1| | 10090 | g15249 | i0 | 100 | 2.62546816479401 | 139 | 0 | 52 | 0 | 129 | 267 | 29805 | 29943 | Mus musculus targeted non-conditional, lacZ-tagged mutant allele Ddx21:tm1e(EUCOMM)Wtsi; transgenic | blastn | 701 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus |
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);;