contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA757618" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 732783 | 732783 | PRJNA757618_P_NODE_7721_length_408_cov_1.629851_g6669_i0 | PRJNA757618 | 7721 | 408 | 1.629851 | 6.64979208 | Praha dicistro-like virus 2 | 2789509 | Viruses | Viruses | 721 | 0 | NTclustered | gi|1940199696|gb|MT757500.1| | 2789509 | g6669 | i0 | 98.529 | 1 | 408 | 6 | 100 | 0 | 1 | 408 | 8586 | 8993 | Praha dicistro-like virus 2 strain Czetp-6 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 408 | 721 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Praha dicistro-like virus 2 | |||
| 732823 | 732823 | PRJNA757618_P_NODE_9381_length_364_cov_1.859107_g8329_i0 | PRJNA757618 | 9381 | 364 | 1.859107 | 6.76714948 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 673 | 0 | NTclustered | gi|323856|gb|M37588.1|EMCDIAB | 12104 | g8329 | i0 | 100 | 4.79395604395604 | 364 | 0 | 100 | 0 | 1 | 364 | 5214 | 4851 | Encephalomyocarditis virus, diabetogenic variant (D variant, ifp- phenotype) polyprotein mRNA, complete cds | blastn | 1745 | 673 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 2477981 | 2477981 | PRJNA757618_P_NODE_6042_length_506_cov_1.542725_g4992_i0 | PRJNA757618 | 6042 | 506 | 1.542725 | 7.8061885 | Cripavirus | 144051 | Viruses | Viruses | 86.1 | 4.88e-12 | NTclustered | gi|2802644575|gb|PQ246907.1| | 12136 | g4992 | i0 | 100 | 1.91699604743083 | 46 | 0 | 9 | 0 | 18 | 63 | 9142 | 9097 | Cricket paralysis virus strain CrPV_BEE, complete genome | blastn | 970 | 86.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus grylli | ||
| 3284015 | 3284015 | PRJNA757618_P_NODE_4283_length_857_cov_2.470663_g3258_i0 | PRJNA757618 | 4283 | 857 | 2.470663 | 21.17358191 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1583 | 0 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g3258 | i0 | 100 | 7.41190198366394 | 857 | 0 | 100 | 0 | 1 | 857 | 2124 | 2980 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 6352 | 1583 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 3284150 | 3284150 | PRJNA757618_P_NODE_6903_length_444_cov_2.105121_g5851_i0 | PRJNA757618 | 6903 | 444 | 2.105121 | 9.34673724 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 821 | 0 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g5851 | i0 | 100 | 70.0135135135135 | 444 | 0 | 100 | 0 | 1 | 444 | 7794 | 7351 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 31086 | 821 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 7111554 | 7111554 | PRJNA757618_P_NODE_6846_length_447_cov_2.368984_g5794_i0 | PRJNA757618 | 6846 | 447 | 2.368984 | 10.58935848 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 821 | 0 | NTclustered | gi|323856|gb|M37588.1|EMCDIAB | 12104 | g5794 | i0 | 99.776 | 65.4407158836689 | 447 | 1 | 100 | 0 | 1 | 447 | 4238 | 3792 | Encephalomyocarditis virus, diabetogenic variant (D variant, ifp- phenotype) polyprotein mRNA, complete cds | blastn | 29252 | 821 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 9661268 | 9661268 | PRJNA757618_P_NODE_6268_length_487_cov_1.381643_g5216_i0 | PRJNA757618 | 6268 | 487 | 1.381643 | 6.72860141 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 900 | 0 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g5216 | i0 | 100 | 6.61601642710472 | 487 | 0 | 100 | 0 | 1 | 487 | 1801 | 1315 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 3222 | 900 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 13485946 | 13485946 | PRJNA757618_P_NODE_11011_length_339_cov_1.864662_g9959_i0 | PRJNA757618 | 11011 | 339 | 1.864662 | 6.32120418 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 621 | 1.95e-173 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g9959 | i0 | 99.705 | 59.5516224188791 | 339 | 1 | 100 | 0 | 1 | 339 | 6748 | 7086 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 20188 | 621 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 13486641 | 13486641 | PRJNA757618_P_NODE_7431_length_420_cov_1.991354_g6379_i0 | PRJNA757618 | 7431 | 420 | 1.991354 | 8.3636868 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 771 | 0 | NTclustered | gi|854638|emb|X87335.1| | 12104 | g6379 | i0 | 99.762 | 5.05238095238095 | 420 | 1 | 100 | 0 | 1 | 420 | 3303 | 3722 | Encephalomyocarditis virus complete genome | blastn | 2122 | 771 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 14761748 | 14761748 | PRJNA757618_P_NODE_4952_length_667_cov_2.745791_g3906_i0 | PRJNA757618 | 4952 | 667 | 2.745791 | 18.31442597 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1221 | 0 | NTclustered | gi|323856|gb|M37588.1|EMCDIAB | 12104 | g3906 | i0 | 99.7 | 4.00449775112444 | 667 | 2 | 100 | 0 | 1 | 667 | 5624 | 6290 | Encephalomyocarditis virus, diabetogenic variant (D variant, ifp- phenotype) polyprotein mRNA, complete cds | blastn | 2671 | 1221 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 18584705 | 18584705 | PRJNA757618_P_NODE_8315_length_389_cov_1.259494_g7263_i0 | PRJNA757618 | 8315 | 389 | 1.259494 | 4.89943166 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 669 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g7263 | i0 | 97.686 | 1 | 389 | 9 | 100 | 0 | 1 | 389 | 5863 | 6251 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 389 | 669 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 22409838 | 22409838 | PRJNA757618_P_NODE_27418_length_252_cov_1.636872_g26366_i0 | PRJNA757618 | 27418 | 252 | 1.636872 | 4.12491744 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 462 | 8.91e-126 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g26366 | i0 | 100 | 87.0436507936508 | 250 | 0 | 99 | 0 | 3 | 252 | 911 | 662 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 21935 | 462 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 24958819 | 24958819 | PRJNA757618_P_NODE_15280_length_300_cov_4.788546_g14228_i0 | PRJNA757618 | 15280 | 300 | 4.788546 | 14.365638 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 553 | 6.279999999999998e-153 | NTclustered | gi|323854|gb|M22458.1|EMCDCG | 12104 | g14228 | i0 | 100 | 100.29 | 299 | 0 | 99 | 0 | 2 | 300 | 609 | 311 | Encephalomyocarditis (EMC) virus EMC-D variant, RNA, complete genome | blastn | 30087 | 553 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 24959367 | 24959367 | PRJNA757618_P_NODE_4980_length_661_cov_3.316327_g3934_i0 | PRJNA757618 | 4980 | 661 | 3.316327 | 21.92092147 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1216 | 0 | NTclustered | gi|323856|gb|M37588.1|EMCDIAB | 12104 | g3934 | i0 | 99.849 | 67.0499243570348 | 661 | 1 | 100 | 0 | 1 | 661 | 4853 | 4193 | Encephalomyocarditis virus, diabetogenic variant (D variant, ifp- phenotype) polyprotein mRNA, complete cds | blastn | 44320 | 1216 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 24959452 | 24959452 | PRJNA757618_P_NODE_9000_length_372_cov_4.280936_g7948_i0 | PRJNA757618 | 9000 | 372 | 4.280936 | 15.92508192 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 688 | 0 | NTclustered | gi|323856|gb|M37588.1|EMCDIAB | 12104 | g7948 | i0 | 100 | 4 | 372 | 0 | 100 | 0 | 1 | 372 | 5258 | 5629 | Encephalomyocarditis virus, diabetogenic variant (D variant, ifp- phenotype) polyprotein mRNA, complete cds | blastn | 1488 | 688 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti |
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);;