RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA657343" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA657343 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1899892 1899892 PRJNA657343_S_NODE_20122_length_201_cov_3.368421_g20097_i0 PRJNA657343 20122 201 3.368421 6.77052621 Phycisphaera sp. 2030824 Bacteria Bacteria 237 4.4999999999999996e-58   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g20097 i0 88.06 8.48258706467662 201 23 100 1 1 201 3047330 3047131 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 1705 237 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
1900206 1900206 PRJNA657343_S_NODE_27662_length_169_cov_5.383333_g27637_i0 PRJNA657343 27662 169 5.383333 9.09783277 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 235 1.31e-57   NTclustered gi|1938775668|gb|CP054178.1| 2026777 g27637 i0 92.169 204.668639053254 166 13 98 0 1 166 192629 192464 MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome blastn 34589 235 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
14652424 14652424 PRJNA657343_S_NODE_13792_length_244_cov_5.692308_g13767_i0 PRJNA657343 13792 244 5.692308 13.88923152 Phycisphaerales bacterium 2052180 Bacteria Bacteria 219 2.05e-52   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g13767 i0 84.052 14.827868852459 232 32 94 5 1 230 2190373 2190145 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 3618 219 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
24849770 24849770 PRJNA657343_S_NODE_13160_length_249_cov_30.555000_g13135_i0 PRJNA657343 13160 249 30.555 76.08195 Phycisphaerales bacterium 2052180 Bacteria Bacteria 307 4.3600000000000006e-79   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g13135 i0 89.243 3.78313253012048 251 20 100 6 1 249 2190130 2190375 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 942 307 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);;