RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1145997" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA1145997 · 4 ✖

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
7942438 7942438 PRJNA1145997_P_NODE_29047_length_404_cov_15.274924_g26430_i0 PRJNA1145997 29047 404 15.274924 61.71069296 Potexvirus alternantherae 85454 Viruses Viruses 302 3.4800000000000005e-77   NTclustered gi|985481707|dbj|LC107515.1| 85454 g26430 i0 81.152 28.1089108910891 382 67 94 5 3 383 6600 6223 Alternanthera mosaic virus genomic RNA, complete genome, isolate: Ac blastn 11356 302 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus alternantherae
7942704 7942704 PRJNA1145997_P_NODE_4487_length_1801_cov_8.185185_g3871_i0 PRJNA1145997 4487 1801 8.185185 147.41518185 Nepovirus avii 3047741 Viruses Viruses 3094 0   NTclustered gi|2520246192|gb|OQ731915.1| 12615 g3871 i0 97.668 61.5552470849528 1801 42 100 0 1 1801 4651 6451 Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA2, complete sequence blastn 110861 3094 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
16866001 16866001 PRJNA1145997_P_NODE_12634_length_1080_cov_11.954320_g10822_i0 PRJNA1145997 12634 1080 11.95432 129.106656 Birch idaeovirus 2600116 Viruses Viruses 1489 0   NTclustered gi|2912264205|gb|PQ867864.1| 2600116 g10822 i0 92.075 1.63796296296296 1060 81 98 2 8 1064 1 1060 Birch idaeovirus isolate C502 segment RNA2, complete sequence blastn 1769 1489 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Mayoviridae Idaeovirus Birch idaeovirus
28870538 28870538 PRJNA1145997_P_NODE_19808_length_705_cov_2.087025_g17271_i0 PRJNA1145997 19808 705 2.087025 14.71352625 Ripalant virus 3130886 Viruses Viruses 90.5 3.56e-19   NR WZH60499.1 3130886 g17271 i0 41.7 0.48936170212766 115 66 48.5 1 321 662 1 115 WZH60499.1 MAG: putative capsid protein [Ripalant virus] diamond 345 90.5 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripalant virus

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