contig_metadata
11 rows where bioproject = "PRJNA599208" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 572294 | 572294 | PRJNA599208_P_NODE_8261_length_250_cov_1.281690_g8065_i0 | PRJNA599208 | 8261 | 250 | 1.28169 | 3.204225 | Tolivirales sp. | 2809914 | Viruses | Viruses | 159 | 1.5599999999999999e-43 | NR | WRQ65630.1 | 2809914 | g8065 | i0 | 85.4 | 1.956 | 82 | 12 | 98.4 | 0 | 3 | 248 | 365 | 446 | WRQ65630.1 polyprotein, partial [Tolivirales sp.] | diamond | 489 | 159 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 3123254 | 3123254 | PRJNA599208_P_NODE_8283_length_249_cov_2.669811_g8087_i0 | PRJNA599208 | 8283 | 249 | 2.669811 | 6.64782939 | Reagent-associated tombus-like virus 1 | 2875818 | Viruses | Viruses | 433 | 6.89e-117 | NTclustered | gi|2094552980|gb|MZ824229.1| | 2875818 | g8087 | i0 | 98.765 | 1.24899598393574 | 243 | 3 | 98 | 0 | 1 | 243 | 243 | 1 | Reagent-associated tombus-like virus 1 isolate 3 replicase-like gene, partial sequence | blastn | 311 | 433 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 1 | |||
| 4399880 | 4399880 | PRJNA599208_P_NODE_14424_length_166_cov_1.914729_g14228_i0 | PRJNA599208 | 14424 | 166 | 1.914729 | 3.17845014 | Reagent-associated tombus-like virus 4 | 2875821 | Viruses | Viruses | 307 | 2.69e-79 | NTclustered | gi|2094552977|gb|MZ824226.1| | 2875821 | g14228 | i0 | 100 | 1 | 166 | 0 | 100 | 0 | 1 | 166 | 374 | 539 | Reagent-associated tombus-like virus 4 isolate 6 replicase-like gene, partial sequence | blastn | 166 | 307 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 4 | |||
| 6950569 | 6950569 | PRJNA599208_P_NODE_8686_length_240_cov_1.724138_g8490_i0 | PRJNA599208 | 8686 | 240 | 1.724138 | 4.1379312 | Reagent-associated tombus-like virus 3 | 2875820 | Viruses | Viruses | 307 | 4.17e-79 | NTclustered | gi|2094552978|gb|MZ824227.1| | 2875820 | g8490 | i0 | 98.286 | 0.729166666666667 | 175 | 3 | 73 | 0 | 1 | 175 | 175 | 1 | Reagent-associated tombus-like virus 3 isolate 5 replicase-like gene, partial sequence | blastn | 175 | 307 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 3 | |||
| 12051320 | 12051320 | PRJNA599208_P_NODE_10350_length_211_cov_1.114943_g10154_i0 | PRJNA599208 | 10350 | 211 | 1.114943 | 2.35252973 | Reagent-associated tombus-like virus 3 | 2875820 | Viruses | Viruses | 379 | 7.489999999999999e-101 | NTclustered | gi|2094552978|gb|MZ824227.1| | 2875820 | g10154 | i0 | 99.052 | 1 | 211 | 2 | 100 | 0 | 1 | 211 | 1281 | 1491 | Reagent-associated tombus-like virus 3 isolate 5 replicase-like gene, partial sequence | blastn | 211 | 379 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 3 | |||
| 12051353 | 12051353 | PRJNA599208_P_NODE_13830_length_171_cov_1.141791_g13634_i0 | PRJNA599208 | 13830 | 171 | 1.141791 | 1.95246261 | Reagent-associated tombus-like virus 3 | 2875820 | Viruses | Viruses | 311 | 2.14e-80 | NTclustered | gi|2094552978|gb|MZ824227.1| | 2875820 | g13634 | i0 | 99.415 | 1 | 171 | 1 | 100 | 0 | 1 | 171 | 803 | 973 | Reagent-associated tombus-like virus 3 isolate 5 replicase-like gene, partial sequence | blastn | 171 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 3 | |||
| 14601182 | 14601182 | PRJNA599208_P_NODE_6692_length_292_cov_1.352941_g6496_i0 | PRJNA599208 | 6692 | 292 | 1.352941 | 3.95058772 | Reagent-associated tombus-like virus 1 | 2875818 | Viruses | Viruses | 531 | 2.85e-146 | NTclustered | gi|2094552980|gb|MZ824229.1| | 2875818 | g6496 | i0 | 99.655 | 0.993150684931507 | 290 | 1 | 99 | 0 | 1 | 290 | 480 | 769 | Reagent-associated tombus-like virus 1 isolate 3 replicase-like gene, partial sequence | blastn | 290 | 531 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 1 | |||
| 17149788 | 17149788 | PRJNA599208_P_NODE_10654_length_206_cov_1.863905_g10458_i0 | PRJNA599208 | 10654 | 206 | 1.863905 | 3.8396443 | Reagent-associated tombus-like virus 4 | 2875821 | Viruses | Viruses | 381 | 2.0199999999999994e-101 | NTclustered | gi|2094552977|gb|MZ824226.1| | 2875821 | g10458 | i0 | 100 | 1 | 206 | 0 | 100 | 0 | 1 | 206 | 853 | 1058 | Reagent-associated tombus-like virus 4 isolate 6 replicase-like gene, partial sequence | blastn | 206 | 381 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 4 | |||
| 23524711 | 23524711 | PRJNA599208_P_NODE_9799_length_219_cov_2.214286_g9603_i0 | PRJNA599208 | 9799 | 219 | 2.214286 | 4.84928634 | Reagent-associated tombus-like virus 1 | 2875818 | Viruses | Viruses | 405 | 1.29e-108 | NTclustered | gi|2094552980|gb|MZ824229.1| | 2875818 | g9603 | i0 | 100 | 1 | 219 | 0 | 100 | 0 | 1 | 219 | 1147 | 929 | Reagent-associated tombus-like virus 1 isolate 3 replicase-like gene, partial sequence | blastn | 219 | 405 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 1 | |||
| 26699862 | 26699862 | PRJNA599208_P_NODE_10401_length_210_cov_1.341040_g10205_i0 | PRJNA599208 | 10401 | 210 | 1.34104 | 2.816184 | Qianjiang tombus-like virus 232 | 3347905 | Viruses | Viruses | 69.7 | 4.88e-12 | NR | XHA86950.1 | 3347905 | g10205 | i0 | 51.4 | 1 | 70 | 30 | 98.6 | 2 | 208 | 2 | 215 | 281 | XHA86950.1 MAG: hypothetical protein [Qianjiang tombus-like virus 232] | diamond | 210 | 69.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 232 | |||
| 31913187 | 31913187 | PRJNA599208_P_NODE_15097_length_161_cov_1.233871_g14901_i0 | PRJNA599208 | 15097 | 161 | 1.233871 | 1.98653231 | Qianjiang tombus-like virus 324 | 3348008 | Viruses | Viruses | 64.3 | 1.42e-10 | NR | XHA87152.1 | 3348008 | g14901 | i0 | 67.4 | 0.857142857142857 | 46 | 14 | 83.9 | 1 | 135 | 1 | 197 | 242 | XHA87152.1 MAG: hypothetical protein [Qianjiang tombus-like virus 324] | diamond | 138 | 64.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 324 |
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);;