contig_metadata
21 rows where bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3783283 | 3783283 | PRJNA846486_P_NODE_22683_length_271_cov_1.770270_g22587_i0 | PRJNA846486 | 22683 | 271 | 1.77027 | 4.7974317 | Viruses | 10239 | Viruses | Viruses | 285 | 2.25e-72 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g22587 | i0 | 98.16 | 3.16605166051661 | 163 | 3 | 100 | 0 | 109 | 271 | 1045 | 1207 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 858 | 285 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 7211342 | 7211342 | PRJNA846486_P_NODE_20666_length_282_cov_1.472103_g20570_i0 | PRJNA846486 | 20666 | 282 | 1.472103 | 4.15133046 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 483 | 7.78e-132 | NTclustered | gi|2496529059|gb|OP577479.1| | 3042447 | g20570 | i0 | 99.621 | 1.87234042553191 | 264 | 1 | 94 | 0 | 19 | 282 | 333 | 70 | Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome | blastn | 528 | 483 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | ||
| 8884514 | 8884514 | PRJNA846486_P_NODE_827_length_1089_cov_12.463462_g789_i0 | PRJNA846486 | 827 | 1089 | 12.463462 | 135.72710118 | Circovirus | 39725 | Viruses | Viruses | 1969 | 0 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g789 | i0 | 99.629 | 4.6969696969697 | 1078 | 4 | 99 | 0 | 12 | 1089 | 1640 | 2717 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 5115 | 1975 | 0.996962025316456 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 11435218 | 11435218 | PRJNA846486_P_NODE_26529_length_254_cov_1.273171_g26433_i0 | PRJNA846486 | 26529 | 254 | 1.273171 | 3.23385434 | Circovirus | 39725 | Viruses | Viruses | 435 | 1.9600000000000003e-117 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g26433 | i0 | 100 | 3.7007874015748 | 235 | 0 | 93 | 0 | 1 | 235 | 1155 | 921 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 940 | 435 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 12312543 | 12312543 | PRJNA846486_P_NODE_88790_length_164_cov_0.904348_g88694_i0 | PRJNA846486 | 88790 | 164 | 0.904348 | 1.48313072 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 254 | 3.5e-63 | NTclustered | gi|2814138553|gb|PQ313134.1| | 1940570 | g88694 | i0 | 97.931 | 2.24390243902439 | 145 | 3 | 88 | 0 | 20 | 164 | 702 | 558 | Parvoviridae sp. isolate SpinColumn19, partial genome | blastn | 368 | 254 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 12711034 | 12711034 | PRJNA846486_P_NODE_27390_length_251_cov_0.821782_g27294_i0 | PRJNA846486 | 27390 | 251 | 0.821782 | 2.06267282 | Viruses | 10239 | Viruses | Viruses | 241 | 4.52e-59 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g27294 | i0 | 96.552 | 3 | 145 | 5 | 100 | 0 | 107 | 251 | 619 | 763 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 753 | 241 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 12711047 | 12711047 | PRJNA846486_P_NODE_4950_length_537_cov_3.145492_g4861_i0 | PRJNA846486 | 4950 | 537 | 3.145492 | 16.89129204 | Viruses | 10239 | Viruses | Viruses | 893 | 0 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g4861 | i0 | 99.39 | 2.71694599627561 | 492 | 3 | 92 | 0 | 1 | 492 | 2234 | 2725 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 1459 | 896 | 0.996651785714286 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 13586923 | 13586923 | PRJNA846486_P_NODE_57471_length_188_cov_1.316547_g57375_i0 | PRJNA846486 | 57471 | 188 | 1.316547 | 2.47510836 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 342 | 8.539999999999999e-90 | NTclustered | gi|2717314865|gb|OR224881.1| | 2748378 | g57375 | i0 | 99.468 | 1 | 188 | 1 | 100 | 0 | 1 | 188 | 259 | 72 | Cressdnaviricota sp. isolate C25N337/AU hypothetical protein gene, complete cds | blastn | 188 | 342 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 16534062 | 16534062 | PRJNA846486_P_NODE_9133_length_408_cov_1.752089_g9038_i0 | PRJNA846486 | 9133 | 408 | 1.752089 | 7.14852312 | Circovirus | 39725 | Viruses | Viruses | 747 | 0 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g9038 | i0 | 100 | 5.26225490196078 | 404 | 0 | 99 | 0 | 5 | 408 | 2909 | 3312 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 2147 | 747 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 17808935 | 17808935 | PRJNA846486_P_NODE_14014_length_334_cov_2.056140_g13918_i0 | PRJNA846486 | 14014 | 334 | 2.05614 | 6.8675076 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 612 | 1.15e-170 | NTclustered | gi|2814138549|gb|PQ313132.1| | 3042447 | g13918 | i0 | 99.701 | 2 | 334 | 1 | 100 | 0 | 1 | 334 | 22 | 355 | Parvoviridae sp. isolate SpinColumn17, partial genome | blastn | 668 | 612 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform aveparvovirus | |||
| 17808954 | 17808954 | PRJNA846486_P_NODE_53214_length_193_cov_2.125000_g53118_i0 | PRJNA846486 | 53214 | 193 | 2.125 | 4.10125 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 342 | 8.819999999999999e-90 | NTclustered | gi|2814138549|gb|PQ313132.1| | 3042447 | g53118 | i0 | 100 | 1.91709844559585 | 185 | 0 | 96 | 0 | 1 | 185 | 425 | 609 | Parvoviridae sp. isolate SpinColumn17, partial genome | blastn | 370 | 342 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform aveparvovirus | |||
| 20357763 | 20357763 | PRJNA846486_P_NODE_32716_length_233_cov_1.478261_g32620_i0 | PRJNA846486 | 32716 | 233 | 1.478261 | 3.44434813 | Circovirus | 39725 | Viruses | Viruses | 403 | 4.9999999999999985e-108 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g32620 | i0 | 99.548 | 4.86266094420601 | 221 | 1 | 95 | 0 | 13 | 233 | 3539 | 3759 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 1133 | 403 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 22510157 | 22510157 | PRJNA846486_P_NODE_77218_length_169_cov_0.866667_g77122_i0 | PRJNA846486 | 77218 | 169 | 0.866667 | 1.46466723 | Reagent-associated CRESS-like virus 1 | 2875809 | Viruses | Viruses | 302 | 1.27e-77 | NTclustered | gi|2094552989|gb|MZ824237.1| | 2875809 | g77122 | i0 | 98.817 | 1 | 169 | 2 | 100 | 0 | 1 | 169 | 485 | 653 | Reagent-associated CRESS-like virus 1 isolate 7 replicase-like gene, partial sequence | blastn | 169 | 302 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 1 | ||||||
| 22908936 | 22908936 | PRJNA846486_P_NODE_23498_length_267_cov_1.986239_g23402_i0 | PRJNA846486 | 23498 | 267 | 1.986239 | 5.30325813 | Circovirus | 39725 | Viruses | Viruses | 494 | 3.38e-135 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g23402 | i0 | 100 | 4 | 267 | 0 | 100 | 0 | 1 | 267 | 1409 | 1143 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 1068 | 494 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 24182997 | 24182997 | PRJNA846486_P_NODE_21319_length_278_cov_1.973799_g21223_i0 | PRJNA846486 | 21319 | 278 | 1.973799 | 5.48716122 | Arfiviricetes | 2732423 | Viruses | Viruses | 508 | 1.26e-139 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g21223 | i0 | 99.64 | 6.23021582733813 | 278 | 1 | 100 | 0 | 1 | 278 | 1655 | 1378 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 1732 | 508 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 26683208 | 26683208 | PRJNA846486_P_NODE_85941_length_165_cov_0.896552_g85845_i0 | PRJNA846486 | 85941 | 165 | 0.896552 | 1.4793108 | Viruses | 10239 | Viruses | Viruses | 45.8 | 0.00104 | NR | QKK82944.1 | 2739858 | g85845 | i0 | 54.5 | 1.21818181818182 | 33 | 13 | 56.4 | 1 | 72 | 164 | 173 | 205 | QKK82944.1 hypothetical protein 3 [Forsythia suspensa parvo-like virus] | diamond | 201 | 45.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Forsythia suspensa parvo-like virus | |||
| 28318053 | 28318053 | PRJNA846486_P_NODE_3506_length_624_cov_9.747826_g3424_i0 | PRJNA846486 | 3506 | 624 | 9.747826 | 60.82643424 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 136 | 5.1799999999999986e-34 | NR | AXH74707.1 | 2748378 | g3424 | i0 | 39.7 | 0.836538461538462 | 174 | 86 | 83.7 | 3 | 70 | 591 | 68 | 222 | AXH74707.1 MAG: Rep [Cressdnaviricota sp.] | diamond | 522 | 136 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29422957 | 29422957 | PRJNA846486_P_NODE_67609_length_177_cov_0.984375_g67513_i0 | PRJNA846486 | 67609 | 177 | 0.984375 | 1.74234375 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 42 | 0.0286 | NR | XNT20757.1 | 1940570 | g67513 | i0 | 50 | 0.610169491525424 | 36 | 18 | 61 | 0 | 109 | 2 | 366 | 401 | XNT20757.1 MAG: replication protein [Parvoviridae sp.] | diamond | 108 | 42 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 29612260 | 29612260 | PRJNA846486_P_NODE_80450_length_167_cov_1.322034_g80354_i0 | PRJNA846486 | 80450 | 167 | 1.322034 | 2.20779678 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 54.7 | 7.46e-7 | NR | WAE42279.1 | 2748378 | g80354 | i0 | 54.3 | 0.826347305389222 | 46 | 20 | 82.6 | 1 | 159 | 22 | 138 | 182 | WAE42279.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 138 | 54.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29801974 | 29801974 | PRJNA846486_P_NODE_11651_length_364_cov_2.895238_g11556_i0 | PRJNA846486 | 11651 | 364 | 2.895238 | 10.53866632 | Phylloscopus proregulus parvoviridae sp. | 2794532 | Viruses | Viruses | 83.6 | 7.41e-16 | NR | QTE04069.1 | 2794532 | g11556 | i0 | 53.1 | 0.667582417582418 | 81 | 37 | 65.9 | 1 | 364 | 125 | 559 | 639 | QTE04069.1 MAG: VP [Phylloscopus proregulus parvoviridae sp.] | diamond | 243 | 83.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phylloscopus proregulus parvoviridae sp. | |||
| 31191852 | 31191852 | PRJNA846486_P_NODE_83455_length_166_cov_0.888889_g83359_i0 | PRJNA846486 | 83455 | 166 | 0.888889 | 1.47555574 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 89.7 | 2.12e-19 | NR | AYP28916.1 | 2748378 | g83359 | i0 | 80.4 | 0.831325301204819 | 46 | 9 | 83.1 | 0 | 164 | 27 | 240 | 285 | AYP28916.1 MAG: putative capsid protein [Cressdnaviricota sp.] | diamond | 138 | 89.7 | 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);;