RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675331 · 19 ✖

analysis 1

  • blastn · 19 ✖

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
647660 647660 PRJNA675331_P_NODE_1701_length_698_cov_1.353600_g1540_i0 PRJNA675331 1701 698 1.3536 9.448128 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 1151 0   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g1540 i0 96.418 1 698 25 100 0 1 698 3748 4445 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 698 1151 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
647683 647683 PRJNA675331_P_NODE_22461_length_244_cov_0.888889_g22289_i0 PRJNA675331 22461 244 0.888889 2.16888916 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 435 1.87e-117   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g22289 i0 98.77 1 244 3 100 0 1 244 334 91 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 244 435 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
1923807 1923807 PRJNA675331_P_NODE_11782_length_294_cov_1.742081_g11610_i0 PRJNA675331 11782 294 1.742081 5.12171814 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 516 8.05e-142   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g11610 i0 98.299 1 294 5 100 0 1 294 3309 3016 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 294 516 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
1923846 1923846 PRJNA675331_P_NODE_15782_length_266_cov_1.347150_g15610_i0 PRJNA675331 15782 266 1.34715 3.583419 Betacoronavirus pandemicum 3418604 Viruses Viruses 492 1.2099999999999999e-134   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g15610 i0 100 100 266 0 100 0 1 266 14123 13858 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 26600 492 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1923908 1923908 PRJNA675331_P_NODE_502_length_1240_cov_1.655527_g403_i0 PRJNA675331 502 1240 1.655527 20.5285348 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 2174 0   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g403 i0 98.306 1 1240 21 100 0 1 1240 8428 7189 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 1240 2174 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
1923925 1923925 PRJNA675331_P_NODE_9062_length_328_cov_0.937255_g8890_i0 PRJNA675331 9062 328 0.937255 3.0741964 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 590 5.29e-164   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g8890 i0 99.085 1 328 3 100 0 1 328 4888 5215 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 328 590 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
3198607 3198607 PRJNA675331_P_NODE_1363_length_774_cov_1.838802_g1208_i0 PRJNA675331 1363 774 1.838802 14.23232748 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 1303 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g1208 i0 97.028 1 774 23 100 0 1 774 8074 7301 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 774 1303 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
4475789 4475789 PRJNA675331_P_NODE_3304_length_514_cov_2.083900_g3134_i0 PRJNA675331 3304 514 2.0839 10.711246 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 911 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g3134 i0 98.638 1 514 7 100 0 1 514 2650 2137 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 514 911 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
4475794 4475794 PRJNA675331_P_NODE_4104_length_466_cov_1.175573_g3932_i0 PRJNA675331 4104 466 1.175573 5.47817018 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 833 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g3932 i0 98.927 1 466 5 100 0 1 466 6680 7145 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 466 833 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
4475801 4475801 PRJNA675331_P_NODE_5384_length_413_cov_0.905882_g5212_i0 PRJNA675331 5384 413 0.905882 3.74129266 Qianjiang dicistro-like virus 168 3347427 Viruses Viruses 736 0   NTclustered gi|2806503225|gb|PQ055042.1| 3347427 g5212 i0 98.789 1 413 5 100 0 1 413 459 871 MAG: Qianjiang dicistro-like virus 168 isolate QJ3DG1347 genomic sequence blastn 413 736 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 168
4475812 4475812 PRJNA675331_P_NODE_824_length_980_cov_1.407938_g699_i0 PRJNA675331 824 980 1.407938 13.7977924 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 1711 0   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g699 i0 98.163 1 980 18 100 0 1 980 3562 2583 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 980 1711 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
5751341 5751341 PRJNA675331_P_NODE_2865_length_550_cov_1.421384_g2697_i0 PRJNA675331 2865 550 1.421384 7.817612 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 966 0   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g2697 i0 98.364 1.23272727272727 550 9 100 0 1 550 8680 9229 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 678 966 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
7026387 7026387 PRJNA675331_P_NODE_1726_length_693_cov_1.598387_g1565_i0 PRJNA675331 1726 693 1.598387 11.07682191 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 1206 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g1565 i0 98.121 0.998556998556999 692 13 99 0 2 693 4232 3541 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 692 1206 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
9576370 9576370 PRJNA675331_P_NODE_4828_length_434_cov_1.706371_g4656_i0 PRJNA675331 4828 434 1.706371 7.40565014 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 769 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g4656 i0 98.618 1 434 6 100 0 1 434 6135 6568 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 434 769 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
13401790 13401790 PRJNA675331_P_NODE_13451_length_279_cov_1.495146_g13279_i0 PRJNA675331 13451 279 1.495146 4.17145734 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 455 1.68e-123   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g13279 i0 96.057 1 279 11 100 0 1 279 4763 5041 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 279 455 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
18500035 18500035 PRJNA675331_P_NODE_21375_length_245_cov_1.343023_g21203_i0 PRJNA675331 21375 245 1.343023 3.29040635 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 448 2.41e-121   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g21203 i0 99.592 1 245 1 100 0 1 245 8434 8678 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 245 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
18500067 18500067 PRJNA675331_P_NODE_615_length_1114_cov_1.494717_g506_i0 PRJNA675331 615 1114 1.494717 16.65114738 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 1591 0   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g506 i0 92.453 1.77468581687612 1113 84 99 0 1 1113 6598 5486 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 1977 1591 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20
19774663 19774663 PRJNA675331_P_NODE_7376_length_358_cov_1.350877_g7204_i0 PRJNA675331 7376 358 1.350877 4.83613966 Qianjiang dicistro-like virus 76 3347492 Viruses Viruses 651 0   NTclustered gi|2806502952|gb|PQ054937.1| 3347492 g7204 i0 99.443 1.00279329608939 359 1 100 1 1 358 168 526 MAG: Qianjiang dicistro-like virus 76 isolate QJ3MS937 genomic sequence blastn 359 651 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 76
22325134 22325134 PRJNA675331_P_NODE_17458_length_254_cov_2.127072_g17286_i0 PRJNA675331 17458 254 2.127072 5.40276288 Qianjiang dicistro-like virus 20 3347433 Viruses Viruses 448 2.5199999999999996e-121   NTclustered gi|2806502782|gb|PQ054880.1| 3347433 g17286 i0 98.425 1 254 4 100 0 1 254 1519 1266 MAG: Qianjiang dicistro-like virus 20 isolate QJ3MS3552 genomic sequence blastn 254 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 20

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