contig_metadata
5 rows where bioproject = "PRJNA1237347", tax_kingdom = "Loebvirae" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16919170 | 16919170 | PRJNA1237347_P_NODE_376734_length_289_cov_3.217593_g370161_i0 | PRJNA1237347 | 376734 | 289 | 3.217593 | 9.29884377 | Inoviridae sp. | 2219103 | Viruses | Viruses | 248 | 3.18e-61 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g370161 | i0 | 96.053 | 56.0207612456747 | 152 | 6 | 53 | 0 | 136 | 287 | 839 | 990 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 16190 | 248 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 22021865 | 22021865 | PRJNA1237347_P_NODE_541118_length_243_cov_0.888235_g534545_i0 | PRJNA1237347 | 541118 | 243 | 0.888235 | 2.15841105 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 274 | 4.29e-69 | NTclustered | gi|2906153236|gb|PQ646714.1| | 2833306 | g534545 | i0 | 89.401 | 0.893004115226337 | 217 | 23 | 89 | 0 | 25 | 241 | 7261 | 7477 | MAG: Tubulavirales sp. isolate k127_4197263 genomic sequence | blastn | 217 | 274 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales sp. | ||||
| 23291061 | 23291061 | PRJNA1237347_P_NODE_210819_length_418_cov_10.055072_g204247_i0 | PRJNA1237347 | 210819 | 418 | 10.055072 | 42.03020096 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 344 | 5.93e-90 | NTclustered | gi|2906144217|gb|PQ646103.1| | 2833306 | g204247 | i0 | 83.646 | 0.892344497607656 | 373 | 54 | 88 | 5 | 5 | 371 | 3183 | 2812 | MAG: Tubulavirales sp. isolate k127_834485 genomic sequence | blastn | 373 | 344 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales sp. | ||||
| 24565572 | 24565572 | PRJNA1237347_P_NODE_24100_length_1601_cov_1.920157_g21116_i0 | PRJNA1237347 | 24100 | 1601 | 1.920157 | 30.74171357 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1788 | 0 | NTclustered | gi|2052176507|tpg|BK033134.1| | 2219103 | g21116 | i0 | 93.703 | 1.0474703310431 | 1207 | 55 | 82 | 1 | 274 | 1459 | 475 | 1681 | MAG TPA_asm: Inoviridae sp. isolate ctFpB4, partial genome | blastn | 1677 | 1788 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24568632 | 24568632 | PRJNA1237347_P_NODE_395980_length_281_cov_1.725962_g389407_i0 | PRJNA1237347 | 395980 | 281 | 1.725962 | 4.84995322 | Inoviridae sp. | 2219103 | Viruses | Viruses | 141 | 5.37e-29 | NTclustered | gi|2906153792|gb|PQ646750.1| | 2219103 | g389407 | i0 | 88.235 | 0.95729537366548 | 119 | 13 | 42 | 1 | 82 | 200 | 4280 | 4397 | MAG: Inoviridae sp. isolate k127_1439344 genomic sequence | blastn | 269 | 141 | 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);;