RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 12 ✖

bioproject 1

  • PRJNA1005695 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1428336 1428336 PRJNA1005695_P_NODE_35222_length_252_cov_0.871508_g34370_i0 PRJNA1005695 35222 252 0.871508 2.19620016 Aeromonas phage AVP1 3003735 Viruses Viruses 377 3.32e-100   NTclustered gi|2416396129|gb|OP889247.1| 3003735 g34370 i0 93.976 2.96825396825397 249 15 99 0 1 249 148035 147787 Aeromonas phage AVP1, complete genome blastn 748 377 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Aeromonas phage AVP1
1428390 1428390 PRJNA1005695_P_NODE_39982_length_242_cov_0.923077_g39130_i0 PRJNA1005695 39982 242 0.923077 2.23384634 Ferozepurvirus pAEv1810 3059998 Viruses Viruses 414 2.41e-111   NTclustered gi|2438103068|ref|NC_070999.1| 2908744 g39130 i0 97.521 4.95454545454545 242 6 100 0 1 242 233578 233337 Aeromonas phage pAEv1810, complete genome blastn 1199 414 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus pAEv1810
2276273 2276273 PRJNA1005695_P_NODE_33342_length_258_cov_1.535135_g32490_i0 PRJNA1005695 33342 258 1.535135 3.9606483 Ferozepurvirus 3044715 Viruses Viruses 392 1.2199999999999997e-104   NTclustered gi|2438102820|ref|NC_070998.1| 2591406 g32490 i0 94.488 5.72868217054264 254 14 98 0 5 258 98972 98719 Aeromonas phage PS1, complete genome blastn 1478 394 0.99492385786802 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus PS1
2703786 2703786 PRJNA1005695_P_NODE_33763_length_256_cov_1.688525_g32911_i0 PRJNA1005695 33763 256 1.688525 4.322624 Caudoviricetes sp. 2832643 Viruses Viruses 351 2.05e-92   NTclustered gi|2914953672|gb|OR221927.1| 2832643 g32911 i0 91.7 3.9296875 253 21 99 0 4 256 45164 44912 MAG: Caudoviricetes sp. isolate MSP0202 genomic sequence blastn 1006 351 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9080896 9080896 PRJNA1005695_P_NODE_17368_length_363_cov_1.062069_g16516_i0 PRJNA1005695 17368 363 1.062069 3.85531047 Ferozepurvirus pAEv1810 3059998 Viruses Viruses 180 1.51e-40   NTclustered gi|2438103068|ref|NC_070999.1| 2908744 g16516 i0 82.075 2.30578512396694 212 36 58 2 1 211 135489 135699 Aeromonas phage pAEv1810, complete genome blastn 837 180 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus pAEv1810
11204343 11204343 PRJNA1005695_P_NODE_16189_length_377_cov_1.026316_g15337_i0 PRJNA1005695 16189 377 1.026316 3.86921132 Ferozepurvirus 3044715 Viruses Viruses 641 1.68e-179   NTclustered gi|2416396129|gb|OP889247.1| 3003735 g15337 i0 97.594 4.96816976127321 374 9 99 0 4 377 4095 3722 Aeromonas phage AVP1, complete genome blastn 1873 647 0.990726429675425 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Aeromonas phage AVP1
11632054 11632054 PRJNA1005695_P_NODE_24190_length_305_cov_2.849138_g23338_i0 PRJNA1005695 24190 305 2.849138 8.6898709 Caudoviricetes sp. 2832643 Viruses Viruses 520 6.479999999999999e-143   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g23338 i0 97.386 429.068852459016 306 7 100 1 1 305 18106 18411 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 130866 520 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12480000 12480000 PRJNA1005695_P_NODE_38910_length_244_cov_1.497076_g38058_i0 PRJNA1005695 38910 244 1.497076 3.65286544 Ferozepurvirus 3044715 Viruses Viruses 374 4.1399999999999986e-99   NTclustered gi|2438102820|ref|NC_070998.1| 2591406 g38058 i0 97.285 4.90983606557377 221 5 91 1 24 244 98580 98361 Aeromonas phage PS1, complete genome blastn 1198 374 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus PS1
12907348 12907348 PRJNA1005695_P_NODE_38911_length_244_cov_1.479532_g38059_i0 PRJNA1005695 38911 244 1.479532 3.61005808 Ferozepurvirus pAEv1810 3059998 Viruses Viruses 403 5.27e-108   NTclustered gi|2438103068|ref|NC_070999.1| 2908744 g38059 i0 97.071 5.53688524590164 239 7 98 0 4 242 115275 115037 Aeromonas phage pAEv1810, complete genome blastn 1351 403 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus pAEv1810
15456066 15456066 PRJNA1005695_P_NODE_15613_length_384_cov_3.845659_g14761_i0 PRJNA1005695 15613 384 3.845659 14.76733056 Ferozepurvirus pAEv1810 3059998 Viruses Viruses 658 0   NTclustered gi|2438103068|ref|NC_070999.1| 2908744 g14761 i0 97.656 4.9453125 384 7 100 2 1 384 41354 40973 Aeromonas phage pAEv1810, complete genome blastn 1899 658 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ferozepurvirus Ferozepurvirus pAEv1810
16730341 16730341 PRJNA1005695_P_NODE_17254_length_364_cov_1.608247_g16402_i0 PRJNA1005695 17254 364 1.608247 5.85401908 Caudoviricetes sp. 2832643 Viruses Viruses 595 1.2699999999999995e-165   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g16402 i0 96.399 313.038461538462 361 13 99 0 1 361 17809 18169 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 113946 595 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23105678 23105678 PRJNA1005695_P_NODE_18259_length_354_cov_1.110320_g17407_i0 PRJNA1005695 18259 354 1.11032 3.9305328 Shantouvirus ZPAH14 3060700 Viruses Viruses 438 2.2000000000000003e-118   NTclustered gi|2438057841|ref|NC_070840.1| 2924887 g17407 i0 89.174 8.93220338983051 351 38 99 0 4 354 32277 31927 Aeromonas phage ZPAH14, complete genome blastn 3162 438 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chaseviridae Shantouvirus Shantouvirus ZPAH14

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