contig_metadata
29 rows where analysis = "blastn", bioproject = "PRJNA758088" and tax_kingdom = "Loebvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 737053 | 737053 | PRJNA758088_P_NODE_302441_length_249_cov_0.869318_g295470_i0 | PRJNA758088 | 302441 | 249 | 0.869318 | 2.16460182 | Inoviridae sp. | 2219103 | Viruses | Viruses | 460 | 3.16e-125 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g295470 | i0 | 100 | 3.98393574297189 | 249 | 0 | 100 | 0 | 1 | 249 | 8353 | 8105 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 992 | 460 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 738952 | 738952 | PRJNA758088_P_NODE_77801_length_482_cov_1.555012_g70837_i0 | PRJNA758088 | 77801 | 482 | 1.555012 | 7.49515784 | Inoviridae sp. | 2219103 | Viruses | Viruses | 857 | 0 | NTclustered | gi|2052974669|tpg|BK030493.1| | 2219103 | g70837 | i0 | 98.755 | 1 | 482 | 6 | 100 | 0 | 1 | 482 | 4329 | 4810 | MAG TPA_asm: Inoviridae sp. isolate ctCBR15, partial genome | blastn | 482 | 857 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1203372 | 1203372 | PRJNA758088_P_NODE_221401_length_286_cov_1.446009_g214430_i0 | PRJNA758088 | 221401 | 286 | 1.446009 | 4.13558574 | root | 1 | Root_unresolved | Root_unresolved | 523 | 4.659999999999998e-144 | NTclustered | gi|2057178442|tpg|BK058966.1| | 2219103 | g214430 | i0 | 99.65 | 4.82167832167832 | 286 | 1 | 100 | 0 | 1 | 286 | 2709 | 2994 | MAG TPA_asm: Inoviridae sp. isolate ctWC68, partial genome | blastn | 1379 | 523 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2011377 | 2011377 | PRJNA758088_P_NODE_184522_length_313_cov_0.887500_g177551_i0 | PRJNA758088 | 184522 | 313 | 0.8875 | 2.777875 | Inoviridae sp. | 2219103 | Viruses | Viruses | 568 | 2.3499999999999998e-157 | NTclustered | gi|2059872983|tpg|BK040889.1| | 2219103 | g177551 | i0 | 99.361 | 2 | 313 | 2 | 100 | 0 | 1 | 313 | 16010 | 15698 | MAG TPA_asm: Inoviridae sp. isolate ctNAv7, partial genome | blastn | 626 | 568 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2012950 | 2012950 | PRJNA758088_P_NODE_293802_length_250_cov_0.870056_g286831_i0 | PRJNA758088 | 293802 | 250 | 0.870056 | 2.17514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g286831 | i0 | 100 | 4 | 250 | 0 | 100 | 0 | 1 | 250 | 8616 | 8367 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 1000 | 462 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2014473 | 2014473 | PRJNA758088_P_NODE_52202_length_613_cov_1.420370_g45451_i0 | PRJNA758088 | 52202 | 613 | 1.42037 | 8.7068681 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1110 | 0 | NTclustered | gi|2052974669|tpg|BK030493.1| | 2219103 | g45451 | i0 | 99.347 | 1 | 613 | 4 | 100 | 0 | 1 | 613 | 3395 | 4007 | MAG TPA_asm: Inoviridae sp. isolate ctCBR15, partial genome | blastn | 613 | 1110 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 3288814 | 3288814 | PRJNA758088_P_NODE_329563_length_245_cov_0.895349_g322592_i0 | PRJNA758088 | 329563 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 388 | 1.48e-103 | NTclustered | gi|2053050784|tpg|BK024455.1| | 2219103 | g322592 | i0 | 95.473 | 0.991836734693878 | 243 | 11 | 99 | 0 | 3 | 245 | 12716 | 12958 | MAG TPA_asm: Inoviridae sp. isolate ct98p36, partial genome | blastn | 243 | 388 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 4562501 | 4562501 | PRJNA758088_P_NODE_105724_length_408_cov_0.901493_g98754_i0 | PRJNA758088 | 105724 | 408 | 0.901493 | 3.67809144 | Inoviridae sp. | 2219103 | Viruses | Viruses | 721 | 0 | NTclustered | gi|2057792455|tpg|BK054884.1| | 2219103 | g98754 | i0 | 98.529 | 1 | 408 | 6 | 100 | 0 | 1 | 408 | 2034 | 1627 | MAG TPA_asm: Inoviridae sp. isolate ctRoo2, partial genome | blastn | 408 | 721 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5842698 | 5842698 | PRJNA758088_P_NODE_85885_length_456_cov_1.005222_g78916_i0 | PRJNA758088 | 85885 | 456 | 1.005222 | 4.58381232 | Inoviridae sp. | 2219103 | Viruses | Viruses | 843 | 0 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g78916 | i0 | 100 | 5.00219298245614 | 456 | 0 | 100 | 0 | 1 | 456 | 4607 | 5062 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 2281 | 843 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 7114885 | 7114885 | PRJNA758088_P_NODE_236806_length_277_cov_1.000000_g229835_i0 | PRJNA758088 | 236806 | 277 | 1 | 2.77 | Inoviridae sp. | 2219103 | Viruses | Viruses | 484 | 2.1199999999999996e-132 | NTclustered | gi|2059729973|tpg|BK025108.1| | 2219103 | g229835 | i0 | 98.195 | 7 | 277 | 5 | 100 | 0 | 1 | 277 | 1486 | 1762 | MAG TPA_asm: Inoviridae sp. isolate ctkgu37, partial genome | blastn | 1939 | 484 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 8390818 | 8390818 | PRJNA758088_P_NODE_332287_length_245_cov_0.895349_g325316_i0 | PRJNA758088 | 332287 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 390 | 4.129999999999999e-104 | NTclustered | gi|2059740745|tpg|BK026520.1| | 2219103 | g325316 | i0 | 95.528 | 1.00408163265306 | 246 | 8 | 100 | 3 | 1 | 245 | 3010 | 3253 | MAG TPA_asm: Inoviridae sp. isolate ctx6u14, partial genome | blastn | 246 | 390 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10940713 | 10940713 | PRJNA758088_P_NODE_274629_length_254_cov_1.276243_g267658_i0 | PRJNA758088 | 274629 | 254 | 1.276243 | 3.24165722 | Inoviridae sp. | 2219103 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g267658 | i0 | 100 | 5 | 254 | 0 | 100 | 0 | 1 | 254 | 4016 | 4269 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 1270 | 470 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10941624 | 10941624 | PRJNA758088_P_NODE_334469_length_245_cov_0.895349_g327498_i0 | PRJNA758088 | 334469 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 436 | 5.229999999999999e-118 | NTclustered | gi|2056916965|tpg|BK054229.1| | 2219103 | g327498 | i0 | 98.776 | 1 | 245 | 3 | 100 | 0 | 1 | 245 | 64991 | 65235 | MAG TPA_asm: Inoviridae sp. isolate ctU8W9, partial genome | blastn | 245 | 436 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10943002 | 10943002 | PRJNA758088_P_NODE_75149_length_492_cov_1.286396_g68186_i0 | PRJNA758088 | 75149 | 492 | 1.286396 | 6.32906832 | Inoviridae sp. | 2219103 | Viruses | Viruses | 130 | 2.16e-25 | NTclustered | gi|2052974669|tpg|BK030493.1| | 2219103 | g68186 | i0 | 86.957 | 0.233739837398374 | 115 | 15 | 23 | 0 | 261 | 375 | 30 | 144 | MAG TPA_asm: Inoviridae sp. isolate ctCBR15, partial genome | blastn | 115 | 130 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 12215538 | 12215538 | PRJNA758088_P_NODE_225490_length_284_cov_1.052133_g218519_i0 | PRJNA758088 | 225490 | 284 | 1.052133 | 2.98805772 | Inoviridae sp. | 2219103 | Viruses | Viruses | 525 | 1.2899999999999994e-144 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g218519 | i0 | 100 | 2.59507042253521 | 284 | 0 | 100 | 0 | 1 | 284 | 9601 | 9318 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 737 | 525 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 12216788 | 12216788 | PRJNA758088_P_NODE_308070_length_248_cov_0.880000_g301099_i0 | PRJNA758088 | 308070 | 248 | 0.88 | 2.1824 | Inoviridae sp. | 2219103 | Viruses | Viruses | 453 | 5.2600000000000005e-123 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g301099 | i0 | 99.597 | 44.125 | 248 | 1 | 100 | 0 | 1 | 248 | 3976 | 3729 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 10943 | 453 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13491351 | 13491351 | PRJNA758088_P_NODE_333151_length_245_cov_0.895349_g326180_i0 | PRJNA758088 | 333151 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 436 | 5.229999999999999e-118 | NTclustered | gi|2059872983|tpg|BK040889.1| | 2219103 | g326180 | i0 | 98.776 | 1 | 245 | 3 | 100 | 0 | 1 | 245 | 3351 | 3107 | MAG TPA_asm: Inoviridae sp. isolate ctNAv7, partial genome | blastn | 245 | 436 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14766673 | 14766673 | PRJNA758088_P_NODE_346372_length_243_cov_0.905882_g339401_i0 | PRJNA758088 | 346372 | 243 | 0.905882 | 2.20129326 | Inoviridae sp. | 2219103 | Viruses | Viruses | 422 | 1.45e-113 | NTclustered | gi|2059749548|tpg|BK027377.1| | 2219103 | g339401 | i0 | 97.942 | 8.97530864197531 | 243 | 5 | 100 | 0 | 1 | 243 | 11030 | 11272 | MAG TPA_asm: Inoviridae sp. isolate ctDS922, partial genome | blastn | 2181 | 422 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 16040407 | 16040407 | PRJNA758088_P_NODE_345653_length_243_cov_0.905882_g338682_i0 | PRJNA758088 | 345653 | 243 | 0.905882 | 2.20129326 | Inoviridae sp. | 2219103 | Viruses | Viruses | 396 | 8.78e-106 | NTclustered | gi|2057785266|tpg|BK054778.1| | 2219103 | g338682 | i0 | 96.266 | 0.991769547325103 | 241 | 9 | 99 | 0 | 1 | 241 | 14501 | 14741 | MAG TPA_asm: Inoviridae sp. isolate ctdKr19, partial genome | blastn | 241 | 396 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17315717 | 17315717 | PRJNA758088_P_NODE_332534_length_245_cov_0.895349_g325563_i0 | PRJNA758088 | 332534 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 431 | 2.4299999999999996e-116 | NTclustered | gi|2059749548|tpg|BK027377.1| | 2219103 | g325563 | i0 | 98.367 | 9 | 245 | 4 | 100 | 0 | 1 | 245 | 7310 | 7066 | MAG TPA_asm: Inoviridae sp. isolate ctDS922, partial genome | blastn | 2205 | 431 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17316901 | 17316901 | PRJNA758088_P_NODE_62434_length_549_cov_1.086134_g55528_i0 | PRJNA758088 | 62434 | 549 | 1.086134 | 5.96287566 | Inoviridae sp. | 2219103 | Viruses | Viruses | 948 | 0 | NTclustered | gi|2052974669|tpg|BK030493.1| | 2219103 | g55528 | i0 | 97.814 | 1 | 549 | 12 | 100 | 0 | 1 | 549 | 4916 | 5464 | MAG TPA_asm: Inoviridae sp. isolate ctCBR15, partial genome | blastn | 549 | 948 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17781219 | 17781219 | PRJNA758088_P_NODE_258194_length_264_cov_1.026178_g251223_i0 | PRJNA758088 | 258194 | 264 | 1.026178 | 2.70910992 | root | 1 | Root_unresolved | Root_unresolved | 477 | 3.359999999999999e-130 | NTclustered | gi|2059701222|tpg|BK029600.1| | 2219103 | g251223 | i0 | 99.242 | 8.01515151515152 | 264 | 2 | 100 | 0 | 1 | 264 | 10455 | 10192 | MAG TPA_asm: Inoviridae sp. isolate ctp6W6, partial genome | blastn | 2116 | 477 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18587188 | 18587188 | PRJNA758088_P_NODE_187715_length_310_cov_1.299578_g180744_i0 | PRJNA758088 | 187715 | 310 | 1.299578 | 4.0286918 | Inoviridae sp. | 2219103 | Viruses | Viruses | 425 | 1.48e-114 | NTclustered | gi|2052215986|tpg|BK056409.1| | 2219103 | g180744 | i0 | 97.211 | 3.31290322580645 | 251 | 7 | 81 | 0 | 60 | 310 | 3825 | 3575 | MAG TPA_asm: Inoviridae sp. isolate ctsIl1, partial genome | blastn | 1027 | 425 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18587644 | 18587644 | PRJNA758088_P_NODE_217835_length_289_cov_0.893519_g210864_i0 | PRJNA758088 | 217835 | 289 | 0.893519 | 2.58226991 | Inoviridae sp. | 2219103 | Viruses | Viruses | 529 | 1.01e-145 | NTclustered | gi|2059740745|tpg|BK026520.1| | 2219103 | g210864 | i0 | 99.654 | 8.98961937716263 | 289 | 1 | 100 | 0 | 1 | 289 | 10231 | 9943 | MAG TPA_asm: Inoviridae sp. isolate ctx6u14, partial genome | blastn | 2598 | 529 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19861819 | 19861819 | PRJNA758088_P_NODE_149696_length_344_cov_1.749077_g142725_i0 | PRJNA758088 | 149696 | 344 | 1.749077 | 6.01682488 | Inoviridae sp. | 2219103 | Viruses | Viruses | 630 | 3.289999999999999e-176 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g142725 | i0 | 99.709 | 6.99418604651163 | 344 | 1 | 100 | 0 | 1 | 344 | 1584 | 1927 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 2406 | 630 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19862632 | 19862632 | PRJNA758088_P_NODE_205796_length_297_cov_1.031250_g198825_i0 | PRJNA758088 | 205796 | 297 | 1.03125 | 3.0628125 | Inoviridae sp. | 2219103 | Viruses | Viruses | 488 | 1.7699999999999993e-133 | NTclustered | gi|2059744995|tpg|BK026932.1| | 2219103 | g198825 | i0 | 95.793 | 4.15488215488215 | 309 | 1 | 100 | 1 | 1 | 297 | 8063 | 7755 | MAG TPA_asm: Inoviridae sp. isolate ctnlV15, partial genome | blastn | 1234 | 488 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 21139595 | 21139595 | PRJNA758088_P_NODE_298837_length_249_cov_0.875000_g291866_i0 | PRJNA758088 | 298837 | 249 | 0.875 | 2.17875 | Inoviridae sp. | 2219103 | Viruses | Viruses | 418 | 1.9299999999999995e-112 | NTclustered | gi|2052974669|tpg|BK030493.1| | 2219103 | g291866 | i0 | 98.723 | 5.72690763052209 | 235 | 3 | 94 | 0 | 1 | 235 | 27208 | 26974 | MAG TPA_asm: Inoviridae sp. isolate ctCBR15, partial genome | blastn | 1426 | 418 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 22416265 | 22416265 | PRJNA758088_P_NODE_72498_length_502_cov_1.501166_g65539_i0 | PRJNA758088 | 72498 | 502 | 1.501166 | 7.53585332 | Inoviridae sp. | 2219103 | Viruses | Viruses | 928 | 0 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g65539 | i0 | 100 | 3.44422310756972 | 502 | 0 | 100 | 0 | 1 | 502 | 6995 | 6494 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 1729 | 928 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24961711 | 24961711 | PRJNA758088_P_NODE_173000_length_322_cov_1.546185_g166029_i0 | PRJNA758088 | 173000 | 322 | 1.546185 | 4.9787157 | Inoviridae sp. | 2219103 | Viruses | Viruses | 595 | 1.1099999999999995e-165 | NTclustered | gi|2057040222|tpg|BK049269.1| | 2219103 | g166029 | i0 | 100 | 2.49068322981366 | 322 | 0 | 100 | 0 | 1 | 322 | 6056 | 6377 | MAG TPA_asm: Inoviridae sp. isolate ctMJk2, partial genome | blastn | 802 | 595 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae 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);;