contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA716463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7086370 | 7086370 | PRJNA716463_P_NODE_24486_length_310_cov_3.037975_g24069_i0 | PRJNA716463 | 24486 | 310 | 3.037975 | 9.4177225 | Inoviridae sp. | 2219103 | Viruses | Viruses | 255 | 2.06e-63 | NTclustered | gi|2056866535|tpg|BK044602.1| | 2219103 | g24069 | i0 | 97.333 | 2.70645161290323 | 150 | 4 | 72 | 0 | 161 | 310 | 49588 | 49737 | MAG TPA_asm: Inoviridae sp. isolate ct5hk1, partial genome | blastn | 839 | 255 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13461290 | 13461290 | PRJNA716463_P_NODE_20991_length_310_cov_3.527426_g20574_i0 | PRJNA716463 | 20991 | 310 | 3.527426 | 10.9350206 | Inoviridae sp. | 2219103 | Viruses | Viruses | 272 | 2.04e-68 | NTclustered | gi|2056866535|tpg|BK044602.1| | 2219103 | g20574 | i0 | 99.333 | 2.90967741935484 | 150 | 1 | 97 | 0 | 161 | 310 | 57489 | 57340 | MAG TPA_asm: Inoviridae sp. isolate ct5hk1, partial genome | blastn | 902 | 272 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14737006 | 14737006 | PRJNA716463_P_NODE_48592_length_291_cov_3.637615_g48175_i0 | PRJNA716463 | 48592 | 291 | 3.637615 | 10.58545965 | Inoviridae sp. | 2219103 | Viruses | Viruses | 538 | 1.6999999999999994e-148 | NTclustered | gi|2057831706|tpg|BK055554.1| | 2219103 | g48175 | i0 | 100 | 75.0378006872852 | 291 | 0 | 100 | 0 | 1 | 291 | 3145 | 2855 | MAG TPA_asm: Inoviridae sp. isolate ctTZp11, partial genome | blastn | 21836 | 538 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17286792 | 17286792 | PRJNA716463_P_NODE_93654_length_257_cov_2.195652_g93237_i0 | PRJNA716463 | 93654 | 257 | 2.195652 | 5.64282564 | Inoviridae sp. | 2219103 | Viruses | Viruses | 250 | 7.72e-62 | NTclustered | gi|2059777179|tpg|BK039263.1| | 2219103 | g93237 | i0 | 84.314 | 6.53307392996109 | 255 | 40 | 99 | 0 | 1 | 255 | 584 | 838 | MAG TPA_asm: Inoviridae sp. isolate ctaGf1, partial genome | blastn | 1679 | 250 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18560386 | 18560386 | PRJNA716463_P_NODE_79615_length_269_cov_1.418367_g79198_i0 | PRJNA716463 | 79615 | 269 | 1.418367 | 3.81540723 | Inoviridae sp. | 2219103 | Viruses | Viruses | 414 | 2.73e-111 | NTclustered | gi|2056866535|tpg|BK044602.1| | 2219103 | g79198 | i0 | 94.424 | 3 | 269 | 15 | 100 | 0 | 1 | 269 | 71037 | 70769 | MAG TPA_asm: Inoviridae sp. isolate ct5hk1, partial genome | blastn | 807 | 414 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18560492 | 18560492 | PRJNA716463_P_NODE_86195_length_263_cov_3.573684_g85778_i0 | PRJNA716463 | 86195 | 263 | 3.573684 | 9.39878892 | Inoviridae sp. | 2219103 | Viruses | Viruses | 453 | 5.63e-123 | NTclustered | gi|2056866535|tpg|BK044602.1| | 2219103 | g85778 | i0 | 97.719 | 2.99619771863118 | 263 | 6 | 100 | 0 | 1 | 263 | 54759 | 54497 | MAG TPA_asm: Inoviridae sp. isolate ct5hk1, partial genome | blastn | 788 | 453 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19045009 | 19045009 | PRJNA716463_P_NODE_99355_length_251_cov_5.348315_g98938_i0 | PRJNA716463 | 99355 | 251 | 5.348315 | 13.42427065 | root | 1 | Root_unresolved | Root_unresolved | 375 | 1.1899999999999998e-99 | NTclustered | gi|2056837707|tpg|BK044060.1| | 2219103 | g98938 | i0 | 93.625 | 8.0597609561753 | 251 | 16 | 100 | 0 | 1 | 251 | 3430 | 3680 | MAG TPA_asm: Inoviridae sp. isolate ctXjl4, partial genome | blastn | 2023 | 375 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19834968 | 19834968 | PRJNA716463_P_NODE_49716_length_290_cov_4.539171_g49299_i0 | PRJNA716463 | 49716 | 290 | 4.539171 | 13.1635959 | Inoviridae sp. | 2219103 | Viruses | Viruses | 250 | 8.87e-62 | NTclustered | gi|2056866535|tpg|BK044602.1| | 2219103 | g49299 | i0 | 96.104 | 3.07241379310345 | 154 | 5 | 100 | 1 | 138 | 290 | 66657 | 66810 | MAG TPA_asm: Inoviridae sp. isolate ct5hk1, partial genome | blastn | 891 | 250 | 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);;