RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB6054" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJEB6054 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
25523000 25523000 PRJEB6054_S_NODE_1481_length_335_cov_1565.420000_g1392_i0 PRJEB6054 1481 335 1565.42 5244.157 Nilaparvata lugens C virus 1577072 Viruses Viruses 115 3.97e-21   NTclustered gi|726973360|gb|KM270560.1| 1577072 g1392 i0 85.714 14.7791044776119 112 12 32 3 175 282 9048 9159 Nilaparvata lugens C virus, complete genome blastn 4951 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Nilaparvata lugens C virus
26339586 26339586 PRJEB6054_S_NODE_823_length_400_cov_16.786301_g735_i0 PRJEB6054 823 400 16.786301 67.145204 Chrocagosk virus 3129397 Viruses Viruses 641 1.7899999999999994e-179   NTclustered gi|2717317479|gb|PP171845.1| 3129397 g735 i0 98.892 45.83 361 1 90 3 40 399 1 359 MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence blastn 18332 641 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Chrocagosk virus
26475845 26475845 PRJEB6054_S_NODE_7456_length_194_cov_5.660377_g7367_i0 PRJEB6054 7456 194 5.660377 10.98113138 Chrocagost virus 3129398 Viruses Viruses 191 3.3999999999999997e-44   NTclustered gi|2717317482|gb|PP171846.1| 3129398 g7367 i0 86.982 192.216494845361 169 22 87 0 1 169 5683 5851 MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence blastn 37290 191 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Chrocagost 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);;