contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4101548 | 4101548 | PRJNA1120203_P_NODE_102024_length_242_cov_0.911243_g101008_i0 | PRJNA1120203 | 102024 | 242 | 0.911243 | 2.20520806 | Inoviridae sp. | 2219103 | Viruses | Viruses | 431 | 2.4e-116 | NTclustered | gi|2057090093|tpg|BK038098.1| | 2219103 | g101008 | i0 | 98.76 | 1 | 242 | 3 | 100 | 0 | 1 | 242 | 18612 | 18371 | MAG TPA_asm: Inoviridae sp. isolate ctlQH11, partial genome | blastn | 242 | 431 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 4102410 | 4102410 | PRJNA1120203_P_NODE_80204_length_251_cov_0.865169_g79188_i0 | PRJNA1120203 | 80204 | 251 | 0.865169 | 2.17157419 | Inoviridae sp. | 2219103 | Viruses | Viruses | 431 | 2.4999999999999996e-116 | NTclustered | gi|2054481614|tpg|BK031967.1| | 2219103 | g79188 | i0 | 97.61 | 4 | 251 | 6 | 100 | 0 | 1 | 251 | 11009 | 11259 | MAG TPA_asm: Inoviridae sp. isolate ctzp04, partial genome | blastn | 1004 | 431 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 4102472 | 4102472 | PRJNA1120203_P_NODE_84144_length_249_cov_0.875000_g83128_i0 | PRJNA1120203 | 84144 | 249 | 0.875 | 2.17875 | Uncultured phage WW-nAnB strain 2 | 1449896 | Viruses | Viruses | 294 | 3.39e-75 | NTclustered | gi|576017109|gb|KJ003981.1| | 1449896 | g83128 | i0 | 87.952 | 9.5140562248996 | 249 | 30 | 100 | 0 | 1 | 249 | 2701 | 2453 | Uncultured phage WW-nAnB strain 2, complete genome | blastn | 2369 | 294 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Uncultured phage WW-nAnB strain 2 | |||
| 4102542 | 4102542 | PRJNA1120203_P_NODE_88004_length_248_cov_0.845714_g86988_i0 | PRJNA1120203 | 88004 | 248 | 0.845714 | 2.09737072 | Inoviridae sp. | 2219103 | Viruses | Viruses | 442 | 1.1399999999999995e-119 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g86988 | i0 | 98.79 | 7.24193548387097 | 248 | 3 | 100 | 0 | 1 | 248 | 339 | 586 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 1796 | 442 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5377633 | 5377633 | PRJNA1120203_P_NODE_104185_length_241_cov_0.916667_g103169_i0 | PRJNA1120203 | 104185 | 241 | 0.916667 | 2.20916747 | Inoviridae sp. | 2219103 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2057776279|tpg|BK054634.1| | 2219103 | g103169 | i0 | 99.585 | 3.12033195020747 | 241 | 1 | 100 | 0 | 1 | 241 | 2052 | 1812 | MAG TPA_asm: Inoviridae sp. isolate ctBoq6, partial genome | blastn | 752 | 440 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 5377953 | 5377953 | PRJNA1120203_P_NODE_41965_length_351_cov_1.338129_g40950_i0 | PRJNA1120203 | 41965 | 351 | 1.338129 | 4.69683279 | Inoviridae sp. | 2219103 | Viruses | Viruses | 632 | 9.309999999999999e-177 | NTclustered | gi|2059749548|tpg|BK027377.1| | 2219103 | g40950 | i0 | 99.145 | 12.8205128205128 | 351 | 3 | 100 | 0 | 1 | 351 | 8986 | 9336 | MAG TPA_asm: Inoviridae sp. isolate ctDS922, partial genome | blastn | 4500 | 632 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11753233 | 11753233 | PRJNA1120203_P_NODE_32230_length_412_cov_1.336283_g31215_i0 | PRJNA1120203 | 32230 | 412 | 1.336283 | 5.50548596 | Inoviridae sp. | 2219103 | Viruses | Viruses | 529 | 1.4999999999999996e-145 | NTclustered | gi|2050460491|tpg|BK059145.1| | 2219103 | g31215 | i0 | 92.643 | 5.65291262135922 | 367 | 27 | 89 | 0 | 1 | 367 | 2080 | 1714 | MAG TPA_asm: Inoviridae sp. isolate ctv9q3 genomic sequence, sequence | blastn | 2329 | 529 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11753391 | 11753391 | PRJNA1120203_P_NODE_45370_length_336_cov_1.171103_g44355_i0 | PRJNA1120203 | 45370 | 336 | 1.171103 | 3.93490608 | Inoviridae sp. | 2219103 | Viruses | Viruses | 571 | 1.97e-158 | NTclustered | gi|2050460491|tpg|BK059145.1| | 2219103 | g44355 | i0 | 97.321 | 22.6755952380952 | 336 | 9 | 100 | 0 | 1 | 336 | 2276 | 2611 | MAG TPA_asm: Inoviridae sp. isolate ctv9q3 genomic sequence, sequence | blastn | 7619 | 571 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11754035 | 11754035 | PRJNA1120203_P_NODE_89010_length_247_cov_0.885057_g87994_i0 | PRJNA1120203 | 89010 | 247 | 0.885057 | 2.18609079 | Inoviridae sp. | 2219103 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g87994 | i0 | 100 | 3.91093117408907 | 247 | 0 | 100 | 0 | 1 | 247 | 30761 | 31007 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 966 | 457 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14303463 | 14303463 | PRJNA1120203_P_NODE_16372_length_685_cov_1.717320_g15390_i0 | PRJNA1120203 | 16372 | 685 | 1.71732 | 11.763642 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1199 | 0 | NTclustered | gi|2052885848|tpg|BK017376.1| | 2219103 | g15390 | i0 | 98.248 | 1 | 685 | 12 | 100 | 0 | 1 | 685 | 30162 | 30846 | MAG TPA_asm: Inoviridae sp. isolate ctt7x1, partial genome | blastn | 685 | 1199 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14303536 | 14303536 | PRJNA1120203_P_NODE_24312_length_499_cov_2.535211_g23300_i0 | PRJNA1120203 | 24312 | 499 | 2.535211 | 12.65070289 | Inoviridae sp. | 2219103 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2054623908|tpg|BK022175.1| | 2219103 | g23300 | i0 | 90.8 | 12.4849699398798 | 500 | 44 | 100 | 2 | 1 | 499 | 1241 | 1739 | MAG TPA_asm: Inoviridae sp. isolate ctzb32, partial genome | blastn | 6230 | 667 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14304457 | 14304457 | PRJNA1120203_P_NODE_93192_length_245_cov_1.790698_g92176_i0 | PRJNA1120203 | 93192 | 245 | 1.790698 | 4.3872101 | Inoviridae sp. | 2219103 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g92176 | i0 | 99.592 | 5 | 245 | 1 | 100 | 0 | 1 | 245 | 14513 | 14757 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 1225 | 448 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15577487 | 15577487 | PRJNA1120203_P_NODE_20513_length_569_cov_1.062500_g19505_i0 | PRJNA1120203 | 20513 | 569 | 1.0625 | 6.045625 | Inoviridae sp. | 2219103 | Viruses | Viruses | 285 | 5.08e-72 | NTclustered | gi|2054623908|tpg|BK022175.1| | 2219103 | g19505 | i0 | 92.857 | 2.14235500878735 | 196 | 14 | 34 | 0 | 374 | 569 | 2234 | 2039 | MAG TPA_asm: Inoviridae sp. isolate ctzb32, partial genome | blastn | 1219 | 285 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15578121 | 15578121 | PRJNA1120203_P_NODE_73673_length_260_cov_1.342246_g72657_i0 | PRJNA1120203 | 73673 | 260 | 1.342246 | 3.4898396 | Inoviridae sp. | 2219103 | Viruses | Viruses | 448 | 2.5899999999999996e-121 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g72657 | i0 | 97.692 | 5.01153846153846 | 260 | 6 | 100 | 0 | 1 | 260 | 16397 | 16656 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 1303 | 448 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 16852947 | 16852947 | PRJNA1120203_P_NODE_9874_length_1079_cov_1.715706_g9077_i0 | PRJNA1120203 | 9874 | 1079 | 1.715706 | 18.51246774 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1092 | 0 | NTclustered | gi|2059650349|tpg|BK028762.1| | 2219103 | g9077 | i0 | 92.448 | 17.8155699721965 | 768 | 52 | 83 | 6 | 17 | 780 | 2984 | 2219 | MAG TPA_asm: Inoviridae sp. isolate ctc0i2, partial genome | blastn | 19223 | 1092 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 21952313 | 21952313 | PRJNA1120203_P_NODE_88318_length_247_cov_1.327586_g87302_i0 | PRJNA1120203 | 88318 | 247 | 1.327586 | 3.27913742 | Inoviridae sp. | 2219103 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|2059655425|tpg|BK028848.1| | 2219103 | g87302 | i0 | 99.595 | 6.95951417004049 | 247 | 1 | 100 | 0 | 1 | 247 | 1611 | 1857 | MAG TPA_asm: Inoviridae sp. isolate ctGcv4, partial genome | blastn | 1719 | 451 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24501173 | 24501173 | PRJNA1120203_P_NODE_70300_length_267_cov_2.139175_g69284_i0 | PRJNA1120203 | 70300 | 267 | 2.139175 | 5.71159725 | Inoviridae sp. | 2219103 | Viruses | Viruses | 401 | 2.1099999999999995e-107 | NTclustered | gi|2056841409|tpg|BK044138.1| | 2219103 | g69284 | i0 | 94.275 | 21.1835205992509 | 262 | 15 | 98 | 0 | 6 | 267 | 2943 | 3204 | MAG TPA_asm: Inoviridae sp. isolate ctOnB2, partial genome | blastn | 5656 | 401 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24501218 | 24501218 | PRJNA1120203_P_NODE_74280_length_259_cov_1.241935_g73264_i0 | PRJNA1120203 | 74280 | 259 | 1.241935 | 3.21661165 | Inoviridae sp. | 2219103 | Viruses | Viruses | 446 | 9.26e-121 | NTclustered | gi|2056815095|tpg|BK057593.1| | 2219103 | g73264 | i0 | 97.683 | 1 | 259 | 6 | 100 | 0 | 1 | 259 | 7118 | 6860 | MAG TPA_asm: Inoviridae sp. isolate ctLzZ1, partial genome | blastn | 259 | 446 | 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);;