RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 18 ✖

bioproject 1

  • PRJNA270367 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
370193 370193 PRJNA270367_P_NODE_46301_length_162_cov_0.920354_g46096_i0 PRJNA270367 46301 162 0.920354 1.49097348 Caudoviricetes sp. 2832643 Viruses Viruses 182 1.6499999999999996e-41   NTclustered gi|2914993804|gb|OR222211.1| 2832643 g46096 i0 86.957 0.993827160493827 161 21 99 0 2 162 53129 53289 MAG: Caudoviricetes sp. isolate MSP0761 genomic sequence blastn 161 182 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1645037 1645037 PRJNA270367_P_NODE_5722_length_571_cov_1.745211_g5530_i0 PRJNA270367 5722 571 1.745211 9.96515481 Pandoravirus quercus 2107709 Viruses Viruses 75 1.2e-8   NTclustered gi|1408259612|ref|NC_037667.1| 2107709 g5530 i0 82.353 0.597197898423818 85 15 16 0 349 433 1563508 1563592 Pandoravirus quercus, complete genome blastn 341 75 1 Viruses             Pandoravirus Pandoravirus quercus
2332861 2332861 PRJNA270367_P_NODE_13622_length_352_cov_3.201320_g13417_i0 PRJNA270367 13622 352 3.20132 11.2686464 root 1 Root_unresolved Root_unresolved 187 8.74e-43   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g13417 i0 100 41.7613636363636 101 0 42 0 1 101 28638 28538 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 14700 187 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
2333608 2333608 PRJNA270367_P_NODE_44782_length_164_cov_0.904348_g44577_i0 PRJNA270367 44782 164 0.904348 1.48313072 root 1 Root_unresolved Root_unresolved 298 1.59e-76   NTclustered gi|2057165040|tpg|BK058725.1| 38018 g44577 i0 99.39 3 164 1 100 0 1 164 15247 15410 MAG TPA_asm: Bacteriophage sp. isolate ctLeQ12, partial genome blastn 492 298 1 Viruses               Bacteriophage sp.
4197013 4197013 PRJNA270367_P_NODE_16224_length_312_cov_3.543726_g16019_i0 PRJNA270367 16224 312 3.543726 11.05642512 Burkholderia phage BCSR5 2805747 Viruses Viruses 67.6 1.04e-6   NTclustered gi|1971775256|gb|MW460245.1| 2805747 g16019 i0 100 0.483974358974359 36 0 12 0 134 169 619 654 Burkholderia phage BCSR5, complete genome blastn 151 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage BCSR5
10574186 10574186 PRJNA270367_P_NODE_45269_length_163_cov_0.912281_g45064_i0 PRJNA270367 45269 163 0.912281 1.48701803 Caudoviricetes sp. 2832643 Viruses Viruses 302 1.22e-77   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g45064 i0 100 1 163 0 100 0 1 163 25373 25535 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 163 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11848655 11848655 PRJNA270367_P_NODE_27910_length_214_cov_0.945455_g27705_i0 PRJNA270367 27910 214 0.945455 2.0232737 Caudoviricetes sp. 2832643 Viruses Viruses 396 7.559999999999996e-106   NTclustered gi|2054436092|tpg|BK036040.1| 2832643 g27705 i0 100 2.98598130841122 214 0 100 0 1 214 29891 29678 MAG TPA_asm: Caudoviricetes sp. isolate ctZQF2, partial genome blastn 639 396 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11848656 11848656 PRJNA270367_P_NODE_27930_length_214_cov_0.884848_g27725_i0 PRJNA270367 27930 214 0.884848 1.89357472 Caudoviricetes sp. 2832643 Viruses Viruses 357 3.5699999999999996e-94   NTclustered gi|2052187283|tpg|BK055844.1| 2832643 g27725 i0 96.729 1.98130841121495 214 7 100 0 1 214 5009 5222 MAG TPA_asm: Caudoviricetes sp. isolate cty0V13, partial genome blastn 424 357 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11848791 11848791 PRJNA270367_P_NODE_41430_length_167_cov_0.881356_g41225_i0 PRJNA270367 41430 167 0.881356 1.47186452 Bacteriophage sp. 38018 Viruses Viruses 281 1.64e-71   NTclustered gi|1977365072|gb|MW462191.1| 38018 g41225 i0 97.006 2.02395209580838 167 5 100 0 1 167 39568 39734 Bacteriophage sp. isolate contig405706 genomic sequence blastn 338 281 1 Viruses               Bacteriophage sp.
14399191 14399191 PRJNA270367_P_NODE_45232_length_163_cov_0.929825_g45027_i0 PRJNA270367 45232 163 0.929825 1.51561475 Caudoviricetes sp. 2832643 Viruses Viruses 302 1.22e-77   NTclustered gi|2054436092|tpg|BK036040.1| 2832643 g45027 i0 100 3 163 0 100 0 1 163 35597 35759 MAG TPA_asm: Caudoviricetes sp. isolate ctZQF2, partial genome blastn 489 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16360057 16360057 PRJNA270367_P_NODE_13573_length_353_cov_1.921053_g13368_i0 PRJNA270367 13573 353 1.921053 6.78131709 root 1 Root_unresolved Root_unresolved 180 1.47e-40   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g13368 i0 99.01 41.7932011331445 101 0 42 1 1 101 11551 11452 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 14753 180 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
18221794 18221794 PRJNA270367_P_NODE_38155_length_173_cov_1.137097_g37950_i0 PRJNA270367 38155 173 1.137097 1.96717781 Caudoviricetes sp. 2832643 Viruses Viruses 315 1.68e-81   NTclustered gi|2058061264|tpg|BK042747.1| 2832643 g37950 i0 99.422 2.99421965317919 173 1 100 0 1 173 3401 3229 MAG TPA_asm: Caudoviricetes sp. isolate ctWpO1, partial genome blastn 518 315 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18221831 18221831 PRJNA270367_P_NODE_41275_length_167_cov_1.322034_g41070_i0 PRJNA270367 41275 167 1.322034 2.20779678 Caudoviricetes sp. 2832643 Viruses Viruses 303 3.5e-78   NTclustered gi|2059682310|tpg|BK029302.1| 2832643 g41070 i0 99.401 5.72455089820359 167 1 100 0 1 167 41766 41600 MAG TPA_asm: Caudoviricetes sp. isolate ctpyl1, partial genome blastn 956 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18909017 18909017 PRJNA270367_P_NODE_13575_length_353_cov_1.825658_g13370_i0 PRJNA270367 13575 353 1.825658 6.44457274 root 1 Root_unresolved Root_unresolved 187 8.77e-43   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g13370 i0 100 56.9376770538244 101 0 57 0 253 353 18402 18302 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 20099 187 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
18909250 18909250 PRJNA270367_P_NODE_21735_length_253_cov_4.098039_g21530_i0 PRJNA270367 21735 253 4.098039 10.36803867 root 1 Root_unresolved Root_unresolved 459 1.1599999999999999e-124   NTclustered gi|2620236085|gb|OR777220.1| 10515 g21530 i0 100 98.0237154150198 248 0 98 0 1 248 14926 15173 Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome blastn 24800 459 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
19496083 19496083 PRJNA270367_P_NODE_40916_length_168_cov_0.873950_g40711_i0 PRJNA270367 40916 168 0.87395 1.468236 Bacteriophage sp. 38018 Viruses Viruses 311 2.11e-80   NTclustered gi|1977365072|gb|MW462191.1| 38018 g40711 i0 100 1.74404761904762 168 0 100 0 1 168 94158 94325 Bacteriophage sp. isolate contig405706 genomic sequence blastn 293 311 1 Viruses               Bacteriophage sp.
22734405 22734405 PRJNA270367_P_NODE_13558_length_353_cov_2.618421_g13353_i0 PRJNA270367 13558 353 2.618421 9.24302613 root 1 Root_unresolved Root_unresolved 187 8.77e-43   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g13353 i0 100 54.8951841359773 101 0 56 0 6 106 11379 11279 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 19378 187 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
23322166 23322166 PRJNA270367_P_NODE_40639_length_168_cov_0.873950_g40434_i0 PRJNA270367 40639 168 0.87395 1.468236 Caudoviricetes sp. 2832643 Viruses Viruses 300 4.56e-77   NTclustered gi|2059789084|tpg|BK039506.1| 2832643 g40434 i0 98.81 1 168 2 100 0 1 168 27429 27262 MAG TPA_asm: Caudoviricetes sp. isolate ctCfj1, partial genome blastn 168 300 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);;