RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA698538", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Kitrinoviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA698538 · 3 ✖

analysis 1

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
681266 681266 PRJNA698538_S_NODE_10521_length_345_cov_1.981618_g10355_i0 PRJNA698538 10521 345 1.981618 6.8365821 Tobamovirus tabaci 3432891 Viruses Viruses 627 4.259999999999999e-175   NTclustered gi|388240233|emb|HE818437.1| 12242 g10355 i0 99.422 100.226086956522 346 0 100 2 1 345 5622 5966 Tobacco mosaic virus isolate Mangshi-2, complete genome blastn 34578 627 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
4509503 4509503 PRJNA698538_S_NODE_28244_length_246_cov_1.780347_g28078_i0 PRJNA698538 28244 246 1.780347 4.37965362 Pestivirus bovis 3052619 Viruses Viruses 427 3.16e-115   NTclustered gi|507866684|gb|KC695810.1| 11099 g28078 i0 97.967 7.36585365853659 246 5 100 0 1 246 4040 4285 Bovine viral diarrhea virus 1 isolate camel-6, complete genome blastn 1812 427 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis
13435346 13435346 PRJNA698538_S_NODE_31951_length_217_cov_112.055556_g31785_i0 PRJNA698538 31951 217 112.055556 243.16055652 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.005   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g31785 i0 100 0.262672811059908 29 0 13 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1

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