RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 6 ✖

bioproject 1

  • PRJNA352850 · 6 ✖

analysis 1

  • diamond · 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
22747682 22747682 PRJNA352850_P_NODE_10978_length_1010_cov_8.680541_g8614_i0 PRJNA352850 10978 1010 8.680541 87.6734641 Aeromonas phage phiA 2885153 Viruses Viruses 369 4.03e-123   NR UIS74291.1 2885153 g8614 i0 83.3 0.944554455445545 318 50 94.5 2 954 1 1 315 UIS74291.1 hypothetical protein pA_gene0076 [Aeromonas phage phiA008] diamond 954 369 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
28559321 28559321 PRJNA352850_P_NODE_80507_length_249_cov_0.965000_g77674_i0 PRJNA352850 80507 249 0.965 2.40285 Aeromonas phage phiA 2885153 Viruses Viruses 79.7 3.75e-17   NR UIS74270.1 2885153 g77674 i0 71.1 0.542168674698795 45 13 54.2 0 207 73 3 47 UIS74270.1 hypothetical protein pA_gene0055 [Aeromonas phage phiA008] diamond 135 79.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
28717081 28717081 PRJNA352850_P_NODE_35827_length_432_cov_1.355091_g32996_i0 PRJNA352850 35827 432 1.355091 5.85399312 Aeromonas phage phiA 2885153 Viruses Viruses 77.8 2.97e-15   NR UIS74280.1 2885153 g32996 i0 60 0.381944444444444 55 22 38.2 0 65 229 1 55 UIS74280.1 hypothetical protein pA_gene0065 [Aeromonas phage phiA008] diamond 165 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
30011792 30011792 PRJNA352850_P_NODE_71591_length_265_cov_1.824074_g68758_i0 PRJNA352850 71591 265 1.824074 4.8337961 Aeromonas phage phiA 2885153 Viruses Viruses 105 1.6500000000000002e-26   NR UIS74284.1 2885153 g68758 i0 77.5 0.80377358490566 71 16 80.4 0 2 214 51 121 UIS74284.1 hypothetical protein pA_gene0069 [Aeromonas phage phiA008] diamond 213 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
30137636 30137636 PRJNA352850_P_NODE_53792_length_324_cov_1.890909_g50959_i0 PRJNA352850 53792 324 1.890909 6.12654516 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 5.69e-16   NR XOS04752.1 2832643 g50959 i0 61.3 0.574074074074074 62 21 54.6 1 135 311 5 66 XOS04752.1 MAG: hypothetical protein MSP1126_6 [Caudoviricetes sp.] diamond 186 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31211801 31211801 PRJNA352850_P_NODE_31975_length_467_cov_2.349282_g29145_i0 PRJNA352850 31975 467 2.349282 10.97114694 Caudoviricetes sp. 2832643 Viruses Viruses 222 1.1e-68   NR XOS04751.1 2832643 g29145 i0 69 0.995717344753747 155 48 99.6 0 3 467 29 183 XOS04751.1 MAG: Int [Caudoviricetes sp.] diamond 465 222 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);;