RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA312899", tax_phylum = "Cressdnaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Cressdnaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312899 · 6 ✖

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
12542957 12542957 PRJNA312899_P_NODE_27910_length_351_cov_26.973510_g27468_i0 PRJNA312899 27910 351 26.97351 94.6770201 Genomoviridae 1910928 Viruses Viruses 601 2.63e-167   NTclustered gi|2045610726|gb|MW182963.1| 1985367 g27468 i0 97.977 8.87464387464387 346 7 99 0 1 346 316 661 MAG: Gemykrogvirus isolate hbl69gen3, complete genome blastn 3115 601 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae Gemykrogvirus  
28937608 28937608 PRJNA312899_P_NODE_42468_length_272_cov_5.937220_g42026_i0 PRJNA312899 42468 272 5.93722 16.1492384 Cressdnaviricota sp. 2748378 Viruses Viruses 80.9 1.21e-16   NR XNT20742.1 2748378 g42026 i0 55.6 0.694852941176471 63 28 69.5 0 3 191 124 186 XNT20742.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 189 80.9 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
28969154 28969154 PRJNA312899_P_NODE_17308_length_453_cov_32.405941_g16868_i0 PRJNA312899 17308 453 32.405941 146.79891273 Cressdnaviricota sp. 2748378 Viruses Viruses 48.1 0.00253   NR UOF80765.1 2748378 g16868 i0 33.3 1.02649006622517 78 48 50.3 3 3 230 148 223 UOF80765.1 capsid protein [Cressdnaviricota sp.] diamond 465 48.1 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
30359151 30359151 PRJNA312899_P_NODE_33212_length_317_cov_3.029851_g32770_i0 PRJNA312899 33212 317 3.029851 9.60462767 Cressdnaviricota sp. 2748378 Viruses Viruses 59.3 1.21e-7   NR WAE42517.1 2748378 g32770 i0 44.6 0.700315457413249 74 39 70 1 316 95 281 352 WAE42517.1 MAG: capsid protein [Cressdnaviricota sp.] diamond 222 59.3 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
31591482 31591482 PRJNA312899_P_NODE_6536_length_725_cov_67.252959_g6188_i0 PRJNA312899 6536 725 67.252959 487.58395275 Cirlivirales sp. 2809008 Viruses Viruses 146 2.03e-39   NR XOF06493.1 2809008 g6188 i0 55.4 0.612413793103448 148 61 61.2 1 444 1 44 186 XOF06493.1 MAG: hypothetical protein, partial [Cirlivirales sp.] diamond 444 146 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales     Cirlivirales sp.
32666422 32666422 PRJNA312899_P_NODE_20240_length_418_cov_39.360434_g19799_i0 PRJNA312899 20240 418 39.360434 164.52661412 Chemarfal virus 111 3063444 Viruses Viruses 49.7 4.01e-4   NR WPR18655.1 3063444 g19799 i0 49 0.351674641148325 49 24 34.4 1 415 272 138 186 WPR18655.1 MAG: capsid protein [Chemarfal virus 111] diamond 147 49.7 1 Viruses   Shotokuvirae Cressdnaviricota         Chemarfal virus 111

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