contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA339266" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1666263 | 1666263 | PRJNA339266_S_NODE_5862_length_205_cov_14.452381_g5851_i0 | PRJNA339266 | 5862 | 205 | 14.452381 | 29.62738105 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 368 | 1.57e-97 | NTclustered | gi|2746299041|dbj|LC818070.1| | 3156536 | g5851 | i0 | 100 | 0.970731707317073 | 199 | 0 | 97 | 0 | 1 | 199 | 50 | 248 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA4, complete sequence | blastn | 199 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 2942305 | 2942305 | PRJNA339266_S_NODE_9343_length_182_cov_22.468966_g9332_i0 | PRJNA339266 | 9343 | 182 | 22.468966000000002 | 40.89351812 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 276 | 8.440000000000001e-70 | NTclustered | gi|2746299043|dbj|LC818071.1| | 3156536 | g9332 | i0 | 98.71 | 0.851648351648352 | 155 | 2 | 85 | 0 | 1 | 155 | 2507 | 2661 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA5, complete sequence | blastn | 155 | 276 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 4218534 | 4218534 | PRJNA339266_P_NODE_1924_length_231_cov_2.020619_g1894_i0 | PRJNA339266 | 1924 | 231 | 2.020619 | 4.66762989 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 353 | 5.05e-93 | NTclustered | gi|2746299037|dbj|LC818068.1| | 3156536 | g1894 | i0 | 97.129 | 0.904761904761905 | 209 | 6 | 90 | 0 | 1 | 209 | 4385 | 4593 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA2, complete sequence | blastn | 209 | 353 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 4218699 | 4218699 | PRJNA339266_S_NODE_15444_length_160_cov_3.260163_g15433_i0 | PRJNA339266 | 15444 | 160 | 3.260163 | 5.2162608 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 274 | 2.5999999999999997e-69 | NTclustered | gi|2746299039|dbj|LC818069.1| | 3156536 | g15433 | i0 | 97.5 | 1 | 160 | 4 | 100 | 0 | 1 | 160 | 2896 | 3055 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA3, complete sequence | blastn | 160 | 274 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 6769302 | 6769302 | PRJNA339266_S_NODE_8586_length_186_cov_10.630872_g8575_i0 | PRJNA339266 | 8586 | 186 | 10.630872 | 19.77342192 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 316 | 5.11e-82 | NTclustered | gi|2746299037|dbj|LC818068.1| | 3156536 | g8575 | i0 | 97.826 | 0.989247311827957 | 184 | 3 | 99 | 1 | 3 | 186 | 3954 | 4136 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA2, complete sequence | blastn | 184 | 316 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 9319438 | 9319438 | PRJNA339266_S_NODE_12528_length_169_cov_3.469697_g12517_i0 | PRJNA339266 | 12528 | 169 | 3.469697 | 5.86378793 | Rhizopus microsporus endornavirus 3 | 3156527 | Viruses | Viruses | 246 | 6.03e-61 | NTclustered | gi|2746299022|dbj|LC818061.1| | 3156527 | g12517 | i0 | 92.899 | 1 | 169 | 12 | 100 | 0 | 1 | 169 | 7214 | 7046 | Rhizopus microsporus endornavirus 3 RmEV3-IFM52934 RNA, complete genome | blastn | 169 | 246 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Rhizopus microsporus endornavirus 3 | |||
| 9319614 | 9319614 | PRJNA339266_S_NODE_48_length_703_cov_25.475976_g43_i0 | PRJNA339266 | 48 | 703 | 25.475976 | 179.09611128 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 1179 | 0 | NTclustered | gi|2746299039|dbj|LC818069.1| | 3156536 | g43 | i0 | 98.363 | 1.06685633001422 | 672 | 10 | 96 | 1 | 1 | 672 | 3138 | 3808 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA3, complete sequence | blastn | 750 | 1179 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 9319619 | 9319619 | PRJNA339266_S_NODE_508_length_374_cov_21.353116_g497_i0 | PRJNA339266 | 508 | 374 | 21.353116 | 79.86065384 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 640 | 5.969999999999999e-179 | NTclustered | gi|2746299043|dbj|LC818071.1| | 3156536 | g497 | i0 | 98.093 | 0.981283422459893 | 367 | 7 | 98 | 0 | 1 | 367 | 2213 | 2579 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA5, complete sequence | blastn | 367 | 640 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 10595088 | 10595088 | PRJNA339266_S_NODE_109_length_561_cov_44.937023_g101_i0 | PRJNA339266 | 109 | 561 | 44.937023 | 252.09669903 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 933 | 0 | NTclustered | gi|2746299035|dbj|LC818067.1| | 3156536 | g101 | i0 | 98.131 | 0.953654188948307 | 535 | 10 | 95 | 0 | 4 | 538 | 4075 | 4609 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA1, complete sequence | blastn | 535 | 933 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 13144939 | 13144939 | PRJNA339266_S_NODE_10191_length_178_cov_5.609929_g10180_i0 | PRJNA339266 | 10191 | 178 | 5.609929 | 9.98567362 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 285 | 1.3599999999999998e-72 | NTclustered | gi|2746299041|dbj|LC818070.1| | 3156536 | g10180 | i0 | 96 | 0.98314606741573 | 175 | 7 | 98 | 0 | 2 | 176 | 526 | 352 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA4, complete sequence | blastn | 175 | 285 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 14420255 | 14420255 | PRJNA339266_S_NODE_132_length_537_cov_37.562000_g124_i0 | PRJNA339266 | 132 | 537 | 37.562 | 201.70794 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 894 | 0 | NTclustered | gi|2746299037|dbj|LC818068.1| | 3156536 | g124 | i0 | 98.242 | 0.953445065176909 | 512 | 7 | 95 | 1 | 28 | 537 | 4593 | 4082 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA2, complete sequence | blastn | 512 | 894 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 14420342 | 14420342 | PRJNA339266_S_NODE_19232_length_151_cov_3.701754_g19221_i0 | PRJNA339266 | 19232 | 151 | 3.701754 | 5.58964854 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 233 | 4.1e-57 | NTclustered | gi|2746299035|dbj|LC818067.1| | 3156536 | g19221 | i0 | 94.667 | 0.993377483443709 | 150 | 8 | 99 | 0 | 1 | 150 | 3569 | 3718 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA1, complete sequence | blastn | 150 | 233 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 16968951 | 16968951 | PRJNA339266_S_NODE_374_length_412_cov_60.882667_g363_i0 | PRJNA339266 | 374 | 412 | 60.882667 | 250.83658804 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 726 | 0 | NTclustered | gi|2746299047|dbj|LC818073.1| | 3156536 | g363 | i0 | 100 | 0.953883495145631 | 393 | 0 | 95 | 0 | 3 | 395 | 1133 | 1525 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA7, complete sequence | blastn | 393 | 726 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 19517427 | 19517427 | PRJNA339266_S_NODE_3956_length_226_cov_14.444444_g3945_i0 | PRJNA339266 | 3956 | 226 | 14.444444 | 32.64444344 | Rhizopus microsporus endornavirus 3 | 3156527 | Viruses | Viruses | 329 | 8.3e-86 | NTclustered | gi|2746299022|dbj|LC818061.1| | 3156527 | g3945 | i0 | 94.037 | 0.964601769911504 | 218 | 11 | 96 | 1 | 1 | 216 | 6430 | 6647 | Rhizopus microsporus endornavirus 3 RmEV3-IFM52934 RNA, complete genome | blastn | 218 | 329 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Rhizopus microsporus endornavirus 3 | |||
| 20792751 | 20792751 | PRJNA339266_P_NODE_77_length_550_cov_6.165692_g60_i0 | PRJNA339266 | 77 | 550 | 6.165692 | 33.911306 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 867 | 0 | NTclustered | gi|2746299047|dbj|LC818073.1| | 3156536 | g60 | i0 | 95.203 | 1.10727272727273 | 542 | 16 | 97 | 1 | 5 | 536 | 579 | 1120 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA7, complete sequence | blastn | 609 | 867 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 20792864 | 20792864 | PRJNA339266_S_NODE_157_length_509_cov_56.591102_g148_i0 | PRJNA339266 | 157 | 509 | 56.591102 | 288.04870918 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 870 | 0 | NTclustered | gi|2746299041|dbj|LC818070.1| | 3156536 | g148 | i0 | 97.817 | 0.990176817288802 | 504 | 11 | 99 | 0 | 6 | 509 | 2362 | 2865 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA4, complete sequence | blastn | 504 | 870 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 20792956 | 20792956 | PRJNA339266_S_NODE_3517_length_233_cov_29.413265_g3506_i0 | PRJNA339266 | 3517 | 233 | 29.413265 | 68.53290745 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 63.9 | 9.63e-6 | NTclustered | gi|2746299035|dbj|LC818067.1| | 3156536 | g3506 | i0 | 91.489 | 0.201716738197425 | 47 | 3 | 20 | 1 | 1 | 46 | 167 | 121 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA1, complete sequence | blastn | 47 | 63.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 22067990 | 22067990 | PRJNA339266_S_NODE_2458_length_255_cov_7.720183_g2447_i0 | PRJNA339266 | 2458 | 255 | 7.720183 | 19.68646665 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 416 | 7.129999999999998e-112 | NTclustered | gi|2746299035|dbj|LC818067.1| | 3156536 | g2447 | i0 | 96.094 | 1.00392156862745 | 256 | 9 | 100 | 1 | 1 | 255 | 2670 | 2415 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA1, complete sequence | blastn | 256 | 416 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 24617688 | 24617688 | PRJNA339266_S_NODE_340_length_420_cov_23.067885_g329_i0 | PRJNA339266 | 340 | 420 | 23.067885 | 96.885117 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2746299045|dbj|LC818072.1| | 3156536 | g329 | i0 | 98.325 | 1.08333333333333 | 418 | 7 | 99 | 0 | 1 | 418 | 1981 | 2398 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA6, complete sequence | blastn | 455 | 734 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 24617708 | 24617708 | PRJNA339266_S_NODE_40_length_746_cov_45.543018_g36_i0 | PRJNA339266 | 40 | 746 | 45.543017999999996 | 339.75091428 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 1299 | 0 | NTclustered | gi|2746299047|dbj|LC818073.1| | 3156536 | g36 | i0 | 98.636 | 1.07238605898123 | 733 | 10 | 98 | 0 | 1 | 733 | 391 | 1123 | Rhizopus microsporus virga-like virus 1 RmVV1-IFM56170 RNA, segment RNA7, complete sequence | blastn | 800 | 1299 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 |
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);;