contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1681332 | 1681332 | PRJNA385073_P_NODE_61862_length_230_cov_2.821656_g61700_i0 | PRJNA385073 | 61862 | 230 | 2.821656 | 6.4898088 | Tolivirales sp. | 2809914 | Viruses | Viruses | 279 | 8.65e-71 | NTclustered | gi|2647550049|gb|OR843807.1| | 2809914 | g61700 | i0 | 95.93 | 1.52173913043478 | 172 | 7 | 75 | 0 | 1 | 172 | 1985 | 2156 | Tolivirales sp. strain MR233-17E/8198 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 350 | 279 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 2957358 | 2957358 | PRJNA385073_P_NODE_9923_length_408_cov_2.202985_g9762_i0 | PRJNA385073 | 9923 | 408 | 2.202985 | 8.9881788 | Beijing sediment noda-like virus 3 | 2824385 | Viruses | Viruses | 137 | 1.05e-27 | NTclustered | gi|2075443876|gb|MW897069.1| | 2824385 | g9762 | i0 | 85.606 | 0.323529411764706 | 132 | 17 | 32 | 2 | 220 | 349 | 3476 | 3345 | MAG: Beijing sediment noda-like virus 3 isolate 165-k141_17508 hypothetical protein gene, complete cds | blastn | 132 | 137 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Beijing sediment noda-like virus 3 | |||
| 4232905 | 4232905 | PRJNA385073_P_NODE_27644_length_286_cov_0.981221_g27482_i0 | PRJNA385073 | 27644 | 286 | 0.981221 | 2.80629206 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 512 | 1.01e-140 | NTclustered | gi|388240233|emb|HE818437.1| | 12242 | g27482 | i0 | 98.951 | 99.9965034965035 | 286 | 3 | 100 | 0 | 1 | 286 | 3494 | 3209 | Tobacco mosaic virus isolate Mangshi-2, complete genome | blastn | 28599 | 512 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 6784362 | 6784362 | PRJNA385073_P_NODE_9306_length_418_cov_1.130435_g9145_i0 | PRJNA385073 | 9306 | 418 | 1.130435 | 4.7252183 | Andihavirus borborohabitans | 2843692 | Viruses | Viruses | 211 | 6.27e-50 | NTclustered | gi|2497515024|ref|NC_074146.1| | 2786658 | g9145 | i0 | 87.166 | 0.447368421052632 | 187 | 23 | 45 | 1 | 92 | 278 | 1 | 186 | SsRNA phage SRR7976300_9 genomic sequence | blastn | 187 | 211 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Andihavirus | Andihavirus borborohabitans | ||
| 8059468 | 8059468 | PRJNA385073_P_NODE_46667_length_248_cov_0.880000_g46505_i0 | PRJNA385073 | 46667 | 248 | 0.88 | 2.1824 | Polerovirus TUYV | 3431793 | Viruses | Viruses | 448 | 2.4499999999999996e-121 | NTclustered | gi|336444814|gb|JN015068.1| | 1046403 | g46505 | i0 | 99.194 | 99.7943548387097 | 248 | 2 | 100 | 0 | 1 | 248 | 2384 | 2137 | Brassica yellows virus, complete genome | blastn | 24749 | 448 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus TUYV | ||
| 8059596 | 8059596 | PRJNA385073_P_NODE_53347_length_244_cov_0.900585_g53185_i0 | PRJNA385073 | 53347 | 244 | 0.900585 | 2.1974274 | Gammacarmovirus melonis | 3048200 | Viruses | Viruses | 429 | 8.699999999999998e-116 | NTclustered | gi|1695685772|gb|MK604924.1| | 11987 | g53185 | i0 | 98.361 | 36.7786885245902 | 244 | 4 | 100 | 0 | 1 | 244 | 1824 | 2067 | Melon necrotic spot virus isolate 3948, complete genome | blastn | 8974 | 429 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Gammacarmovirus | Gammacarmovirus melonis | ||
| 11279229 | 11279229 | PRJNA385073_P_NODE_19149_length_324_cov_0.920319_g18987_i0 | PRJNA385073 | 19149 | 324 | 0.920319 | 2.98183356 | Tobamovirus | 12234 | Viruses | Viruses | 584 | 2.429999999999999e-162 | NTclustered | gi|20177424|ref|NC_003630.1| | 12239 | g18987 | i0 | 99.381 | 94.4320987654321 | 323 | 1 | 99 | 1 | 2 | 324 | 4056 | 3735 | Pepper mild mottle virus, complete genome | blastn | 30596 | 584 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 11884162 | 11884162 | PRJNA385073_P_NODE_14030_length_360_cov_1.898955_g13869_i0 | PRJNA385073 | 14030 | 360 | 1.898955 | 6.836238 | Chrocajirk virus | 3129534 | Viruses | Viruses | 191 | 6.93e-44 | NTclustered | gi|2717317823|gb|PP171982.1| | 3129534 | g13869 | i0 | 100 | 36.25 | 103 | 0 | 29 | 0 | 1 | 103 | 14 | 116 | MAG: Chrocajirk virus isolate CC1C_k141_100002 genomic sequence | blastn | 13050 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocajirk virus | |||
| 11884955 | 11884955 | PRJNA385073_P_NODE_4950_length_537_cov_17.081897_g4792_i0 | PRJNA385073 | 4950 | 537 | 17.081897 | 91.72978689 | Bahdevuvirus caenivivens | 2843795 | Viruses | Viruses | 342 | 2.8e-89 | NTclustered | gi|2497513288|ref|NC_073766.1| | 2786400 | g4792 | i0 | 94.954 | 0.899441340782123 | 218 | 11 | 41 | 0 | 320 | 537 | 241 | 24 | SsRNA phage SRR5466365_1 genomic sequence | blastn | 483 | 342 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Bahdevuvirus | Bahdevuvirus caenivivens | ||
| 16983040 | 16983040 | PRJNA385073_P_NODE_22114_length_309_cov_1.305085_g21952_i0 | PRJNA385073 | 22114 | 309 | 1.305085 | 4.03271265 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 571 | 1.7899999999999995e-158 | NTclustered | gi|388240233|emb|HE818437.1| | 12242 | g21952 | i0 | 100 | 100 | 309 | 0 | 100 | 0 | 1 | 309 | 3916 | 4224 | Tobacco mosaic virus isolate Mangshi-2, complete genome | blastn | 30900 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 16983503 | 16983503 | PRJNA385073_P_NODE_4254_length_570_cov_1.068410_g4098_i0 | PRJNA385073 | 4254 | 570 | 1.06841 | 6.089937 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1053 | 0 | NTclustered | gi|348605458|gb|JF920727.1| | 12242 | g4098 | i0 | 100 | 99.978947368421 | 570 | 0 | 100 | 0 | 1 | 570 | 5193 | 5762 | Tobacco mosaic virus isolate Shanxi, complete genome | blastn | 56988 | 1053 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 18257756 | 18257756 | PRJNA385073_P_NODE_49055_length_247_cov_0.885057_g48893_i0 | PRJNA385073 | 49055 | 247 | 0.885057 | 2.18609079 | Lentinula edodes deltaflexivirus 2 | 2778980 | Viruses | Viruses | 329 | 9.21e-86 | NTclustered | gi|1928162793|gb|MN744724.1| | 2778980 | g48893 | i0 | 90.688 | 1 | 247 | 23 | 100 | 0 | 1 | 247 | 4653 | 4407 | Lentinula edodes deltaflexivirus 2 isolate Le10WIL RNA-dependent RNA polymerase gene, partial cds; and hypothetical protein gene, complete cds | blastn | 247 | 329 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Lentinula edodes deltaflexivirus 2 | |||
| 18258060 | 18258060 | PRJNA385073_P_NODE_63295_length_221_cov_5.560811_g63133_i0 | PRJNA385073 | 63295 | 221 | 5.560811 | 12.28939231 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 359 | 1.03e-94 | NTclustered | gi|2324991072|gb|OK636212.1| | 2992848 | g63133 | i0 | 95.928 | 1 | 221 | 9 | 100 | 0 | 1 | 221 | 4982 | 5202 | Lentinula eaodes hypovirus 2 isolate LED2-8 RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 221 | 359 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 18927627 | 18927627 | PRJNA385073_P_NODE_27155_length_287_cov_1.439252_g26993_i0 | PRJNA385073 | 27155 | 287 | 1.439252 | 4.13065324 | Tobamovirus | 12234 | Viruses | Viruses | 531 | 2.799999999999999e-146 | NTclustered | gi|2327914667|gb|OM366242.1| | 12242 | g26993 | i0 | 100 | 99.9581881533101 | 287 | 0 | 100 | 0 | 1 | 287 | 114 | 400 | Tobacco mosaic virus isolate Yunnanwenshan replicase protein gene, complete cds | blastn | 28688 | 531 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 19531654 | 19531654 | PRJNA385073_P_NODE_28716_length_282_cov_2.894737_g28554_i0 | PRJNA385073 | 28716 | 282 | 2.894737 | 8.16315834 | Chrocagosk virus | 3129397 | Viruses | Viruses | 63.9 | 1.2e-5 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g28554 | i0 | 97.297 | 0.131205673758865 | 37 | 1 | 13 | 0 | 48 | 84 | 517 | 553 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 37 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 20807085 | 20807085 | PRJNA385073_P_NODE_15757_length_346_cov_1.875458_g15596_i0 | PRJNA385073 | 15757 | 346 | 1.875458 | 6.48908468 | Timirovirus borboradaptatum | 2846450 | Viruses | Viruses | 501 | 2.71e-137 | NTclustered | gi|2497516585|ref|NC_074508.1| | 2786465 | g15596 | i0 | 93.003 | 0.991329479768786 | 343 | 24 | 99 | 0 | 1 | 343 | 1938 | 2280 | SsRNA phage SRR5467091_15 genomic sequence | blastn | 343 | 501 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Timirovirus | Timirovirus borboradaptatum | ||
| 20807430 | 20807430 | PRJNA385073_P_NODE_31277_length_275_cov_2.029703_g31115_i0 | PRJNA385073 | 31277 | 275 | 2.029703 | 5.58168325 | Divavirus alphadiuris | 3428303 | Viruses | Viruses | 65.8 | 3.25e-6 | NTclustered | gi|410428375|ref|NC_019029.1| | 1247115 | g31115 | i0 | 91.489 | 0.341818181818182 | 47 | 4 | 17 | 0 | 229 | 275 | 6769 | 6815 | Diuris virus A isolate SW3.3, complete genome | blastn | 94 | 65.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Divavirus | Divavirus alphadiuris | ||
| 22082517 | 22082517 | PRJNA385073_P_NODE_41758_length_251_cov_0.865169_g41596_i0 | PRJNA385073 | 41758 | 251 | 0.865169 | 2.17157419 | Ripachij virus | 3130407 | Viruses | Viruses | 267 | 7.459999999999999e-67 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g41596 | i0 | 85.827 | 169.741035856574 | 254 | 32 | 100 | 4 | 1 | 251 | 684 | 432 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 42605 | 267 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 22082608 | 22082608 | PRJNA385073_P_NODE_46198_length_248_cov_1.451429_g46036_i0 | PRJNA385073 | 46198 | 248 | 1.451429 | 3.59954392 | Ripaflec virus | 3130560 | Viruses | Viruses | 313 | 9.32e-81 | NTclustered | gi|2717320098|gb|PP172862.1| | 3130560 | g46036 | i0 | 91.304 | 120.487903225806 | 230 | 18 | 92 | 2 | 20 | 248 | 5456 | 5684 | MAG: Ripaflec virus isolate KCAP2_k141_128097 genomic sequence | blastn | 29881 | 313 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaflec virus | |||||
| 23358480 | 23358480 | PRJNA385073_P_NODE_5779_length_506_cov_7.988453_g5619_i0 | PRJNA385073 | 5779 | 506 | 7.988453 | 40.42157218 | Bahdevuvirus caenivivens | 2843795 | Viruses | Viruses | 326 | 2.64e-84 | NTclustered | gi|2497513288|ref|NC_073766.1| | 2786400 | g5619 | i0 | 93.578 | 0.954545454545455 | 218 | 14 | 43 | 0 | 289 | 506 | 241 | 24 | SsRNA phage SRR5466365_1 genomic sequence | blastn | 483 | 326 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Bahdevuvirus | Bahdevuvirus caenivivens | ||
| 24631944 | 24631944 | PRJNA385073_P_NODE_17860_length_331_cov_3.852713_g17698_i0 | PRJNA385073 | 17860 | 331 | 3.852713 | 12.75248003 | Bahdevuvirus caenivivens | 2843795 | Viruses | Viruses | 292 | 1.6899999999999999e-74 | NTclustered | gi|2497513288|ref|NC_073766.1| | 2786400 | g17698 | i0 | 91.163 | 0.649546827794562 | 215 | 19 | 65 | 0 | 117 | 331 | 241 | 27 | SsRNA phage SRR5466365_1 genomic sequence | blastn | 215 | 292 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Bahdevuvirus | Bahdevuvirus caenivivens | ||
| 24632343 | 24632343 | PRJNA385073_P_NODE_34340_length_267_cov_1.829897_g34178_i0 | PRJNA385073 | 34340 | 267 | 1.829897 | 4.88582499 | Sichuan mamastrovirus 11 | 2933222 | Viruses | Viruses | 215 | 2.94e-51 | NTclustered | gi|2203408192|gb|MW784105.1| | 2933222 | g34178 | i0 | 86.911 | 31.1647940074906 | 191 | 25 | 72 | 0 | 77 | 267 | 194 | 4 | MAG: Sichuan mamastrovirus 11 isolate R69-151373, complete genome | blastn | 8321 | 215 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Mamastrovirus | Sichuan mamastrovirus 11 |
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);;