RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA704949 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
702499 702499 PRJNA704949_P_NODE_995601_length_261_cov_1.448113_g980266_i0 PRJNA704949 995601 261 1.448113 3.77957493 Reagent-associated CRESS-like virus 6 2875814 Viruses Viruses 460 3.3399999999999995e-125   NTclustered gi|2094552983|gb|MZ824232.1| 2875814 g980266 i0 99.603 0.96551724137931 252 1 97 0 10 261 691 440 Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence blastn 252 460 1 Viruses   Shotokuvirae Cressdnaviricota         Reagent-associated CRESS-like virus 6
13443314 13443314 PRJNA704949_P_NODE_1444811_length_206_cov_1.299363_g1429473_i0 PRJNA704949 1444811 206 1.299363 2.67668778 Reagent-associated CRESS-like virus 6 2875814 Viruses Viruses 307 3.4800000000000004e-79   NTclustered gi|2094552983|gb|MZ824232.1| 2875814 g1429473 i0 98.295 1.05825242718447 176 2 100 1 31 206 1692 1866 Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence blastn 218 307 1 Viruses   Shotokuvirae Cressdnaviricota         Reagent-associated CRESS-like virus 6
20311972 20311972 PRJNA704949_P_NODE_1119416_length_243_cov_0.948454_g1104080_i0 PRJNA704949 1119416 243 0.948454 2.30474322 Viruses 10239 Viruses Viruses 416 6.739999999999998e-112   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g1104080 i0 100 2.77777777777778 225 0 93 0 19 243 116 340 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 675 416 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS 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);;