contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1040136" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3558787 | 3558787 | PRJNA1040136_S_NODE_43_length_842_cov_3.534460_g40_i0 | PRJNA1040136 | 43 | 842 | 3.53446 | 29.7601532 | Circovirus | 39725 | Viruses | Viruses | 1539 | 0 | NTclustered | gi|2717314922|gb|OR224879.1| | 1964372 | g40 | i0 | 100 | 3.80047505938242 | 833 | 0 | 99 | 0 | 10 | 842 | 1782 | 2614 | Circovirus sp. isolate C25N74/AU, complete genome | blastn | 3200 | 1539 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 9936235 | 9936235 | PRJNA1040136_S_NODE_2148_length_256_cov_1.387978_g2145_i0 | PRJNA1040136 | 2148 | 256 | 1.387978 | 3.55322368 | Viruses | 10239 | Viruses | Viruses | 453 | 5.460000000000001e-123 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g2145 | i0 | 99.206 | 2.6328125 | 252 | 1 | 98 | 1 | 1 | 251 | 990 | 739 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 674 | 453 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 10372972 | 10372972 | PRJNA1040136_S_NODE_2009_length_262_cov_1.587302_g2006_i0 | PRJNA1040136 | 2009 | 262 | 1.587302 | 4.15873124 | Microvirus sp. | 2202559 | Viruses | Viruses | 220 | 6.19e-53 | NTclustered | gi|1832330121|gb|MT310010.1| | 2202559 | g2006 | i0 | 86.111 | 0.824427480916031 | 216 | 16 | 79 | 8 | 47 | 252 | 3001 | 2790 | MAG: Microvirus sp. isolate BS1_250, complete genome | blastn | 216 | 220 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 12487005 | 12487005 | PRJNA1040136_S_NODE_2250_length_252_cov_1.949721_g2247_i0 | PRJNA1040136 | 2250 | 252 | 1.949721 | 4.91329692 | Viruses | 10239 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g2247 | i0 | 100 | 3 | 252 | 0 | 100 | 0 | 1 | 252 | 2327 | 2578 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 756 | 466 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 12923453 | 12923453 | PRJNA1040136_S_NODE_1251_length_301_cov_1.350877_g1248_i0 | PRJNA1040136 | 1251 | 301 | 1.350877 | 4.06613977 | Microvirus sp. | 2202559 | Viruses | Viruses | 484 | 2.3299999999999996e-132 | NTclustered | gi|1832330271|gb|MT310032.1| | 2202559 | g1248 | i0 | 95.681 | 3.04318936877076 | 301 | 13 | 100 | 0 | 1 | 301 | 3420 | 3120 | MAG: Microvirus sp. isolate 6538_62, complete genome | blastn | 916 | 484 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 12923454 | 12923454 | PRJNA1040136_S_NODE_2071_length_260_cov_1.000000_g2068_i0 | PRJNA1040136 | 2071 | 260 | 1 | 2.6 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.3 | 6.54e-8 | NTclustered | gi|2914864270|gb|OR222410.1| | 2832643 | g2068 | i0 | 92.308 | 19.5153846153846 | 52 | 0 | 20 | 3 | 208 | 259 | 54454 | 54501 | MAG: Caudoviricetes sp. isolate MSP0987 genomic sequence | blastn | 5074 | 71.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12923457 | 12923457 | PRJNA1040136_S_NODE_2931_length_223_cov_6.146667_g2928_i0 | PRJNA1040136 | 2931 | 223 | 6.146667 | 13.70706741 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 9.15e-6 | NTclustered | gi|2165837646|emb|OV197539.1| | 2697049 | g2928 | i0 | 91.667 | 2.96412556053812 | 48 | 1 | 21 | 3 | 2 | 47 | 32 | 78 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 661 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15035808 | 15035808 | PRJNA1040136_S_NODE_1212_length_303_cov_1.947826_g1209_i0 | PRJNA1040136 | 1212 | 303 | 1.947826 | 5.90191278 | Circovirus | 39725 | Viruses | Viruses | 556 | 4.91e-154 | NTclustered | gi|2496529047|gb|OP564891.1| | 1964372 | g1209 | i0 | 100 | 5.05940594059406 | 301 | 0 | 99 | 0 | 1 | 301 | 3682 | 3382 | Circovirus sp. strain OBP1/FE1/23/2022, complete genome | blastn | 1533 | 556 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 15035810 | 15035810 | PRJNA1040136_S_NODE_1792_length_270_cov_3.532995_g1789_i0 | PRJNA1040136 | 1792 | 270 | 3.532995 | 9.5390865 | Viruses | 10239 | Viruses | Viruses | 494 | 3.4199999999999996e-135 | NTclustered | gi|2271980621|gb|ON668995.1| | 2963861 | g1789 | i0 | 99.63 | 5 | 270 | 1 | 100 | 0 | 1 | 270 | 847 | 578 | Tick-associated circular DNA virus isolate HJMX01-1, complete genome | blastn | 1350 | 494 | 1 | Viruses | Tick-associated circular DNA virus | ||||||||
| 16310517 | 16310517 | PRJNA1040136_S_NODE_1033_length_316_cov_2.930041_g1030_i0 | PRJNA1040136 | 1033 | 316 | 2.930041 | 9.25892956 | Circovirus | 39725 | Viruses | Viruses | 558 | 1.43e-154 | NTclustered | gi|2717314922|gb|OR224879.1| | 1964372 | g1030 | i0 | 100 | 3.92405063291139 | 302 | 0 | 96 | 0 | 15 | 316 | 96 | 397 | Circovirus sp. isolate C25N74/AU, complete genome | blastn | 1240 | 558 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 16746716 | 16746716 | PRJNA1040136_S_NODE_1074_length_313_cov_0.962500_g1071_i0 | PRJNA1040136 | 1074 | 313 | 0.9625 | 3.012625 | Microviridae sp. | 2202644 | Viruses | Viruses | 163 | 1.3e-35 | NTclustered | gi|2906150692|gb|PQ646526.1| | 2202644 | g1071 | i0 | 87.586 | 1.54313099041534 | 145 | 13 | 45 | 4 | 17 | 158 | 3816 | 3674 | MAG: Microviridae sp. isolate k127_1321310 genomic sequence | blastn | 483 | 163 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23122021 | 23122021 | PRJNA1040136_S_NODE_1879_length_267_cov_1.649485_g1876_i0 | PRJNA1040136 | 1879 | 267 | 1.649485 | 4.40412495 | Microviridae sp. | 2202644 | Viruses | Viruses | 320 | 6.07e-83 | NTclustered | gi|2302017686|gb|MT205519.1| | 2202644 | g1876 | i0 | 88.636 | 3.45692883895131 | 264 | 28 | 99 | 2 | 4 | 266 | 3948 | 3686 | MAG: Microviridae sp. isolate CN7_L16_647, complete genome | blastn | 923 | 320 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23960465 | 23960465 | PRJNA1040136_S_NODE_1399_length_292_cov_1.525114_g1396_i0 | PRJNA1040136 | 1399 | 292 | 1.525114 | 4.45333288 | Viruses | 10239 | Viruses | Viruses | 414 | 2.9999999999999993e-111 | NTclustered | gi|2271980621|gb|ON668995.1| | 2963861 | g1396 | i0 | 100 | 3.85616438356164 | 224 | 0 | 77 | 0 | 19 | 242 | 95 | 318 | Tick-associated circular DNA virus isolate HJMX01-1, complete genome | blastn | 1126 | 414 | 1 | Viruses | Tick-associated circular DNA virus |
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);;