contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 402275 | 402275 | PRJNA380660_P_NODE_6761_length_285_cov_2.640625_g6361_i0 | PRJNA380660 | 6761 | 285 | 2.640625 | 7.52578125 | Erythrolamprus reginae | 121349 | Chordata | Chordata | 75 | 5.62e-9 | NTclustered | gi|2876190807|ref|XM_070733000.1| | 121349 | g6361 | i0 | 89.655 | 0.684210526315789 | 58 | 6 | 20 | 0 | 105 | 162 | 348 | 291 | PREDICTED: Erythrolamprus reginae protein disulfide isomerase family A member 6 (PDIA6), mRNA | blastn | 195 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dipsadidae | Erythrolamprus | Erythrolamprus reginae | |
| 402282 | 402282 | PRJNA380660_P_NODE_8621_length_233_cov_2.205882_g8221_i0 | PRJNA380660 | 8621 | 233 | 2.205882 | 5.13970506 | Serinus canaria | 9135 | Chordata | Chordata | 62.1 | 3.46e-5 | NTclustered | gi|2312754485|ref|XM_009093859.4| | 9135 | g8221 | i0 | 100 | 1.89270386266094 | 33 | 0 | 14 | 0 | 190 | 222 | 232 | 200 | PREDICTED: Serinus canaria protein disulfide isomerase family A member 4 (PDIA4), mRNA | blastn | 441 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Serinus | Serinus canaria | |
| 2952896 | 2952896 | PRJNA380660_P_NODE_3803_length_419_cov_2.169231_g3412_i0 | PRJNA380660 | 3803 | 419 | 2.169231 | 9.08907789 | Styela clava | 7725 | Chordata | Chordata | 73.1 | 3.1e-8 | NTclustered | gi|1981807334|ref|XM_039415743.1| | 7725 | g3412 | i0 | 97.619 | 2.96897374701671 | 42 | 1 | 10 | 0 | 342 | 383 | 385 | 426 | PREDICTED: Styela clava elongation factor-like GTPase 1 (LOC120346092), mRNA | blastn | 1244 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 5505901 | 5505901 | PRJNA380660_P_NODE_12885_length_151_cov_2.065574_g12485_i0 | PRJNA380660 | 12885 | 151 | 2.065574 | 3.11901674 | Mus musculus | 10090 | Chordata | Chordata | 274 | 2.42e-69 | NTclustered | gi|1907197542|ref|XM_011242739.3| | 10090 | g12485 | i0 | 99.338 | 12.0132450331126 | 151 | 1 | 100 | 0 | 1 | 151 | 3422 | 3272 | PREDICTED: Mus musculus ariadne RBR E3 ubiquitin protein ligase 1 (Arih1), transcript variant X2, mRNA | blastn | 1814 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 6177157 | 6177157 | PRJNA380660_P_NODE_11145_length_187_cov_1.278481_g10745_i0 | PRJNA380660 | 11145 | 187 | 1.278481 | 2.39075947 | Corvus | 30420 | Chordata | Chordata | 56.5 | 0.001 | NTclustered | gi|2240515910|ref|XM_048300726.1| | 134902 | g10745 | i0 | 96.97 | 0.352941176470588 | 33 | 1 | 18 | 0 | 2 | 34 | 1435 | 1467 | PREDICTED: Corvus hawaiiensis uncharacterized LOC125324627 (LOC125324627), mRNA | blastn | 66 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Corvidae | Corvus | Corvus hawaiiensis | |
| 6177182 | 6177182 | PRJNA380660_P_NODE_9485_length_216_cov_2.459893_g9085_i0 | PRJNA380660 | 9485 | 216 | 2.459893 | 5.31336888 | Metazoa | 33208 | Chordata | Chordata | 52.8 | 0.019 | NTclustered | gi|2853569888|ref|XM_069898128.1| | 1343680 | g9085 | i0 | 100 | 0.259259259259259 | 28 | 0 | 13 | 0 | 47 | 74 | 3376 | 3349 | PREDICTED: Narcine bancroftii RNA binding motif protein 27 (rbm27), transcript variant X3, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Torpediniformes | Narcinidae | Narcine | Narcine bancroftii | |
| 8055515 | 8055515 | PRJNA380660_P_NODE_5647_length_326_cov_2.545455_g5248_i0 | PRJNA380660 | 5647 | 326 | 2.545455 | 8.2981833 | Mus musculus | 10090 | Chordata | Chordata | 549 | 8.909999999999997e-152 | NTclustered | gi|74178163|dbj|AK150806.1| | 10090 | g5248 | i0 | 100 | 89.9079754601227 | 297 | 0 | 91 | 0 | 26 | 322 | 112 | 408 | Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830015J16 product:mitochondrial ribosomal protein L52, full insert sequence | blastn | 29310 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 9330311 | 9330311 | PRJNA380660_P_NODE_11948_length_170_cov_1.716312_g11548_i0 | PRJNA380660 | 11948 | 170 | 1.716312 | 2.9177304 | Trichosurus vulpecula | 9337 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|1919058789|ref|XM_036736415.1| | 9337 | g11548 | i0 | 100 | 1.84117647058824 | 29 | 0 | 17 | 0 | 126 | 154 | 971 | 999 | PREDICTED: Trichosurus vulpecula perilipin 1 (PLIN1), mRNA | blastn | 313 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Phalangeridae | Trichosurus | Trichosurus vulpecula | |
| 9330326 | 9330326 | PRJNA380660_P_NODE_4448_length_383_cov_1.646893_g4051_i0 | PRJNA380660 | 4448 | 383 | 1.646893 | 6.30760019 | Ovis canadensis | 37174 | Chordata | Chordata | 54.7 | 0.01 | NTclustered | gi|2841411603|ref|XR_011258666.1| | 37174 | g4051 | i0 | 100 | 0.368146214099217 | 29 | 0 | 8 | 0 | 48 | 76 | 3655 | 3683 | PREDICTED: Ovis canadensis large tumor suppressor kinase 1 (LATS1), transcript variant X2, misc_RNA | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis canadensis | |
| 9330334 | 9330334 | PRJNA380660_P_NODE_6948_length_279_cov_2.008000_g6548_i0 | PRJNA380660 | 6948 | 279 | 2.008 | 5.60232 | Mus musculus | 10090 | Chordata | Chordata | 496 | 9.88e-136 | NTclustered | gi|42517182|gb|AC113540.12| | 10090 | g6548 | i0 | 100 | 0.960573476702509 | 268 | 0 | 96 | 0 | 1 | 268 | 182281 | 182014 | Mus musculus chromosome 17, clone RP23-158F13, complete sequence | blastn | 268 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 14431000 | 14431000 | PRJNA380660_P_NODE_8072_length_246_cov_2.161290_g7672_i0 | PRJNA380660 | 8072 | 246 | 2.16129 | 5.3167734 | Mus musculus | 10090 | Chordata | Chordata | 455 | 1.4500000000000002e-123 | NTclustered | gi|52694076|gb|AC120870.8| | 10090 | g7672 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 176935 | 177180 | Mus musculus chromosome 1, clone RP23-15D1, complete sequence | blastn | 246 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 18253876 | 18253876 | PRJNA380660_P_NODE_12955_length_150_cov_1.760331_g12555_i0 | PRJNA380660 | 12955 | 150 | 1.760331 | 2.6404965 | Mus musculus | 10090 | Chordata | Chordata | 278 | 1.85e-70 | NTclustered | gi|58531605|gb|AC132226.3| | 10090 | g12555 | i0 | 100 | 114.32 | 150 | 0 | 100 | 0 | 1 | 150 | 45737 | 45588 | Mus musculus BAC clone RP24-571A14 from 1, complete sequence | blastn | 17148 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 20803738 | 20803738 | PRJNA380660_P_NODE_7577_length_260_cov_2.316017_g7177_i0 | PRJNA380660 | 7577 | 260 | 2.316017 | 6.0216442 | Mus musculus | 10090 | Chordata | Chordata | 470 | 5.519999999999998e-128 | NTclustered | gi|84039715|gb|AC154560.3| | 10090 | g7177 | i0 | 99.231 | 1 | 260 | 2 | 100 | 0 | 1 | 260 | 158067 | 157808 | Mus musculus BAC clone RP23-400E20 from chromosome 17, complete sequence | blastn | 260 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 20803740 | 20803740 | PRJNA380660_P_NODE_7697_length_256_cov_2.903084_g7297_i0 | PRJNA380660 | 7697 | 256 | 2.903084 | 7.43189504 | Mus musculus | 10090 | Chordata | Chordata | 457 | 4.22e-124 | NTclustered | gi|49615286|gb|AC091309.13| | 10090 | g7297 | i0 | 100 | 0.96484375 | 247 | 0 | 96 | 0 | 1 | 247 | 97268 | 97022 | Mus musculus chromosome 17, clone RP23-127L4, complete sequence | blastn | 247 | 457 | 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);;