contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 391944 | 391944 | PRJNA340009_P_NODE_17081_length_289_cov_1.595833_g16774_i0 | PRJNA340009 | 17081 | 289 | 1.595833 | 4.61195737 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 63.9 | 1.24e-5 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g16774 | i0 | 100 | 0.681660899653979 | 34 | 0 | 24 | 0 | 254 | 287 | 2537 | 2570 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 197 | 63.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 391993 | 391993 | PRJNA340009_P_NODE_201_length_2787_cov_13.846969_g63_i1 | PRJNA340009 | 201 | 2787 | 13.846969 | 385.91502603 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2985 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g63 | i1 | 99.693 | 0.966630785791173 | 1631 | 5 | 97 | 0 | 1 | 1631 | 3593 | 5223 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 2694 | 2985 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 1666497 | 1666497 | PRJNA340009_P_NODE_15922_length_298_cov_2.040161_g15615_i0 | PRJNA340009 | 15922 | 298 | 2.040161 | 6.07967978 | Reagent-associated CRESS-like virus 7 | 2875815 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|2094552982|gb|MZ824231.1| | 2875815 | g15615 | i0 | 100 | 2.93959731543624 | 298 | 0 | 100 | 0 | 1 | 298 | 918 | 621 | Reagent-associated CRESS-like virus 7 isolate 13 replicase-like gene, partial sequence | blastn | 876 | 551 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 7 | ||||||
| 4219381 | 4219381 | PRJNA340009_P_NODE_35424_length_212_cov_0.877301_g35117_i0 | PRJNA340009 | 35424 | 212 | 0.877301 | 1.85987812 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 115 | 2.3400000000000003e-21 | NTclustered | gi|2302005281|gb|MT200828.1| | 1954248 | g35117 | i0 | 93.59 | 1 | 78 | 4 | 37 | 1 | 104 | 181 | 1166 | 1242 | MAG: Circoviridae sp. isolate CN13_L12_1, complete genome | blastn | 212 | 115 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 5496050 | 5496050 | PRJNA340009_P_NODE_61985_length_167_cov_0.864407_g61678_i0 | PRJNA340009 | 61985 | 167 | 0.864407 | 1.44355969 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 111 | 2.28e-20 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g61678 | i0 | 84.685 | 1.38323353293413 | 111 | 17 | 66 | 0 | 57 | 167 | 1798 | 1908 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 231 | 111 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 5496199 | 5496199 | PRJNA340009_P_NODE_75505_length_161_cov_1.821429_g75198_i0 | PRJNA340009 | 75505 | 161 | 1.821429 | 2.93250069 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 126 | 7.77e-25 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g75198 | i0 | 80.864 | 2.01242236024845 | 162 | 29 | 100 | 2 | 1 | 161 | 1574 | 1734 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 324 | 126 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 6769543 | 6769543 | PRJNA340009_P_NODE_186_length_3006_cov_13.897193_g63_i0 | PRJNA340009 | 186 | 3006 | 13.897193 | 417.74962158 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2985 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g63 | i0 | 99.693 | 1 | 1631 | 5 | 100 | 0 | 1 | 1631 | 3593 | 5223 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 3006 | 2985 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 8045231 | 8045231 | PRJNA340009_P_NODE_247_length_2227_cov_13.495868_g99_i0 | PRJNA340009 | 247 | 2227 | 13.495868 | 300.55298036 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 4039 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g99 | i0 | 99.416 | 1 | 2227 | 12 | 100 | 1 | 1 | 2227 | 3606 | 1381 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 2227 | 4039 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 8045682 | 8045682 | PRJNA340009_P_NODE_62047_length_167_cov_0.864407_g61740_i0 | PRJNA340009 | 62047 | 167 | 0.864407 | 1.44355969 | Protoambidensovirus incertum3 | 3431910 | Viruses | Viruses | 167 | 4.79e-37 | NTclustered | gi|2742831367|gb|PP793395.1| | 2050976 | g61740 | i0 | 88.489 | 3.65868263473054 | 139 | 15 | 83 | 1 | 9 | 146 | 497 | 359 | MAG: Ambidensovirus sp. isolate 136_3958, partial genome | blastn | 611 | 167 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoambidensovirus | Protoambidensovirus incertum3 | ||
| 9319852 | 9319852 | PRJNA340009_P_NODE_12328_length_332_cov_1.862191_g12021_i0 | PRJNA340009 | 12328 | 332 | 1.862191 | 6.18247412 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 603 | 6.889999999999997e-168 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g12021 | i0 | 99.398 | 1.54518072289157 | 332 | 2 | 100 | 0 | 1 | 332 | 1462 | 1131 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 513 | 603 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 9320299 | 9320299 | PRJNA340009_P_NODE_48328_length_186_cov_1.489051_g48021_i0 | PRJNA340009 | 48328 | 186 | 1.489051 | 2.76963486 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 339 | 1.0899999999999998e-88 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g48021 | i0 | 99.462 | 1 | 186 | 1 | 100 | 0 | 1 | 186 | 3309 | 3124 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 186 | 339 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 9320417 | 9320417 | PRJNA340009_P_NODE_58888_length_171_cov_0.909836_g58581_i0 | PRJNA340009 | 58888 | 171 | 0.909836 | 1.55581956 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 159 | 8.199999999999998e-35 | NTclustered | gi|156598992|gb|EF579658.1| | 1891767 | g58581 | i0 | 86.755 | 0.883040935672515 | 151 | 11 | 88 | 4 | 11 | 161 | 2675 | 2534 | Simian virus 40 isolate SV40(Ad)191, complete genome | blastn | 151 | 159 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 9320519 | 9320519 | PRJNA340009_P_NODE_69668_length_164_cov_0.886957_g69361_i0 | PRJNA340009 | 69668 | 164 | 0.886957 | 1.45460948 | Cynopterus sphinx circular DNA virus 4 | 3064087 | Viruses | Viruses | 152 | 1.31e-32 | NTclustered | gi|2593361788|gb|OQ267683.1| | 3064087 | g69361 | i0 | 96.739 | 0.560975609756098 | 92 | 2 | 56 | 1 | 73 | 164 | 160 | 250 | MAG: Cynopterus sphinx circular DNA virus 4 isolate 68C4 genomic sequence | blastn | 92 | 152 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 4 | ||||||
| 10596000 | 10596000 | PRJNA340009_P_NODE_50009_length_183_cov_3.455224_g49702_i0 | PRJNA340009 | 50009 | 183 | 3.455224 | 6.32305992 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 333 | 4.97e-87 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g49702 | i0 | 99.454 | 1 | 183 | 1 | 100 | 0 | 1 | 183 | 2116 | 1934 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 183 | 333 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 15694619 | 15694619 | PRJNA340009_P_NODE_23073_length_254_cov_1.292683_g22766_i0 | PRJNA340009 | 23073 | 254 | 1.292683 | 3.28341482 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 355 | 1.57e-93 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g22766 | i0 | 95.111 | 0.885826771653543 | 225 | 11 | 89 | 0 | 30 | 254 | 2538 | 2314 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 225 | 355 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 16372511 | 16372511 | PRJNA340009_P_NODE_19473_length_273_cov_1.901786_g19166_i0 | PRJNA340009 | 19473 | 273 | 1.901786 | 5.19187578 | Viruses | 10239 | Viruses | Viruses | 433 | 7.66e-117 | NTclustered | gi|2626080152|gb|OR270642.1| | 3063427 | g19166 | i0 | 95.238 | 3 | 273 | 13 | 100 | 0 | 1 | 273 | 1172 | 900 | MAG: Chegonang virus 3 isolate GL83, complete genome | blastn | 819 | 433 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Chegonang virus 3 | ||||||
| 19517832 | 19517832 | PRJNA340009_P_NODE_24396_length_248_cov_1.989950_g24089_i0 | PRJNA340009 | 24396 | 248 | 1.98995 | 4.935076 | Cynopterus sphinx circular DNA virus 5 | 3064088 | Viruses | Viruses | 350 | 7.100000000000001e-92 | NTclustered | gi|2593361791|gb|OQ267684.1| | 3064088 | g24089 | i0 | 93.59 | 1.89516129032258 | 234 | 15 | 94 | 0 | 8 | 241 | 1 | 234 | MAG: Cynopterus sphinx circular DNA virus 5 isolate 68C5 genomic sequence | blastn | 470 | 350 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 5 | ||||||
| 22068310 | 22068310 | PRJNA340009_P_NODE_13378_length_321_cov_1.547794_g13071_i0 | PRJNA340009 | 13378 | 321 | 1.547794 | 4.96841874 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 390 | 5.62e-104 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g13071 | i0 | 99.078 | 1.03738317757009 | 217 | 2 | 100 | 0 | 1 | 217 | 654 | 870 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 333 | 390 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 22069077 | 22069077 | PRJNA340009_P_NODE_78258_length_159_cov_2.290909_g77951_i0 | PRJNA340009 | 78258 | 159 | 2.290909 | 3.64254531 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 219 | 1.23e-52 | NTclustered | gi|2028284253|gb|MW046451.1| | 3003968 | g77951 | i0 | 95 | 1.76100628930818 | 140 | 6 | 88 | 1 | 20 | 159 | 525 | 387 | MAG: Grus japonensis parvo-like hybrid virus isolate cra70par025 genomic sequence, sequence | blastn | 280 | 219 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 22746925 | 22746925 | PRJNA340009_P_NODE_39058_length_203_cov_2.500000_g38751_i0 | PRJNA340009 | 39058 | 203 | 2.5 | 5.075 | Viruses | 10239 | Viruses | Viruses | 372 | 1.2e-98 | NTclustered | gi|2089355977|gb|MZ364300.1| | 2748378 | g38751 | i0 | 100 | 7.01477832512315 | 201 | 0 | 99 | 0 | 1 | 201 | 417 | 217 | CRESS virus sp. strain CRESS-2/S10/AUS, complete sequence | blastn | 1424 | 372 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 23344544 | 23344544 | PRJNA340009_P_NODE_7999_length_396_cov_2.512968_g7692_i0 | PRJNA340009 | 7999 | 396 | 2.512968 | 9.95135328 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 676 | 0 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g7692 | i0 | 97.475 | 1 | 396 | 10 | 100 | 0 | 1 | 396 | 3110 | 2715 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 396 | 676 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae 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);;