RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1146029" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 25 ✖

bioproject 1

  • PRJNA1146029 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
7411542 7411542 PRJNA1146029_P_NODE_5206_length_381_cov_1.000000_g4928_i0 PRJNA1146029 5206 381 1 3.81 Caudoviricetes sp. 2832643 Viruses Viruses 225 1.01e-70   NR XOR08214.1 2832643 g4928 i0 86.5 0.992125984251969 126 17 99.2 0 3 380 143 268 XOR08214.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 378 225 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26690710 26690710 PRJNA1146029_P_NODE_4541_length_405_cov_1.548193_g4263_i0 PRJNA1146029 4541 405 1.548193 6.27018165 Changjiang levi-like virus 2 1922774 Viruses Viruses 148 4.59e-39   NR APG77106.1 1922774 g4263 i0 62.6 0.911111111111111 123 46 91.1 0 371 3 24 146 APG77106.1 hypothetical protein [Changjiang levi-like virus 2] diamond 369 148 1 Viruses               Changjiang levi-like virus 2
27070535 27070535 PRJNA1146029_P_NODE_12722_length_273_cov_1.730000_g12441_i0 PRJNA1146029 12722 273 1.73 4.7229 Changjiang levi-like virus 2 1922774 Viruses Viruses 48.5 4.79e-4   NR APG77104.1 1922774 g12441 i0 48.8 0.450549450549451 41 21 45.1 0 162 40 148 188 APG77104.1 hypothetical protein [Changjiang levi-like virus 2] diamond 123 48.5 1 Viruses               Changjiang levi-like virus 2
27133437 27133437 PRJNA1146029_P_NODE_22302_length_241_cov_0.916667_g22021_i0 PRJNA1146029 22302 241 0.916667 2.20916747 Phage AS32 2604894 Viruses Viruses 80.1 2.51e-15   NR QEM40901.1 2604894 g22021 i0 61.4 0.871369294605809 70 27 87.1 0 212 3 110 179 QEM40901.1 MAG: tape measure protein [Phage AS32] diamond 210 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Phage AS32
27323513 27323513 PRJNA1146029_P_NODE_22183_length_241_cov_0.916667_g21902_i0 PRJNA1146029 22183 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 122 2.43e-30   NR XOR08232.1 2832643 g21902 i0 72.5 0.995850622406639 80 22 99.6 0 2 241 96 175 XOR08232.1 MAG: DNA polymerase [Caudoviricetes sp.] diamond 240 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27323516 27323516 PRJNA1146029_P_NODE_4763_length_396_cov_1.798762_g4485_i0 PRJNA1146029 4763 396 1.798762 7.12309752 Caudoviricetes sp. 2832643 Viruses Viruses 167 1.17e-50   NR XOR08193.1 2832643 g4485 i0 76.5 0.871212121212121 115 27 87.1 0 391 47 19 133 XOR08193.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 345 167 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27860128 27860128 PRJNA1146029_P_NODE_21365_length_242_cov_0.911243_g21084_i0 PRJNA1146029 21365 242 0.911243 2.20520806 Phage 64_12 2718477 Viruses Viruses 84 1.13e-16   NR QOR55675.1 2718477 g21084 i0 53.1 1.00413223140496 81 36 97.9 1 241 5 529 609 QOR55675.1 MAG: hypothetical protein YHS30scaffold392_18 [Phage 64_12] diamond 243 84 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae   Phage 64_12
28018234 28018234 PRJNA1146029_P_NODE_10305_length_288_cov_1.790698_g10024_i0 PRJNA1146029 10305 288 1.790698 5.15721024 Caudoviricetes sp. 2832643 Viruses Viruses 67 2.12e-12   NR XOR08174.1 2832643 g10024 i0 50.8 0.677083333333333 65 31 67.7 1 239 45 3 66 XOR08174.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 195 67 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28385905 28385905 PRJNA1146029_P_NODE_2666_length_524_cov_1.305987_g2390_i0 PRJNA1146029 2666 524 1.305987 6.84337188 root 1 Root_unresolved Root_unresolved 167 8.55e-45   NR NP_043127.1 1891767 g2390 i0 56.5 2.49045801526718 147 60 81.9 1 430 2 77 223 NP_043127.1 large T antigen [Betapolyomavirus macacae] diamond 1305 167 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae Betapolyomavirus Betapolyomavirus macacae
28965517 28965517 PRJNA1146029_P_NODE_16688_length_250_cov_0.870056_g16407_i0 PRJNA1146029 16688 250 0.870056 2.17514 Sinorhizobium phage ort11 2599764 Viruses Viruses 50.4 6.72e-5   NR YP_009884364.1 2599764 g16407 i0 39.4 1.128 94 46 99.6 3 249 1 98 191 YP_009884364.1 hypothetical protein HYP99_gp064 [Sinorhizobium phage ort11] diamond 282 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Huelvavirus Huelvavirus ort11
29249375 29249375 PRJNA1146029_P_NODE_17069_length_249_cov_1.750000_g16788_i0 PRJNA1146029 17069 249 1.75 4.3575 Riboviria sp. 2585031 Viruses Viruses 67.8 6.08e-11   NR WKV33374.1 2585031 g16788 i0 44.2 1.03614457831325 86 43 97.6 2 7 249 286 371 WKV33374.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] diamond 258 67.8 1 Viruses               Riboviria sp.
29659564 29659564 PRJNA1146029_P_NODE_13150_length_270_cov_2.304569_g12869_i0 PRJNA1146029 13150 270 2.304569 6.2223363 Betapolyomavirus macacae 1891767 Viruses Viruses 61.2 1.55e-8   NR AAK29054.1 1891767 g12869 i0 76.2 0.466666666666667 42 10 46.7 0 268 143 496 537 AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] diamond 126 61.2 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae Betapolyomavirus Betapolyomavirus macacae
29881214 29881214 PRJNA1146029_P_NODE_18311_length_247_cov_1.637931_g18030_i0 PRJNA1146029 18311 247 1.637931 4.04568957 Escherichia phage Copypasta 3096133 Viruses Viruses 61.6 1.39e-10   NR WPH57058.1 3096133 g18030 i0 63.5 0.631578947368421 52 19 63.2 0 229 74 1 52 WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] diamond 156 61.6 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Escherichia phage Copypasta
30038946 30038946 PRJNA1146029_P_NODE_16731_length_250_cov_0.870056_g16450_i0 PRJNA1146029 16731 250 0.870056 2.17514 Satyrvirus sp. 2487771 Viruses Viruses 73.2 7.73e-13   NR AYV85210.1 2487771 g16450 i0 39.8 0.996 83 49 99.6 1 249 1 53 134 AYV85210.1 MAG: serpin [Satyrvirus sp.] diamond 249 73.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Satyrvirus sp.
30038955 30038955 PRJNA1146029_P_NODE_3511_length_455_cov_2.060209_g3233_i0 PRJNA1146029 3511 455 2.060209 9.37395095 Riboviria sp. 2585031 Viruses Viruses 124 4.44e-30   NR WKV33374.1 2585031 g3233 i0 46.4 0.995604395604396 151 80 98.9 1 5 454 130 280 WKV33374.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] diamond 453 124 1 Viruses               Riboviria sp.
30038956 30038956 PRJNA1146029_P_NODE_7011_length_336_cov_2.288973_g6733_i0 PRJNA1146029 7011 336 2.288973 7.69094928 Caudoviricetes sp. 2832643 Viruses Viruses 152 3.49e-40   NR XOR08201.1 2832643 g6733 i0 66.4 2.98214285714286 110 37 98.2 0 330 1 281 390 XOR08201.1 MAG: phage tail protein [Caudoviricetes sp.] diamond 1002 152 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30228482 30228482 PRJNA1146029_P_NODE_1372_length_760_cov_1.924309_g1125_i0 PRJNA1146029 1372 760 1.924309 14.6247484 Riboviria sp. 2585031 Viruses Viruses 74.7 2.92e-11   NR WKV33374.1 2585031 g1125 i0 37.7 0.45 114 71 45 0 455 114 1 114 WKV33374.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] diamond 342 74.7 1 Viruses               Riboviria sp.
30418476 30418476 PRJNA1146029_P_NODE_14353_length_262_cov_1.476190_g14072_i0 PRJNA1146029 14353 262 1.47619 3.8676178 Betapolyomavirus macacae 1891767 Viruses Viruses 58.2 1.74e-7   NR AAK29054.1 1891767 g14072 i0 70.5 0.50381679389313 44 13 50.4 0 244 113 494 537 AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] diamond 132 58.2 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae Betapolyomavirus Betapolyomavirus macacae
30481355 30481355 PRJNA1146029_P_NODE_13213_length_270_cov_1.558376_g12932_i0 PRJNA1146029 13213 270 1.558376 4.2076152 Caudoviricetes sp. 2832643 Viruses Viruses 114 1.36e-30   NR XOS73446.1 2832643 g12932 i0 68.9 0.822222222222222 74 23 82.2 0 238 17 1 74 XOS73446.1 MAG: virion-associated phage protein [Caudoviricetes sp.] diamond 222 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30786162 30786162 PRJNA1146029_P_NODE_21294_length_242_cov_1.390533_g21013_i0 PRJNA1146029 21294 242 1.390533 3.36508986 root 1 Root_unresolved Root_unresolved 122 2.48e-33   NR CAA10165.1 1891767 g21013 i0 73.8 3.95454545454545 80 21 99.2 0 2 241 82 161 CAA10165.1 large tumor antigen [Betapolyomavirus macacae] diamond 957 122 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae Betapolyomavirus Betapolyomavirus macacae
31018502 31018502 PRJNA1146029_P_NODE_2575_length_534_cov_3.065076_g2300_i0 PRJNA1146029 2575 534 3.065076 16.36750584 Riboviria sp. 2585031 Viruses Viruses 135 1.18e-33   NR WKV33374.1 2585031 g2300 i0 45.4 0.792134831460674 141 75 78.1 1 532 116 371 511 WKV33374.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] diamond 423 135 1 Viruses               Riboviria sp.
31682221 31682221 PRJNA1146029_P_NODE_10437_length_288_cov_0.734884_g10156_i0 PRJNA1146029 10437 288 0.734884 2.11646592 Betapolyomavirus macacae 1891767 Viruses Viruses 59.3 9.18e-8   NR AAK29054.1 1891767 g10156 i0 69 0.4375 42 13 43.8 0 131 256 494 535 AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] diamond 126 59.3 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae Betapolyomavirus Betapolyomavirus macacae
31745619 31745619 PRJNA1146029_P_NODE_857_length_969_cov_1.428571_g656_i0 PRJNA1146029 857 969 1.428571 13.84285299 Christensen virus 2707205 Viruses Viruses 49.7 0.0126   NR QIS88030.1 2707205 g656 i0 27.6 1.08359133126935 145 61 44.9 3 456 22 176 276 QIS88030.1 MAG: maturation protein [Christensen virus] diamond 1050 49.7 1 Viruses               Christensen virus
32125591 32125591 PRJNA1146029_P_NODE_3978_length_429_cov_0.828652_g3700_i0 PRJNA1146029 3978 429 0.828652 3.55491708 Changjiang levi-like virus 2 1922774 Viruses Viruses 178 5.08e-50   NR APG77106.1 1922774 g3700 i0 61.5 1 143 55 100 0 1 429 243 385 APG77106.1 hypothetical protein [Changjiang levi-like virus 2] diamond 429 178 1 Viruses               Changjiang levi-like virus 2
32788574 32788574 PRJNA1146029_P_NODE_12220_length_276_cov_2.911330_g11939_i0 PRJNA1146029 12220 276 2.91133 8.0352708 Caudoviricetes sp. 2832643 Viruses Viruses 41.2 0.0321   NR XOR14122.1 2832643 g11939 i0 33.9 0.608695652173913 56 34 57.6 1 29 187 16 71 XOR14122.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 168 41.2 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);;