RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax_phylum = "Artverviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Artverviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA597223 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
4396497 4396497 PRJNA597223_P_NODE_22884_length_331_cov_4.337838_g21041_i0 PRJNA597223 22884 331 4.337838 14.35824378 Dioscorea nummularia-associated virus 2303485 Viruses Viruses 103 3.62e-23   NR YP_009553219.1 2303485 g21041 i0 63.4 0.643504531722054 71 26 64.4 0 7 219 1280 1350 YP_009553219.1 ORF3 [Dioscorea nummularia-associated virus] diamond 213 103 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Dioscovirus Dioscovirus dioscoreae
5672725 5672725 PRJNA597223_P_NODE_26725_length_298_cov_4.288973_g24880_i0 PRJNA597223 26725 298 4.288973 12.78113954 Dioscorea nummularia-associated virus 2303485 Viruses Viruses 93.6 1.04e-19   NR YP_009553219.1 2303485 g24880 i0 62.5 1.93288590604027 64 24 64.4 0 292 101 1280 1343 YP_009553219.1 ORF3 [Dioscorea nummularia-associated virus] diamond 576 93.6 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Dioscovirus Dioscovirus dioscoreae
8222269 8222269 PRJNA597223_P_NODE_35487_length_244_cov_4.727273_g33641_i0 PRJNA597223 35487 244 4.727273 11.53454612 Dioscorea nummularia-associated virus 2303485 Viruses Viruses 77.8 1.76e-14   NR YP_009553219.1 2303485 g33641 i0 73.3 0.55327868852459 45 12 55.3 0 238 104 1280 1324 YP_009553219.1 ORF3 [Dioscorea nummularia-associated virus] diamond 135 77.8 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Dioscovirus Dioscovirus dioscoreae
24795536 24795536 PRJNA597223_P_NODE_720_length_1852_cov_11.987892_g429_i0 PRJNA597223 720 1852 11.987892 222.01575984 Sweet potato collusive virus 930168 Viruses Viruses 134 1.9299999999999999e-28   NR YP_004347414.1 930168 g429 i0 27.7 1.45302375809935 537 321 82.5 20 322 1848 427 924 YP_004347414.1 coat protein/movement protein [Sweet potato collusive virus] diamond 2691 134 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Cavemovirus Cavemovirus collusipomeae
28722104 28722104 PRJNA597223_P_NODE_12587_length_480_cov_8.377528_g10844_i0 PRJNA597223 12587 480 8.377528 40.2121344 Grapevine pararetrovirus 2996761 Viruses Viruses 86.7 2.32e-16   NR WBR64758.1 2996761 g10844 i0 33.6 0.93125 149 96 93.1 3 4 450 13 158 WBR64758.1 MAG: putative polymerase polyprotein [Grapevine pararetrovirus] diamond 447 86.7 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales     Grapevine pararetrovirus
29290288 29290288 PRJNA597223_P_NODE_15409_length_426_cov_6.337596_g13612_i0 PRJNA597223 15409 426 6.337596 26.99815896 Sweet potato collusive virus 930168 Viruses Viruses 67.4 7.17e-10   NR YP_004347414.1 930168 g13612 i0 45.9 0.52112676056338 74 38 50.7 1 219 4 553 626 YP_004347414.1 coat protein/movement protein [Sweet potato collusive virus] diamond 222 67.4 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Cavemovirus Cavemovirus collusipomeae
29461252 29461252 PRJNA597223_P_NODE_33510_length_254_cov_6.799087_g31664_i0 PRJNA597223 33510 254 6.799087 17.26968098 Cavemovirus 186533 Viruses Viruses 51.2 4.48e-5   NR YP_004347414.1 930168 g31664 i0 38.7 1.66535433070866 75 45 88.6 1 3 227 585 658 YP_004347414.1 coat protein/movement protein [Sweet potato collusive virus] diamond 423 51.2 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Cavemovirus Cavemovirus collusipomeae
29858617 29858617 PRJNA597223_P_NODE_3371_length_938_cov_11.703212_g2414_i0 PRJNA597223 3371 938 11.703212 109.77612856 Cauliflower mosaic virus 10641 Viruses Viruses 213 1.0400000000000001e-59   NR NP_056728.1 10641 g2414 i0 37 2.12046908315565 330 186 99.1 7 4 933 23 350 NP_056728.1 reverse transcriptase [Cauliflower mosaic virus] diamond 1989 213 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Caulimovirus Caulimovirus tessellobrassicae
30237842 30237842 PRJNA597223_P_NODE_79212_length_158_cov_4.772358_g77366_i0 PRJNA597223 79212 158 4.772358 7.54032564 chicory mosaic cavemovirus 2871729 Viruses Viruses 41.6 0.0306   NR QZH55166.1 2871729 g77366 i0 35.6 0.854430379746835 45 29 85.4 0 136 2 1220 1264 QZH55166.1 coat protein [chicory mosaic cavemovirus] diamond 135 41.6 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Cavemovirus chicory mosaic cavemovirus
30459389 30459389 PRJNA597223_P_NODE_29533_length_278_cov_4.506173_g27687_i0 PRJNA597223 29533 278 4.506173 12.52716094 Agapanthus tungrovirus 2838078 Viruses Viruses 82.4 6.54e-16   NR QVY19172.1 2838078 g27687 i0 51.8 7.89928057553957 83 39 88.5 1 273 28 1305 1387 QVY19172.1 p194 [Agapanthus tungrovirus] diamond 2196 82.4 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Tungrovirus Tungrovirus agapanthi
32071332 32071332 PRJNA597223_P_NODE_48858_length_200_cov_1.793939_g47012_i0 PRJNA597223 48858 200 1.793939 3.587878 Water chestnut soymovirus 1 1848040 Viruses Viruses 50.8 2.94e-5   NR YP_009254008.1 1848040 g47012 i0 55.6 1.41 45 18 64.5 1 9 137 418 462 YP_009254008.1 putative aspartic protease [Water chestnut soymovirus 1] diamond 282 50.8 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Soymovirus Soymovirus eleocharis
32387756 32387756 PRJNA597223_P_NODE_23719_length_323_cov_6.128472_g21875_i0 PRJNA597223 23719 323 6.128472 19.79496456 Sweet potato collusive virus 930168 Viruses Viruses 68.9 6.24e-11   NR YP_004347414.1 930168 g21875 i0 40.2 0.947368421052632 102 54 88.2 2 288 4 525 626 YP_004347414.1 coat protein/movement protein [Sweet potato collusive virus] diamond 306 68.9 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Cavemovirus Cavemovirus collusipomeae

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