RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA416866" and tax_clade = "unclassified ssRNA positive-strand viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • unclassified ssRNA positive-strand viruses · 4 ✖

bioproject 1

  • PRJNA416866 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_phylum 0

tax_kingdom 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
1694480 1694480 PRJNA416866_P_NODE_62_length_2274_cov_3.456394_g51_i0 PRJNA416866 62 2274 3.456394 78.59839956 Drosophila A virus 595895 Viruses Viruses 3945 0   NTclustered gi|822478147|gb|KP969949.1| 595895 g51 i0 97.933 34.150835532102 2274 47 100 0 1 2274 1545 3818 Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds blastn 77659 3945 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
8072990 8072990 PRJNA416866_P_NODE_847_length_799_cov_3.200542_g720_i0 PRJNA416866 847 799 3.200542 25.57233058 Drosophila A virus 595895 Viruses Viruses 1343 0   NTclustered gi|253761971|ref|NC_012958.1| 595895 g720 i0 96.996 22.575719649562 799 24 100 0 1 799 3961 4759 Drosophila A virus, complete genome blastn 18038 1343 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
8072991 8072991 PRJNA416866_P_NODE_9047_length_213_cov_2.526316_g8903_i0 PRJNA416866 9047 213 2.526316 5.38105308 Drosophila A virus 595895 Viruses Viruses 383 5.8499999999999996e-102   NTclustered gi|822478135|gb|KP969945.1| 595895 g8903 i0 99.061 40.9671361502347 213 2 100 0 1 213 217 5 Drosophila A virus isolate XID_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds blastn 8726 383 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A virus
23371770 23371770 PRJNA416866_P_NODE_259_length_1369_cov_3.630734_g201_i0 PRJNA416866 259 1369 3.630734 49.70474846 Drosophila A virus 595895 Viruses Viruses 2457 0   NTclustered gi|822478150|gb|KP969950.1| 595895 g201 i0 99.05 34.6939371804237 1369 13 100 0 1 1369 216 1584 Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds blastn 47496 2457 1 Viruses unclassified ssRNA positive-strand viruses             Drosophila A 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);;