contig_metadata
9 rows where bioproject = "PRJNA1195374", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2317842 | 2317842 | PRJNA1195374_P_NODE_12382_length_636_cov_1.651865_g12047_i0 | PRJNA1195374 | 12382 | 636 | 1.651865 | 10.5058614 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g12047 | i0 | 99.843 | 70.4795597484277 | 636 | 1 | 100 | 0 | 1 | 636 | 8637 | 9272 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 44825 | 1170 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2318202 | 2318202 | PRJNA1195374_P_NODE_562_length_1849_cov_25.340653_g475_i0 | PRJNA1195374 | 562 | 1849 | 25.340653 | 468.54867397 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3356 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g475 | i0 | 99.459 | 82.7003785830179 | 1847 | 10 | 99 | 0 | 3 | 1849 | 8371 | 6525 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 152913 | 3373 | 0.994959976282241 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6145749 | 6145749 | PRJNA1195374_P_NODE_685_length_1750_cov_67.106738_g592_i0 | PRJNA1195374 | 685 | 1750 | 67.106738000000007 | 1174.367915 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3205 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g592 | i0 | 99.714 | 76.0194285714286 | 1750 | 5 | 100 | 0 | 1 | 1750 | 1812 | 63 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 133034 | 3210 | 0.998442367601246 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7420645 | 7420645 | PRJNA1195374_P_NODE_46_length_4459_cov_34.137255_g25_i0 | PRJNA1195374 | 46 | 4459 | 34.137255 | 1522.18020045 | Orthorubulavirus | 2560195 | Viruses | Viruses | 8172 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g25 | i0 | 99.753 | 78.94797039695 | 4458 | 11 | 99 | 0 | 1 | 4458 | 1795 | 6252 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 352029 | 8189 | 0.997924044449872 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8695820 | 8695820 | PRJNA1195374_P_NODE_5867_length_873_cov_1.673750_g5593_i0 | PRJNA1195374 | 5867 | 873 | 1.67375 | 14.6118375 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1596 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g5593 | i0 | 99.656 | 68.3367697594502 | 873 | 3 | 100 | 0 | 1 | 873 | 12420 | 13292 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 59658 | 1596 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13075727 | 13075727 | PRJNA1195374_P_NODE_68291_length_257_cov_10.983696_g67947_i0 | PRJNA1195374 | 68291 | 257 | 10.983696 | 28.22809872 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 466 | 7.05e-127 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g67947 | i0 | 99.608 | 68.9805447470817 | 255 | 1 | 99 | 0 | 3 | 257 | 6489 | 6235 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 17728 | 466 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18893968 | 18893968 | PRJNA1195374_P_NODE_14495_length_592_cov_1.870906_g14156_i0 | PRJNA1195374 | 14495 | 592 | 1.870906 | 11.07576352 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1077 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14156 | i0 | 99.493 | 69.3817567567568 | 592 | 3 | 100 | 0 | 1 | 592 | 10549 | 9958 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 41074 | 1083 | 0.994459833795014 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21444450 | 21444450 | PRJNA1195374_P_NODE_14617_length_590_cov_1.189555_g14278_i0 | PRJNA1195374 | 14617 | 590 | 1.189555 | 7.0183745 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14278 | i0 | 99.661 | 70.1389830508475 | 590 | 2 | 100 | 0 | 1 | 590 | 11268 | 10679 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 41382 | 1085 | 0.994470046082949 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21444949 | 21444949 | PRJNA1195374_P_NODE_897_length_1641_cov_3.095663_g796_i0 | PRJNA1195374 | 897 | 1641 | 3.095663 | 50.79982983 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3003 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g796 | i0 | 99.695 | 67.1602681291895 | 1641 | 5 | 100 | 0 | 1 | 1641 | 13575 | 15215 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 110210 | 3003 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;