contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 613777 | 613777 | PRJNA641707_P_NODE_231541_length_189_cov_11.207143_g228878_i0 | PRJNA641707 | 231541 | 189 | 11.207143 | 21.18150027 | Inoviridae sp. ctWUU20 | 2823615 | Viruses | Viruses | 145 | 2.6e-30 | NTclustered | gi|2051114658|tpg|BK014694.1| | 2823615 | g228878 | i0 | 92.233 | 8.41798941798942 | 103 | 7 | 54 | 1 | 1 | 103 | 4138 | 4037 | MAG TPA_asm: Inoviridae sp. ctWUU20, partial genome | blastn | 1591 | 145 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. ctWUU20 | |||
| 4440082 | 4440082 | PRJNA641707_P_NODE_171304_length_201_cov_6.322368_g168641_i0 | PRJNA641707 | 171304 | 201 | 6.322368 | 12.70795968 | Inoviridae sp. | 2219103 | Viruses | Viruses | 183 | 5.94e-42 | NTclustered | gi|2054537114|tpg|BK047777.1| | 2219103 | g168641 | i0 | 100 | 24.7960199004975 | 99 | 0 | 49 | 0 | 101 | 199 | 10618 | 10716 | MAG TPA_asm: Inoviridae sp. isolate ctVky9, partial genome | blastn | 4984 | 183 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6991449 | 6991449 | PRJNA641707_P_NODE_197066_length_198_cov_3.516779_g194403_i0 | PRJNA641707 | 197066 | 198 | 3.516779 | 6.96322242 | Inoviridae sp. | 2219103 | Viruses | Viruses | 335 | 1.5199999999999996e-87 | NTclustered | gi|2054444724|tpg|BK036222.1| | 2219103 | g194403 | i0 | 97.927 | 12.6717171717172 | 193 | 4 | 97 | 0 | 1 | 193 | 48180 | 47988 | MAG TPA_asm: Inoviridae sp. isolate ctSjg4, partial genome | blastn | 2509 | 335 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6992117 | 6992117 | PRJNA641707_P_NODE_225746_length_191_cov_10.161972_g223083_i0 | PRJNA641707 | 225746 | 191 | 10.161972 | 19.40936652 | Inoviridae sp. | 2219103 | Viruses | Viruses | 224 | 3.2899999999999996e-54 | NTclustered | gi|2058151629|tpg|BK034522.1| | 2219103 | g223083 | i0 | 87.895 | 0.994764397905759 | 190 | 23 | 99 | 0 | 1 | 190 | 1481 | 1292 | MAG TPA_asm: Inoviridae sp. isolate ctvsW9, partial genome | blastn | 190 | 224 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 8264592 | 8264592 | PRJNA641707_P_NODE_122327_length_245_cov_5.836735_g119664_i0 | PRJNA641707 | 122327 | 245 | 5.836735 | 14.30000075 | Inoviridae sp. | 2219103 | Viruses | Viruses | 180 | 9.72e-41 | NTclustered | gi|2056936201|tpg|BK022393.1| | 2219103 | g119664 | i0 | 100 | 42.3795918367347 | 97 | 0 | 80 | 0 | 5 | 101 | 2932 | 2836 | MAG TPA_asm: Inoviridae sp. isolate ct6Da14, partial genome | blastn | 10383 | 180 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 8266201 | 8266201 | PRJNA641707_P_NODE_193987_length_198_cov_7.503356_g191324_i0 | PRJNA641707 | 193987 | 198 | 7.503356 | 14.85664488 | Inoviridae sp. | 2219103 | Viruses | Viruses | 178 | 2.71e-40 | NTclustered | gi|2056936201|tpg|BK022393.1| | 2219103 | g191324 | i0 | 98.039 | 9.82323232323232 | 102 | 2 | 52 | 0 | 96 | 197 | 7556 | 7455 | MAG TPA_asm: Inoviridae sp. isolate ct6Da14, partial genome | blastn | 1945 | 178 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9542601 | 9542601 | PRJNA641707_P_NODE_244608_length_184_cov_8.533333_g241945_i0 | PRJNA641707 | 244608 | 184 | 8.533333 | 15.70133272 | Inoviridae sp. | 2219103 | Viruses | Viruses | 311 | 2.34e-80 | NTclustered | gi|2056767787|tpg|BK045651.1| | 2219103 | g241945 | i0 | 98.305 | 2.88586956521739 | 177 | 3 | 96 | 0 | 2 | 178 | 19373 | 19197 | MAG TPA_asm: Inoviridae sp. isolate ct0IR21, partial genome | blastn | 531 | 311 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10820401 | 10820401 | PRJNA641707_P_NODE_33669_length_373_cov_4.703704_g31045_i0 | PRJNA641707 | 33669 | 373 | 4.703704 | 17.54481592 | Inoviridae sp. | 2219103 | Viruses | Viruses | 241 | 7.06e-59 | NTclustered | gi|2054800178|tpg|BK050093.1| | 2219103 | g31045 | i0 | 100 | 9.25201072386059 | 130 | 0 | 61 | 0 | 99 | 228 | 13 | 142 | MAG TPA_asm: Inoviridae sp. isolate ctoyC15, partial genome | blastn | 3451 | 241 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 12095898 | 12095898 | PRJNA641707_P_NODE_45110_length_323_cov_5.047445_g42459_i0 | PRJNA641707 | 45110 | 323 | 5.047445 | 16.30324735 | Inoviridae sp. | 2219103 | Viruses | Viruses | 499 | 9.01e-137 | NTclustered | gi|2054428949|tpg|BK035896.1| | 2219103 | g42459 | i0 | 95.527 | 55.7461300309598 | 313 | 13 | 97 | 1 | 11 | 322 | 6525 | 6837 | MAG TPA_asm: Inoviridae sp. isolate ctppP11, partial genome | blastn | 18006 | 499 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13370380 | 13370380 | PRJNA641707_P_NODE_36691_length_358_cov_3.721683_g34056_i0 | PRJNA641707 | 36691 | 358 | 3.721683 | 13.32362514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 326 | 1.81e-84 | NTclustered | gi|2058074506|tpg|BK043007.1| | 2219103 | g34056 | i0 | 95.146 | 21.6033519553073 | 206 | 10 | 86 | 0 | 8 | 213 | 1368 | 1163 | MAG TPA_asm: Inoviridae sp. isolate ctuMM5, partial genome | blastn | 7734 | 326 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 13371126 | 13371126 | PRJNA641707_P_NODE_69571_length_251_cov_9.534653_g66908_i0 | PRJNA641707 | 69571 | 251 | 9.534653 | 23.93197903 | Inoviridae sp. | 2219103 | Viruses | Viruses | 355 | 1.55e-93 | NTclustered | gi|2056770937|tpg|BK045722.1| | 2219103 | g66908 | i0 | 92.308 | 18.6414342629482 | 260 | 5 | 98 | 3 | 6 | 250 | 893 | 634 | MAG TPA_asm: Inoviridae sp. isolate ctMGq3, partial genome | blastn | 4679 | 355 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 20284280 | 20284280 | PRJNA641707_P_NODE_39496_length_346_cov_8.808081_g36856_i0 | PRJNA641707 | 39496 | 346 | 8.808081 | 30.47596026 | root | 1 | Root_unresolved | Root_unresolved | 603 | 7.209999999999997e-168 | NTclustered | gi|2054428949|tpg|BK035896.1| | 2219103 | g36856 | i0 | 98.534 | 23.2109826589595 | 341 | 5 | 99 | 0 | 6 | 346 | 3397 | 3057 | MAG TPA_asm: Inoviridae sp. isolate ctppP11, partial genome | blastn | 8031 | 603 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24837491 | 24837491 | PRJNA641707_P_NODE_115900_length_246_cov_1.908629_g113237_i0 | PRJNA641707 | 115900 | 246 | 1.908629 | 4.69522734 | Inoviridae sp. | 2219103 | Viruses | Viruses | 174 | 4.55e-39 | NTclustered | gi|2054640097|tpg|BK051796.1| | 2219103 | g113237 | i0 | 98 | 11.7357723577236 | 100 | 2 | 41 | 0 | 147 | 246 | 8086 | 8185 | MAG TPA_asm: Inoviridae sp. isolate ctcuq11, partial genome | blastn | 2887 | 174 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24841010 | 24841010 | PRJNA641707_P_NODE_269900_length_174_cov_5.280000_g267237_i0 | PRJNA641707 | 269900 | 174 | 5.28 | 9.1872 | Inoviridae sp. | 2219103 | Viruses | Viruses | 263 | 6.21e-66 | NTclustered | gi|2059878544|tpg|BK040982.1| | 2219103 | g267237 | i0 | 95.706 | 4.45402298850575 | 163 | 7 | 94 | 0 | 7 | 169 | 6580 | 6742 | MAG TPA_asm: Inoviridae sp. isolate ctMpa10, partial genome | blastn | 775 | 263 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24842669 | 24842669 | PRJNA641707_P_NODE_37920_length_353_cov_7.773026_g35281_i0 | PRJNA641707 | 37920 | 353 | 7.773026 | 27.43878178 | Inoviridae sp. | 2219103 | Viruses | Viruses | 58.4 | 7.17e-4 | NTclustered | gi|2906156750|gb|PQ646969.1| | 2219103 | g35281 | i0 | 84.127 | 0.178470254957507 | 63 | 7 | 18 | 3 | 257 | 318 | 532 | 472 | MAG: Inoviridae sp. isolate k127_4105812 genomic sequence | blastn | 63 | 58.4 | 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);;