contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1247234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351255 | 351255 | PRJNA1247234_P_NODE_1_length_8465_cov_89.071973_g0_i0 | PRJNA1247234 | 1 | 8465 | 89.071973 | 7539.94251445 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 15006 | 0 | NTclustered | gi|1214947080|gb|MF033144.1| | 12169 | g0 | i0 | 98.665 | 93.5755463673952 | 8465 | 113 | 100 | 0 | 1 | 8465 | 8483 | 19 | Potato virus S isolate BY, complete genome | blastn | 792117 | 15006 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 1626013 | 1626013 | PRJNA1247234_P_NODE_14862_length_291_cov_1.431193_g14706_i0 | PRJNA1247234 | 14862 | 291 | 1.431193 | 4.16477163 | Erysiphe necator associated mitovirus 35 | 2950447 | Viruses | Viruses | 494 | 3.7299999999999996e-135 | NTclustered | gi|2250491993|gb|ON605605.1| | 2950447 | g14706 | i0 | 97.251 | 9.43642611683849 | 291 | 8 | 100 | 0 | 1 | 291 | 1948 | 2238 | Erysiphe necator associated mitovirus 35 RNA-dependent RNA polymerase gene, complete cds | blastn | 2746 | 494 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Erysiphe necator associated mitovirus 35 | ||
| 13105209 | 13105209 | PRJNA1247234_P_NODE_16131_length_281_cov_1.500000_g15975_i0 | PRJNA1247234 | 16131 | 281 | 1.5 | 4.215 | Potyvirus orionspassiflorae | 3240573 | Viruses | Viruses | 503 | 5.95e-138 | NTclustered | gi|998454002|gb|KT724930.1| | 341167 | g15975 | i0 | 98.932 | 6.13523131672598 | 281 | 3 | 100 | 0 | 1 | 281 | 6855 | 6575 | East Asian Passiflora virus isolate EAPV-IB-dpd, complete genome | blastn | 1724 | 503 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus orionspassiflorae | ||
| 16928720 | 16928720 | PRJNA1247234_P_NODE_24794_length_246_cov_0.901734_g24638_i0 | PRJNA1247234 | 24794 | 246 | 0.901734 | 2.21826564 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 425 | 1.14e-114 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g24638 | i0 | 97.959 | 9.89024390243902 | 245 | 5 | 99 | 0 | 1 | 245 | 1601 | 1845 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 2433 | 425 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 16928883 | 16928883 | PRJNA1247234_P_NODE_874_length_945_cov_2.305046_g777_i0 | PRJNA1247234 | 874 | 945 | 2.305046 | 21.7826847 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1301 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g777 | i0 | 91.429 | 1 | 945 | 81 | 100 | 0 | 1 | 945 | 6083 | 7027 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 945 | 1301 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 19477514 | 19477514 | PRJNA1247234_P_NODE_21016_length_252_cov_0.871508_g20860_i0 | PRJNA1247234 | 21016 | 252 | 0.871508 | 2.19620016 | Potyvirus orionspassiflorae | 3240573 | Viruses | Viruses | 433 | 6.98e-117 | NTclustered | gi|998454002|gb|KT724930.1| | 341167 | g20860 | i0 | 97.992 | 3.95238095238095 | 249 | 5 | 99 | 0 | 4 | 252 | 6293 | 6045 | East Asian Passiflora virus isolate EAPV-IB-dpd, complete genome | blastn | 996 | 433 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus orionspassiflorae | ||
| 19477695 | 19477695 | PRJNA1247234_P_NODE_6096_length_416_cov_3.361516_g5942_i0 | PRJNA1247234 | 6096 | 416 | 3.361516 | 13.98390656 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 558 | 1.93e-154 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g5942 | i0 | 90.887 | 1.00240384615385 | 417 | 36 | 100 | 2 | 1 | 416 | 5596 | 6011 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 417 | 558 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 20752938 | 20752938 | PRJNA1247234_P_NODE_21557_length_251_cov_0.876404_g21401_i0 | PRJNA1247234 | 21557 | 251 | 0.876404 | 2.19977404 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 440 | 4.149999999999998e-119 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g21401 | i0 | 98.4 | 8.93227091633466 | 250 | 4 | 99 | 0 | 2 | 251 | 1512 | 1263 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 2242 | 440 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 20753164 | 20753164 | PRJNA1247234_P_NODE_7497_length_383_cov_1.458065_g7341_i0 | PRJNA1247234 | 7497 | 383 | 1.458065 | 5.58438895 | Duamitovirus boci1 | 2955769 | Viruses | Viruses | 656 | 0 | NTclustered | gi|955660101|emb|LN827944.1| | 444193 | g7341 | i0 | 97.65 | 6.25065274151436 | 383 | 8 | 100 | 1 | 1 | 383 | 398 | 17 | Botrytis cinerea mitovirus 1 RdRp gene for RNA dependent RNA polymerase, isolate HAZ3-1 | blastn | 2394 | 656 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus boci1 | ||
| 22028055 | 22028055 | PRJNA1247234_P_NODE_15358_length_287_cov_2.028037_g15202_i0 | PRJNA1247234 | 15358 | 287 | 2.028037 | 5.82046619 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 497 | 2.84e-136 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g15202 | i0 | 97.909 | 13.191637630662 | 287 | 6 | 100 | 0 | 1 | 287 | 1296 | 1010 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 3786 | 497 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 22028081 | 22028081 | PRJNA1247234_P_NODE_16558_length_278_cov_1.502439_g16402_i0 | PRJNA1247234 | 16558 | 278 | 1.502439 | 4.17678042 | Duamitovirus scsc3 | 2955836 | Viruses | Viruses | 448 | 2.79e-121 | NTclustered | gi|1838367559|gb|MN954876.1| | 1279099 | g16402 | i0 | 95.683 | 1 | 278 | 12 | 100 | 0 | 1 | 278 | 2960 | 2683 | Sclerotinia sclerotiorum mitovirus 3 isolate BCI2_DN28, complete genome | blastn | 278 | 448 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus scsc3 |
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);;