contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135213 | 135213 | PRJEB73599_P_NODE_8021_length_191_cov_2.623457_g7734_i0 | PRJEB73599 | 8021 | 191 | 2.623457 | 5.01080287 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 351 | 1.45e-92 | NTclustered | gi|1338075553|gb|MG647772.1| | 2080259 | g7734 | i0 | 100 | 0.994764397905759 | 190 | 0 | 99 | 0 | 1 | 190 | 876 | 1065 | Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds | blastn | 190 | 351 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 1409753 | 1409753 | PRJEB73599_P_NODE_2_length_8228_cov_6.194170_g1_i0 | PRJEB73599 | 2 | 8228 | 6.19417 | 509.6563076 | Crogonang virus 58 | 3063050 | Viruses | Viruses | 3365 | 0 | NTclustered | gi|2836327550|gb|PQ161599.1| | 3063050 | g1 | i0 | 81.318 | 1.34309674282936 | 4202 | 736 | 51 | 44 | 2278 | 6455 | 144 | 4320 | MAG: Crogonang virus 58 isolate CS25 RNA-dependent RNA polymerase gene, complete cds; and capsid protein gene, partial cds | blastn | 11051 | 3365 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 58 | ||||
| 2685252 | 2685252 | PRJEB73599_P_NODE_3_length_8164_cov_6.212415_g1_i1 | PRJEB73599 | 3 | 8164 | 6.212415 | 507.1815606 | Crogonang virus 58 | 3063050 | Viruses | Viruses | 3365 | 0 | NTclustered | gi|2836327550|gb|PQ161599.1| | 3063050 | g1 | i1 | 81.318 | 1.35362567368937 | 4202 | 736 | 51 | 44 | 2278 | 6455 | 144 | 4320 | MAG: Crogonang virus 58 isolate CS25 RNA-dependent RNA polymerase gene, complete cds; and capsid protein gene, partial cds | blastn | 11051 | 3365 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 58 | ||||
| 2685275 | 2685275 | PRJEB73599_P_NODE_6643_length_230_cov_1.741294_g6356_i0 | PRJEB73599 | 6643 | 230 | 1.741294 | 4.0049762 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 420 | 4.89e-113 | NTclustered | gi|1338075549|gb|MG647770.1| | 2080259 | g6356 | i0 | 99.565 | 2 | 230 | 1 | 100 | 0 | 1 | 230 | 1189 | 1418 | Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds | blastn | 460 | 420 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 3961275 | 3961275 | PRJEB73599_P_NODE_3844_length_355_cov_1.794479_g3558_i0 | PRJEB73599 | 3844 | 355 | 1.794479 | 6.37040045 | Tolivirales sp. | 2809914 | Viruses | Viruses | 538 | 2.109999999999999e-148 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g3558 | i0 | 92.703 | 1.34647887323944 | 370 | 12 | 100 | 1 | 1 | 355 | 1812 | 2181 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 478 | 538 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 5237756 | 5237756 | PRJEB73599_P_NODE_7545_length_203_cov_1.390805_g7258_i0 | PRJEB73599 | 7545 | 203 | 1.390805 | 2.82333415 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 370 | 4.3e-98 | NTclustered | gi|2083529919|tpd|BR001724.1| | 104580 | g7258 | i0 | 99.507 | 2 | 203 | 1 | 100 | 0 | 1 | 203 | 1358 | 1156 | TPA_asm: Kadipiro virus rat/2019/395 gene for VP4 protein, complete cds | blastn | 406 | 370 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 9062458 | 9062458 | PRJEB73599_P_NODE_5708_length_262_cov_1.811159_g5421_i0 | PRJEB73599 | 5708 | 262 | 1.811159 | 4.74523658 | Tolivirales sp. | 2809914 | Viruses | Viruses | 438 | 1.5699999999999999e-118 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g5421 | i0 | 95.802 | 1.97328244274809 | 262 | 10 | 100 | 1 | 1 | 262 | 1096 | 1356 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 517 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 9062494 | 9062494 | PRJEB73599_P_NODE_9788_length_157_cov_1.421875_g9501_i0 | PRJEB73599 | 9788 | 157 | 1.421875 | 2.23234375 | Chronazork virus | 3129863 | Viruses | Viruses | 111 | 2.11e-20 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g9501 | i0 | 94.521 | 0.464968152866242 | 73 | 3 | 46 | 1 | 18 | 90 | 97 | 168 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 73 | 111 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 11613657 | 11613657 | PRJEB73599_P_NODE_2510_length_466_cov_2.073227_g2239_i0 | PRJEB73599 | 2510 | 466 | 2.073227 | 9.66123782 | Tolivirales sp. | 2809914 | Viruses | Viruses | 861 | 0 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g2239 | i0 | 100 | 2.02145922746781 | 466 | 0 | 100 | 0 | 1 | 466 | 195 | 660 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 942 | 861 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 14163619 | 14163619 | PRJEB73599_P_NODE_8492_length_181_cov_1.263158_g8205_i0 | PRJEB73599 | 8492 | 181 | 1.263158 | 2.28631598 | Clinch narna-like virus 1 | 2767026 | Viruses | Viruses | 171 | 4.0699999999999997e-38 | NTclustered | gi|2836327573|gb|PQ161607.1| | 2767026 | g8205 | i0 | 85.714 | 1.77900552486188 | 161 | 23 | 89 | 0 | 21 | 181 | 3132 | 2972 | MAG: Clinch narna-like virus 1 isolate CS06 helicase gene, complete cds | blastn | 322 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Clinch narna-like virus 1 | |||
| 17986761 | 17986761 | PRJEB73599_P_NODE_5255_length_281_cov_1.480159_g4968_i0 | PRJEB73599 | 5255 | 281 | 1.480159 | 4.15924679 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 257 | 5.11e-64 | NTclustered | gi|2183471762|gb|MZ680303.1| | 2583949 | g4968 | i0 | 83.636 | 1.93950177935943 | 275 | 43 | 98 | 2 | 1 | 274 | 1902 | 2175 | MAG: Narnaviridae sp. isolate R66-k141_857485 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 545 | 257 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 17986786 | 17986786 | PRJEB73599_P_NODE_7175_length_214_cov_1.767568_g6888_i0 | PRJEB73599 | 7175 | 214 | 1.767568 | 3.78259552 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 387 | 4.55e-103 | NTclustered | gi|1338075549|gb|MG647770.1| | 2080259 | g6888 | i0 | 100 | 1.96728971962617 | 209 | 0 | 98 | 0 | 4 | 212 | 1182 | 974 | Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds | blastn | 421 | 387 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 20536118 | 20536118 | PRJEB73599_P_NODE_9617_length_160_cov_1.679389_g9330_i0 | PRJEB73599 | 9617 | 160 | 1.679389 | 2.6870224 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 296 | 5.55e-76 | NTclustered | gi|1338075553|gb|MG647772.1| | 2080259 | g9330 | i0 | 100 | 2 | 160 | 0 | 100 | 0 | 1 | 160 | 187 | 28 | Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds | blastn | 320 | 296 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 21811960 | 21811960 | PRJEB73599_P_NODE_5458_length_272_cov_2.074074_g5171_i0 | PRJEB73599 | 5458 | 272 | 2.074074 | 5.64148128 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 497 | 2.67e-136 | NTclustered | gi|1338075549|gb|MG647770.1| | 2080259 | g5171 | i0 | 99.632 | 2 | 272 | 1 | 100 | 0 | 1 | 272 | 920 | 649 | Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds | blastn | 544 | 497 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 24361039 | 24361039 | PRJEB73599_P_NODE_9460_length_163_cov_1.149254_g9173_i0 | PRJEB73599 | 9460 | 163 | 1.149254 | 1.87328402 | Qianjiang tombus-like virus 116 | 3347776 | Viruses | Viruses | 126 | 7.89e-25 | NTclustered | gi|2806501001|gb|PQ054236.1| | 3347776 | g9173 | i0 | 81.646 | 1.51533742331288 | 158 | 23 | 95 | 5 | 9 | 163 | 1062 | 1216 | MAG: Qianjiang tombus-like virus 116 isolate QJ5MS217 genomic sequence | blastn | 247 | 126 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 116 |
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);;