contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA401346" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 414123 | 414123 | PRJNA401346_P_NODE_1_length_6428_cov_8.859746_g0_i0 | PRJNA401346 | 1 | 6428 | 8.859746 | 569.50447288 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 11638 | 0 | NTclustered | gi|1173652586|gb|KU886553.1| | 12224 | g0 | i0 | 99.347 | 99.1067205973864 | 6428 | 42 | 100 | 0 | 1 | 6428 | 9580 | 3153 | Sugarcane mosaic virus isolate Yunan, complete genome | blastn | 637058 | 11638 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 414131 | 414131 | PRJNA401346_P_NODE_2421_length_322_cov_2.172414_g2400_i0 | PRJNA401346 | 2421 | 322 | 2.172414 | 6.99517308 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 595 | 1.1099999999999995e-165 | NTclustered | gi|447380403|gb|JX047426.1| | 12224 | g2400 | i0 | 100 | 76.5217391304348 | 322 | 0 | 100 | 0 | 1 | 322 | 4869 | 4548 | Sugarcane mosaic virus isolate YL8, complete genome | blastn | 24640 | 595 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 14443088 | 14443088 | PRJNA401346_P_NODE_12_length_2556_cov_3.388778_g10_i0 | PRJNA401346 | 12 | 2556 | 3.388778 | 86.61716568 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 4647 | 0 | NTclustered | gi|987898853|gb|KU171817.1| | 12224 | g10 | i0 | 99.491 | 99.481220657277 | 2555 | 13 | 99 | 0 | 1 | 2555 | 637 | 3191 | Sugarcane mosaic virus isolate CN:HB:15, complete genome | blastn | 254274 | 4647 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 14443132 | 14443132 | PRJNA401346_P_NODE_3192_length_289_cov_2.421053_g3171_i0 | PRJNA401346 | 3192 | 289 | 2.421053 | 6.99684317 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 518 | 2.19e-142 | NTclustered | gi|1782804217|gb|MN756484.1| | 12224 | g3171 | i0 | 98.962 | 99.8304498269896 | 289 | 3 | 100 | 0 | 1 | 289 | 8433 | 8145 | Sugarcane mosaic virus isolate SCMV Mara13-TZA, complete genome | blastn | 28851 | 518 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 18265781 | 18265781 | PRJNA401346_P_NODE_115_length_1251_cov_7.282353_g106_i0 | PRJNA401346 | 115 | 1251 | 7.282353 | 91.10223603 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 2139 | 0 | NTclustered | gi|447380327|gb|JX047388.1| | 12224 | g106 | i0 | 98.753 | 95.8705035971223 | 1203 | 15 | 99 | 0 | 4 | 1206 | 9576 | 8374 | Sugarcane mosaic virus isolate BD13, complete genome | blastn | 119934 | 2139 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 18265794 | 18265794 | PRJNA401346_P_NODE_1575_length_385_cov_1.574074_g1554_i0 | PRJNA401346 | 1575 | 385 | 1.574074 | 6.0601849 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 691 | 0 | NTclustered | gi|447380343|gb|JX047396.1| | 12224 | g1554 | i0 | 99.474 | 98.8051948051948 | 380 | 2 | 99 | 0 | 6 | 385 | 3638 | 4017 | Sugarcane mosaic virus isolate NX7271, complete genome | blastn | 38040 | 691 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 20207290 | 20207290 | PRJNA401346_P_NODE_6756_length_208_cov_0.870748_g6735_i0 | PRJNA401346 | 6756 | 208 | 0.870748 | 1.81115584 | Polerovirus | 119164 | Viruses | Viruses | 368 | 1.59e-97 | NTclustered | gi|1023464444|ref|NC_029990.1| | 1833824 | g6735 | i0 | 98.558 | 85.5673076923077 | 208 | 3 | 100 | 0 | 1 | 208 | 4907 | 4700 | Maize yellow dwarf virus-RMV2, complete genome | blastn | 17798 | 368 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus MAYMV | ||
| 20815973 | 20815973 | PRJNA401346_P_NODE_757_length_529_cov_3.440171_g736_i0 | PRJNA401346 | 757 | 529 | 3.440171 | 18.19850459 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 961 | 0 | NTclustered | gi|987898853|gb|KU171817.1| | 12224 | g736 | i0 | 99.433 | 84.937618147448 | 529 | 3 | 100 | 0 | 1 | 529 | 549 | 21 | Sugarcane mosaic virus isolate CN:HB:15, complete genome | blastn | 44932 | 961 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 22090639 | 22090639 | PRJNA401346_P_NODE_2478_length_319_cov_2.046512_g2457_i0 | PRJNA401346 | 2478 | 319 | 2.046512 | 6.52837328 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 573 | 5.159999999999998e-159 | NTclustered | gi|1368163998|gb|MF467399.1| | 12224 | g2457 | i0 | 99.06 | 89 | 319 | 3 | 100 | 0 | 1 | 319 | 7321 | 7003 | Sugarcane mosaic virus isolate NA41-Tz, complete genome | blastn | 28391 | 573 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari |
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);;