contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA939415" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2532459 | 2532459 | PRJNA939415_P_NODE_85162_length_249_cov_2.835227_g84740_i0 | PRJNA939415 | 85162 | 249 | 2.835227 | 7.05971523 | Enterovirus | 12059 | Viruses | Viruses | 455 | 1.47e-123 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g84740 | i0 | 99.598 | 99.3212851405623 | 249 | 1 | 100 | 0 | 1 | 249 | 17 | 265 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 24731 | 455 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 4743951 | 4743951 | PRJNA939415_P_NODE_4644_length_998_cov_2.028108_g4277_i0 | PRJNA939415 | 4644 | 998 | 2.028108 | 20.24051784 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 1844 | 0 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g4277 | i0 | 100 | 99.9609218436874 | 998 | 0 | 100 | 0 | 1 | 998 | 6244 | 5247 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 99761 | 1844 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 5084884 | 5084884 | PRJNA939415_P_NODE_57524_length_276_cov_2.344828_g57102_i0 | PRJNA939415 | 57524 | 276 | 2.344828 | 6.47172528 | Alphavirus | 11019 | Viruses | Viruses | 510 | 3.48e-140 | NTclustered | gi|2125357852|gb|OK539682.1| | 11034 | g57102 | i0 | 100 | 99.6449275362319 | 276 | 0 | 100 | 0 | 1 | 276 | 4978 | 5253 | Sindbis virus isolate AR339 non-structural polyprotein and structural polyprotein genes, complete cds | blastn | 27502 | 510 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus sindbis | ||
| 7294086 | 7294086 | PRJNA939415_P_NODE_6366_length_717_cov_3.059006_g5965_i0 | PRJNA939415 | 6366 | 717 | 3.059006 | 21.93307302 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 1319 | 0 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g5965 | i0 | 99.861 | 99.931659693166 | 717 | 1 | 100 | 0 | 1 | 717 | 4527 | 5243 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 71651 | 1319 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 17493405 | 17493405 | PRJNA939415_P_NODE_20794_length_342_cov_1.947955_g20374_i0 | PRJNA939415 | 20794 | 342 | 1.947955 | 6.6620061 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 632 | 9.079999999999999e-177 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g20374 | i0 | 100 | 100.011695906433 | 342 | 0 | 100 | 0 | 1 | 342 | 404 | 745 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 34204 | 632 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 17494028 | 17494028 | PRJNA939415_P_NODE_5254_length_875_cov_3.733167_g4866_i0 | PRJNA939415 | 5254 | 875 | 3.733167 | 32.66521125 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 1611 | 0 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g4866 | i0 | 99.886 | 100 | 875 | 1 | 100 | 0 | 1 | 875 | 1751 | 877 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 87500 | 1611 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 18767949 | 18767949 | PRJNA939415_P_NODE_7975_length_584_cov_1.755382_g7559_i0 | PRJNA939415 | 7975 | 584 | 1.755382 | 10.25143088 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 1057 | 0 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g7559 | i0 | 99.315 | 99.9948630136986 | 584 | 4 | 100 | 0 | 1 | 584 | 2589 | 3172 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 58397 | 1057 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 20041646 | 20041646 | PRJNA939415_P_NODE_17076_length_377_cov_1.638158_g16656_i0 | PRJNA939415 | 17076 | 377 | 1.638158 | 6.17585566 | Enterovirus deconjuncti | 3428506 | Viruses | Viruses | 697 | 0 | NTclustered | gi|694265777|gb|KM851231.1| | 42789 | g16656 | i0 | 100 | 100 | 377 | 0 | 100 | 0 | 1 | 377 | 3505 | 3881 | Enterovirus D68 strain US/KY/14-18953, complete genome | blastn | 37700 | 697 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus deconjuncti | ||
| 20041659 | 20041659 | PRJNA939415_P_NODE_176_length_7555_cov_315.918070_g123_i0 | PRJNA939415 | 176 | 7555 | 315.91807 | 23867.6101885 | Norovirus norwalkense | 3431196 | Viruses | Viruses | 13570 | 0 | NTclustered | gi|2027319263|gb|MW661278.1| | 122929 | g123 | i0 | 99.087 | 99.6820648577101 | 7555 | 69 | 100 | 0 | 1 | 7555 | 7569 | 15 | Norovirus GII isolate BMH19-127, complete genome | blastn | 753098 | 13570 | 1 | Viruses | Norovirus GII | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Norovirus | Norovirus norwalkense |
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);;