RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674050 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
9573014 9573014 PRJNA674050_P_NODE_7788_length_317_cov_1.381148_g7585_i0 PRJNA674050 7788 317 1.381148 4.37823916 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 488 1.91e-133   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g7585 i0 94.888 559.845425867508 313 14 98 2 6 317 2581813 2582124 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 177471 488 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
16469212 16469212 PRJNA674050_P_NODE_32853_length_246_cov_0.884393_g32650_i0 PRJNA674050 32853 246 0.884393 2.17560678 Gemmata 113 Bacteria Bacteria 375 1.16e-99   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g32650 i0 94.309 142.00406504065 246 12 100 2 1 246 3634898 3635141 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 34933 375 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
18495579 18495579 PRJNA674050_P_NODE_10255_length_298_cov_2.502222_g10052_i0 PRJNA674050 10255 298 2.502222 7.45662156 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 339 1.9e-88   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g10052 i0 87.086 82.1610738255034 302 35 100 4 1 298 7051729 7051428 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 24484 339 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24869741 24869741 PRJNA674050_P_NODE_20000_length_258_cov_2.302703_g19797_i0 PRJNA674050 20000 258 2.302703 5.94097374 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 278 3.5600000000000004e-70   NTclustered gi|2874254043|emb|OY970367.1| 120965 g19797 i0 86.434 242.085271317829 258 30 99 4 2 258 3454039 3454292 MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 blastn 62458 278 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
24870446 24870446 PRJNA674050_P_NODE_3860_length_376_cov_1.029703_g3657_i0 PRJNA674050 3860 376 1.029703 3.87168328 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 468 2.9999999999999997e-127   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g3657 i0 89.333 280.210106382979 375 36 99 3 1 374 2583782 2584153 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 105359 468 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);;