RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA309466" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA309466 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1651639 1651639 PRJNA309466_P_NODE_3742_length_304_cov_2.431373_g3686_i0 PRJNA309466 3742 304 2.431373 7.39137392 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 291 5.51e-74   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g3686 i0 84.211 8.50657894736842 304 42 98 4 5 303 2582826 2583128 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 2586 291 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
2927470 2927470 PRJNA309466_P_NODE_1443_length_608_cov_29.028623_g1398_i0 PRJNA309466 1443 608 29.028623 176.49402784 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 784 0   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g1398 i0 90.065 124.083881578947 614 48 99 11 1 607 1866203 1866810 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 75443 784 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
9304935 9304935 PRJNA309466_P_NODE_9448_length_203_cov_6.512987_g9391_i0 PRJNA309466 9448 203 6.512987 13.22136361 planctomycete str. 139 149588 Bacteria Bacteria 294 2.66e-75   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g9391 i0 94.271 120.694581280788 192 11 95 0 1 192 1576 1767 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 24501 294 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139
16954217 16954217 PRJNA309466_P_NODE_6054_length_238_cov_4.783069_g5997_i0 PRJNA309466 6054 238 4.783069 11.38370422 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 313 8.88e-81   NTclustered gi|2874253847|emb|OY969903.1| 904075 g5997 i0 90.756 198.504201680672 238 17 99 5 2 236 1829908 1830143 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 47244 313 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
20778422 20778422 PRJNA309466_P_NODE_8697_length_209_cov_4.018750_g8640_i0 PRJNA309466 8697 209 4.01875 8.3991875 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 278 2.78e-70   NTclustered gi|1015448679|gb|CP011272.1| 1632865 g8640 i0 91.919 375.622009569378 198 16 95 0 1 198 3095669 3095472 Pirellula sp. SH-Sr6A, complete genome blastn 78505 278 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
24602916 24602916 PRJNA309466_P_NODE_4640_length_267_cov_2.940367_g4584_i0 PRJNA309466 4640 267 2.940367 7.85077989 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 405 1.63e-108   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g4584 i0 95.294 103.007490636704 255 12 96 0 9 263 1867071 1866817 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 27503 405 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae 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);;