RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 14 ✖

bioproject 1

  • PRJNA1247234 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
2902315 2902315 PRJNA1247234_P_NODE_22603_length_250_cov_0.881356_g22447_i0 PRJNA1247234 22603 250 0.881356 2.20339 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 215 2.73e-51   NTclustered gi|2258877542|gb|CP060234.1| 2026777 g22447 i0 86.911 7.384 191 25 76 0 48 238 2286652 2286462 MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome blastn 1846 215 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
2902389 2902389 PRJNA1247234_P_NODE_26323_length_244_cov_0.912281_g26167_i0 PRJNA1247234 26323 244 0.912281 2.22596564 Gemmataceae bacterium 2052164 Bacteria Bacteria 296 9.21e-76   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g26167 i0 89.362 31.9631147540984 235 25 96 0 6 240 4061023 4060789 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 7799 296 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
5455029 5455029 PRJNA1247234_P_NODE_3945_length_500_cov_1.501171_g3794_i0 PRJNA1247234 3945 500 1.501171 7.505855 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 627 6.38e-175   NTclustered gi|2874253690|emb|OY969416.1| 412056 g3794 i0 89.328 156.23 506 45 100 7 1 500 1316825 1316323 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 78115 627 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
6729218 6729218 PRJNA1247234_P_NODE_21066_length_252_cov_0.871508_g20910_i0 PRJNA1247234 21066 252 0.871508 2.19620016 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 84.2 8.1e-12   NTclustered gi|2258877542|gb|CP060234.1| 2026777 g20910 i0 90.476 0.25 63 6 25 0 7 69 117499 117561 MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome blastn 63 84.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
8004538 8004538 PRJNA1247234_P_NODE_1027_length_887_cov_14.025799_g924_i0 PRJNA1247234 1027 887 14.025799 124.40883713 Gemmata algarum 2975278 Bacteria Bacteria 1408 0   NTclustered gi|2589385451|gb|OR644607.1| 2975278 g924 i0 95.378 117.356257046223 887 37 100 4 1 887 15 897 Gemmata algarum strain JC673 16S ribosomal RNA gene, partial sequence blastn 104095 1408 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata algarum
8004871 8004871 PRJNA1247234_P_NODE_27567_length_242_cov_0.923077_g27411_i0 PRJNA1247234 27567 242 0.923077 2.23384634 Candidatus Brocadia sp. 2172549 Bacteria Bacteria 230 9.38e-56   NTclustered gi|1958017660|gb|CP064969.1| 2172549 g27411 i0 90.286 4.1404958677686 175 17 72 0 1 175 578977 579151 MAG: Candidatus Brocadia sp. isolate Ega_18-Q3-R5-49_MAXAC.112v2 chromosome, complete genome blastn 1002 230 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Brocadia Candidatus Brocadia sp.
11830114 11830114 PRJNA1247234_P_NODE_24670_length_246_cov_1.352601_g24514_i0 PRJNA1247234 24670 246 1.352601 3.32739846 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 206 1.61e-48   NTclustered gi|2258877542|gb|CP060234.1| 2026777 g24514 i0 83.26 4.34959349593496 227 34 91 4 22 246 1691840 1692064 MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome blastn 1070 206 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
12530341 12530341 PRJNA1247234_P_NODE_24330_length_247_cov_0.896552_g24174_i0 PRJNA1247234 24330 247 0.896552 2.21448344 Bacteria 2 Bacteria Bacteria 161 3.56e-35   NTclustered gi|2916408352|gb|CP170455.1| 2052180 g24174 i0 86 1.20242914979757 150 21 61 0 98 247 409424 409573 MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome blastn 297 161 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
13105362 13105362 PRJNA1247234_P_NODE_23891_length_248_cov_0.891429_g23735_i0 PRJNA1247234 23891 248 0.891429 2.21074392 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 183 7.62e-42   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g23735 i0 86.391 1.12903225806452 169 21 68 2 2 169 279460 279293 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 280 183 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
19477596 19477596 PRJNA1247234_P_NODE_25616_length_245_cov_0.906977_g25460_i0 PRJNA1247234 25616 245 0.906977 2.22209365 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 331 2.5400000000000002e-86   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g25460 i0 91.02 29.665306122449 245 22 100 0 1 245 2327517 2327273 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 7268 331 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
20752891 20752891 PRJNA1247234_P_NODE_19437_length_257_cov_1.271739_g19281_i0 PRJNA1247234 19437 257 1.271739 3.26836923 Phycisphaera sp. 2030824 Bacteria Bacteria 213 1.01e-50   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g19281 i0 81.783 4.90272373540856 258 43 99 4 1 256 3365725 3365470 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 1260 213 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
22027990 22027990 PRJNA1247234_P_NODE_11518_length_324_cov_0.932271_g11362_i0 PRJNA1247234 11518 324 0.932271 3.02055804 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 300 9.84e-77   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g11362 i0 83.486 5.02469135802469 327 48 100 6 1 324 2373904 2374227 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 1628 300 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
22728531 22728531 PRJNA1247234_P_NODE_15478_length_286_cov_8.558685_g15322_i0 PRJNA1247234 15478 286 8.558685 24.4778391 Gemmata 113 Bacteria Bacteria 431 2.909999999999999e-116   NTclustered gi|12583965|gb|AF245369.1|AF245369 114 g15322 i0 94.035 40.9055944055944 285 16 99 1 2 286 2750 2467 Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence blastn 11699 431 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
25277854 25277854 PRJNA1247234_P_NODE_27060_length_243_cov_0.917647_g26904_i0 PRJNA1247234 27060 243 0.917647 2.22988221 Bacteria 2 Bacteria Bacteria 399 6.789999999999999e-107   NTclustered gi|2916408352|gb|CP170455.1| 2052180 g26904 i0 96.296 3.97942386831276 243 9 100 0 1 243 2433436 2433194 MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome blastn 967 399 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium

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