contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 702116 | 702116 | PRJNA704949_P_NODE_948781_length_269_cov_1.181818_g933446_i0 | PRJNA704949 | 948781 | 269 | 1.181818 | 3.17909042 | Inoviridae sp. | 2219103 | Viruses | Viruses | 453 | 5.78e-123 | NTclustered | gi|2056867760|tpg|BK044621.1| | 2219103 | g933446 | i0 | 97.026 | 188.405204460967 | 269 | 8 | 100 | 0 | 1 | 269 | 1785 | 2053 | MAG TPA_asm: Inoviridae sp. isolate ctOUb3, partial genome | blastn | 50681 | 453 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 4514456 | 4514456 | PRJNA704949_P_NODE_1044964_length_253_cov_1.965686_g1029628_i0 | PRJNA704949 | 1044964 | 253 | 1.965686 | 4.97318558 | Inoviridae sp. | 2219103 | Viruses | Viruses | 425 | 1.17e-114 | NTclustered | gi|2057103586|tpg|BK038368.1| | 2219103 | g1029628 | i0 | 99.571 | 5.73122529644269 | 233 | 1 | 92 | 0 | 21 | 253 | 14444 | 14676 | MAG TPA_asm: Inoviridae sp. isolate ctsTY7, partial genome | blastn | 1450 | 425 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 8344777 | 8344777 | PRJNA704949_P_NODE_1699967_length_185_cov_1.161765_g1684628_i0 | PRJNA704949 | 1699967 | 185 | 1.161765 | 2.14926525 | Inoviridae sp. | 2219103 | Viruses | Viruses | 283 | 5.15e-72 | NTclustered | gi|2057880594|tpg|BK050833.1| | 2219103 | g1684628 | i0 | 97.576 | 89.1783783783784 | 165 | 4 | 89 | 0 | 1 | 165 | 14430 | 14266 | MAG TPA_asm: Inoviridae sp. isolate ctYis4, partial genome | blastn | 16498 | 283 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9617924 | 9617924 | PRJNA704949_P_NODE_1415048_length_209_cov_0.975000_g1399710_i0 | PRJNA704949 | 1415048 | 209 | 0.975 | 2.03775 | Inoviridae sp. | 2219103 | Viruses | Viruses | 159 | 1.05e-34 | NTclustered | gi|2059613483|tpg|BK037346.1| | 2219103 | g1399710 | i0 | 95.918 | 0.4688995215311 | 98 | 4 | 47 | 0 | 3 | 100 | 7081 | 6984 | MAG TPA_asm: Inoviridae sp. isolate ct4SZ4, partial genome | blastn | 98 | 159 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9619240 | 9619240 | PRJNA704949_P_NODE_158388_length_646_cov_2.755444_g144806_i0 | PRJNA704949 | 158388 | 646 | 2.755444 | 17.80016824 | Inoviridae sp. | 2219103 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2059787237|tpg|BK039469.1| | 2219103 | g144806 | i0 | 89.49 | 12.3808049535604 | 628 | 65 | 97 | 1 | 19 | 646 | 1528 | 2154 | MAG TPA_asm: Inoviridae sp. isolate ctVCf3, partial genome | blastn | 7998 | 793 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9627370 | 9627370 | PRJNA704949_P_NODE_558548_length_364_cov_1.555556_g543237_i0 | PRJNA704949 | 558548 | 364 | 1.555556 | 5.66222384 | Inoviridae sp. | 2219103 | Viruses | Viruses | 673 | 0 | NTclustered | gi|2057940741|tpg|BK045985.1| | 2219103 | g543237 | i0 | 100 | 46.1510989010989 | 364 | 0 | 100 | 0 | 1 | 364 | 5899 | 5536 | MAG TPA_asm: Inoviridae sp. isolate ctGPG1, partial genome | blastn | 16799 | 673 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 12177486 | 12177486 | PRJNA704949_P_NODE_484790_length_391_cov_2.239766_g469552_i0 | PRJNA704949 | 484790 | 391 | 2.239766 | 8.75748506 | Inoviridae sp. | 2219103 | Viruses | Viruses | 680 | 0 | NTclustered | gi|2052973664|tpg|BK030472.1| | 2219103 | g469552 | i0 | 99.73 | 0.948849104859335 | 371 | 1 | 95 | 0 | 21 | 391 | 11663 | 11293 | MAG TPA_asm: Inoviridae sp. isolate ctwRX5, partial genome | blastn | 371 | 680 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13943686 | 13943686 | PRJNA704949_P_NODE_564911_length_362_cov_1.290735_g549599_i0 | PRJNA704949 | 564911 | 362 | 1.290735 | 4.6724607 | root | 1 | Root_unresolved | Root_unresolved | 555 | 2.1499999999999998e-153 | NTclustered | gi|2059604206|tpg|BK037164.1| | 2219103 | g549599 | i0 | 97.819 | 29.8674033149171 | 321 | 7 | 89 | 0 | 20 | 340 | 6697 | 6377 | MAG TPA_asm: Inoviridae sp. isolate ctPvE6, partial genome | blastn | 10812 | 560 | 0.991071428571429 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17266560 | 17266560 | PRJNA704949_P_NODE_1318134_length_219_cov_0.917647_g1302797_i0 | PRJNA704949 | 1318134 | 219 | 0.917647 | 2.00964693 | Inoviridae sp. | 2219103 | Viruses | Viruses | 350 | 6.139999999999999e-92 | NTclustered | gi|2056895684|tpg|BK053794.1| | 2219103 | g1302797 | i0 | 95.434 | 13 | 219 | 10 | 100 | 0 | 1 | 219 | 2435 | 2653 | MAG TPA_asm: Inoviridae sp. isolate ct4zD2, partial genome | blastn | 2847 | 350 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17271816 | 17271816 | PRJNA704949_P_NODE_1987814_length_167_cov_1.491525_g1972475_i0 | PRJNA704949 | 1987814 | 167 | 1.491525 | 2.49084675 | Inoviridae sp. | 2219103 | Viruses | Viruses | 309 | 7.53e-80 | NTclustered | gi|2057940741|tpg|BK045985.1| | 2219103 | g1972475 | i0 | 100 | 45.7125748502994 | 167 | 0 | 100 | 0 | 1 | 167 | 5297 | 5463 | MAG TPA_asm: Inoviridae sp. isolate ctGPG1, partial genome | blastn | 7634 | 309 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 20314150 | 20314150 | PRJNA704949_P_NODE_189816_length_599_cov_1.994545_g175783_i0 | PRJNA704949 | 189816 | 599 | 1.994545 | 11.94732455 | Inovirus | 10861 | Viruses | Viruses | 918 | 0 | NTclustered | gi|2054444724|tpg|BK036222.1| | 2219103 | g175783 | i0 | 95.329 | 188.786310517529 | 578 | 27 | 96 | 0 | 1 | 578 | 41075 | 40498 | MAG TPA_asm: Inoviridae sp. isolate ctSjg4, partial genome | blastn | 113083 | 924 | 0.993506493506494 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24915853 | 24915853 | PRJNA704949_P_NODE_1438160_length_206_cov_2.503185_g1422822_i0 | PRJNA704949 | 1438160 | 206 | 2.503185 | 5.1565611 | Inoviridae sp. | 2219103 | Viruses | Viruses | 381 | 2.0199999999999994e-101 | NTclustered | gi|2057940741|tpg|BK045985.1| | 2219103 | g1422822 | i0 | 100 | 29.631067961165 | 206 | 0 | 100 | 0 | 1 | 206 | 5934 | 6139 | MAG TPA_asm: Inoviridae sp. isolate ctGPG1, partial genome | blastn | 6104 | 381 | 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);;