contig_metadata
10 rows where bioproject = "PRJNA934472", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3807587 | 3807587 | PRJNA934472_P_NODE_33483_length_257_cov_1.500000_g33105_i0 | PRJNA934472 | 33483 | 257 | 1.5 | 3.855 | root | 1 | Root_unresolved | Root_unresolved | 446 | 9.179999999999998e-121 | NTclustered | gi|1590853289|gb|MH595919.1| | 12242 | g33105 | i0 | 98.047 | 99.295719844358 | 256 | 5 | 99 | 0 | 2 | 257 | 3106 | 2851 | Tobacco mosaic virus isolate Harbin-1, complete genome | blastn | 25519 | 446 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 4739529 | 4739529 | PRJNA934472_P_NODE_3524_length_719_cov_2.154799_g3235_i0 | PRJNA934472 | 3524 | 719 | 2.154799 | 15.49300481 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1280 | 0 | NTclustered | gi|388240225|emb|HE818435.1| | 12242 | g3235 | i0 | 98.748 | 99.923504867872 | 719 | 9 | 100 | 0 | 1 | 719 | 5569 | 6287 | Tobacco mosaic virus isolate Ludian, complete genome | blastn | 71845 | 1280 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 7289224 | 7289224 | PRJNA934472_P_NODE_32326_length_262_cov_1.253968_g31948_i0 | PRJNA934472 | 32326 | 262 | 1.253968 | 3.28539616 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 473 | 4.31e-129 | NTclustered | gi|1102971919|gb|KX650856.1| | 12242 | g31948 | i0 | 99.237 | 99.9541984732824 | 262 | 2 | 100 | 0 | 1 | 262 | 3427 | 3166 | Tobacco mosaic virus isolate Dzh-Qyg nonfunctional Replicase and nonfunctional movement protein genes, complete sequence | blastn | 26188 | 473 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 7289282 | 7289282 | PRJNA934472_P_NODE_3486_length_722_cov_2.443760_g3197_i0 | PRJNA934472 | 3486 | 722 | 2.44376 | 17.6439472 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1306 | 0 | NTclustered | gi|388240261|emb|HE818444.1| | 12242 | g3197 | i0 | 99.307 | 100 | 722 | 5 | 100 | 0 | 1 | 722 | 4310 | 5031 | Tobacco mosaic virus isolate Tianzhu-1, complete genome | blastn | 72200 | 1306 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12734944 | 12734944 | PRJNA934472_P_NODE_24170_length_298_cov_2.640000_g23792_i0 | PRJNA934472 | 24170 | 298 | 2.64 | 7.8672 | root | 1 | Root_unresolved | Root_unresolved | 523 | 4.879999999999998e-144 | NTclustered | gi|388240305|emb|HE818455.1| | 12242 | g23792 | i0 | 98.322 | 100 | 298 | 5 | 100 | 0 | 1 | 298 | 2443 | 2146 | Tobacco mosaic virus isolate Yihan-1, complete genome | blastn | 29800 | 523 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 15283533 | 15283533 | PRJNA934472_P_NODE_7192_length_522_cov_3.209354_g6875_i0 | PRJNA934472 | 7192 | 522 | 3.209354 | 16.75282788 | Tobamovirus | 12234 | Viruses | Viruses | 953 | 0 | NTclustered | gi|388240149|emb|HE818416.1| | 12242 | g6875 | i0 | 99.617 | 99.9674329501916 | 522 | 2 | 100 | 0 | 1 | 522 | 1641 | 2162 | Tobacco mosaic virus isolate Fumeng, complete genome | blastn | 52183 | 953 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20037874 | 20037874 | PRJNA934472_P_NODE_36796_length_246_cov_2.236994_g36418_i0 | PRJNA934472 | 36796 | 246 | 2.236994 | 5.50300524 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|1102971919|gb|KX650856.1| | 12242 | g36418 | i0 | 100 | 99.9756097560976 | 246 | 0 | 100 | 0 | 1 | 246 | 461 | 706 | Tobacco mosaic virus isolate Dzh-Qyg nonfunctional Replicase and nonfunctional movement protein genes, complete sequence | blastn | 24594 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20381784 | 20381784 | PRJNA934472_P_NODE_15436_length_365_cov_2.027397_g15059_i0 | PRJNA934472 | 15436 | 365 | 2.027397 | 7.39999905 | root | 1 | Root_unresolved | Root_unresolved | 658 | 0 | NTclustered | gi|388240149|emb|HE818416.1| | 12242 | g15059 | i0 | 99.178 | 100 | 365 | 3 | 100 | 0 | 1 | 365 | 1160 | 1524 | Tobacco mosaic virus isolate Fumeng, complete genome | blastn | 36500 | 658 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 22587762 | 22587762 | PRJNA934472_P_NODE_15598_length_363_cov_9.627586_g15221_i0 | PRJNA934472 | 15598 | 363 | 9.627586 | 34.94813718 | Chrocomolt virus | 3129476 | Viruses | Viruses | 540 | 6.03e-149 | NTclustered | gi|2717317674|gb|PP171924.1| | 3129476 | g15221 | i0 | 94.318 | 1.71900826446281 | 352 | 20 | 97 | 0 | 1 | 352 | 4049 | 4400 | MAG: Chrocomolt virus isolate CC1B_k141_48525 genomic sequence | blastn | 624 | 540 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chrocomolt virus | ||||
| 22588264 | 22588264 | PRJNA934472_P_NODE_5118_length_607_cov_1.801498_g4808_i0 | PRJNA934472 | 5118 | 607 | 1.801498 | 10.93509286 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1094 | 0 | NTclustered | gi|388240245|emb|HE818440.1| | 12242 | g4808 | i0 | 99.176 | 100.00823723229 | 607 | 5 | 100 | 0 | 1 | 607 | 4326 | 3720 | Tobacco mosaic virus isolate Shaoxing, complete genome | blastn | 60705 | 1094 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci |
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);;