contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1221567 | 1221567 | PRJNA800090_S_NODE_27441_length_244_cov_1.645714_g27329_i0 | PRJNA800090 | 27441 | 244 | 1.645714 | 4.01554216 | Orthorubulavirus | 2560195 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g27329 | i0 | 100 | 67.9672131147541 | 244 | 0 | 100 | 0 | 1 | 244 | 12888 | 13131 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16584 | 451 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3772551 | 3772551 | PRJNA800090_P_NODE_26883_length_752_cov_4.393851_g24869_i0 | PRJNA800090 | 26883 | 752 | 4.393851 | 33.04175952 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1389 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g24869 | i0 | 100 | 69.2433510638298 | 752 | 0 | 100 | 0 | 1 | 752 | 12742 | 11991 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 52071 | 1389 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3772917 | 3772917 | PRJNA800090_P_NODE_7303_length_1472_cov_2.867427_g6403_i0 | PRJNA800090 | 7303 | 1472 | 2.867427 | 42.20852544 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2682 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g6403 | i0 | 99.525 | 70.7445652173913 | 1474 | 5 | 100 | 1 | 1 | 1472 | 10003 | 8530 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 104136 | 2682 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 4625911 | 4625911 | PRJNA800090_P_NODE_150724_length_255_cov_2.053763_g148539_i0 | PRJNA800090 | 150724 | 255 | 2.053763 | 5.23709565 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|1919524639|gb|MT160087.1| | 2905673 | g148539 | i0 | 100 | 68.8588235294118 | 255 | 0 | 100 | 0 | 1 | 255 | 13976 | 14230 | Parainfluenza virus 5 strain L, complete genome | blastn | 17559 | 472 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6325697 | 6325697 | PRJNA800090_S_NODE_5_length_4464_cov_9.785210_g2_i0 | PRJNA800090 | 5 | 4464 | 9.78521 | 436.8117744 | Orthorubulavirus | 2560195 | Viruses | Viruses | 8189 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2 | i0 | 99.776 | 78.9240591397849 | 4464 | 10 | 100 | 0 | 1 | 4464 | 1770 | 6233 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 352317 | 8205 | 0.998049969530774 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8874423 | 8874423 | PRJNA800090_P_NODE_7_length_8367_cov_78.862859_g5_i0 | PRJNA800090 | 7 | 8367 | 78.862859 | 6598.45541253 | Orthorubulavirus | 2560195 | Viruses | Viruses | 15311 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g5 | i0 | 99.701 | 72.6171865662723 | 8366 | 25 | 99 | 0 | 1 | 8366 | 8 | 8373 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 607588 | 15361 | 0.996745003580496 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8874656 | 8874656 | PRJNA800090_S_NODE_17607_length_292_cov_1.452915_g17495_i0 | PRJNA800090 | 17607 | 292 | 1.452915 | 4.2425118 | Orthorubulavirus | 2560195 | Viruses | Viruses | 540 | 4.74e-149 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g17495 | i0 | 100 | 69.9897260273973 | 292 | 0 | 100 | 0 | 1 | 292 | 12409 | 12118 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20437 | 540 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10150237 | 10150237 | PRJNA800090_S_NODE_88_length_2218_cov_9.517450_g83_i0 | PRJNA800090 | 88 | 2218 | 9.51745 | 211.097041 | Orthorubulavirus | 2560195 | Viruses | Viruses | 4026 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g83 | i0 | 99.637 | 79.9152389540126 | 2204 | 8 | 99 | 0 | 15 | 2218 | 8392 | 6189 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 177252 | 4043 | 0.995795201582983 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11424803 | 11424803 | PRJNA800090_P_NODE_45929_length_534_cov_4.088172_g43756_i0 | PRJNA800090 | 45929 | 534 | 4.088172 | 21.83083848 | Orthorubulavirus | 2560195 | Viruses | Viruses | 987 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g43756 | i0 | 100 | 67.9269662921348 | 534 | 0 | 100 | 0 | 1 | 534 | 14205 | 14738 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 36273 | 987 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15249788 | 15249788 | PRJNA800090_S_NODE_35252_length_226_cov_1.146497_g35140_i0 | PRJNA800090 | 35252 | 226 | 1.146497 | 2.59108322 | Orthorubulavirus | 2560195 | Viruses | Viruses | 418 | 1.7199999999999998e-112 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g35140 | i0 | 100 | 68.9601769911504 | 226 | 0 | 100 | 0 | 1 | 226 | 9429 | 9204 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 15585 | 418 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16523429 | 16523429 | PRJNA800090_P_NODE_178153_length_233_cov_3.280488_g175968_i0 | PRJNA800090 | 178153 | 233 | 3.280488 | 7.64353704 | Orthorubulavirus | 2560195 | Viruses | Viruses | 425 | 1.07e-114 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g175968 | i0 | 99.571 | 63.9785407725322 | 233 | 1 | 100 | 0 | 1 | 233 | 14878 | 15110 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 14907 | 425 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 20347812 | 20347812 | PRJNA800090_S_NODE_11376_length_350_cov_1.281139_g11264_i0 | PRJNA800090 | 11376 | 350 | 1.281139 | 4.4839865 | Orthorubulavirus | 2560195 | Viruses | Viruses | 630 | 3.3399999999999984e-176 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g11264 | i0 | 99.424 | 66.8885714285714 | 347 | 2 | 99 | 0 | 4 | 350 | 14730 | 14384 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 23411 | 630 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22898374 | 22898374 | PRJNA800090_P_NODE_20578_length_880_cov_3.207152_g18780_i0 | PRJNA800090 | 20578 | 880 | 3.207152 | 28.2229376 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1602 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g18780 | i0 | 99.545 | 67.9136363636364 | 879 | 4 | 99 | 0 | 1 | 879 | 13727 | 12849 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 59764 | 1607 | 0.996888612321095 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22899153 | 22899153 | PRJNA800090_S_NODE_218_length_1779_cov_27.550877_g205_i0 | PRJNA800090 | 218 | 1779 | 27.550877 | 490.13010183 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3229 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g205 | i0 | 99.493 | 75.4007869589657 | 1775 | 9 | 99 | 0 | 1 | 1775 | 12 | 1786 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 134138 | 3245 | 0.995069337442219 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24173130 | 24173130 | PRJNA800090_S_NODE_16559_length_299_cov_1.521739_g16447_i0 | PRJNA800090 | 16559 | 299 | 1.521739 | 4.54999961 | Orthorubulavirus | 2560195 | Viruses | Viruses | 553 | 6.25e-153 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g16447 | i0 | 100 | 70.4782608695652 | 299 | 0 | 100 | 0 | 1 | 299 | 8775 | 9073 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 21073 | 553 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25447772 | 25447772 | PRJNA800090_P_NODE_6540_length_1539_cov_2.970068_g5727_i0 | PRJNA800090 | 6540 | 1539 | 2.970068 | 45.70934652 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2811 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g5727 | i0 | 99.611 | 69.6712150747238 | 1542 | 3 | 100 | 2 | 1 | 1539 | 11970 | 10429 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 107224 | 2822 | 0.996102055279943 | 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);;