contig_metadata
8 rows where bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6546787 | 6546787 | PRJNA1035005_P_NODE_23906_length_290_cov_2.239631_g23500_i0 | PRJNA1035005 | 23906 | 290 | 2.239631 | 6.4949299 | brine shrimp partitivirus 3 | 2900394 | Viruses | Viruses | 536 | 6.079999999999999e-148 | NTclustered | gi|2209094945|gb|OL472544.1| | 2900394 | g23500 | i0 | 100 | 15.5103448275862 | 290 | 0 | 100 | 0 | 1 | 290 | 2017 | 2306 | MAG: Brine shrimp partitivirus 3 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 4498 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 3 | |||
| 11211175 | 11211175 | PRJNA1035005_P_NODE_4669_length_493_cov_1.164286_g4269_i0 | PRJNA1035005 | 4669 | 493 | 1.164286 | 5.73992998 | Viruses | 10239 | Viruses | Viruses | 889 | 0 | NTclustered | gi|2209094941|gb|OL472542.1| | 2900394 | g4269 | i0 | 99.19 | 15.030425963488799 | 494 | 3 | 100 | 1 | 1 | 493 | 566 | 73 | MAG: Brine shrimp partitivirus 3 isolate SD/11-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 7410 | 894 | 0.994407158836689 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 3 | |||
| 11647185 | 11647185 | PRJNA1035005_P_NODE_1110_length_1275_cov_1.503328_g862_i0 | PRJNA1035005 | 1110 | 1275 | 1.503328 | 19.167432 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 2106 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g862 | i0 | 96.471 | 3 | 1275 | 45 | 100 | 0 | 1 | 1275 | 7864 | 6590 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 3825 | 2106 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 11647232 | 11647232 | PRJNA1035005_P_NODE_17690_length_311_cov_1.310924_g17284_i0 | PRJNA1035005 | 17690 | 311 | 1.310924 | 4.07697364 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 514 | 3.08e-141 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g17284 | i0 | 96.463 | 3 | 311 | 11 | 100 | 0 | 1 | 311 | 3548 | 3238 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 933 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14197356 | 14197356 | PRJNA1035005_P_NODE_2232_length_781_cov_2.843220_g1861_i0 | PRJNA1035005 | 2232 | 781 | 2.84322 | 22.2055482 | Penaeus vannamei partiti-like virus 1 | 3119342 | Viruses | Viruses | 1375 | 0 | NTclustered | gi|2697475300|gb|PP215226.1| | 3119342 | g1861 | i0 | 99.866 | 3.6235595390525 | 747 | 1 | 96 | 0 | 35 | 781 | 2080 | 1334 | Penaeus vannamei partiti-like virus 1 isolate 03/SD/202005 hypothetical protein gene, complete cds | blastn | 2830 | 1375 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Penaeus vannamei partiti-like virus 1 | |||
| 14197533 | 14197533 | PRJNA1035005_P_NODE_44552_length_264_cov_1.162304_g44146_i0 | PRJNA1035005 | 44552 | 264 | 1.162304 | 3.06848256 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 444 | 3.41e-120 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g44146 | i0 | 96.97 | 3 | 264 | 8 | 100 | 0 | 1 | 264 | 4817 | 4554 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 792 | 444 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22684609 | 22684609 | PRJNA1035005_P_NODE_22358_length_292_cov_2.114155_g21952_i0 | PRJNA1035005 | 22358 | 292 | 2.114155 | 6.1733326 | Viruses | 10239 | Viruses | Viruses | 540 | 4.74e-149 | NTclustered | gi|2209094941|gb|OL472542.1| | 2900394 | g21952 | i0 | 100 | 15 | 292 | 0 | 100 | 0 | 1 | 292 | 1438 | 1147 | MAG: Brine shrimp partitivirus 3 isolate SD/11-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 4380 | 540 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 3 | |||
| 32501480 | 32501480 | PRJNA1035005_P_NODE_13539_length_333_cov_1.107692_g13133_i0 | PRJNA1035005 | 13539 | 333 | 1.107692 | 3.68861436 | brine shrimp dicistrovirus 1 | 2900466 | Viruses | Viruses | 61.2 | 3.41e-8 | NR | UNI73824.1 | 2900466 | g13133 | i0 | 45 | 0.540540540540541 | 60 | 33 | 54.1 | 0 | 182 | 3 | 649 | 708 | UNI73824.1 MAG: capsid protein [brine shrimp dicistrovirus 1] | diamond | 180 | 61.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | brine shrimp dicistrovirus 1 |
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);;