RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1123686" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 7 ✖

bioproject 1

  • PRJNA1123686 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1555504 1555504 PRJNA1123686_S_NODE_5362_length_226_cov_2.497462_g5330_i0 PRJNA1123686 5362 226 2.497462 5.64426412 Cripavirus drosophilae 3047809 Viruses Viruses 407 3.73e-109   NTclustered gi|2147549872|gb|MW834587.1| 64279 g5330 i0 99.115 10.0309734513274 226 2 100 0 1 226 2180 2405 Drosophila C virus isolate caf replicase polyprotein gene, partial cds; and capsid polyprotein gene, complete cds blastn 2267 407 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
2831542 2831542 PRJNA1123686_S_NODE_14143_length_171_cov_3.239437_g14111_i0 PRJNA1123686 14143 171 3.239437 5.53943727 Cripavirus drosophilae 3047809 Viruses Viruses 294 2.16e-75   NTclustered gi|1743646616|gb|MK645242.1| 64279 g14111 i0 97.661 9.29824561403509 171 4 100 0 1 171 8958 8788 Drosophila C virus isolate CHA, complete genome blastn 1590 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
2831563 2831563 PRJNA1123686_S_NODE_17283_length_161_cov_3.045455_g17251_i0 PRJNA1123686 17283 161 3.045455 4.90318255 Cripavirus drosophilae 3047809 Viruses Viruses 274 2.62e-69   NTclustered gi|2714662726|gb|OR820583.1| 64279 g17251 i0 97.5 7.95031055900621 160 4 99 0 2 161 3957 4116 Drosophila C virus isolate Davidson2006, complete genome blastn 1280 274 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
4107917 4107917 PRJNA1123686_S_NODE_17744_length_160_cov_1.221374_g17712_i0 PRJNA1123686 17744 160 1.221374 1.9541984 Cripavirus drosophilae 3047809 Viruses Viruses 278 2.01e-70   NTclustered gi|2322367289|gb|OK188767.1| 64279 g17712 i0 98.113 6.9 159 3 99 0 1 159 3760 3918 Drosophila C virus isolate SMN, complete genome blastn 1104 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
20682340 20682340 PRJNA1123686_S_NODE_11917_length_180_cov_1.543046_g11885_i0 PRJNA1123686 11917 180 1.543046 2.7774828 Cripavirus drosophilae 3047809 Viruses Viruses 311 2.28e-80   NTclustered gi|2714662726|gb|OR820583.1| 64279 g11885 i0 97.778 9 180 4 100 0 1 180 8103 8282 Drosophila C virus isolate Davidson2006, complete genome blastn 1620 311 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
21957682 21957682 PRJNA1123686_S_NODE_18898_length_157_cov_2.523438_g18866_i0 PRJNA1123686 18898 157 2.523438 3.96179766 Cripavirus drosophilae 3047809 Viruses Viruses 268 1.1799999999999998e-67   NTclustered gi|2714662726|gb|OR820583.1| 64279 g18866 i0 97.452 8.8343949044586 157 4 100 0 1 157 4807 4963 Drosophila C virus isolate Davidson2006, complete genome blastn 1387 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
24506825 24506825 PRJNA1123686_S_NODE_17000_length_162_cov_2.248120_g16968_i0 PRJNA1123686 17000 162 2.24812 3.6419544 Cripavirus drosophilae 3047809 Viruses Viruses 300 4.36e-77   NTclustered gi|2322367289|gb|OK188767.1| 64279 g16968 i0 100 22.1049382716049 162 0 100 0 1 162 6205 6366 Drosophila C virus isolate SMN, complete genome blastn 3581 300 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae

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