contig_metadata
14 rows where bioproject = "PRJNA902848", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 882070 | 882070 | PRJNA902848_P_NODE_1_length_5615_cov_9.733670_g0_i0 | PRJNA902848 | 1 | 5615 | 9.73367 | 546.5455705 | La Jolla virus | 1654357 | Viruses | Viruses | 8514 | 0 | NTclustered | gi|1417910481|gb|MH384285.1| | 1654357 | g0 | i0 | 94.034 | 31.2780053428317 | 5615 | 335 | 100 | 0 | 1 | 5615 | 10235 | 4621 | La Jolla virus strain HUNplus6453 putative polyprotein gene, complete cds | blastn | 175626 | 8514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | La Jolla virus | |||
| 882173 | 882173 | PRJNA902848_P_NODE_5761_length_353_cov_1.114286_g5711_i0 | PRJNA902848 | 5761 | 353 | 1.114286 | 3.93342958 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 597 | 3.42e-166 | NTclustered | gi|1743646607|gb|MK645238.1| | 64279 | g5711 | i0 | 97.167 | 9.97733711048159 | 353 | 10 | 100 | 0 | 1 | 353 | 8441 | 8089 | Drosophila C virus isolate CYG, complete genome | blastn | 3522 | 597 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 3432810 | 3432810 | PRJNA902848_P_NODE_623_length_803_cov_2.001370_g581_i0 | PRJNA902848 | 623 | 803 | 2.00137 | 16.0710011 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 1423 | 0 | NTclustered | gi|1743646607|gb|MK645238.1| | 64279 | g581 | i0 | 98.63 | 23.2739726027397 | 803 | 11 | 100 | 0 | 1 | 803 | 5903 | 6705 | Drosophila C virus isolate CYG, complete genome | blastn | 18689 | 1423 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 3432821 | 3432821 | PRJNA902848_P_NODE_6623_length_335_cov_2.469466_g6573_i0 | PRJNA902848 | 6623 | 335 | 2.469466 | 8.2727111 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 597 | 3.239999999999999e-166 | NTclustered | gi|1743646610|gb|MK645239.1| | 64279 | g6573 | i0 | 98.806 | 9.6089552238806 | 335 | 4 | 100 | 0 | 1 | 335 | 6895 | 7229 | Drosophila C virus isolate EB, complete genome | blastn | 3219 | 597 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 3432898 | 3432898 | PRJNA902848_P_NODE_963_length_679_cov_1.783828_g916_i0 | PRJNA902848 | 963 | 679 | 1.783828 | 12.11219212 | La Jolla virus | 1654357 | Viruses | Viruses | 1227 | 0 | NTclustered | gi|2463635383|gb|OP263081.1| | 1654357 | g916 | i0 | 99.265 | 23.2091310751105 | 680 | 4 | 100 | 1 | 1 | 679 | 13 | 692 | La Jolla virus isolate GBM59 putative polyprotein gene, complete cds | blastn | 15759 | 1227 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | La Jolla virus | |||
| 5985491 | 5985491 | PRJNA902848_P_NODE_7585_length_318_cov_1.571429_g7535_i0 | PRJNA902848 | 7585 | 318 | 1.571429 | 4.99714422 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 569 | 6.649999999999998e-158 | NTclustered | gi|1743646610|gb|MK645239.1| | 64279 | g7535 | i0 | 99.054 | 9.9685534591195 | 317 | 3 | 99 | 0 | 1 | 317 | 7446 | 7762 | Drosophila C virus isolate EB, complete genome | blastn | 3170 | 569 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 11085802 | 11085802 | PRJNA902848_P_NODE_6809_length_332_cov_1.444015_g6759_i0 | PRJNA902848 | 6809 | 332 | 1.444015 | 4.7941298 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 475 | 1.5699999999999994e-129 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g6759 | i0 | 92.47 | 1 | 332 | 25 | 100 | 0 | 1 | 332 | 6028 | 6359 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 332 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12360880 | 12360880 | PRJNA902848_P_NODE_1450_length_585_cov_2.134766_g1401_i0 | PRJNA902848 | 1450 | 585 | 2.134766 | 12.4883811 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 1029 | 0 | NTclustered | gi|1743646607|gb|MK645238.1| | 64279 | g1401 | i0 | 98.459 | 11.6820512820513 | 584 | 9 | 99 | 0 | 1 | 584 | 8448 | 9031 | Drosophila C virus isolate CYG, complete genome | blastn | 6834 | 1029 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 12360987 | 12360987 | PRJNA902848_P_NODE_190_length_1234_cov_1.589147_g165_i0 | PRJNA902848 | 190 | 1234 | 1.589147 | 19.61007398 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 749 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g165 | i0 | 93.137 | 0.640194489465154 | 510 | 35 | 64 | 0 | 81 | 590 | 4195 | 4704 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 790 | 749 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13635765 | 13635765 | PRJNA902848_P_NODE_2291_length_494_cov_2.688836_g2241_i0 | PRJNA902848 | 2291 | 494 | 2.688836 | 13.28284984 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 745 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g2241 | i0 | 93.737 | 1.00202429149798 | 495 | 30 | 100 | 1 | 1 | 494 | 6832 | 6338 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 495 | 745 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 16184648 | 16184648 | PRJNA902848_P_NODE_11553_length_267_cov_1.871134_g11503_i0 | PRJNA902848 | 11553 | 267 | 1.871134 | 4.99592778 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 477 | 3.3999999999999993e-130 | NTclustered | gi|1743646610|gb|MK645239.1| | 64279 | g11503 | i0 | 98.876 | 7.99250936329588 | 267 | 3 | 100 | 0 | 1 | 267 | 4680 | 4414 | Drosophila C virus isolate EB, complete genome | blastn | 2134 | 477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 22558914 | 22558914 | PRJNA902848_P_NODE_18_length_2456_cov_4.029375_g15_i0 | PRJNA902848 | 18 | 2456 | 4.029375 | 98.96145 | La Jolla virus | 1654357 | Viruses | Viruses | 3832 | 0 | NTclustered | gi|2034669305|gb|MW556743.1| | 1654357 | g15 | i0 | 94.829 | 25.8334690553746 | 2456 | 127 | 100 | 0 | 1 | 2456 | 2218 | 4673 | La Jolla virus putative polyprotein gene, complete cds | blastn | 63447 | 3832 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | La Jolla virus | |||
| 23834373 | 23834373 | PRJNA902848_P_NODE_9859_length_287_cov_1.004673_g9809_i0 | PRJNA902848 | 9859 | 287 | 1.004673 | 2.88341151 | Cripavirus drosophilae | 3047809 | Viruses | Viruses | 470 | 6.18e-128 | NTclustered | gi|1743646607|gb|MK645238.1| | 64279 | g9809 | i0 | 96.167 | 8.98954703832753 | 287 | 11 | 100 | 0 | 1 | 287 | 3660 | 3946 | Drosophila C virus isolate CYG, complete genome | blastn | 2580 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 25108079 | 25108079 | PRJNA902848_P_NODE_2160_length_506_cov_1.217090_g2111_i0 | PRJNA902848 | 2160 | 506 | 1.21709 | 6.1584754 | La Jolla virus | 1654357 | Viruses | Viruses | 582 | 1.4199999999999996e-161 | NTclustered | gi|822477737|gb|KP969764.1| | 1654357 | g2111 | i0 | 99.074 | 42.5691699604743 | 324 | 3 | 64 | 0 | 1 | 324 | 365 | 688 | La Jolla virus isolate UM01_LaJolla polyprotein gene, partial cds | blastn | 21540 | 582 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | La Jolla virus |
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);;