contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1013345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1002478 | 1002478 | PRJNA1013345_P_NODE_11821_length_193_cov_3.143836_g11691_i0 | PRJNA1013345 | 11821 | 193 | 3.143836 | 6.06760348 | Viruses | 10239 | Viruses | Viruses | 357 | 3.1499999999999996e-94 | NTclustered | gi|2054444724|tpg|BK036222.1| | 2219103 | g11691 | i0 | 100 | 100.39378238342 | 193 | 0 | 100 | 0 | 1 | 193 | 5772 | 5580 | MAG TPA_asm: Inoviridae sp. isolate ctSjg4, partial genome | blastn | 19376 | 357 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1432893 | 1432893 | PRJNA1013345_P_NODE_11162_length_197_cov_1.360000_g11032_i0 | PRJNA1013345 | 11162 | 197 | 1.36 | 2.6792 | Inoviridae sp. | 2219103 | Viruses | Viruses | 364 | 1.929999999999999e-96 | NTclustered | gi|2059813419|tpg|BK039887.1| | 2219103 | g11032 | i0 | 100 | 5.95939086294416 | 197 | 0 | 100 | 0 | 1 | 197 | 1804 | 1608 | MAG TPA_asm: Inoviridae sp. isolate ct5Qd9, partial genome | blastn | 1174 | 364 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2277614 | 2277614 | PRJNA1013345_P_NODE_14562_length_183_cov_2.411765_g14432_i0 | PRJNA1013345 | 14562 | 183 | 2.411765 | 4.41352995 | Viruses | 10239 | Viruses | Viruses | 339 | 1.07e-88 | NTclustered | gi|2054444724|tpg|BK036222.1| | 2219103 | g14432 | i0 | 100 | 16.9289617486339 | 183 | 0 | 100 | 0 | 1 | 183 | 8666 | 8848 | MAG TPA_asm: Inoviridae sp. isolate ctSjg4, partial genome | blastn | 3098 | 339 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2708649 | 2708649 | PRJNA1013345_P_NODE_24083_length_164_cov_1.743590_g23953_i0 | PRJNA1013345 | 24083 | 164 | 1.74359 | 2.8594876 | Inoviridae sp. | 2219103 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|2054428949|tpg|BK035896.1| | 2219103 | g23953 | i0 | 100 | 16.719512195122 | 164 | 0 | 100 | 0 | 1 | 164 | 1619 | 1456 | MAG TPA_asm: Inoviridae sp. isolate ctppP11, partial genome | blastn | 2742 | 303 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11637023 | 11637023 | PRJNA1013345_P_NODE_29310_length_159_cov_1.928571_g29180_i0 | PRJNA1013345 | 29310 | 159 | 1.928571 | 3.06642789 | Inoviridae sp. | 2219103 | Viruses | Viruses | 278 | 2e-70 | NTclustered | gi|2059813419|tpg|BK039887.1| | 2219103 | g29180 | i0 | 98.113 | 22.251572327044 | 159 | 3 | 100 | 0 | 1 | 159 | 4085 | 3927 | MAG TPA_asm: Inoviridae sp. isolate ct5Qd9, partial genome | blastn | 3538 | 278 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13755918 | 13755918 | PRJNA1013345_P_NODE_22931_length_165_cov_2.313559_g22801_i0 | PRJNA1013345 | 22931 | 165 | 2.313559 | 3.81737235 | Viruses | 10239 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|2054640328|tpg|BK051800.1| | 2219103 | g22801 | i0 | 100 | 17.4969696969697 | 165 | 0 | 100 | 0 | 1 | 165 | 4926 | 5090 | MAG TPA_asm: Inoviridae sp. isolate ctJG56, partial genome | blastn | 2887 | 305 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15460813 | 15460813 | PRJNA1013345_P_NODE_15913_length_180_cov_2.300752_g15783_i0 | PRJNA1013345 | 15913 | 180 | 2.300752 | 4.1413536 | Inoviridae sp. | 2219103 | Viruses | Viruses | 311 | 2.28e-80 | NTclustered | gi|2054428949|tpg|BK035896.1| | 2219103 | g15783 | i0 | 97.778 | 22.7888888888889 | 180 | 4 | 100 | 0 | 1 | 180 | 15986 | 16165 | MAG TPA_asm: Inoviridae sp. isolate ctppP11, partial genome | blastn | 4102 | 311 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18010406 | 18010406 | PRJNA1013345_P_NODE_8175_length_221_cov_1.482759_g8045_i0 | PRJNA1013345 | 8175 | 221 | 1.482759 | 3.27689739 | Inoviridae sp. | 2219103 | Viruses | Viruses | 353 | 4.789999999999999e-93 | NTclustered | gi|2058097480|tpg|BK033507.1| | 2219103 | g8045 | i0 | 95.475 | 21.158371040724 | 221 | 10 | 100 | 0 | 1 | 221 | 7025 | 6805 | MAG TPA_asm: Inoviridae sp. isolate ct7Qh16, partial genome | blastn | 4676 | 353 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19284098 | 19284098 | PRJNA1013345_P_NODE_33716_length_152_cov_2.523810_g33586_i0 | PRJNA1013345 | 33716 | 152 | 2.52381 | 3.8361912 | Inoviridae sp. | 2219103 | Viruses | Viruses | 243 | 6.87e-60 | NTclustered | gi|2054515042|tpg|BK047337.1| | 2219103 | g33586 | i0 | 95.425 | 2.01315789473684 | 153 | 6 | 100 | 1 | 1 | 152 | 11095 | 10943 | MAG TPA_asm: Inoviridae sp. isolate ct0Mx9, partial genome | blastn | 306 | 243 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23110424 | 23110424 | PRJNA1013345_P_NODE_12959_length_187_cov_2.914286_g12829_i0 | PRJNA1013345 | 12959 | 187 | 2.914286 | 5.44971482 | Inoviridae sp. | 2219103 | Viruses | Viruses | 329 | 6.6e-86 | NTclustered | gi|2057880594|tpg|BK050833.1| | 2219103 | g12829 | i0 | 99.448 | 17.6310160427808 | 181 | 1 | 97 | 0 | 1 | 181 | 3381 | 3561 | MAG TPA_asm: Inoviridae sp. isolate ctYis4, partial genome | blastn | 3297 | 329 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23110785 | 23110785 | PRJNA1013345_P_NODE_4239_length_290_cov_1.263374_g4110_i0 | PRJNA1013345 | 4239 | 290 | 1.263374 | 3.6637846 | Inoviridae sp. | 2219103 | Viruses | Viruses | 531 | 2.83e-146 | NTclustered | gi|2050464316|tpg|BK016829.1| | 2219103 | g4110 | i0 | 99.655 | 97.0103448275862 | 290 | 1 | 100 | 0 | 1 | 290 | 807 | 518 | MAG TPA_asm: Inoviridae sp. isolate ctEAr15, partial genome | blastn | 28133 | 531 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24384223 | 24384223 | PRJNA1013345_P_NODE_13220_length_186_cov_2.992806_g13090_i0 | PRJNA1013345 | 13220 | 186 | 2.992806 | 5.56661916 | Inoviridae sp. | 2219103 | Viruses | Viruses | 305 | 1.11e-78 | NTclustered | gi|2057880594|tpg|BK050833.1| | 2219103 | g13090 | i0 | 96.237 | 18 | 186 | 7 | 100 | 0 | 1 | 186 | 8406 | 8591 | MAG TPA_asm: Inoviridae sp. isolate ctYis4, partial genome | blastn | 3348 | 305 | 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);;