contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577101 | 577101 | PRJNA603943_P_NODE_36241_length_305_cov_1.293103_g36049_i0 | PRJNA603943 | 36241 | 305 | 1.293103 | 3.94396415 | Inoviridae sp. | 2219103 | Viruses | Viruses | 167 | 9.73e-37 | NTclustered | gi|2054534757|tpg|BK047731.1| | 2219103 | g36049 | i0 | 79.668 | 1.59672131147541 | 241 | 41 | 78 | 5 | 11 | 247 | 13247 | 13483 | MAG TPA_asm: Inoviridae sp. isolate ctrQT1, partial genome | blastn | 487 | 167 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1852919 | 1852919 | PRJNA603943_P_NODE_37562_length_300_cov_1.317181_g37370_i0 | PRJNA603943 | 37562 | 300 | 1.317181 | 3.951543 | Inoviridae sp. | 2219103 | Viruses | Viruses | 538 | 1.76e-148 | NTclustered | gi|2056827398|tpg|BK043864.1| | 2219103 | g37370 | i0 | 99 | 2.98 | 300 | 3 | 100 | 0 | 1 | 300 | 19236 | 18937 | MAG TPA_asm: Inoviridae sp. isolate ctplv73, partial genome | blastn | 894 | 538 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5681404 | 5681404 | PRJNA603943_P_NODE_55425_length_250_cov_0.870056_g55233_i0 | PRJNA603943 | 55425 | 250 | 0.870056 | 2.17514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 335 | 2.0099999999999996e-87 | NTclustered | gi|2053007724|tpg|BK016970.1| | 2219103 | g55233 | i0 | 90.8 | 5.016 | 250 | 23 | 100 | 0 | 1 | 250 | 9660 | 9909 | MAG TPA_asm: Inoviridae sp. isolate ctiSu20, partial genome | blastn | 1254 | 335 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6956328 | 6956328 | PRJNA603943_P_NODE_65506_length_244_cov_0.900585_g65314_i0 | PRJNA603943 | 65506 | 244 | 0.900585 | 2.1974274 | Inoviridae sp. | 2219103 | Viruses | Viruses | 394 | 3.17e-105 | NTclustered | gi|2057150379|tpg|BK058502.1| | 2219103 | g65314 | i0 | 99.537 | 0.885245901639344 | 216 | 1 | 89 | 0 | 29 | 244 | 12350 | 12135 | MAG TPA_asm: Inoviridae sp. isolate ctwJm14, partial genome | blastn | 216 | 394 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 7521139 | 7521139 | PRJNA603943_P_NODE_68926_length_242_cov_0.887574_g68734_i0 | PRJNA603943 | 68926 | 242 | 0.887574 | 2.14792908 | root | 1 | Root_unresolved | Root_unresolved | 272 | 1.5399999999999998e-68 | NTclustered | gi|2053007724|tpg|BK016970.1| | 2219103 | g68734 | i0 | 87.083 | 5.79338842975207 | 240 | 31 | 99 | 0 | 1 | 240 | 9915 | 10154 | MAG TPA_asm: Inoviridae sp. isolate ctiSu20, partial genome | blastn | 1402 | 272 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 8795982 | 8795982 | PRJNA603943_P_NODE_43967_length_279_cov_1.121359_g43775_i0 | PRJNA603943 | 43967 | 279 | 1.121359 | 3.12859161 | root | 1 | Root_unresolved | Root_unresolved | 483 | 7.689999999999998e-132 | NTclustered | gi|2056827398|tpg|BK043864.1| | 2219103 | g43775 | i0 | 97.849 | 2 | 279 | 6 | 100 | 0 | 1 | 279 | 228 | 506 | MAG TPA_asm: Inoviridae sp. isolate ctplv73, partial genome | blastn | 558 | 483 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14606283 | 14606283 | PRJNA603943_P_NODE_44572_length_277_cov_1.132353_g44380_i0 | PRJNA603943 | 44572 | 277 | 1.132353 | 3.13661781 | Inoviridae sp. | 2219103 | Viruses | Viruses | 512 | 9.73e-141 | NTclustered | gi|2054627565|tpg|BK022248.1| | 2219103 | g44380 | i0 | 100 | 8 | 277 | 0 | 100 | 0 | 1 | 277 | 11817 | 11541 | MAG TPA_asm: Inoviridae sp. isolate cteA81, partial genome | blastn | 2216 | 512 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14606790 | 14606790 | PRJNA603943_P_NODE_61492_length_246_cov_0.890173_g61300_i0 | PRJNA603943 | 61492 | 246 | 0.890173 | 2.18982558 | Inoviridae sp. | 2219103 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2053060158|tpg|BK024631.1| | 2219103 | g61300 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 8371 | 8126 | MAG TPA_asm: Inoviridae sp. isolate ctISv12, partial genome | blastn | 246 | 455 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17154431 | 17154431 | PRJNA603943_P_NODE_22934_length_364_cov_1.058419_g22742_i0 | PRJNA603943 | 22934 | 364 | 1.058419 | 3.85264516 | Inoviridae sp. | 2219103 | Viruses | Viruses | 488 | 2.2199999999999996e-133 | NTclustered | gi|2053078019|tpg|BK020029.1| | 2219103 | g22742 | i0 | 97.544 | 6.21978021978022 | 285 | 7 | 78 | 0 | 80 | 364 | 1759 | 2043 | MAG TPA_asm: Inoviridae sp. isolate ctuB34, partial genome | blastn | 2264 | 488 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18429803 | 18429803 | PRJNA603943_P_NODE_59375_length_247_cov_1.051724_g59183_i0 | PRJNA603943 | 59375 | 247 | 1.051724 | 2.59775828 | Inoviridae sp. | 2219103 | Viruses | Viruses | 424 | 4.1099999999999996e-114 | NTclustered | gi|2059699281|tpg|BK029575.1| | 2219103 | g59183 | i0 | 97.951 | 3.88663967611336 | 244 | 5 | 99 | 0 | 4 | 247 | 16999 | 17242 | MAG TPA_asm: Inoviridae sp. isolate ct4hP2, partial genome | blastn | 960 | 424 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18994646 | 18994646 | PRJNA603943_P_NODE_48035_length_266_cov_1.129534_g47843_i0 | PRJNA603943 | 48035 | 266 | 1.129534 | 3.00456044 | root | 1 | Root_unresolved | Root_unresolved | 475 | 1.2199999999999997e-129 | NTclustered | gi|2050460370|tpg|BK059151.1| | 2219103 | g47843 | i0 | 98.872 | 3.83082706766917 | 266 | 3 | 100 | 0 | 1 | 266 | 7850 | 8115 | MAG TPA_asm: Inoviridae sp. isolate ctUVL21 genomic sequence, sequence | blastn | 1019 | 475 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 20980337 | 20980337 | PRJNA603943_P_NODE_68877_length_242_cov_0.905325_g68685_i0 | PRJNA603943 | 68877 | 242 | 0.905325 | 2.1908865 | Inoviridae sp. | 2219103 | Viruses | Viruses | 359 | 1.15e-94 | NTclustered | gi|2059741787|tpg|BK026610.1| | 2219103 | g68685 | i0 | 98.522 | 2.5702479338843 | 203 | 3 | 99 | 0 | 2 | 204 | 2814 | 2612 | MAG TPA_asm: Inoviridae sp. isolate ctTsM18, partial genome | blastn | 622 | 359 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23529258 | 23529258 | PRJNA603943_P_NODE_25039_length_352_cov_1.103943_g24847_i0 | PRJNA603943 | 25039 | 352 | 1.103943 | 3.88587936 | Inoviridae sp. | 2219103 | Viruses | Viruses | 645 | 1.2e-180 | NTclustered | gi|2054627565|tpg|BK022248.1| | 2219103 | g24847 | i0 | 99.716 | 7.33238636363636 | 352 | 1 | 100 | 0 | 1 | 352 | 12195 | 11844 | MAG TPA_asm: Inoviridae sp. isolate cteA81, partial genome | blastn | 2581 | 645 | 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);;