RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA683669 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
6278878 6278878 PRJNA683669_P_NODE_20365_length_286_cov_1.248826_g20133_i0 PRJNA683669 20365 286 1.248826 3.57164236 Cripavirus 144051 Viruses Viruses 424 4.86e-114   NTclustered gi|2196304203|gb|MZ679075.1| 1955141 g20133 i0 93.357 7.24825174825175 286 19 100 0 1 286 697 982 MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds blastn 2073 424 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
7043565 7043565 PRJNA683669_P_NODE_14306_length_342_cov_1.784387_g14075_i0 PRJNA683669 14306 342 1.784387 6.10260354 Hangzhou hydrellia griseola dicistrovirus 1 2905414 Viruses Viruses 424 5.95e-114   NTclustered gi|2170811221|gb|MZ209736.1| 2905414 g14075 i0 93.357 3.34502923976608 286 19 84 0 57 342 7749 8034 MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate YSP1FY336, complete genome blastn 1144 424 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Hangzhou hydrellia griseola dicistrovirus 1
8318260 8318260 PRJNA683669_P_NODE_9187_length_422_cov_1.191977_g8956_i0 PRJNA683669 9187 422 1.191977 5.03014294 Dicistroviridae sp. 1955144 Viruses Viruses 680 0   NTclustered gi|1836405876|gb|MN905999.1| 1955144 g8956 i0 95.735 5.39810426540284 422 18 100 0 1 422 8143 8564 MAG: Dicistroviridae sp. isolate wag171dic3 genomic sequence, sequence blastn 2278 680 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
12654250 12654250 PRJNA683669_P_NODE_15930_length_325_cov_1.099206_g15699_i0 PRJNA683669 15930 325 1.099206 3.5724195 Cripavirus 144051 Viruses Viruses 440 5.579999999999999e-119   NTclustered gi|2196304203|gb|MZ679075.1| 1955141 g15699 i0 91.077 9.98769230769231 325 29 100 0 1 325 1548 1872 MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds blastn 3246 440 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
13418996 13418996 PRJNA683669_P_NODE_32171_length_243_cov_1.129412_g31939_i0 PRJNA683669 32171 243 1.129412 2.74447116 Dicistroviridae sp. 1955144 Viruses Viruses 364 2.479999999999999e-96   NTclustered gi|2756423324|gb|PP745452.1| 1955144 g31939 i0 93.802 7.96296296296296 242 15 99 0 2 243 2953 3194 MAG: Dicistroviridae sp. isolate 129_15506 genomic sequence blastn 1935 364 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
15203559 15203559 PRJNA683669_P_NODE_25472_length_254_cov_1.276243_g25240_i0 PRJNA683669 25472 254 1.276243 3.24165722 Viruses 10239 Viruses Viruses 357 4.36e-94   NTclustered gi|2756423469|gb|PP745525.1| 1955144 g25240 i0 92.095 9.91732283464567 253 20 99 0 2 254 373 625 MAG: Dicistroviridae sp. isolate 196_164348 genomic sequence blastn 2519 359 0.994428969359331 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
22852255 22852255 PRJNA683669_P_NODE_14638_length_339_cov_0.868421_g14407_i0 PRJNA683669 14638 339 0.868421 2.94394719 Viruses 10239 Viruses Viruses 516 9.44e-142   NTclustered gi|2170811218|gb|MZ209732.1| 2905414 g14407 i0 94.1 10.7109144542773 339 20 100 0 1 339 4882 4544 MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate XHQTFY46, complete genome blastn 3631 521 0.990403071017274 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Hangzhou hydrellia griseola dicistrovirus 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;