contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA745923" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724611 | 724611 | PRJNA745923_S_NODE_18341_length_231_cov_1.276596_g18009_i0 | PRJNA745923 | 18341 | 231 | 1.276596 | 2.94893676 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 111 | 3.36e-20 | NTclustered | gi|2053084802|tpg|BK020171.1| | 2832643 | g18009 | i0 | 94.521 | 6.07792207792208 | 73 | 3 | 32 | 1 | 1 | 73 | 1271 | 1200 | MAG TPA_asm: Caudoviricetes sp. isolate ctkEe11, partial genome | blastn | 1404 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724708 | 724708 | PRJNA745923_S_NODE_24361_length_196_cov_1.980392_g24029_i0 | PRJNA745923 | 24361 | 196 | 1.980392 | 3.88156832 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 213 | 7.35e-51 | NTclustered | gi|2054791465|tpg|BK049930.1| | 2832643 | g24029 | i0 | 90.184 | 1.71938775510204 | 163 | 16 | 83 | 0 | 1 | 163 | 5296 | 5458 | MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome | blastn | 337 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724758 | 724758 | PRJNA745923_S_NODE_2741_length_908_cov_18.077457_g2495_i0 | PRJNA745923 | 2741 | 908 | 18.077457 | 164.14330956 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 785 | 0 | NTclustered | gi|2915029488|gb|OR222647.1| | 2832643 | g2495 | i0 | 82.697 | 30.9151982378855 | 890 | 149 | 97 | 2 | 24 | 908 | 79246 | 80135 | MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence | blastn | 28071 | 785 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724946 | 724946 | PRJNA745923_S_NODE_40021_length_150_cov_2.242991_g39689_i0 | PRJNA745923 | 40021 | 150 | 2.242991 | 3.3644865 | Pestivirus tauri | 3052626 | Viruses | Viruses | 267 | 4.009999999999999e-67 | NTclustered | gi|1540352871|gb|MH231127.1| | 54315 | g39689 | i0 | 98.667 | 99.7066666666667 | 150 | 2 | 100 | 0 | 1 | 150 | 2231 | 2380 | Bovine viral diarrhea virus 2 isolate 53637c polyprotein gene, complete cds | blastn | 14956 | 267 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus tauri | ||
| 2000784 | 2000784 | PRJNA745923_S_NODE_24482_length_195_cov_20.046053_g24150_i0 | PRJNA745923 | 24482 | 195 | 20.046053 | 39.08980335 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g24150 | i0 | 100 | 0.292307692307692 | 29 | 0 | 15 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 2001010 | 2001010 | PRJNA745923_S_NODE_4722_length_520_cov_4.532495_g4399_i0 | PRJNA745923 | 4722 | 520 | 4.532495 | 23.568974 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 628 | 1.8499999999999994e-175 | NTclustered | gi|2915029488|gb|OR222647.1| | 2832643 | g4399 | i0 | 89.655 | 3.79230769230769 | 493 | 51 | 95 | 0 | 1 | 493 | 72238 | 72730 | MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence | blastn | 1972 | 628 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4553228 | 4553228 | PRJNA745923_S_NODE_23284_length_201_cov_1.518987_g22952_i0 | PRJNA745923 | 23284 | 201 | 1.518987 | 3.05316387 | Pestivirus bovis | 3052619 | Viruses | Viruses | 342 | 9.259999999999999e-90 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g22952 | i0 | 97.5 | 99.4427860696517 | 200 | 5 | 99 | 0 | 1 | 200 | 3707 | 3508 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 19988 | 342 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 4553235 | 4553235 | PRJNA745923_S_NODE_23664_length_199_cov_2.378205_g23332_i0 | PRJNA745923 | 23664 | 199 | 2.378205 | 4.73262795 | Pestivirus bovis | 3052619 | Viruses | Viruses | 296 | 7.23e-76 | NTclustered | gi|49614511|dbj|AB105677.1| | 11099 | g23332 | i0 | 93.467 | 61.2361809045226 | 199 | 13 | 100 | 0 | 1 | 199 | 149 | 347 | Bovine viral diarrhea virus 1 gene for structural glycoprotein E2, partial cds, isolate: AK Higashiyuri NCP/96 | blastn | 12186 | 296 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 5828328 | 5828328 | PRJNA745923_S_NODE_21185_length_212_cov_1.704142_g20853_i0 | PRJNA745923 | 21185 | 212 | 1.704142 | 3.6127810400000002 | Erysiphe necator associated abispo virus 6 | 2741922 | Viruses | Viruses | 348 | 2.12e-91 | NTclustered | gi|1848976859|gb|MN611691.1| | 2741922 | g20853 | i0 | 96.226 | 1 | 212 | 8 | 100 | 0 | 1 | 212 | 1526 | 1737 | Erysiphe necator associated abispo virus 6 isolate PMS17_139 segment RNA1, complete sequence | blastn | 212 | 348 | 1 | Viruses | Erysiphe necator associated abispo virus 6 | ||||||||
| 8378314 | 8378314 | PRJNA745923_S_NODE_6407_length_423_cov_2.492105_g6076_i0 | PRJNA745923 | 6407 | 423 | 2.492105 | 10.54160415 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 5.669999999999998e-130 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g6076 | i0 | 87.089 | 9.87234042553191 | 426 | 49 | 100 | 5 | 1 | 423 | 18252 | 18674 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 4176 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10928923 | 10928923 | PRJNA745923_S_NODE_4789_length_515_cov_2.682203_g4466_i0 | PRJNA745923 | 4789 | 515 | 2.682203 | 13.81334545 | Pestivirus bovis | 3052619 | Viruses | Viruses | 863 | 0 | NTclustered | gi|2858850717|gb|PQ613792.1| | 11099 | g4466 | i0 | 96.893 | 97.7941747572816 | 515 | 16 | 100 | 0 | 1 | 515 | 43 | 557 | Bovine viral diarrhea virus 1 isolate USMARC/PI-91-21/MDBK polyprotein gene, complete cds | blastn | 50364 | 863 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 13478446 | 13478446 | PRJNA745923_S_NODE_18631_length_228_cov_9.729730_g18299_i0 | PRJNA745923 | 18631 | 228 | 9.72973 | 22.1837844 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 58.4 | 4.37e-4 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g18299 | i0 | 100 | 0.258771929824561 | 31 | 0 | 14 | 0 | 1 | 31 | 13 | 43 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 59 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 14753449 | 14753449 | PRJNA745923_S_NODE_14672_length_263_cov_2.881818_g14340_i0 | PRJNA745923 | 14672 | 263 | 2.881818 | 7.57918134 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.58e-131 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g14340 | i0 | 99.62 | 38.3498098859316 | 263 | 1 | 100 | 0 | 1 | 263 | 1000 | 1262 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 10086 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16027474 | 16027474 | PRJNA745923_S_NODE_32553_length_166_cov_2.203252_g32221_i0 | PRJNA745923 | 32553 | 166 | 2.203252 | 3.65739832 | Pestivirus bovis | 3052619 | Viruses | Viruses | 291 | 2.7099999999999998e-74 | NTclustered | gi|1129880259|gb|KX170497.1| | 11099 | g32221 | i0 | 98.193 | 99.8192771084337 | 166 | 3 | 100 | 0 | 1 | 166 | 178 | 13 | Bovine viral diarrhea virus 1 isolate V045 NS4A gene, partial cds | blastn | 16570 | 291 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 17302756 | 17302756 | PRJNA745923_S_NODE_2094_length_1190_cov_3.185702_g1885_i0 | PRJNA745923 | 2094 | 1190 | 3.185702 | 37.9098538 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 2069 | 0 | NTclustered | gi|2059647249|tpg|BK028718.1| | 2832643 | g1885 | i0 | 98.712 | 96.4857142857143 | 1165 | 15 | 98 | 0 | 1 | 1165 | 6390 | 5226 | MAG TPA_asm: Caudoviricetes sp. isolate ctQcn1, partial genome | blastn | 114818 | 2069 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17302966 | 17302966 | PRJNA745923_S_NODE_35594_length_158_cov_1.669565_g35262_i0 | PRJNA745923 | 35594 | 158 | 1.669565 | 2.6379127000000002 | Pestivirus bovis | 3052619 | Viruses | Viruses | 276 | 7.120000000000001e-70 | NTclustered | gi|800924328|gb|KP941589.1| | 11099 | g35262 | i0 | 98.101 | 99.8607594936709 | 158 | 3 | 100 | 0 | 1 | 158 | 10350 | 10193 | Bovine viral diarrhea virus 1 strain USMARC-55923 polyprotein gene, complete cds | blastn | 15778 | 276 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 17776571 | 17776571 | PRJNA745923_S_NODE_19754_length_221_cov_1.061798_g19422_i0 | PRJNA745923 | 19754 | 221 | 1.061798 | 2.34657358 | root | 1 | Root_unresolved | Root_unresolved | 167 | 6.7e-37 | NTclustered | gi|2054791465|tpg|BK049930.1| | 2832643 | g19422 | i0 | 98.925 | 5.98642533936652 | 93 | 1 | 42 | 0 | 1 | 93 | 12248 | 12156 | MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome | blastn | 1323 | 167 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19050574 | 19050574 | PRJNA745923_S_NODE_14175_length_268_cov_4.271111_g13843_i0 | PRJNA745923 | 14175 | 268 | 4.271111 | 11.44657748 | Pestivirus | 11095 | Viruses | Viruses | 440 | 4.479999999999998e-119 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g13843 | i0 | 96.269 | 99.9813432835821 | 268 | 10 | 100 | 0 | 1 | 268 | 9431 | 9698 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 26795 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19050665 | 19050665 | PRJNA745923_S_NODE_27435_length_183_cov_1.642857_g27103_i0 | PRJNA745923 | 27435 | 183 | 1.642857 | 3.00642831 | Pestivirus | 11095 | Viruses | Viruses | 300 | 5.040000000000001e-77 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g27103 | i0 | 96.175 | 99.1584699453552 | 183 | 7 | 100 | 0 | 1 | 183 | 4720 | 4902 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 18146 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19852025 | 19852025 | PRJNA745923_S_NODE_816_length_2710_cov_27.151106_g706_i0 | PRJNA745923 | 816 | 2710 | 27.151106 | 735.7949726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1105 | 0 | NTclustered | gi|2915042807|gb|OR222762.1| | 2832643 | g706 | i0 | 87.067 | 17.7394833948339 | 982 | 121 | 36 | 6 | 1709 | 2687 | 47208 | 46230 | MAG: Caudoviricetes sp. isolate MSP0596 genomic sequence | blastn | 48074 | 1105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20325364 | 20325364 | PRJNA745923_S_NODE_28996_length_177_cov_2.149254_g28664_i0 | PRJNA745923 | 28996 | 177 | 2.149254 | 3.80417958 | Pestivirus | 11095 | Viruses | Viruses | 305 | 1.04e-78 | NTclustered | gi|2731951075|gb|PP770551.1| | 11099 | g28664 | i0 | 97.74 | 99.774011299435 | 177 | 4 | 100 | 0 | 1 | 177 | 9897 | 10073 | Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome | blastn | 17660 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 21127097 | 21127097 | PRJNA745923_S_NODE_11277_length_306_cov_13.878327_g10945_i0 | PRJNA745923 | 11277 | 306 | 13.878327 | 42.46768062 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.029 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g10945 | i0 | 94.286 | 0.11437908496732 | 35 | 1 | 11 | 1 | 70 | 103 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 21601076 | 21601076 | PRJNA745923_S_NODE_2797_length_884_cov_3.664685_g2549_i0 | PRJNA745923 | 2797 | 884 | 3.664685 | 32.3958154 | root | 1 | Root_unresolved | Root_unresolved | 1616 | 0 | NTclustered | gi|2053021216|tpg|BK023879.1| | 38018 | g2549 | i0 | 99.661 | 126.990950226244 | 884 | 3 | 100 | 0 | 1 | 884 | 2941 | 2058 | MAG TPA_asm: Bacteriophage sp. isolate ctXXx2, partial genome | blastn | 112260 | 1616 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 23677778 | 23677778 | PRJNA745923_S_NODE_26939_length_185_cov_1.352113_g26607_i0 | PRJNA745923 | 26939 | 185 | 1.352113 | 2.50140905 | Pestivirus bovis | 3052619 | Viruses | Viruses | 298 | 1.84e-76 | NTclustered | gi|1129880365|gb|KX170550.1| | 11099 | g26607 | i0 | 95.676 | 99.972972972973 | 185 | 8 | 100 | 0 | 1 | 185 | 574 | 390 | Bovine viral diarrhea virus 1 isolate V048 NS4B gene, partial cds | blastn | 18495 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 25425412 | 25425412 | PRJNA745923_S_NODE_1540_length_1649_cov_27.437733_g1369_i0 | PRJNA745923 | 1540 | 1649 | 27.437733 | 452.44821717 | root | 1 | Root_unresolved | Root_unresolved | 2907 | 0 | NTclustered | gi|2053021216|tpg|BK023879.1| | 38018 | g1369 | i0 | 99.134 | 134.313523347483 | 1617 | 12 | 98 | 2 | 33 | 1649 | 4544 | 2930 | MAG TPA_asm: Bacteriophage sp. isolate ctXXx2, partial genome | blastn | 221483 | 2920 | 0.995547945205479 | Viruses | Bacteriophage sp. |
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);;