contig_metadata
17 rows where bioproject = "PRJNA1123436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 279932 | 279932 | PRJNA1123436_P_NODE_51881_length_347_cov_0.872263_g50667_i0 | PRJNA1123436 | 51881 | 347 | 0.872263 | 3.02675261 | Inoviridae sp. | 2219103 | Viruses | Viruses | 630 | 3.319999999999999e-176 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g50667 | i0 | 99.424 | 2 | 347 | 2 | 100 | 0 | 1 | 347 | 962 | 616 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 694 | 630 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 280730 | 280730 | PRJNA1123436_P_NODE_91961_length_256_cov_1.158470_g90747_i0 | PRJNA1123436 | 91961 | 256 | 1.1584700000000001 | 2.9656832 | Inoviridae sp. | 2219103 | Viruses | Viruses | 446 | 9.139999999999999e-121 | NTclustered | gi|2057090093|tpg|BK038098.1| | 2219103 | g90747 | i0 | 98.047 | 1 | 256 | 5 | 100 | 0 | 1 | 256 | 969 | 1224 | MAG TPA_asm: Inoviridae sp. isolate ctlQH11, partial genome | blastn | 256 | 446 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2830567 | 2830567 | PRJNA1123436_P_NODE_52623_length_344_cov_1.136531_g51409_i0 | PRJNA1123436 | 52623 | 344 | 1.136531 | 3.90966664 | Inoviridae sp. | 2219103 | Viruses | Viruses | 636 | 7.059999999999998e-178 | NTclustered | gi|2052892616|tpg|BK017517.1| | 2219103 | g51409 | i0 | 100 | 1.98837209302326 | 344 | 0 | 100 | 0 | 1 | 344 | 8906 | 8563 | MAG TPA_asm: Inoviridae sp. isolate ctma920, partial genome | blastn | 684 | 636 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5383339 | 5383339 | PRJNA1123436_P_NODE_6525_length_1181_cov_1.848375_g5679_i0 | PRJNA1123436 | 6525 | 1181 | 1.848375 | 21.82930875 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1982 | 0 | NTclustered | gi|2052885848|tpg|BK017376.1| | 2219103 | g5679 | i0 | 97.263 | 0.989839119390347 | 1169 | 32 | 99 | 0 | 13 | 1181 | 31235 | 30067 | MAG TPA_asm: Inoviridae sp. isolate ctt7x1, partial genome | blastn | 1169 | 1982 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5383987 | 5383987 | PRJNA1123436_P_NODE_99065_length_250_cov_0.870056_g97851_i0 | PRJNA1123436 | 99065 | 250 | 0.870056 | 2.17514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 440 | 4.1399999999999976e-119 | NTclustered | gi|2057046081|tpg|BK049376.1| | 2219103 | g97851 | i0 | 98.4 | 5.992 | 250 | 4 | 100 | 0 | 1 | 250 | 7227 | 6978 | MAG TPA_asm: Inoviridae sp. isolate ctkNc15, partial genome | blastn | 1498 | 440 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6656613 | 6656613 | PRJNA1123436_P_NODE_104566_length_248_cov_0.880000_g103352_i0 | PRJNA1123436 | 104566 | 248 | 0.88 | 2.1824 | Inoviridae sp. | 2219103 | Viruses | Viruses | 331 | 2.57e-86 | NTclustered | gi|2059562607|tpg|BK036347.1| | 2219103 | g103352 | i0 | 90.726 | 3 | 248 | 23 | 100 | 0 | 1 | 248 | 13936 | 13689 | MAG TPA_asm: Inoviridae sp. isolate ctdOu2, partial genome | blastn | 744 | 331 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6657982 | 6657982 | PRJNA1123436_P_NODE_6526_length_1181_cov_1.639892_g5679_i1 | PRJNA1123436 | 6526 | 1181 | 1.639892 | 19.36712452 | Inoviridae sp. | 2219103 | Viruses | Viruses | 2015 | 0 | NTclustered | gi|2052885848|tpg|BK017376.1| | 2219103 | g5679 | i1 | 97.776 | 0.989839119390347 | 1169 | 26 | 99 | 0 | 13 | 1181 | 31235 | 30067 | MAG TPA_asm: Inoviridae sp. isolate ctt7x1, partial genome | blastn | 1169 | 2015 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6657989 | 6657989 | PRJNA1123436_P_NODE_65726_length_308_cov_0.855319_g64512_i0 | PRJNA1123436 | 65726 | 308 | 0.855319 | 2.63438252 | Inoviridae sp. | 2219103 | Viruses | Viruses | 145 | 4.61e-30 | NTclustered | gi|2057090093|tpg|BK038098.1| | 2219103 | g64512 | i0 | 83.439 | 31.8246753246753 | 157 | 24 | 51 | 2 | 140 | 295 | 7165 | 7010 | MAG TPA_asm: Inoviridae sp. isolate ctlQH11, partial genome | blastn | 9802 | 145 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 7407856 | 7407856 | PRJNA1123436_P_NODE_89526_length_260_cov_1.572193_g88312_i0 | PRJNA1123436 | 89526 | 260 | 1.572193 | 4.0877018 | Viruses | 10239 | Viruses | Viruses | 459 | 1.19e-124 | NTclustered | gi|2053060158|tpg|BK024631.1| | 2219103 | g88312 | i0 | 98.462 | 2.51538461538462 | 260 | 4 | 100 | 0 | 1 | 260 | 47242 | 46983 | MAG TPA_asm: Inoviridae sp. isolate ctISv12, partial genome | blastn | 654 | 459 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11757503 | 11757503 | PRJNA1123436_P_NODE_115170_length_245_cov_0.895349_g113956_i0 | PRJNA1123436 | 115170 | 245 | 0.895349 | 2.19360505 | Inoviridae sp. | 2219103 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g113956 | i0 | 100 | 58.1469387755102 | 245 | 0 | 100 | 0 | 1 | 245 | 17628 | 17384 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 14246 | 453 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11759012 | 11759012 | PRJNA1123436_P_NODE_78990_length_280_cov_1.169082_g77776_i0 | PRJNA1123436 | 78990 | 280 | 1.169082 | 3.2734296 | Inoviridae sp. | 2219103 | Viruses | Viruses | 490 | 4.61e-134 | NTclustered | gi|2059571885|tpg|BK036535.1| | 2219103 | g77776 | i0 | 98.221 | 60.3428571428571 | 281 | 3 | 100 | 2 | 1 | 280 | 8239 | 7960 | MAG TPA_asm: Inoviridae sp. isolate ctXGq1, partial genome | blastn | 16896 | 490 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13032707 | 13032707 | PRJNA1123436_P_NODE_118331_length_244_cov_0.900585_g117117_i0 | PRJNA1123436 | 118331 | 244 | 0.900585 | 2.1974274 | Inoviridae sp. | 2219103 | Viruses | Viruses | 220 | 5.699999999999998e-53 | NTclustered | gi|2056916965|tpg|BK054229.1| | 2219103 | g117117 | i0 | 83.475 | 0.967213114754098 | 236 | 39 | 97 | 0 | 1 | 236 | 72869 | 73104 | MAG TPA_asm: Inoviridae sp. isolate ctU8W9, partial genome | blastn | 236 | 220 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13033908 | 13033908 | PRJNA1123436_P_NODE_67231_length_304_cov_1.186147_g66017_i0 | PRJNA1123436 | 67231 | 304 | 1.186147 | 3.60588688 | Inoviridae sp. | 2219103 | Viruses | Viruses | 551 | 2.289999999999999e-152 | NTclustered | gi|2052892616|tpg|BK017517.1| | 2219103 | g66017 | i0 | 99.344 | 1.00328947368421 | 305 | 1 | 100 | 1 | 1 | 304 | 11717 | 12021 | MAG TPA_asm: Inoviridae sp. isolate ctma920, partial genome | blastn | 305 | 551 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15583515 | 15583515 | PRJNA1123436_P_NODE_88973_length_261_cov_1.601064_g87759_i0 | PRJNA1123436 | 88973 | 261 | 1.601064 | 4.17877704 | Inoviridae sp. | 2219103 | Viruses | Viruses | 294 | 3.58e-75 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g87759 | i0 | 97.126 | 0.666666666666667 | 174 | 5 | 67 | 0 | 1 | 174 | 23014 | 23187 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 174 | 294 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 20681725 | 20681725 | PRJNA1123436_P_NODE_68557_length_301_cov_1.166667_g67343_i0 | PRJNA1123436 | 68557 | 301 | 1.166667 | 3.51166767 | Inoviridae sp. | 2219103 | Viruses | Viruses | 551 | 2.2699999999999992e-152 | NTclustered | gi|2050460431|tpg|BK059140.1| | 2219103 | g67343 | i0 | 99.668 | 52.624584717608 | 301 | 1 | 100 | 0 | 1 | 301 | 1610 | 1310 | MAG TPA_asm: Inoviridae sp. isolate ctxJs71 genomic sequence, sequence | blastn | 15840 | 551 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 21957338 | 21957338 | PRJNA1123436_P_NODE_84338_length_270_cov_1.172589_g83124_i0 | PRJNA1123436 | 84338 | 270 | 1.172589 | 3.1659903 | Inoviridae sp. | 2219103 | Viruses | Viruses | 499 | 7.349999999999998e-137 | NTclustered | gi|2057776279|tpg|BK054634.1| | 2219103 | g83124 | i0 | 100 | 3 | 270 | 0 | 100 | 0 | 1 | 270 | 1076 | 807 | MAG TPA_asm: Inoviridae sp. isolate ctBoq6, partial genome | blastn | 810 | 499 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24506783 | 24506783 | PRJNA1123436_P_NODE_99380_length_250_cov_0.870056_g98166_i0 | PRJNA1123436 | 99380 | 250 | 0.870056 | 2.17514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 76.8 | 1.34e-9 | NTclustered | gi|2057942008|tpg|BK046014.1| | 2219103 | g98166 | i0 | 97.727 | 0.376 | 44 | 1 | 30 | 0 | 158 | 201 | 4599 | 4642 | MAG TPA_asm: Inoviridae sp. isolate ctJAh3, partial genome | blastn | 94 | 76.8 | 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);;