contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Cressdnaviricota"
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 | ||
| 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 | ||||||
| 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 | ||||||
| 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. |
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);;