contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3016144 | 3016144 | PRJNA493632_P_NODE_51663_length_597_cov_1.788168_g48424_i0 | PRJNA493632 | 51663 | 597 | 1.788168 | 10.67536296 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 872 | 0 | NTclustered | gi|2067465795|gb|MW678893.1| | 2202565 | g48424 | i0 | 93.654 | 1.66834170854271 | 583 | 37 | 98 | 0 | 8 | 590 | 1 | 583 | MAG: Genomoviridae sp. isolate D10_10246, complete genome | blastn | 996 | 872 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 5564305 | 5564305 | PRJNA493632_P_NODE_267545_length_310_cov_2.244726_g264109_i0 | PRJNA493632 | 267545 | 310 | 2.244726 | 6.9586506 | Torque teno midi virus | 432261 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2169232058|gb|MN780441.1| | 432261 | g264109 | i0 | 96.97 | 1.31935483870968 | 33 | 1 | 11 | 0 | 93 | 125 | 2826 | 2794 | MAG: Torque teno midi virus isolate SAfiA-296-16 ORF1 gene, complete cds | blastn | 409 | 56.5 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Torque teno midi virus | |||
| 9390762 | 9390762 | PRJNA493632_P_NODE_378868_length_276_cov_5.177340_g375429_i0 | PRJNA493632 | 378868 | 276 | 5.17734 | 14.2894584 | Gammapapillomavirus 7 | 1175849 | Viruses | Viruses | 472 | 1.64e-128 | NTclustered | gi|312451781|gb|GU117629.1| | 909328 | g375429 | i0 | 97.464 | 3 | 276 | 7 | 100 | 0 | 1 | 276 | 5899 | 6174 | Human papillomavirus type 149, complete genome | blastn | 828 | 472 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 7 | ||
| 11940097 | 11940097 | PRJNA493632_P_NODE_305890_length_293_cov_3.113636_g302452_i0 | PRJNA493632 | 305890 | 293 | 3.113636 | 9.12295348 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 470 | 6.33e-128 | NTclustered | gi|2067465795|gb|MW678893.1| | 2202565 | g302452 | i0 | 95.563 | 17.6587030716724 | 293 | 13 | 100 | 0 | 1 | 293 | 1328 | 1036 | MAG: Genomoviridae sp. isolate D10_10246, complete genome | blastn | 5174 | 470 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 11947340 | 11947340 | PRJNA493632_P_NODE_714470_length_216_cov_4.188811_g711028_i0 | PRJNA493632 | 714470 | 216 | 4.188811 | 9.04783176 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 399 | 5.909999999999999e-107 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g711028 | i0 | 100 | 1 | 216 | 0 | 100 | 0 | 1 | 216 | 2983 | 3198 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 216 | 399 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 13216477 | 13216477 | PRJNA493632_P_NODE_377531_length_277_cov_1.357843_g374092_i0 | PRJNA493632 | 377531 | 277 | 1.357843 | 3.76122511 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 501 | 2.11e-137 | NTclustered | gi|1020170|gb|U31779.1|HPU31779 | 31548 | g374092 | i0 | 99.278 | 4.81227436823105 | 277 | 2 | 100 | 0 | 1 | 277 | 457 | 181 | Human papillomavirus type 21, complete genome | blastn | 1333 | 501 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 15771559 | 15771559 | PRJNA493632_P_NODE_728633_length_202_cov_5.209302_g725190_i0 | PRJNA493632 | 728633 | 202 | 5.209302 | 10.52279004 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 267 | 5.77e-67 | NTclustered | gi|2384852566|gb|OM154726.1| | 2748378 | g725190 | i0 | 90.547 | 0.995049504950495 | 201 | 19 | 99 | 0 | 2 | 202 | 167 | 367 | MAG: Cressdnaviricota sp. isolate Miresoil virus 95, complete genome | blastn | 201 | 267 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 19594737 | 19594737 | PRJNA493632_P_NODE_72276_length_519_cov_3.224215_g68922_i0 | PRJNA493632 | 72276 | 519 | 3.224215 | 16.73367585 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 948 | 0 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g68922 | i0 | 99.615 | 10.9287090558767 | 519 | 2 | 100 | 0 | 1 | 519 | 237 | 755 | Human papillomavirus type 94 complete genome | blastn | 5672 | 948 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 22141763 | 22141763 | PRJNA493632_P_NODE_515398_length_251_cov_0.865169_g511959_i0 | PRJNA493632 | 515398 | 251 | 0.865169 | 2.17157419 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 451 | 1.92e-122 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g511959 | i0 | 99.2 | 5.91235059760956 | 250 | 2 | 99 | 0 | 2 | 251 | 5369 | 5120 | Human papillomavirus type 94 complete genome | blastn | 1484 | 451 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 24693653 | 24693653 | PRJNA493632_P_NODE_662200_length_241_cov_0.886905_g658759_i0 | PRJNA493632 | 662200 | 241 | 0.886905 | 2.13744105 | Camellia oleifera geminivirus | 2713609 | Viruses | Viruses | 250 | 7.17e-62 | NTclustered | gi|1815417282|gb|MN161582.1| | 2713609 | g658759 | i0 | 86.404 | 1.2448132780083 | 228 | 31 | 95 | 0 | 8 | 235 | 1685 | 1458 | Camellia oleifera geminivirus isolate Pxcs-11 segment DNA-B, complete sequence | blastn | 300 | 250 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Camellia oleifera geminivirus | |||
| 24693880 | 24693880 | PRJNA493632_P_NODE_675600_length_236_cov_2.797546_g672159_i0 | PRJNA493632 | 675600 | 236 | 2.797546 | 6.60220856 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 425 | 1.08e-114 | NTclustered | gi|40804528|emb|AJ620211.1| | 260717 | g672159 | i0 | 99.153 | 6.97881355932203 | 236 | 2 | 100 | 0 | 1 | 236 | 7542 | 7307 | Human papillomavirus type 94 complete genome | blastn | 1647 | 425 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 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);;