contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 445028 | 445028 | PRJNA473641_P_NODE_1941_length_597_cov_3.654580_g1859_i0 | PRJNA473641 | 1941 | 597 | 3.65458 | 21.8178426 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 1048 | 0 | NTclustered | gi|2754692633|gb|PP872994.1| | 3003959 | g1859 | i0 | 98.325 | 1 | 597 | 10 | 100 | 0 | 1 | 597 | 4756 | 4160 | MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence | blastn | 597 | 1048 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 1719638 | 1719638 | PRJNA473641_P_NODE_11782_length_297_cov_2.642857_g11699_i0 | PRJNA473641 | 11782 | 297 | 2.642857 | 7.84928529 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 516 | 8.14e-142 | NTclustered | gi|2754692633|gb|PP872994.1| | 3003959 | g11699 | i0 | 97.98 | 1 | 297 | 6 | 100 | 0 | 1 | 297 | 3775 | 4071 | MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence | blastn | 297 | 516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 5548912 | 5548912 | PRJNA473641_P_NODE_685_length_911_cov_1.852029_g622_i0 | PRJNA473641 | 685 | 911 | 1.852029 | 16.87198419 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 1037 | 0 | NTclustered | gi|2754692633|gb|PP872994.1| | 3003959 | g622 | i0 | 88.101 | 2.52140504939627 | 874 | 102 | 96 | 2 | 1 | 873 | 3624 | 2752 | MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence | blastn | 2297 | 1037 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 5548952 | 5548952 | PRJNA473641_P_NODE_8525_length_334_cov_1.084291_g8442_i0 | PRJNA473641 | 8525 | 334 | 1.084291 | 3.62153194 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 113 | 1.42e-20 | NTclustered | gi|2165832678|emb|OV195277.1| | 2697049 | g8442 | i0 | 93.59 | 47.997005988024 | 78 | 1 | 22 | 3 | 1 | 74 | 29930 | 30007 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 16031 | 113 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6198613 | 6198613 | PRJNA473641_P_NODE_26225_length_237_cov_2.439024_g26142_i0 | PRJNA473641 | 26225 | 237 | 2.439024 | 5.78048688 | root | 1 | Root_unresolved | Root_unresolved | 438 | 1.4e-118 | NTclustered | gi|15485521|emb|AJ293908.1| | 10515 | g26142 | i0 | 100 | 99.9662447257384 | 237 | 0 | 100 | 0 | 1 | 237 | 1327 | 1091 | Human adenovirus type 2 penton gene, isolate 352 | blastn | 23692 | 438 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 6822900 | 6822900 | PRJNA473641_P_NODE_6666_length_365_cov_1.051370_g6583_i0 | PRJNA473641 | 6666 | 365 | 1.05137 | 3.8375005 | Alpharetrovirus avileu | 3426267 | Viruses | Viruses | 675 | 0 | NTclustered | gi|2575656431|gb|OQ990407.1| | 11864 | g6583 | i0 | 100 | 100.005479452055 | 365 | 0 | 100 | 0 | 1 | 365 | 1242 | 1606 | Avian leukosis virus isolate GX23BH03K envelope protein gene, partial cds | blastn | 36502 | 675 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 6822908 | 6822908 | PRJNA473641_P_NODE_6_length_3647_cov_8.905428_g4_i0 | PRJNA473641 | 6 | 3647 | 8.905428 | 324.78095916 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 2344 | 0 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g4 | i0 | 78.488 | 26.8390457910611 | 3677 | 722 | 100 | 61 | 1 | 3647 | 5545 | 9182 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 97882 | 2344 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 10023748 | 10023748 | PRJNA473641_P_NODE_15968_length_259_cov_2.064516_g15885_i0 | PRJNA473641 | 15968 | 259 | 2.064516 | 5.34709644 | root | 1 | Root_unresolved | Root_unresolved | 296 | 9.87e-76 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g15885 | i0 | 96.648 | 103.328185328185 | 179 | 4 | 97 | 2 | 10 | 186 | 16393 | 16215 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 26762 | 298 | 0.993288590604027 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 14473753 | 14473753 | PRJNA473641_P_NODE_24932_length_242_cov_0.911243_g24849_i0 | PRJNA473641 | 24932 | 242 | 0.911243 | 2.20520806 | Gylbovirus aagae | 2955967 | Viruses | Viruses | 403 | 5.22e-108 | NTclustered | gi|1407526736|gb|MH430649.1| | 2230910 | g24849 | i0 | 97.083 | 28.5537190082645 | 240 | 5 | 99 | 1 | 3 | 242 | 6031 | 5794 | Aedes anphevirus isolate Bora Bora nucleoprotein and small TMD protein genes, complete cds; nonfunctional putative glycoprotein genes, complete sequence; putative ZnF protein and putative TMD protein genes, complete cds; and nonfunctional RdRP protein gene, complete sequence | blastn | 6910 | 403 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Xinmoviridae | Gylbovirus | Gylbovirus aagae | ||
| 14473858 | 14473858 | PRJNA473641_P_NODE_572_length_965_cov_3.014574_g512_i0 | PRJNA473641 | 572 | 965 | 3.014574 | 29.0906391 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 538 | 6.149999999999998e-148 | NTclustered | gi|2756423296|gb|PP745438.1| | 1955144 | g512 | i0 | 76.899 | 1.00932642487047 | 974 | 209 | 100 | 14 | 1 | 965 | 4860 | 3894 | MAG: Dicistroviridae sp. isolate 087_50073 genomic sequence | blastn | 974 | 538 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 14473911 | 14473911 | PRJNA473641_P_NODE_7872_length_343_cov_3.425926_g7789_i0 | PRJNA473641 | 7872 | 343 | 3.425926 | 11.75092618 | brine shrimp dicistrovirus 1 | 2900466 | Viruses | Viruses | 82.4 | 4.14e-11 | NTclustered | gi|2209094695|gb|OL472420.1| | 2900466 | g7789 | i0 | 86.842 | 1.06705539358601 | 76 | 6 | 22 | 3 | 232 | 307 | 9460 | 9531 | MAG: Brine shrimp dicistrovirus 1 isolate KAZ/15-16 RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 366 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | brine shrimp dicistrovirus 1 | |||
| 20846766 | 20846766 | PRJNA473641_P_NODE_25377_length_241_cov_1.589286_g25294_i0 | PRJNA473641 | 25377 | 241 | 1.589286 | 3.83017926 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 418 | 1.8599999999999995e-112 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g25294 | i0 | 97.925 | 3 | 241 | 5 | 100 | 0 | 1 | 241 | 5886 | 6126 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 723 | 418 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21497316 | 21497316 | PRJNA473641_P_NODE_3297_length_479_cov_1.270936_g3214_i0 | PRJNA473641 | 3297 | 479 | 1.270936 | 6.08778344 | root | 1 | Root_unresolved | Root_unresolved | 865 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g3214 | i0 | 99.372 | 99.7933194154488 | 478 | 2 | 99 | 1 | 3 | 479 | 16079 | 15602 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 47801 | 865 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 24047435 | 24047435 | PRJNA473641_P_NODE_819_length_852_cov_2.568678_g752_i0 | PRJNA473641 | 819 | 852 | 2.568678 | 21.88513656 | root | 1 | Root_unresolved | Root_unresolved | 1555 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g752 | i0 | 99.648 | 100 | 852 | 2 | 100 | 1 | 1 | 852 | 16820 | 17670 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 85200 | 1555 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;