contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA781453" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1212188 | 1212188 | PRJNA781453_P_NODE_28781_length_268_cov_1.497436_g28666_i0 | PRJNA781453 | 28781 | 268 | 1.497436 | 4.01312848 | Carlavirus | 12163 | Viruses | Viruses | 468 | 2.06e-127 | NTclustered | gi|1081700958|gb|KU896946.1| | 12169 | g28666 | i0 | 98.134 | 35.1865671641791 | 268 | 5 | 100 | 0 | 1 | 268 | 1871 | 1604 | Potato virus S isolate HB7, complete genome | blastn | 9430 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 7141040 | 7141040 | PRJNA781453_P_NODE_24946_length_291_cov_1.224771_g24831_i0 | PRJNA781453 | 24946 | 291 | 1.224771 | 3.56408361 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 488 | 1.7299999999999995e-133 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24831 | i0 | 96.907 | 99.7731958762887 | 291 | 9 | 100 | 0 | 1 | 291 | 6781 | 7071 | Potato virus S isolate X1-SD, complete genome | blastn | 29034 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 7141584 | 7141584 | PRJNA781453_P_NODE_6486_length_588_cov_1.943689_g6376_i0 | PRJNA781453 | 6486 | 588 | 1.943689 | 11.42889132 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 1086 | 0 | NTclustered | gi|2209095232|gb|OL472818.1| | 2900455 | g6376 | i0 | 100 | 4.98639455782313 | 588 | 0 | 100 | 0 | 1 | 588 | 4476 | 3889 | MAG: Brine shrimp yue-like virus 3 isolate SH/98 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2932 | 1086 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 10966852 | 10966852 | PRJNA781453_P_NODE_31029_length_256_cov_1.016393_g30914_i0 | PRJNA781453 | 31029 | 256 | 1.016393 | 2.60196608 | Potyvirus rapae | 3240607 | Viruses | Viruses | 457 | 4.22e-124 | NTclustered | gi|2019445938|dbj|LC537503.1| | 12230 | g30914 | i0 | 98.828 | 100 | 256 | 3 | 100 | 0 | 1 | 256 | 8845 | 9100 | Turnip mosaic virus CHN244 RNA, nearly complete sequence | blastn | 25600 | 457 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 12691914 | 12691914 | PRJNA781453_P_NODE_38750_length_243_cov_0.905882_g38635_i0 | PRJNA781453 | 38750 | 243 | 0.905882 | 2.20129326 | Carlavirus | 12163 | Viruses | Viruses | 427 | 3.11e-115 | NTclustered | gi|1746543057|gb|MN095414.1| | 12169 | g38635 | i0 | 98.354 | 97.7942386831276 | 243 | 4 | 100 | 0 | 1 | 243 | 4992 | 5234 | Potato virus S isolate KZ.Ushkonyr, complete genome | blastn | 23764 | 427 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 13516061 | 13516061 | PRJNA781453_P_NODE_15851_length_368_cov_1.037288_g15737_i0 | PRJNA781453 | 15851 | 368 | 1.037288 | 3.81721984 | Potyvirus rapae | 3240607 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2019445986|dbj|LC537527.1| | 12230 | g15737 | i0 | 99.455 | 99.7255434782609 | 367 | 2 | 99 | 0 | 2 | 368 | 7384 | 7750 | Turnip mosaic virus CHZH34A RNA, nearly complete sequence | blastn | 36699 | 667 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 14791446 | 14791446 | PRJNA781453_P_NODE_35132_length_248_cov_0.862857_g35017_i0 | PRJNA781453 | 35132 | 248 | 0.862857 | 2.13988536 | Potyvirus rapae | 3240607 | Viruses | Viruses | 420 | 5.34e-113 | NTclustered | gi|2019445942|dbj|LC537505.1| | 12230 | g35017 | i0 | 97.177 | 100.008064516129 | 248 | 7 | 100 | 0 | 1 | 248 | 3048 | 2801 | Turnip mosaic virus CHN254 RNA, nearly complete sequence | blastn | 24802 | 420 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 19889153 | 19889153 | PRJNA781453_P_NODE_17076_length_354_cov_1.096085_g16961_i0 | PRJNA781453 | 17076 | 354 | 1.096085 | 3.8801409 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 643 | 4.3399999999999985e-180 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g16961 | i0 | 99.435 | 99.4124293785311 | 354 | 2 | 100 | 0 | 1 | 354 | 5934 | 6287 | Potato virus S isolate X1-SD, complete genome | blastn | 35192 | 643 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 19889382 | 19889382 | PRJNA781453_P_NODE_24656_length_293_cov_1.227273_g24541_i0 | PRJNA781453 | 24656 | 293 | 1.227273 | 3.59590989 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 536 | 6.149999999999998e-148 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24541 | i0 | 99.659 | 99.8668941979522 | 293 | 1 | 100 | 0 | 1 | 293 | 7943 | 7651 | Potato virus S isolate X1-SD, complete genome | blastn | 29261 | 536 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 24988649 | 24988649 | PRJNA781453_P_NODE_12760_length_413_cov_1.358824_g12646_i0 | PRJNA781453 | 12760 | 413 | 1.358824 | 5.61194312 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 741 | 0 | NTclustered | gi|1002341922|gb|KU058657.1| | 12169 | g12646 | i0 | 99.031 | 57.041162227602896 | 413 | 4 | 100 | 0 | 1 | 413 | 8197 | 7785 | Potato virus S isolate NZ-A ab030 Lincoln, complete genome | blastn | 23558 | 741 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani |
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);;