RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA416866" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 24 ✖

bioproject 1

  • PRJNA416866 · 24 ✖
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
419610 419610 PRJNA416866_P_NODE_1_length_8517_cov_6.467715_g0_i0 PRJNA416866 1 8517 6.467715 550.85528655 Cripavirus drosophilae 3047809 Viruses Viruses 12273 0   NTclustered gi|1743646607|gb|MK645238.1| 64279 g0 i0 97.938 19.9293178349184 7081 146 100 0 935 8015 8062 982 Drosophila C virus isolate CYG, complete genome blastn 169738 12273 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
1694480 1694480 PRJNA416866_P_NODE_62_length_2274_cov_3.456394_g51_i0 PRJNA416866 62 2274 3.456394 78.59839956 Drosophila A virus 595895 Viruses Viruses 3945 0   NTclustered gi|822478147|gb|KP969949.1| 595895 g51 i0 97.933 34.150835532102 2274 47 100 0 1 2274 1545 3818 Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds blastn 77659 3945 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
1694490 1694490 PRJNA416866_P_NODE_8422_length_222_cov_1.590062_g8278_i0 PRJNA416866 8422 222 1.590062 3.52993764 Caudoviricetes sp. 2832643 Viruses Viruses 372 1.33e-98   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g8278 i0 96.861 409.405405405405 223 6 100 1 1 222 18392 18170 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 90888 372 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4246703 4246703 PRJNA416866_P_NODE_2744_length_409_cov_1.465517_g2601_i0 PRJNA416866 2744 409 1.465517 5.99396453 Shahe picorna-like virus 13 1923443 Viruses Viruses 750 0   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g2601 i0 99.756 9 409 1 100 0 1 409 8277 8685 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 3681 750 1 Viruses               Shahe picorna-like virus 13
4911750 4911750 PRJNA416866_P_NODE_10464_length_206_cov_0.882759_g10320_i0 PRJNA416866 10464 206 0.882759 1.81848354 Viruses 10239 Viruses Viruses 375 9.41e-100   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g10320 i0 99.515 8.99029126213592 206 1 100 0 1 206 4659 4864 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 1852 375 1 Viruses               Shahe picorna-like virus 13
6797409 6797409 PRJNA416866_P_NODE_11626_length_202_cov_0.907801_g11482_i0 PRJNA416866 11626 202 0.907801 1.83375802 Biavirus raunefjordenense 3059777 Viruses Viruses 147 7.84e-31   NTclustered gi|2500387999|ref|NC_077221.1| 1499987 g11482 i0 84.106 3.22772277227723 151 24 75 0 4 154 1131164 1131014 Prymnesium kappa virus genome assembly, chromosome: 1 blastn 652 147 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Schizomimiviridae Biavirus Biavirus raunefjordenense
8072990 8072990 PRJNA416866_P_NODE_847_length_799_cov_3.200542_g720_i0 PRJNA416866 847 799 3.200542 25.57233058 Drosophila A virus 595895 Viruses Viruses 1343 0   NTclustered gi|253761971|ref|NC_012958.1| 595895 g720 i0 96.996 22.575719649562 799 24 100 0 1 799 3961 4759 Drosophila A virus, complete genome blastn 18038 1343 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
8072991 8072991 PRJNA416866_P_NODE_9047_length_213_cov_2.526316_g8903_i0 PRJNA416866 9047 213 2.526316 5.38105308 Drosophila A virus 595895 Viruses Viruses 383 5.8499999999999996e-102   NTclustered gi|822478135|gb|KP969945.1| 595895 g8903 i0 99.061 40.9671361502347 213 2 100 0 1 213 217 5 Drosophila A virus isolate XID_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds blastn 8726 383 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
9347737 9347737 PRJNA416866_P_NODE_4028_length_329_cov_1.194030_g3885_i0 PRJNA416866 4028 329 1.19403 3.9283587 Shahe picorna-like virus 13 1923443 Viruses Viruses 608 1.4599999999999995e-169   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g3885 i0 100 7.7629179331307 329 0 100 0 1 329 7417 7089 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 2554 608 1 Viruses               Shahe picorna-like virus 13
11898487 11898487 PRJNA416866_P_NODE_4550_length_309_cov_1.028226_g4406_i0 PRJNA416866 4550 309 1.028226 3.17721834 Shahe picorna-like virus 13 1923443 Viruses Viruses 571 1.7899999999999995e-158   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g4406 i0 100 8.02588996763754 309 0 100 0 1 309 8198 7890 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 2480 571 1 Viruses               Shahe picorna-like virus 13
13173406 13173406 PRJNA416866_P_NODE_10051_length_207_cov_0.876712_g9907_i0 PRJNA416866 10051 207 0.876712 1.81479384 Caudoviricetes sp. 2832643 Viruses Viruses 361 2.65e-95   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g9907 i0 98.068 355.95652173913 207 4 100 0 1 207 18145 17939 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 73683 361 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18271273 18271273 PRJNA416866_P_NODE_1135_length_668_cov_1.970346_g998_i0 PRJNA416866 1135 668 1.970346 13.16191128 Caudoviricetes sp. 2832643 Viruses Viruses 62.1 1.11e-4   NTclustered gi|2059632675|tpg|BK028438.1| 2832643 g998 i0 92.857 0.320359281437126 42 3 6 0 402 443 42472 42431 MAG TPA_asm: Caudoviricetes sp. isolate ctawJ4, partial genome blastn 214 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19545512 19545512 PRJNA416866_P_NODE_9496_length_209_cov_0.864865_g9352_i0 PRJNA416866 9496 209 0.864865 1.80756785 Eriocheir sinensis alphatetra-like virus 3022104 Viruses Viruses 274 3.59e-69   NTclustered gi|2430285571|gb|OP019089.1| 3022104 g9352 i0 90.385 0.995215311004785 208 20 99 0 1 208 9785 9578 MAG: Eriocheir sinensis alphatetra-like virus isolate Tangshan, Hebei genomic sequence blastn 208 274 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales Alphatetraviridae   Eriocheir sinensis alphatetra-like virus
20821389 20821389 PRJNA416866_P_NODE_3297_length_369_cov_2.571429_g3154_i0 PRJNA416866 3297 369 2.571429 9.48857301 Cripavirus drosophilae 3047809 Viruses Viruses 632 9.839999999999998e-177   NTclustered gi|9629650|ref|NC_001834.1| 64279 g3154 i0 97.568 13.4986449864499 370 8 100 1 1 369 385 16 Drosophila C virus strain EB, complete genome blastn 4981 632 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
20821404 20821404 PRJNA416866_P_NODE_6757_length_250_cov_1.354497_g6613_i0 PRJNA416866 6757 250 1.354497 3.3862425 Eridge virus 1807812 Viruses Viruses 429 8.949999999999998e-116   NTclustered gi|1003096245|gb|KU754528.1| 1807812 g6613 i0 97.6 1.988 250 6 100 0 1 250 460 211 Eridge virus segment B putative replicase gene, complete cds blastn 497 429 1 Viruses   Orthornavirae       Birnaviridae   Eridge virus
20821405 20821405 PRJNA416866_P_NODE_7137_length_243_cov_1.054945_g6993_i0 PRJNA416866 7137 243 1.054945 2.56351635 Shahe picorna-like virus 13 1923443 Viruses Viruses 444 3.09e-120   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g6993 i0 99.588 6.8641975308642 243 1 100 0 1 243 2248 2490 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 1668 444 1 Viruses               Shahe picorna-like virus 13
22096103 22096103 PRJNA416866_P_NODE_6898_length_247_cov_1.580645_g6754_i0 PRJNA416866 6898 247 1.580645 3.90419315 Shahe picorna-like virus 13 1923443 Viruses Viruses 457 4.05e-124   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g6754 i0 100 6 247 0 100 0 1 247 7420 7666 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 1482 457 1 Viruses               Shahe picorna-like virus 13
23371767 23371767 PRJNA416866_P_NODE_1839_length_507_cov_1.455157_g1697_i0 PRJNA416866 1839 507 1.455157 7.37764599 Shahe picorna-like virus 13 1923443 Viruses Viruses 920 0   NTclustered gi|1110864981|gb|KX883657.1| 1923443 g1697 i0 99.408 9.98224852071006 507 3 100 0 1 507 4823 5329 Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds blastn 5061 920 1 Viruses               Shahe picorna-like virus 13
23371770 23371770 PRJNA416866_P_NODE_259_length_1369_cov_3.630734_g201_i0 PRJNA416866 259 1369 3.630734 49.70474846 Drosophila A virus 595895 Viruses Viruses 2457 0   NTclustered gi|822478150|gb|KP969950.1| 595895 g201 i0 99.05 34.6939371804237 1369 13 100 0 1 1369 216 1584 Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds blastn 47496 2457 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
24646022 24646022 PRJNA416866_P_NODE_3640_length_349_cov_1.215278_g3497_i0 PRJNA416866 3640 349 1.215278 4.24132022 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 0.009   NTclustered gi|2914861204|gb|OR222093.1| 2832643 g3497 i0 100 0.965616045845272 29 0 8 0 60 88 228486 228514 MAG: Caudoviricetes sp. isolate MSP0019 genomic sequence blastn 337 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27739328 27739328 PRJNA416866_P_NODE_4124_length_325_cov_1.215909_g3981_i0 PRJNA416866 4124 325 1.215909 3.95170425 Caudoviricetes sp. 2832643 Viruses Viruses 108 8.630000000000001e-27   NR DAY69239.1 2832643 g3981 i0 55.4 1.80923076923077 101 44 92.3 1 302 3 119 219 DAY69239.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 588 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30392019 30392019 PRJNA416866_P_NODE_9333_length_210_cov_1.543624_g9189_i0 PRJNA416866 9333 210 1.543624 3.2416104 Moss partitivirus 7 3067240 Viruses Viruses 94.7 1.1e-20   NR WPR17416.1 3067240 g9189 i0 58 0.985714285714286 69 29 98.6 0 3 209 293 361 WPR17416.1 MAG: RNA-dependent RNA polymerase, partial [Moss partitivirus 7] diamond 207 94.7 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Moss partitivirus 7
31055348 31055348 PRJNA416866_P_NODE_7995_length_228_cov_1.532934_g7851_i0 PRJNA416866 7995 228 1.532934 3.49508952 Tupanvirus deep ocean 2126984 Viruses Viruses 56.2 5e-7   NR YP_010781083.1 2126984 g7851 i0 38.7 0.986842105263158 75 38 98.7 1 225 1 94 160 YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] diamond 225 56.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus altamarinense
31466250 31466250 PRJNA416866_P_NODE_5076_length_291_cov_1.113043_g4932_i0 PRJNA416866 5076 291 1.113043 3.23895513 Klosneuvirus KNV1 1977640 Viruses Viruses 59.3 9.31e-8   NR ARF12104.1 1977640 g4932 i0 40.3 0.742268041237113 72 35 71.1 3 284 78 11 77 ARF12104.1 serpin [Klosneuvirus KNV1] diamond 216 59.3 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1

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