contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281641 | 281641 | PRJNA1126198_P_NODE_423441_length_246_cov_1.508671_g422720_i0 | PRJNA1126198 | 423441 | 246 | 1.508671 | 3.71133066 | Inoviridae sp. | 2219103 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2056890097|tpg|BK053677.1| | 2219103 | g422720 | i0 | 100 | 5.14634146341463 | 246 | 0 | 100 | 0 | 1 | 246 | 6897 | 6652 | MAG TPA_asm: Inoviridae sp. isolate ctMlF9, partial genome | blastn | 1266 | 455 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2831939 | 2831939 | PRJNA1126198_P_NODE_23543_length_474_cov_1.052369_g22845_i0 | PRJNA1126198 | 23543 | 474 | 1.052369 | 4.98822906 | Inoviridae sp. | 2219103 | Viruses | Viruses | 529 | 1.7499999999999993e-145 | NTclustered | gi|2057936157|tpg|BK045885.1| | 2219103 | g22845 | i0 | 92.722 | 25.4177215189873 | 371 | 19 | 78 | 6 | 1 | 368 | 21139 | 20774 | MAG TPA_asm: Inoviridae sp. isolate cthsW4, partial genome | blastn | 12048 | 529 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 4108750 | 4108750 | PRJNA1126198_P_NODE_455344_length_243_cov_1.370588_g454623_i0 | PRJNA1126198 | 455344 | 243 | 1.370588 | 3.33052884 | Inoviridae sp. | 2219103 | Viruses | Viruses | 372 | 1.48e-98 | NTclustered | gi|2057940741|tpg|BK045985.1| | 2219103 | g454623 | i0 | 94.239 | 1.48559670781893 | 243 | 14 | 100 | 0 | 1 | 243 | 9517 | 9275 | MAG TPA_asm: Inoviridae sp. isolate ctGPG1, partial genome | blastn | 361 | 372 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10484545 | 10484545 | PRJNA1126198_P_NODE_11209_length_574_cov_2.512974_g10536_i0 | PRJNA1126198 | 11209 | 574 | 2.512974 | 14.42447076 | Inoviridae sp. | 2219103 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g10536 | i0 | 90.815 | 1.0052264808362401 | 577 | 47 | 100 | 5 | 1 | 574 | 3807 | 3234 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 577 | 767 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11760373 | 11760373 | PRJNA1126198_P_NODE_469190_length_242_cov_0.923077_g468469_i0 | PRJNA1126198 | 469190 | 242 | 0.923077 | 2.23384634 | Inoviridae sp. | 2219103 | Viruses | Viruses | 254 | 5.57e-63 | NTclustered | gi|2058066295|tpg|BK042848.1| | 2219103 | g468469 | i0 | 85.597 | 1.00413223140496 | 243 | 33 | 100 | 2 | 1 | 242 | 394 | 635 | MAG TPA_asm: Inoviridae sp. isolate ctlXs1, partial genome | blastn | 243 | 254 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14310648 | 14310648 | PRJNA1126198_P_NODE_46712_length_404_cov_1.401813_g45995_i0 | PRJNA1126198 | 46712 | 404 | 1.401813 | 5.66332452 | Inoviridae sp. | 2219103 | Viruses | Viruses | 603 | 8.53e-168 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g45995 | i0 | 93.564 | 1 | 404 | 26 | 100 | 0 | 1 | 404 | 332 | 735 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 404 | 603 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15584351 | 15584351 | PRJNA1126198_P_NODE_33273_length_436_cov_1.964187_g32564_i0 | PRJNA1126198 | 33273 | 436 | 1.964187 | 8.56385532 | Inoviridae sp. | 2219103 | Viruses | Viruses | 425 | 2.15e-114 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g32564 | i0 | 94.853 | 1.22706422018349 | 272 | 14 | 99 | 0 | 1 | 272 | 4688 | 4417 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 535 | 425 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 21957901 | 21957901 | PRJNA1126198_P_NODE_14878_length_531_cov_1.569869_g14193_i0 | PRJNA1126198 | 14878 | 531 | 1.569869 | 8.33600439 | Inoviridae sp. | 2219103 | Viruses | Viruses | 566 | 1.51e-156 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g14193 | i0 | 86.09 | 1.00188323917137 | 532 | 66 | 99 | 7 | 3 | 531 | 5963 | 6489 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 532 | 566 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23233715 | 23233715 | PRJNA1126198_P_NODE_305519_length_264_cov_1.910995_g304798_i0 | PRJNA1126198 | 305519 | 264 | 1.910995 | 5.0450268 | Inoviridae sp. | 2219103 | Viruses | Viruses | 339 | 1.65e-88 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g304798 | i0 | 89.773 | 1 | 264 | 27 | 100 | 0 | 1 | 264 | 987 | 1250 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 264 | 339 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24507241 | 24507241 | PRJNA1126198_P_NODE_261180_length_275_cov_1.534653_g260459_i0 | PRJNA1126198 | 261180 | 275 | 1.534653 | 4.22029575 | Inoviridae sp. | 2219103 | Viruses | Viruses | 333 | 8.06e-87 | NTclustered | gi|2054750353|tpg|BK043403.1| | 2219103 | g260459 | i0 | 88.489 | 1.01090909090909 | 278 | 29 | 100 | 1 | 1 | 275 | 5694 | 5971 | MAG TPA_asm: Inoviridae sp. isolate ctqQ43, partial genome | blastn | 278 | 333 | 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);;