RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1237347 · 23 ✖

analysis 1

  • blastn · 23 ✖

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
1048834 1048834 PRJNA1237347_P_NODE_425001_length_269_cov_1.571429_g418428_i0 PRJNA1237347 425001 269 1.571429 4.22714401 Tobamovirus 12234 Viruses Viruses 497 2.63e-136   NTclustered gi|2837380181|gb|PP099897.1| 1761477 g418428 i0 100 100 269 0 100 0 1 269 653 921 Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome blastn 26900 497 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum
3597833 3597833 PRJNA1237347_P_NODE_118223_length_612_cov_1.512059_g111721_i0 PRJNA1237347 118223 612 1.512059 9.25380108 Tobamovirus 12234 Viruses Viruses 1131 0   NTclustered gi|2794685826|gb|PQ243309.1| 1761477 g111721 i0 100 100 612 0 100 0 1 612 53 664 Tomato brown rugose fruit virus isolate RHN RNA-dependent RNA polymerase gene, partial cds blastn 61200 1131 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum
4165939 4165939 PRJNA1237347_P_NODE_218284_length_409_cov_2.211310_g211712_i0 PRJNA1237347 218284 409 2.21131 9.0442579 Lake Sinai virus 1547219 Viruses Viruses 660 0   NTclustered gi|2200496761|gb|OL803842.1| 1547219 g211712 i0 95.833 87.8533007334963 408 17 99 0 2 409 32 439 Lake Sinai virus strain LSV-B7B ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds; and ORF4 gene, partial cds blastn 35932 660 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus
4173194 4173194 PRJNA1237347_P_NODE_75644_length_815_cov_2.691375_g69671_i0 PRJNA1237347 75644 815 2.691375 21.93470625 Lake Sinai virus 2 1041831 Viruses Viruses 1312 0   NTclustered gi|2500352213|ref|NC_074993.1| 1041831 g69671 i0 95.706 91.1226993865031 815 35 100 0 1 815 5603 4789 Lake Sinai virus 2 strain BruceSD_T17E01 Orf1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 74265 1312 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
5440300 5440300 PRJNA1237347_P_NODE_132385_length_568_cov_2.038384_g125854_i0 PRJNA1237347 132385 568 2.038384 11.57802112 Lake Sinai virus 2 1041831 Viruses Viruses 961 0   NTclustered gi|2500352213|ref|NC_074993.1| 1041831 g125854 i0 97.183 96.9348591549296 568 16 100 0 1 568 5036 5603 Lake Sinai virus 2 strain BruceSD_T17E01 Orf1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 55059 961 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
6714201 6714201 PRJNA1237347_P_NODE_111366_length_636_cov_1.895204_g104892_i0 PRJNA1237347 111366 636 1.8952040000000001 12.05349744 Lake Sinai virus 2 1041831 Viruses Viruses 946 0   NTclustered gi|1229082879|gb|KY465711.1| 1041831 g104892 i0 93.543 43.8805031446541 635 41 99 0 2 636 633 1267 Lake Sinai virus 2 strain QLD ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 27908 946 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
6714273 6714273 PRJNA1237347_P_NODE_114786_length_624_cov_1.470054_g108299_i0 PRJNA1237347 114786 624 1.470054 9.17313696 Potexvirus marmorplantagonis 3433852 Viruses Viruses 54.7 0.017   NTclustered gi|1469213961|dbj|LC422371.1| 28354 g108299 i0 100 0.046474358974359 29 0 5 0 228 256 2975 2947 Plantago asiatica mosaic virus kr2 genomic RNA, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus marmorplantagonis
9266099 9266099 PRJNA1237347_P_NODE_178548_length_467_cov_2.832487_g171977_i0 PRJNA1237347 178548 467 2.832487 13.22771429 Lake Sinai virus 1547219 Viruses Viruses 808 0   NTclustered gi|2200496756|gb|OL803841.1| 1547219 g171977 i0 97.859 92.4603854389722 467 10 100 0 1 467 2459 1993 Lake Sinai virus strain LSV-B7A ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds; and ORF4 gene, partial cds blastn 43179 808 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus
9266514 9266514 PRJNA1237347_P_NODE_198108_length_436_cov_2.140496_g191536_i0 PRJNA1237347 198108 436 2.140496 9.33256256 Sinaivirus sp. 2809865 Viruses Viruses 739 0   NTclustered gi|2753027953|gb|PP830606.1| 2809865 g191536 i0 97.248 46.0298165137615 436 12 100 0 1 436 3117 3552 MAG: Sinaivirus sp. isolate BB_H09_000001 genomic sequence blastn 20069 739 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Sinaivirus sp.
9266938 9266938 PRJNA1237347_P_NODE_217508_length_410_cov_2.035608_g210936_i0 PRJNA1237347 217508 410 2.035608 8.3459928 Sinaivirus sp. 2809865 Viruses Viruses 680 0   NTclustered gi|2753027953|gb|PP830606.1| 2809865 g210936 i0 96.814 83.7658536585366 408 12 99 1 3 410 1972 1566 MAG: Sinaivirus sp. isolate BB_H09_000001 genomic sequence blastn 34344 680 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Sinaivirus sp.
9269644 9269644 PRJNA1237347_P_NODE_351148_length_302_cov_4.144105_g344575_i0 PRJNA1237347 351148 302 4.144105 12.5151971 Sinaivirus sp. 2809865 Viruses Viruses 508 1.39e-139   NTclustered gi|2753027958|gb|PP830611.1| 2809865 g344575 i0 97.02 41 302 9 100 0 1 302 675 976 MAG: Sinaivirus sp. isolate BB_UH12_000006 genomic sequence blastn 12382 508 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Sinaivirus sp.
11815446 11815446 PRJNA1237347_P_NODE_123190_length_595_cov_4.649425_g116673_i0 PRJNA1237347 123190 595 4.649425 27.66407875 Lake Sinai virus 2 1041831 Viruses Viruses 898 0   NTclustered gi|1229082879|gb|KY465711.1| 1041831 g116673 i0 93.939 42.6050420168067 594 36 99 0 1 594 4464 3871 Lake Sinai virus 2 strain QLD ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 25350 898 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
11815820 11815820 PRJNA1237347_P_NODE_1390_length_5731_cov_5.060269_g1207_i0 PRJNA1237347 1390 5731 5.060269 290.00401639 Martellivirales sp. gcode 6 3108922 Viruses Viruses 65.8 7.69e-5   NTclustered gi|2647548592|gb|OR843387.1| 3108922 g1207 i0 83.333 0.0125632524864771 72 10 1 2 2118 2188 1144 1074 Martellivirales sp. gcode 6 strain MR233-17E/2180 polyprotein gene, partial cds blastn 72 65.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales     Martellivirales sp. gcode 6
14367136 14367136 PRJNA1237347_P_NODE_182972_length_460_cov_1.369509_g176401_i0 PRJNA1237347 182972 460 1.369509 6.2997414 Lake Sinai virus 2 1041831 Viruses Viruses 767 0   NTclustered gi|1229082879|gb|KY465711.1| 1041831 g176401 i0 96.739 45.3282608695652 460 15 100 0 1 460 2531 2990 Lake Sinai virus 2 strain QLD ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 20851 767 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
15075682 15075682 PRJNA1237347_P_NODE_282952_length_346_cov_2.249084_g276379_i0 PRJNA1237347 282952 346 2.249084 7.78183064 Tobamovirus 12234 Viruses Viruses 638 1.9799999999999997e-178   NTclustered gi|2837380407|gb|PP099942.1| 1761477 g276379 i0 100 99.7109826589595 345 0 99 0 2 346 1550 1206 Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome blastn 34500 638 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum
16914356 16914356 PRJNA1237347_P_NODE_143074_length_540_cov_3.064240_g136533_i0 PRJNA1237347 143074 540 3.06424 16.546896 Lake Sinai virus 2 1041831 Viruses Viruses 826 0   NTclustered gi|1229082879|gb|KY465711.1| 1041831 g136533 i0 94.259 46.3611111111111 540 31 100 0 1 540 2917 3456 Lake Sinai virus 2 strain QLD ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 25035 826 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
17625335 17625335 PRJNA1237347_P_NODE_18754_length_1828_cov_3.469516_g16350_i0 PRJNA1237347 18754 1828 3.469516 63.42275248 Tobamovirus 12234 Viruses Viruses 3358 0   NTclustered gi|2201445597|gb|OM515237.1| 1761477 g16350 i0 99.836 99.9403719912473 1827 3 99 0 2 1828 6293 4467 Tomato brown rugose fruit virus isolate 6166394_2, complete genome blastn 182691 3358 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum
17627388 17627388 PRJNA1237347_P_NODE_65834_length_890_cov_1.596083_g60160_i0 PRJNA1237347 65834 890 1.596083 14.2051387 Sinaivirus 1921556 Viruses Viruses 1386 0   NTclustered gi|1229082879|gb|KY465711.1| 1041831 g60160 i0 94.82 94.0943820224719 888 46 99 0 2 889 1011 1898 Lake Sinai virus 2 strain QLD ORF1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 83744 1393 0.994974874371859 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
18194668 18194668 PRJNA1237347_P_NODE_430475_length_267_cov_1.489691_g423902_i0 PRJNA1237347 430475 267 1.489691 3.97747497 Sinaivirus sp. 2809865 Viruses Viruses 459 1.2299999999999998e-124   NTclustered gi|2753027958|gb|PP830611.1| 2809865 g423902 i0 97.744 42.8052434456929 266 6 99 0 2 267 646 381 MAG: Sinaivirus sp. isolate BB_UH12_000006 genomic sequence blastn 11429 459 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Sinaivirus sp.
18899094 18899094 PRJNA1237347_P_NODE_173275_length_477_cov_1.351485_g166704_i0 PRJNA1237347 173275 477 1.351485 6.44658345 Tobamovirus 12234 Viruses Viruses 874 0   NTclustered gi|2419914955|gb|OM782671.1| 1761477 g166704 i0 99.79 99.79035639413 476 1 99 0 2 477 4375 3900 Tomato brown rugose fruit virus strain ClnSin, complete genome blastn 47600 874 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum
19470741 19470741 PRJNA1237347_P_NODE_517316_length_245_cov_2.412791_g510743_i0 PRJNA1237347 517316 245 2.412791 5.91133795 Sinaivirus sp. 2809865 Viruses Viruses 411 3.17e-110   NTclustered gi|2753027953|gb|PP830606.1| 2809865 g510743 i0 97.131 43.1714285714286 244 6 99 1 3 245 3818 3575 MAG: Sinaivirus sp. isolate BB_H09_000001 genomic sequence blastn 10577 411 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Sinaivirus sp.
20747726 20747726 PRJNA1237347_P_NODE_83117_length_767_cov_2.760807_g76970_i0 PRJNA1237347 83117 767 2.760807 21.17538969 Lake Sinai virus 2 1041831 Viruses Viruses 1146 0   NTclustered gi|2500352213|ref|NC_074993.1| 1041831 g76970 i0 93.611 42.8657105606258 767 49 100 0 1 767 3809 4575 Lake Sinai virus 2 strain BruceSD_T17E01 Orf1, RNA-dependant RNA polymerase, and capsid protein genes, complete cds blastn 32878 1146 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Sinhaliviridae Sinaivirus Lake Sinai virus 2
22021949 22021949 PRJNA1237347_P_NODE_546338_length_242_cov_0.911243_g539765_i0 PRJNA1237347 546338 242 0.911243 2.20520806 Tobamovirus fructirugosum 3432872 Viruses Viruses 442 1.1099999999999995e-119   NTclustered gi|2837380181|gb|PP099897.1| 1761477 g539765 i0 99.587 100 242 1 100 0 1 242 587 346 Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome blastn 24200 442 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus fructirugosum

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