contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1732056 | 1732056 | PRJNA493244_P_NODE_626242_length_620_cov_16.633274_g604465_i0 | PRJNA493244 | 626242 | 620 | 16.633274 | 103.1262988 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1085 | 0 | NTclustered | gi|2756421351|gb|PP744662.1| | 2202565 | g604465 | i0 | 99.169 | 58.0258064516129 | 602 | 5 | 97 | 0 | 1 | 602 | 658 | 1259 | MAG: Genomoviridae sp. isolate 226_270563 genomic sequence | blastn | 35976 | 1085 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 3007286 | 3007286 | PRJNA493244_P_NODE_1728763_length_199_cov_3.282609_g1705638_i0 | PRJNA493244 | 1728763 | 199 | 3.282609 | 6.53239191 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 311 | 2.58e-80 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g1705638 | i0 | 98.305 | 7.10050251256281 | 177 | 3 | 89 | 0 | 23 | 199 | 2939 | 3115 | Human papillomavirus type 94 complete genome | blastn | 1413 | 311 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 14483382 | 14483382 | PRJNA493244_P_NODE_1025952_length_395_cov_8.128743_g1002848_i0 | PRJNA493244 | 1025952 | 395 | 8.128743 | 32.10853485 | Tetraparvovirus ungulate1 | 3052771 | Viruses | Viruses | 562 | 1.41e-155 | NTclustered | gi|1372080036|gb|MG745679.1| | 494651 | g1002848 | i0 | 98.137 | 14.3139240506329 | 322 | 6 | 90 | 0 | 74 | 395 | 5368 | 5047 | Bovine hokovirus 1 isolate Guarapuava nonstructural protein 1 and capsid protein 1 genes, complete cds | blastn | 5654 | 562 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Tetraparvovirus | Tetraparvovirus ungulate1 | ||
| 17032150 | 17032150 | PRJNA493244_P_NODE_1071614_length_376_cov_13.990476_g1048497_i0 | PRJNA493244 | 1071614 | 376 | 13.990476 | 52.60418976 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 671 | 0 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g1048497 | i0 | 99.194 | 7.32446808510638 | 372 | 3 | 99 | 0 | 1 | 372 | 6133 | 6504 | Human papillomavirus type 94 complete genome | blastn | 2754 | 671 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 19581094 | 19581094 | PRJNA493244_P_NODE_1245976_length_313_cov_13.706349_g1222852_i0 | PRJNA493244 | 1245976 | 313 | 13.706349 | 42.90087237 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 475 | 1.4699999999999995e-129 | NTclustered | gi|2756421351|gb|PP744662.1| | 2202565 | g1222852 | i0 | 98.513 | 37.2939297124601 | 269 | 4 | 86 | 0 | 23 | 291 | 1782 | 2050 | MAG: Genomoviridae sp. isolate 226_270563 genomic sequence | blastn | 11673 | 475 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 20857146 | 20857146 | PRJNA493244_P_NODE_1380337_length_274_cov_1.098592_g1357212_i0 | PRJNA493244 | 1380337 | 274 | 1.098592 | 3.01014208 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 457 | 4.5599999999999985e-124 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g1357212 | i0 | 99.209 | 4.62043795620438 | 253 | 2 | 92 | 0 | 22 | 274 | 1945 | 1693 | Human papillomavirus type 94 complete genome | blastn | 1266 | 457 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 22131338 | 22131338 | PRJNA493244_P_NODE_1088798_length_370_cov_1.242718_g1065677_i0 | PRJNA493244 | 1088798 | 370 | 1.242718 | 4.5980566 | Iteradensovirus incertum2 | 3060057 | Viruses | Viruses | 660 | 0 | NTclustered | gi|2500383794|ref|NC_076998.1| | 1850255 | g1065677 | i0 | 98.919 | 1 | 370 | 3 | 100 | 1 | 1 | 370 | 1730 | 1362 | Human CSF-associated densovirus putative nonstructural protein NS1 (QKT79_gp1), nonstructural protein NS2 (QKT79_gp2), nonstructural protein NS3 (QKT79_gp3), and structural protein VP (QKT79_gp4) genes, complete cds | blastn | 370 | 660 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Iteradensovirus | Iteradensovirus incertum2 | ||
| 23410225 | 23410225 | PRJNA493244_P_NODE_991879_length_410_cov_5.550143_g968799_i0 | PRJNA493244 | 991879 | 410 | 5.550143 | 22.7555863 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 664 | 0 | NTclustered | gi|396924|emb|X74468.1| | 10606 | g968799 | i0 | 96.97 | 8.27317073170732 | 396 | 10 | 96 | 2 | 16 | 410 | 3930 | 3536 | Human papillomavirus type 15 genomic DNA | blastn | 3392 | 664 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 |
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);;