contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA602115" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 575720 | 575720 | PRJNA602115_P_NODE_5621_length_268_cov_1.342995_g5596_i0 | PRJNA602115 | 5621 | 268 | 1.342995 | 3.5992266 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 381 | 2.759999999999999e-101 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g5596 | i0 | 92.509 | 0.996268656716418 | 267 | 18 | 99 | 2 | 1 | 266 | 3168 | 2903 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 267 | 381 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 5679416 | 5679416 | PRJNA602115_P_NODE_3185_length_340_cov_1.379928_g3160_i0 | PRJNA602115 | 3185 | 340 | 1.379928 | 4.6917552 | Wigfec virus K19_555 | 2986010 | Viruses | Viruses | 573 | 5.54e-159 | NTclustered | gi|2316504316|gb|OP549837.1| | 2986010 | g3160 | i0 | 97.059 | 1 | 340 | 10 | 100 | 0 | 1 | 340 | 479 | 818 | MAG: Wigfec virus K19_555, complete genome | blastn | 340 | 573 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_555 | ||||||
| 10780046 | 10780046 | PRJNA602115_P_NODE_5369_length_274_cov_1.201878_g5344_i0 | PRJNA602115 | 5369 | 274 | 1.201878 | 3.29314572 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 460 | 3.53e-125 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g5344 | i0 | 99.603 | 0.91970802919708 | 252 | 1 | 92 | 0 | 1 | 252 | 1130 | 879 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 252 | 460 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 12054949 | 12054949 | PRJNA602115_P_NODE_3410_length_330_cov_0.951673_g3385_i0 | PRJNA602115 | 3410 | 330 | 0.951673 | 3.1405209 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 516 | 9.17e-142 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g3385 | i0 | 94.848 | 1.19090909090909 | 330 | 17 | 100 | 0 | 1 | 330 | 3220 | 3549 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 393 | 516 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 17153483 | 17153483 | PRJNA602115_P_NODE_6734_length_245_cov_1.043478_g6709_i0 | PRJNA602115 | 6734 | 245 | 1.043478 | 2.5565211 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 381 | 2.4799999999999995e-101 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g6709 | i0 | 94.694 | 14.4 | 245 | 13 | 100 | 0 | 1 | 245 | 1355 | 1111 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 3528 | 381 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 18427699 | 18427699 | PRJNA602115_P_NODE_4455_length_296_cov_0.872340_g4430_i0 | PRJNA602115 | 4455 | 296 | 0.87234 | 2.5821264 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 403 | 6.59e-108 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g4430 | i0 | 91.275 | 1.00675675675676 | 298 | 22 | 100 | 2 | 1 | 296 | 2583 | 2878 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 298 | 403 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 20978078 | 20978078 | PRJNA602115_P_NODE_637_length_726_cov_1.493233_g613_i0 | PRJNA602115 | 637 | 726 | 1.493233 | 10.84087158 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1184 | 0 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g613 | i0 | 96.639 | 41.961432506887 | 714 | 22 | 98 | 2 | 10 | 722 | 1444 | 2156 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 30464 | 1184 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 22252962 | 22252962 | PRJNA602115_P_NODE_9938_length_206_cov_0.882759_g9913_i0 | PRJNA602115 | 9938 | 206 | 0.882759 | 1.81848354 | Wigfec virus K19_555 | 2986010 | Viruses | Viruses | 215 | 2.17e-51 | NTclustered | gi|2316504316|gb|OP549837.1| | 2986010 | g9913 | i0 | 86.911 | 0.927184466019418 | 191 | 25 | 93 | 0 | 13 | 203 | 1335 | 1525 | MAG: Wigfec virus K19_555, complete genome | blastn | 191 | 215 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_555 |
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);;