RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1073712" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_superkingdom 1

  • Viruses · 7 ✖

bioproject 1

  • PRJNA1073712 · 7 ✖

analysis 1

  • diamond · 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
27035783 27035783 PRJNA1073712_P_NODE_9062_length_271_cov_1.277778_g8979_i0 PRJNA1073712 9062 271 1.277778 3.46277838 Escherichia phage Copypasta 3096133 Viruses Viruses 61.6 1.86e-10   NR WPH57058.1 3096133 g8979 i0 64 0.553505535055351 50 18 55.4 0 162 13 1 50 WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] diamond 150 61.6 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Escherichia phage Copypasta
27098978 27098978 PRJNA1073712_P_NODE_4062_length_356_cov_1.632509_g3979_i0 PRJNA1073712 4062 356 1.632509 5.81173204 Citrus leaf blotch virus 129141 Viruses Viruses 230 9.96e-73   NR NP_624334.1 129141 g3979 i0 99.2 2.98314606741573 118 1 99.4 0 356 3 75 192 NP_624334.1 movement protein [Citrus leaf blotch virus] diamond 1062 230 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Citrivirus Citrivirus citri
27920176 27920176 PRJNA1073712_P_NODE_2205_length_437_cov_2.417582_g2122_i0 PRJNA1073712 2205 437 2.417582 10.56483334 Citrus leaf blotch virus 129141 Viruses Viruses 297 2.67e-90   NR WHN55394.1 129141 g2122 i0 97.2 4.97711670480549 145 4 99.5 0 436 2 269 413 WHN55394.1 polyprotein [Citrus leaf blotch virus] diamond 2175 297 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Citrivirus Citrivirus citri
28235701 28235701 PRJNA1073712_P_NODE_10166_length_260_cov_1.647059_g10083_i0 PRJNA1073712 10166 260 1.647059 4.2823534 Caudoviricetes sp. 2832643 Viruses Viruses 48.5 7.12e-5   NR DAS72892.1 2832643 g10083 i0 72.4 0.334615384615385 29 8 33.5 0 159 73 60 88 DAS72892.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 87 48.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28299053 28299053 PRJNA1073712_P_NODE_3346_length_381_cov_1.402597_g3263_i0 PRJNA1073712 3346 381 1.402597 5.34389457 Citrus leaf blotch virus 129141 Viruses Viruses 241 5.44e-71   NR WHN55394.1 129141 g3263 i0 92.1 4.96062992125984 126 10 99.2 0 379 2 925 1050 WHN55394.1 polyprotein [Citrus leaf blotch virus] diamond 1890 241 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Citrivirus Citrivirus citri
29846276 29846276 PRJNA1073712_P_NODE_14631_length_245_cov_0.895349_g14548_i0 PRJNA1073712 14631 245 0.895349 2.19360505 Caudoviricetes sp. 2832643 Viruses Viruses 114 1.1000000000000001e-30   NR XOR78575.1 2832643 g14548 i0 71.6 1.98367346938776 81 23 99.2 0 243 1 8 88 XOR78575.1 MAG: N-acetyltransferase-like protein [Caudoviricetes sp.] diamond 486 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30383774 30383774 PRJNA1073712_P_NODE_7333_length_290_cov_1.216590_g7250_i0 PRJNA1073712 7333 290 1.21659 3.528111 Caudoviricetes sp. 2832643 Viruses Viruses 193 1.4599999999999998e-56   NR DAP39503.1 2832643 g7250 i0 91.7 0.993103448275862 96 8 99.3 0 289 2 274 369 DAP39503.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 288 193 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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