RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA670521 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
3188968 3188968 PRJNA670521_P_NODE_2723_length_1064_cov_1.718466_g2205_i0 PRJNA670521 2723 1064 1.718466 18.28447824 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 1478 0   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g2205 i0 91.791 201.417293233083 1072 72 99 15 1 1063 2002345 2003409 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 214308 1478 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
6268789 6268789 PRJNA670521_P_NODE_12165_length_518_cov_1.384270_g11430_i0 PRJNA670521 12165 518 1.38427 7.1705186 Isosphaeraceae 1763524 Bacteria Bacteria 595 1.8699999999999998e-165   NTclustered gi|1730068067|gb|CP042997.1| 406548 g11430 i0 88.063 145.015444015444 511 50 98 9 11 518 9143435 9143937 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 75118 599 0.993322203672788 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
8291356 8291356 PRJNA670521_P_NODE_37547_length_331_cov_1.922481_g36802_i0 PRJNA670521 37547 331 1.922481 6.36341211 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 440 5.689999999999998e-119   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g36802 i0 91.385 297.247734138973 325 23 98 5 3 325 2001897 2002218 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 98389 440 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
10093607 10093607 PRJNA670521_P_NODE_73468_length_250_cov_0.870056_g72723_i0 PRJNA670521 73468 250 0.870056 2.17514 Isosphaeraceae 1763524 Bacteria Bacteria 329 9.34e-86   NTclustered gi|1730068067|gb|CP042997.1| 406548 g72723 i0 94.811 356.672 212 10 85 1 1 212 5179190 5179400 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 89168 331 0.993957703927492 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
20291377 20291377 PRJNA670521_P_NODE_74476_length_249_cov_0.875000_g73731_i0 PRJNA670521 74476 249 0.875 2.17875 Pirellulaceae 2691357 Bacteria Bacteria 355 1.53e-93   NTclustered gi|1015448679|gb|CP011272.1| 1632865 g73731 i0 92.369 173.763052208835 249 19 100 0 1 249 3095525 3095277 Pirellula sp. SH-Sr6A, complete genome blastn 43267 355 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
22315552 22315552 PRJNA670521_P_NODE_57618_length_278_cov_1.502439_g56873_i0 PRJNA670521 57618 278 1.502439 4.17678042 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 407 4.74e-109   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g56873 i0 92.933 250.115107913669 283 15 100 3 1 278 2004109 2004391 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 69532 407 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24864358 24864358 PRJNA670521_P_NODE_62340_length_267_cov_3.381443_g61595_i0 PRJNA670521 62340 267 3.381443 9.02845281 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 311 3.65e-80   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g61595 i0 87.687 173.089887640449 268 31 100 2 1 267 2001633 2001899 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 46215 311 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae 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);;