RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA493827", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 17 ✖

tax_phylum 1

  • Duplornaviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 17 ✖

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
471097 471097 PRJNA493827_P_NODE_171541_length_261_cov_1.563830_g169343_i0 PRJNA493827 171541 261 1.56383 4.0815963 Betacystovirus phi12 3427160 Viruses Viruses 422 1.57e-113   NTclustered gi|22855221|ref|NC_004175.1| 161736 g169343 i0 95.785 1 261 11 100 0 1 261 1033 773 Pseudomonas phage phi12 segment M, complete sequence blastn 261 422 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
474247 474247 PRJNA493827_P_NODE_91821_length_358_cov_1.417544_g89623_i0 PRJNA493827 91821 358 1.417544 5.07480752 Betacystovirus phi12 3427160 Viruses Viruses 606 5.769999999999998e-169   NTclustered gi|22855221|ref|NC_004175.1| 161736 g89623 i0 97.207 1 358 10 100 0 1 358 1831 1474 Pseudomonas phage phi12 segment M, complete sequence blastn 358 606 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
1749152 1749152 PRJNA493827_P_NODE_92462_length_357_cov_1.052817_g90264_i0 PRJNA493827 92462 357 1.052817 3.75855669 Betacystovirus phi12 3427160 Viruses Viruses 545 1.27e-150   NTclustered gi|22855221|ref|NC_004175.1| 161736 g90264 i0 94.602 0.985994397759104 352 19 99 0 6 357 3535 3184 Pseudomonas phage phi12 segment M, complete sequence blastn 352 545 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
6851015 6851015 PRJNA493827_P_NODE_58906_length_459_cov_1.196891_g56710_i0 PRJNA493827 58906 459 1.196891 5.49372969 Betacystovirus phi12 3427160 Viruses Viruses 398 4.969999999999998e-106   NTclustered gi|22855209|ref|NC_004173.1| 161736 g56710 i0 82.418 0.991285403050109 455 80 99 0 2 456 5580 6034 Pseudomonas phage phi12 segment L, complete sequence blastn 455 398 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
9401772 9401772 PRJNA493827_P_NODE_73488_length_404_cov_1.574018_g71290_i0 PRJNA493827 73488 404 1.574018 6.35903272 Betacystovirus phi12 3427160 Viruses Viruses 603 8.53e-168   NTclustered gi|22855221|ref|NC_004175.1| 161736 g71290 i0 93.564 1 404 26 100 0 1 404 2669 3072 Pseudomonas phage phi12 segment M, complete sequence blastn 404 603 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
9402133 9402133 PRJNA493827_P_NODE_89688_length_362_cov_2.847751_g87490_i0 PRJNA493827 89688 362 2.847751 10.30885862 Betacystovirus phi12 3427160 Viruses Viruses 270 8.71e-68   NTclustered gi|22855209|ref|NC_004173.1| 161736 g87490 i0 80.737 0.975138121546961 353 62 97 6 3 352 1734 2083 Pseudomonas phage phi12 segment L, complete sequence blastn 353 270 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
10673244 10673244 PRJNA493827_P_NODE_104749_length_334_cov_2.065134_g102551_i0 PRJNA493827 104749 334 2.065134 6.89754756 Betacystovirus phi12 3427160 Viruses Viruses 540 5.51e-149   NTclustered gi|22855221|ref|NC_004175.1| 161736 g102551 i0 95.808 1 334 14 100 0 1 334 4074 3741 Pseudomonas phage phi12 segment M, complete sequence blastn 334 540 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
11952540 11952540 PRJNA493827_P_NODE_76430_length_395_cov_1.913043_g74232_i0 PRJNA493827 76430 395 1.913043 7.55651985 Betacystovirus phi12 3427160 Viruses Viruses 603 8.319999999999999e-168   NTclustered gi|22855221|ref|NC_004175.1| 161736 g74232 i0 94.177 1 395 23 100 0 1 395 1063 1457 Pseudomonas phage phi12 segment M, complete sequence blastn 395 603 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
11952660 11952660 PRJNA493827_P_NODE_81290_length_382_cov_1.245955_g79092_i0 PRJNA493827 81290 382 1.245955 4.7595481 Betacystovirus phi12 3427160 Viruses Viruses 623 6.159999999999999e-174   NTclustered gi|22855221|ref|NC_004175.1| 161736 g79092 i0 96.073 1 382 15 100 0 1 382 2427 2046 Pseudomonas phage phi12 segment M, complete sequence blastn 382 623 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
14499736 14499736 PRJNA493827_P_NODE_16932_length_967_cov_2.809843_g15270_i0 PRJNA493827 16932 967 2.809843 27.17118181 Betacystovirus phi12 3427160 Viruses Viruses 1026 0   NTclustered gi|22855209|ref|NC_004173.1| 161736 g15270 i0 85.818 0.998965873836608 966 137 99 0 1 966 605 1570 Pseudomonas phage phi12 segment L, complete sequence blastn 966 1026 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
17050063 17050063 PRJNA493827_P_NODE_3614_length_2280_cov_5.608971_g3046_i0 PRJNA493827 3614 2280 5.608971 127.8845388 Betacystovirus phi12 3427160 Viruses Viruses 4000 0   NTclustered gi|22855216|ref|NC_004174.1| 161736 g3046 i0 98.333 1 2280 38 100 0 1 2280 2298 19 Pseudomonas phage phi12 segment S, complete sequence blastn 2280 4000 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
17050277 17050277 PRJNA493827_P_NODE_43854_length_546_cov_2.183932_g41668_i0 PRJNA493827 43854 546 2.183932 11.92426872 Betacystovirus phi12 3427160 Viruses Viruses 957 0   NTclustered gi|22855221|ref|NC_004175.1| 161736 g41668 i0 98.352 1 546 8 99 1 1 545 24 569 Pseudomonas phage phi12 segment M, complete sequence blastn 546 957 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
19599206 19599206 PRJNA493827_P_NODE_54176_length_482_cov_1.315403_g51985_i0 PRJNA493827 54176 482 1.315403 6.34024246 Betacystovirus phi12 3427160 Viruses Viruses 457 8.52e-124   NTclustered gi|22855209|ref|NC_004173.1| 161736 g51985 i0 83.891 0.991701244813278 478 77 99 0 5 482 4005 3528 Pseudomonas phage phi12 segment L, complete sequence blastn 478 457 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27692956 27692956 PRJNA493827_P_NODE_185384_length_251_cov_0.865169_g183186_i0 PRJNA493827 185384 251 0.865169 2.17157419 Viruses 10239 Viruses Viruses 63.9 1.41e-9   NR UYL95680.1 2972361 g183186 i0 60 1.19521912350598 50 20 59.8 0 157 8 609 658 UYL95680.1 MAG: polyprotein [Dali Totiv tick virus 1] diamond 300 63.9 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Dali Totiv tick virus 1
28940231 28940231 PRJNA493827_P_NODE_54668_length_479_cov_2.487685_g52476_i0 PRJNA493827 54668 479 2.487685 11.91601115 Jiangsu sediment cystovirus 2824307 Viruses Viruses 50.8 5.23e-4   NR QYF49681.1 2824307 g52476 i0 29.2 1.07098121085595 171 102 98.3 6 4 474 125 290 QYF49681.1 MAG: putative RNA-dependent RNA polymerase, partial [Jiangsu sediment cystovirus] diamond 513 50.8 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Cystovirus Jiangsu sediment cystovirus
28971711 28971711 PRJNA493827_P_NODE_59028_length_458_cov_2.153247_g56832_i0 PRJNA493827 59028 458 2.153247 9.86187126 Pseudomonas phage phi12 161736 Viruses Viruses 278 7.989999999999999e-87   NR NP_690825.1 161736 g56832 i0 97.4 0.995633187772926 152 4 99.6 0 2 457 19 170 NP_690825.1 major core structural protein P1 [Pseudomonas phage phi12] diamond 456 278 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
32700297 32700297 PRJNA493827_P_NODE_144860_length_284_cov_1.459716_g142662_i0 PRJNA493827 144860 284 1.459716 4.14559344 Pseudomonas phage phi12 161736 Viruses Viruses 198 5.42e-58   NR NP_690823.1 161736 g142662 i0 96.8 0.992957746478873 94 3 99.3 0 284 3 493 586 NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] diamond 282 198 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12

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