RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 14 ✖

bioproject 1

  • PRJNA849172 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
3387062 3387062 PRJNA849172_P_NODE_4383_length_1060_cov_78.398176_g4119_i0 PRJNA849172 4383 1060 78.398176 831.0206656 Aspergillus creber narnavirus 1 2875494 Viruses Viruses 1413 0   NTclustered gi|2130544298|dbj|LC648936.1| 2875494 g4119 i0 90.951 1.01132075471698 1072 65 99 24 8 1060 1073 15 Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 4, complete sequence blastn 1072 1413 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Aspergillus creber narnavirus 1
4663217 4663217 PRJNA849172_P_NODE_124624_length_228_cov_3.412903_g124264_i0 PRJNA849172 124624 228 3.412903 7.78141884 Botourmiaviridae sp. 2808997 Viruses Viruses 355 1.38e-93   NTclustered gi|2396039473|gb|ON812832.1| 2808997 g124264 i0 95.111 0.986842105263158 225 11 99 0 1 225 1460 1684 MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome blastn 225 355 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
4663546 4663546 PRJNA849172_P_NODE_136764_length_211_cov_11.775362_g136404_i0 PRJNA849172 136764 211 11.775362 24.84601382 Botourmiaviridae sp. 2808997 Viruses Viruses 372 1.25e-98   NTclustered gi|2396039473|gb|ON812832.1| 2808997 g136404 i0 98.571 0.995260663507109 210 3 99 0 1 210 2503 2294 MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome blastn 210 372 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
8488338 8488338 PRJNA849172_P_NODE_16407_length_514_cov_3.247166_g16048_i0 PRJNA849172 16407 514 3.247166 16.69043324 Shenzhen dicistro-like virus 2789378 Viruses Viruses 922 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g16048 i0 99.029 3.20622568093385 515 4 100 1 1 514 8901 8387 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 1648 922 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
8488370 8488370 PRJNA849172_P_NODE_1727_length_1649_cov_20.180838_g1594_i0 PRJNA849172 1727 1649 20.180838 332.78201862 Aspergillus creber narnavirus 1 2875494 Viruses Viruses 2320 0   NTclustered gi|2130544296|dbj|LC648935.1| 2875494 g1594 i0 92.266 1.63856882959369 1642 117 99 9 12 1649 1653 18 Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 3, complete sequence blastn 2702 2320 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Aspergillus creber narnavirus 1
14862913 14862913 PRJNA849172_P_NODE_132452_length_217_cov_6.944444_g132092_i0 PRJNA849172 132452 217 6.944444 15.06944348 Dicistroviridae sp. 1955144 Viruses Viruses 390 3.579999999999999e-104   NTclustered gi|2756423573|gb|PP745577.1| 1955144 g132092 i0 99.078 4.20276497695852 217 2 100 0 1 217 1566 1350 MAG: Dicistroviridae sp. isolate 268_6903 genomic sequence blastn 912 390 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
14865594 14865594 PRJNA849172_P_NODE_8632_length_739_cov_42.429429_g8290_i0 PRJNA849172 8632 739 42.429429 313.55348031 Shenzhen dicistro-like virus 2789378 Viruses Viruses 1000 0   NTclustered gi|1940197836|gb|MT721845.1| 2789378 g8290 i0 96.529 3.07171853856563 605 20 82 1 135 739 9270 8667 Shenzhen dicistro-like virus polyprotein gene, complete cds blastn 2270 1000 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
18685451 18685451 PRJNA849172_P_NODE_10315_length_668_cov_4.347899_g9963_i0 PRJNA849172 10315 668 4.347899 29.04396532 Aspergillus creber narnavirus 1 2875494 Viruses Viruses 802 0   NTclustered gi|2130544291|dbj|LC648933.1| 2875494 g9963 i0 88.358 1.00299401197605 670 74 100 4 1 668 111 778 Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence blastn 670 802 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Aspergillus creber narnavirus 1
19961455 19961455 PRJNA849172_P_NODE_1336_length_1818_cov_44.459599_g1230_i0 PRJNA849172 1336 1818 44.459599 808.27550982 Aspergillus creber narnavirus 1 2875494 Viruses Viruses 1070 0   NTclustered gi|2130544293|dbj|LC648934.1| 2875494 g1230 i0 79.2 1.12101210121012 1601 287 87 39 16 1599 84 1655 Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 2, complete sequence blastn 2038 1070 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Aspergillus creber narnavirus 1
19961920 19961920 PRJNA849172_P_NODE_15176_length_537_cov_3.424569_g14817_i0 PRJNA849172 15176 537 3.424569 18.38993553 Shenzhen dicistro-like virus 2789378 Viruses Viruses 920 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g14817 i0 97.579 2 537 13 100 0 1 537 7867 8403 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 1074 920 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
21237866 21237866 PRJNA849172_P_NODE_26437_length_399_cov_16.036810_g26078_i0 PRJNA849172 26437 399 16.03681 63.9868719 Aspergillus creber narnavirus 1 2875494 Viruses Viruses 593 5.059999999999998e-165   NTclustered gi|2130544291|dbj|LC648933.1| 2875494 g26078 i0 93.924 0.989974937343358 395 21 98 2 7 398 3381 2987 Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence blastn 395 593 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Aspergillus creber narnavirus 1
21238009 21238009 PRJNA849172_P_NODE_30797_length_369_cov_15.395270_g30438_i0 PRJNA849172 30797 369 15.39527 56.8085463 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 377 5.090000000000001e-100   NTclustered gi|2754691651|gb|PP872615.1| 3003959 g30438 i0 89.632 0.81029810298103 299 27 80 4 1 297 9266 8970 MAG: Picornavirales sp. isolate TC-PLV-59 MR233-17E/322 genomic sequence blastn 299 377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
25061468 25061468 PRJNA849172_P_NODE_142880_length_204_cov_5.770992_g142520_i0 PRJNA849172 142880 204 5.770992 11.77282368 Skokie dicistro-like virus 2789443 Viruses Viruses 322 1.23e-83   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g142520 i0 95.098 1.75490196078431 204 10 100 0 1 204 8469 8672 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 358 322 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
25062923 25062923 PRJNA849172_P_NODE_560_length_2444_cov_16.794601_g505_i0 PRJNA849172 560 2444 16.794601 410.46004844 Hulunbuir Botou tick virus 2 2972054 Viruses Viruses 4348 0   NTclustered gi|2820295211|gb|PQ180957.1| 2972054 g505 i0 98.773 12.7385433715221 2444 30 100 0 1 2444 68 2511 MAG: Hulunbuir Botou tick virus 2 isolate Hebei_107 genomic sequence blastn 31133 4348 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Hulunbuir Botou tick virus 2

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