RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1059246 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
177406 177406 PRJNA1059246_P_NODE_64121_length_249_cov_0.875000_g63495_i0 PRJNA1059246 64121 249 0.875 2.17875 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 187 5.919999999999998e-43   NTclustered gi|2874253952|emb|OY970277.1| 412056 g63495 i0 81.148 210.59437751004 244 36 96 6 1 238 2749929 2749690 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 52438 187 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
4003495 4003495 PRJNA1059246_P_NODE_38264_length_346_cov_1.410256_g37638_i0 PRJNA1059246 38264 346 1.410256 4.87948576 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 56.5 0.003   NTclustered gi|2874254065|emb|OY970130.1| 412056 g37638 i0 100 0.0867052023121387 30 0 9 0 125 154 3205139 3205168 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 30 56.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
6555057 6555057 PRJNA1059246_P_NODE_44266_length_315_cov_1.900826_g43640_i0 PRJNA1059246 44266 315 1.900826 5.9876019 Pedosphaera parvula 1032527 Bacteria Bacteria 435 2.5100000000000003e-117   NTclustered gi|183579829|emb|AM905426.1| 320771 g43640 i0 92.182 140.552380952381 307 24 97 0 6 312 2424 2118 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 44274 435 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
7830021 7830021 PRJNA1059246_P_NODE_70367_length_243_cov_0.905882_g69741_i0 PRJNA1059246 70367 243 0.905882 2.20129326 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 71.3 6.05e-8   NTclustered gi|2916415364|gb|CP170459.1| 2026799 g69741 i0 90.741 0.222222222222222 54 4 22 1 180 232 1644405 1644352 MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome blastn 54 71.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
16753855 16753855 PRJNA1059246_P_NODE_2934_length_1446_cov_2.938820_g2654_i0 PRJNA1059246 2934 1446 2.93882 42.4953372 Pedosphaera parvula 1032527 Bacteria Bacteria 1733 0   NTclustered gi|183579829|emb|AM905426.1| 320771 g2654 i0 88.581 176.353388658368 1445 141 99 22 1 1440 45 1470 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 255007 1733 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
19302616 19302616 PRJNA1059246_P_NODE_25056_length_446_cov_4.520107_g24432_i0 PRJNA1059246 25056 446 4.520107 20.15967722 Pedosphaera parvula 1032527 Bacteria Bacteria 671 0   NTclustered gi|183579829|emb|AM905426.1| 320771 g24432 i0 93.933 246.905829596413 445 26 99 1 1 445 1131 688 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 110120 671 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
20137897 20137897 PRJNA1059246_P_NODE_36576_length_355_cov_2.464539_g35950_i0 PRJNA1059246 36576 355 2.464539 8.74911345 Verrucomicrobiota 74201 Bacteria Bacteria 387 8.11e-103   NTclustered gi|183579829|emb|AM905426.1| 320771 g35950 i0 86.479 74.4957746478873 355 45 100 3 1 355 254 605 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 26446 387 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
20577886 20577886 PRJNA1059246_P_NODE_19197_length_522_cov_1.770601_g18579_i0 PRJNA1059246 19197 522 1.770601 9.2425372200000009 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 723 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g18579 i0 91.682 51.6704980842912 529 33 100 8 1 522 1316670 1316146 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 26972 723 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
20578266 20578266 PRJNA1059246_P_NODE_49797_length_290_cov_1.064516_g49171_i0 PRJNA1059246 49797 290 1.064516 3.0870964 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 318 2.3999999999999995e-82   NTclustered gi|2874253779|emb|OY969763.1| 412056 g49171 i0 86.598 82.0965517241379 291 35 100 4 1 290 3833415 3833128 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 23808 318 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
23129093 23129093 PRJNA1059246_P_NODE_17399_length_553_cov_1.766667_g16788_i0 PRJNA1059246 17399 553 1.766667 9.76966851 Oceaniferula spumae 2979115 Bacteria Bacteria 56.5 0.004   NTclustered gi|2753272999|dbj|AP026866.1| 2979115 g16788 i0 96.97 0.164556962025316 33 1 6 0 302 334 1663640 1663672 Verrucomicrobiaceae bacterium NT6N DNA, complete genome blastn 91 56.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Oceaniferula Oceaniferula spumae
24403378 24403378 PRJNA1059246_P_NODE_67060_length_246_cov_0.890173_g66434_i0 PRJNA1059246 67060 246 0.890173 2.18982558 Actomonas aquatica 2866162 Bacteria Bacteria 104 6.05e-18   NTclustered gi|2647674565|gb|CP139781.1| 2866162 g66434 i0 100 23.6422764227642 56 0 23 0 12 67 5831663 5831718 Actomonas aquatica strain WL0086 chromosome, complete genome blastn 5816 104 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Actomonas Actomonas aquatica

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