RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA606583" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA606583 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
1859377 1859377 PRJNA606583_P_NODE_10882_length_403_cov_2.502732_g10457_i0 PRJNA606583 10882 403 2.502732 10.08600996 Gordonia phage CheeseTouch 3118976 Viruses Viruses 179 3.15e-53   NR WVX88606.1 3118976 g10457 i0 72.1 0.826302729528536 111 31 82.6 0 32 364 8 118 WVX88606.1 antirepressor [Gordonia phage CheeseTouch] diamond 333 179 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Getalongvirus Gordonia phage CheeseTouch
27333141 27333141 PRJNA606583_P_NODE_39943_length_157_cov_1.300000_g39514_i0 PRJNA606583 39943 157 1.3 2.041 Caudoviricetes sp. 2832643 Viruses Viruses 41.6 0.0187   NR DAQ64683.1 2832643 g39514 i0 44.4 0.859872611464968 45 21 86 1 1 135 45 85 DAQ64683.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 135 41.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27743763 27743763 PRJNA606583_P_NODE_18084_length_288_cov_2.083665_g17655_i0 PRJNA606583 18084 288 2.083665 6.0009552 Caudoviricetes sp. 2832643 Viruses Viruses 159 7.709999999999999e-45   NR XOR87907.1 2832643 g17655 i0 78.1 2 96 21 100 0 288 1 81 176 XOR87907.1 MAG: terminase large subunit, partial [Caudoviricetes sp.] diamond 576 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28059148 28059148 PRJNA606583_P_NODE_9845_length_428_cov_2.107417_g9420_i0 PRJNA606583 9845 428 2.107417 9.01974476 Caudoviricetes sp. 2832643 Viruses Viruses 193 8.739999999999999e-57   NR XOR87824.1 2832643 g9420 i0 75.6 1.66822429906542 119 29 83.4 0 72 428 1 119 XOR87824.1 MAG: phage portal protein [Caudoviricetes sp.] diamond 714 193 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29038273 29038273 PRJNA606583_P_NODE_21228_length_255_cov_2.633028_g20799_i0 PRJNA606583 21228 255 2.633028 6.7142214 Caudoviricetes sp. 2832643 Viruses Viruses 135 8.86e-36   NR XOR87907.1 2832643 g20799 i0 76.5 1 85 20 100 0 255 1 339 423 XOR87907.1 MAG: terminase large subunit, partial [Caudoviricetes sp.] diamond 255 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29385439 29385439 PRJNA606583_P_NODE_41249_length_154_cov_1.333333_g40820_i0 PRJNA606583 41249 154 1.333333 2.05333282 Caudoviricetes sp. 2832643 Viruses Viruses 50.4 3.32e-6   NR XOR11119.1 2832643 g40820 i0 59.6 0.915584415584416 47 17 91.6 1 141 1 11 55 XOR11119.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 141 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29732402 29732402 PRJNA606583_P_NODE_6910_length_516_cov_3.728601_g6495_i0 PRJNA606583 6910 516 3.728601 19.23958116 Caudoviricetes sp. 2832643 Viruses Viruses 87 2.49e-18   NR XOR77129.1 2832643 g6495 i0 40.5 0.645348837209302 111 65 64.5 1 25 357 26 135 XOR77129.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 333 87 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30743597 30743597 PRJNA606583_P_NODE_40554_length_155_cov_3.305085_g40125_i0 PRJNA606583 40554 155 3.305085 5.12288175 Caudoviricetes sp. 2832643 Viruses Viruses 80.1 6.64e-16   NR XOR87907.1 2832643 g40125 i0 70.6 0.987096774193548 51 15 98.7 0 1 153 288 338 XOR87907.1 MAG: terminase large subunit, partial [Caudoviricetes sp.] diamond 153 80.1 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);;