contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA206070" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 366355 | 366355 | PRJNA206070_S_NODE_22841_length_185_cov_2.898649_g20965_i0 | PRJNA206070 | 22841 | 185 | 2.898649 | 5.36250065 | Hyla sarda | 327740 | Chordata | Chordata | 52.8 | 0.016 | NTclustered | gi|2512160518|ref|XM_056558461.1| | 327740 | g20965 | i0 | 100 | 2.87567567567568 | 28 | 0 | 15 | 0 | 1 | 28 | 3951 | 3978 | PREDICTED: Hyla sarda MAX network transcriptional repressor (MNT), transcript variant X2, mRNA | blastn | 532 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Hyla | Hyla sarda | |
| 366566 | 366566 | PRJNA206070_S_NODE_4821_length_775_cov_2.415989_g3083_i0 | PRJNA206070 | 4821 | 775 | 2.415989 | 18.72391475 | Canis lupus | 9612 | Chordata | Chordata | 1101 | 0 | NTclustered | gi|190576522|gb|AC186968.15| | 9615 | g3083 | i0 | 92.387 | 49.0245161290323 | 775 | 55 | 100 | 3 | 3 | 775 | 66446 | 65674 | Canis familiaris chromosome 3, clone XX-219I19, complete sequence | blastn | 37994 | 1101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 1640826 | 1640826 | PRJNA206070_S_NODE_10222_length_375_cov_2.150888_g8347_i0 | PRJNA206070 | 10222 | 375 | 2.150888 | 8.06583 | Balaenoptera acutorostrata | 9767 | Chordata | Chordata | 58.4 | 7.67e-4 | NTclustered | gi|2526559425|ref|XR_452228.3| | 9767 | g8347 | i0 | 100 | 0.0826666666666667 | 31 | 0 | 8 | 0 | 48 | 78 | 2770 | 2740 | PREDICTED: Balaenoptera acutorostrata uncharacterized LOC103019002 (LOC103019002), ncRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera acutorostrata | |
| 4193559 | 4193559 | PRJNA206070_S_NODE_27944_length_161_cov_1.032258_g26068_i0 | PRJNA206070 | 27944 | 161 | 1.032258 | 1.66193538 | Balaenoptera acutorostrata | 9767 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|2526559425|ref|XR_452228.3| | 9767 | g26068 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 63 | 91 | 2770 | 2742 | PREDICTED: Balaenoptera acutorostrata uncharacterized LOC103019002 (LOC103019002), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera acutorostrata | |
| 6158290 | 6158290 | PRJNA206070_S_NODE_14125_length_280_cov_2.510288_g12249_i0 | PRJNA206070 | 14125 | 280 | 2.510288 | 7.0288064 | Canis | 9611 | Chordata | Chordata | 507 | 4.58e-139 | NTclustered | gi|2671958728|tpg|BK065026.1| | 9615 | g12249 | i0 | 99.286 | 550.775 | 280 | 2 | 100 | 0 | 1 | 280 | 215539 | 215818 | TPA: Canis lupus familiaris breed boxer TRA/TRD locus, complete sequence | blastn | 154217 | 512 | 0.990234375 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 11844716 | 11844716 | PRJNA206070_S_NODE_14470_length_274_cov_1.308017_g12594_i0 | PRJNA206070 | 14470 | 274 | 1.308017 | 3.58396658 | Canis lupus | 9612 | Chordata | Chordata | 451 | 2.12e-122 | NTclustered | gi|124001724|gb|AC186959.6| | 9615 | g12594 | i0 | 96.35 | 278.770072992701 | 274 | 10 | 100 | 0 | 1 | 274 | 98104 | 97831 | Canis Familiaris chromosome 9, clone XX-196G23, complete sequence | blastn | 76383 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 11844971 | 11844971 | PRJNA206070_S_NODE_24150_length_178_cov_0.921986_g22274_i0 | PRJNA206070 | 24150 | 178 | 0.921986 | 1.64113508 | Canis lupus | 9612 | Chordata | Chordata | 318 | 1.34e-82 | NTclustered | gi|45504247|gb|AC147784.3| | 9615 | g22274 | i0 | 98.883 | 206.938202247191 | 179 | 1 | 100 | 1 | 1 | 178 | 85048 | 84870 | Canis Familiaris, clone XX-25F3, complete sequence | blastn | 36835 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 11844995 | 11844995 | PRJNA206070_S_NODE_25350_length_171_cov_7.470149_g23474_i0 | PRJNA206070 | 25350 | 171 | 7.470149 | 12.77395479 | Polypterus senegalus | 55291 | Chordata | Chordata | 202 | 1.34e-47 | NTclustered | gi|1993956580|ref|XM_039752052.1| | 55291 | g23474 | i0 | 91.216 | 15.9707602339181 | 148 | 13 | 87 | 0 | 24 | 171 | 2674 | 2527 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120528061), transcript variant X1, mRNA | blastn | 2731 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 13119942 | 13119942 | PRJNA206070_S_NODE_13631_length_289_cov_19834.595238_g11755_i0 | PRJNA206070 | 13631 | 289 | 19834.595238 | 57321.98023782 | Saccopteryx leptura | 249018 | Chordata | Chordata | 344 | 3.94e-90 | NTclustered | gi|2756186286|ref|XR_010750705.1| | 249018 | g11755 | i0 | 92.063 | 84.159169550173 | 252 | 9 | 86 | 9 | 37 | 284 | 1242 | 998 | PREDICTED: Saccopteryx leptura 28S ribosomal RNA (LOC136401697), rRNA | blastn | 24322 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Emballonuridae | Saccopteryx | Saccopteryx leptura | |
| 15669017 | 15669017 | PRJNA206070_S_NODE_15993_length_250_cov_8.868545_g14117_i0 | PRJNA206070 | 15993 | 250 | 8.868545 | 22.1713625 | Polypterus senegalus | 55291 | Chordata | Chordata | 195 | 3.55e-45 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g14117 | i0 | 89.677 | 6.984 | 155 | 13 | 61 | 3 | 1 | 153 | 1326 | 1173 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 1746 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 15669033 | 15669033 | PRJNA206070_S_NODE_16613_length_242_cov_1.848780_g14737_i0 | PRJNA206070 | 16613 | 242 | 1.84878 | 4.4740476 | Canis lupus | 9612 | Chordata | Chordata | 442 | 1.1099999999999995e-119 | NTclustered | gi|111378431|gb|AC187025.7| | 9615 | g14737 | i0 | 99.587 | 288.888429752066 | 242 | 1 | 100 | 0 | 1 | 242 | 146550 | 146309 | Canis Familiaris chromosome 31, clone XX-251H2, complete sequence | blastn | 69911 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 17633206 | 17633206 | PRJNA206070_S_NODE_15174_length_262_cov_3.937778_g13298_i0 | PRJNA206070 | 15174 | 262 | 3.937778 | 10.31697836 | Lampetra | 13103 | Chordata | Chordata | 54.7 | 0.007 | NTclustered | gi|2805717555|emb|OZ078437.1| | 7748 | g13298 | i0 | 96.875 | 0.366412213740458 | 32 | 1 | 12 | 0 | 11 | 42 | 5750083 | 5750052 | Lampetra fluviatilis genome assembly, chromosome: 34 | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 20767991 | 20767991 | PRJNA206070_S_NODE_27217_length_163_cov_2.801587_g25341_i0 | PRJNA206070 | 27217 | 163 | 2.801587 | 4.56658681 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 52.8 | 0.014 | NTclustered | gi|1910340942|ref|XM_016124325.2| | 9407 | g25341 | i0 | 100 | 0.687116564417178 | 28 | 0 | 17 | 0 | 19 | 46 | 4955 | 4928 | PREDICTED: Rousettus aegyptiacus nebulette (LOC107499789), transcript variant X3, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 24592869 | 24592869 | PRJNA206070_S_NODE_6520_length_567_cov_7.373585_g4672_i0 | PRJNA206070 | 6520 | 567 | 7.373585 | 41.80822695 | Gallus gallus | 9031 | Chordata | Chordata | 1048 | 0 | NTclustered | gi|2201755425|ref|XR_006936394.1| | 9031 | g4672 | i0 | 100 | 61.4109347442681 | 567 | 0 | 100 | 0 | 1 | 567 | 1237 | 671 | PREDICTED: Gallus gallus 28S ribosomal RNA (LOC121106977), rRNA | blastn | 34820 | 1048 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus |
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);;