contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA675638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1924623 | 1924623 | PRJNA675638_P_NODE_15262_length_184_cov_1.007407_g15065_i0 | PRJNA675638 | 15262 | 184 | 1.007407 | 1.85362888 | Fringilla coelebs | 37598 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|2917613052|emb|OZ228692.1| | 37598 | g15065 | i0 | 100 | 0.315217391304348 | 29 | 0 | 16 | 0 | 90 | 118 | 69805682 | 69805654 | Fringilla coelebs genome assembly, chromosome: 5 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Fringilla | Fringilla coelebs | |
| 3199495 | 3199495 | PRJNA675638_S_NODE_6803_length_175_cov_1.214286_g6741_i0 | PRJNA675638 | 6803 | 175 | 1.214286 | 2.1250005 | Crotalus tigris | 88082 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|1974302038|ref|XR_005554669.1| | 88082 | g6741 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 1 | 28 | 6886 | 6859 | PREDICTED: Crotalus tigris ligand dependent nuclear receptor corepressor like (LCORL), transcript variant X3, misc_RNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus tigris | |
| 3720649 | 3720649 | PRJNA675638_P_NODE_15963_length_180_cov_0.908397_g15766_i0 | PRJNA675638 | 15963 | 180 | 0.908397 | 1.6351146 | Lampetra | 13103 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|2815006793|emb|OZ078596.2| | 7748 | g15766 | i0 | 96.875 | 3.86111111111111 | 32 | 1 | 18 | 0 | 149 | 180 | 8892445 | 8892414 | Lampetra fluviatilis genome assembly, chromosome: 28 | blastn | 695 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 4476572 | 4476572 | PRJNA675638_S_NODE_9064_length_162_cov_0.902655_g9002_i0 | PRJNA675638 | 9064 | 162 | 0.902655 | 1.4623011 | Vulpes lagopus | 494514 | Chordata | Chordata | 250 | 4.45e-62 | NTclustered | gi|2044212914|ref|XR_005985650.1| | 494514 | g9002 | i0 | 94.512 | 2.02469135802469 | 164 | 6 | 100 | 2 | 1 | 162 | 21507 | 21669 | PREDICTED: Vulpes lagopus uncharacterized LOC121482884 (LOC121482884), transcript variant X1, ncRNA | blastn | 328 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Vulpes | Vulpes lagopus | |
| 5752163 | 5752163 | PRJNA675638_S_NODE_1825_length_324_cov_0.894545_g1763_i0 | PRJNA675638 | 1825 | 324 | 0.894545 | 2.8983258 | Saccopteryx leptura | 249018 | Chordata | Chordata | 54.7 | 0.008 | NTclustered | gi|2756211817|ref|XM_066357328.1| | 249018 | g1763 | i0 | 100 | 0.0895061728395062 | 29 | 0 | 9 | 0 | 65 | 93 | 1200 | 1228 | PREDICTED: Saccopteryx leptura uncharacterized protein (LOC136386014), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Emballonuridae | Saccopteryx | Saccopteryx leptura | |
| 5752170 | 5752170 | PRJNA675638_S_NODE_5885_length_187_cov_0.847826_g5823_i0 | PRJNA675638 | 5885 | 187 | 0.847826 | 1.58543462 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 63.9 | 7.39e-6 | NTclustered | gi|2805719359|emb|OZ078470.1| | 7748 | g5823 | i0 | 100 | 149.181818181818 | 34 | 0 | 18 | 0 | 154 | 187 | 5226036 | 5226069 | Lampetra fluviatilis genome assembly, chromosome: 67 | blastn | 27897 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 9577137 | 9577137 | PRJNA675638_P_NODE_5948_length_280_cov_0.995671_g5751_i0 | PRJNA675638 | 5948 | 280 | 0.995671 | 2.7878788 | Saccopteryx leptura | 249018 | Chordata | Chordata | 54.7 | 0.007 | NTclustered | gi|2756211817|ref|XM_066357328.1| | 249018 | g5751 | i0 | 100 | 0.103571428571429 | 29 | 0 | 10 | 0 | 2 | 30 | 1200 | 1228 | PREDICTED: Saccopteryx leptura uncharacterized protein (LOC136386014), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Emballonuridae | Saccopteryx | Saccopteryx leptura | |
| 11372507 | 11372507 | PRJNA675638_P_NODE_13609_length_194_cov_1.055172_g13412_i0 | PRJNA675638 | 13609 | 194 | 1.055172 | 2.04703368 | Chordata | 7711 | Chordata | Chordata | 54.7 | 0.005 | NTclustered | gi|56608624|gb|AY840232.1| | 8384 | g13412 | i0 | 100 | 14.9484536082474 | 29 | 0 | 15 | 0 | 1 | 29 | 831 | 859 | Bufo bufo isolate Sumela2 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2900 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 13402615 | 13402615 | PRJNA675638_P_NODE_5111_length_299_cov_2.864000_g4914_i0 | PRJNA675638 | 5111 | 299 | 2.864 | 8.56336 | Polypterus senegalus | 55291 | Chordata | Chordata | 335 | 2.47e-87 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g4914 | i0 | 90.038 | 15.3110367892977 | 261 | 23 | 87 | 3 | 40 | 298 | 1173 | 1432 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 4578 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 14677642 | 14677642 | PRJNA675638_S_NODE_5292_length_196_cov_1.149660_g5230_i0 | PRJNA675638 | 5292 | 196 | 1.14966 | 2.2533336 | Apteryx mantelli | 2696672 | Chordata | Chordata | 54.7 | 0.005 | NTclustered | gi|840038716|emb|LK085257.1| | 202946 | g5230 | i0 | 100 | 0.147959183673469 | 29 | 0 | 15 | 0 | 84 | 112 | 228 | 256 | Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold20688 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apterygiformes | Apterygidae | Apteryx | Apteryx mantelli | |
| 15951238 | 15951238 | PRJNA675638_P_NODE_17133_length_173_cov_0.790323_g16936_i0 | PRJNA675638 | 17133 | 173 | 0.790323 | 1.36725879 | Fringilla coelebs | 37598 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|2917623610|emb|OZ228715.1| | 37598 | g16936 | i0 | 100 | 0.161849710982659 | 28 | 0 | 16 | 0 | 77 | 104 | 4379107 | 4379134 | Fringilla coelebs genome assembly, chromosome: 28 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Fringilla | Fringilla coelebs | |
| 17226567 | 17226567 | PRJNA675638_P_NODE_14714_length_187_cov_1.456522_g14517_i0 | PRJNA675638 | 14714 | 187 | 1.456522 | 2.72369614 | Spinus spinus | 160760 | Chordata | Chordata | 97.1 | 7.29e-16 | NTclustered | gi|2917656247|emb|OZ228746.1| | 160760 | g14517 | i0 | 85.567 | 2.20855614973262 | 97 | 9 | 49 | 5 | 41 | 132 | 2660462 | 2660558 | Spinus spinus genome assembly, chromosome: 29 | blastn | 413 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Spinus | Spinus spinus | |
| 22325845 | 22325845 | PRJNA675638_P_NODE_10878_length_214_cov_0.933333_g10681_i0 | PRJNA675638 | 10878 | 214 | 0.933333 | 1.99733262 | Spinus spinus | 160760 | Chordata | Chordata | 58.4 | 4.05e-4 | NTclustered | gi|2917633021|emb|OZ228725.1| | 160760 | g10681 | i0 | 100 | 1.53738317757009 | 31 | 0 | 16 | 0 | 14 | 44 | 381663 | 381633 | Spinus spinus genome assembly, chromosome: 8 | blastn | 329 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Spinus | Spinus spinus | |
| 23601349 | 23601349 | PRJNA675638_P_NODE_15599_length_182_cov_1.233083_g15402_i0 | PRJNA675638 | 15599 | 182 | 1.233083 | 2.24421106 | Cairina moschata | 8855 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|2921976028|gb|CP130398.1| | 8855 | g15402 | i0 | 100 | 0.153846153846154 | 28 | 0 | 15 | 0 | 152 | 179 | 9382051 | 9382078 | Cairina moschata breed yongchun chromosome 20 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cairina | Cairina moschata | |
| 23601385 | 23601385 | PRJNA675638_P_NODE_4579_length_315_cov_1.078947_g4382_i0 | PRJNA675638 | 4579 | 315 | 1.078947 | 3.39868305 | Hyaena hyaena | 95912 | Chordata | Chordata | 52.8 | 0.029 | NTclustered | gi|1965455095|ref|XM_039231209.1| | 95912 | g4382 | i0 | 100 | 0.0888888888888889 | 28 | 0 | 9 | 0 | 152 | 179 | 42 | 69 | PREDICTED: Hyaena hyaena cullin 7 (CUL7), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Hyaena | Hyaena hyaena | |
| 23601443 | 23601443 | PRJNA675638_S_NODE_9359_length_161_cov_0.875000_g9297_i0 | PRJNA675638 | 9359 | 161 | 0.875 | 1.40875 | Sus scrofa | 9823 | Chordata | Chordata | 137 | 3.59e-28 | NTclustered | gi|224419421|emb|CU468098.7| | 9823 | g9297 | i0 | 83.007 | 2.82608695652174 | 153 | 24 | 94 | 2 | 6 | 157 | 142851 | 142700 | Pig DNA sequence from clone CH242-187J16 on chromosome X, complete sequence | blastn | 455 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa |
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);;