RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB50332" 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

  • PRJEB50332 · 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
7771877 7771877 PRJEB50332_P_NODE_4347_length_287_cov_1.548673_g4265_i0 PRJEB50332 4347 287 1.548673 4.44469151 Humisphaera borealis 2807512 Bacteria Bacteria 427 3.7699999999999997e-115   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g4265 i0 94.585 480.81881533101 277 13 97 1 1 277 5063276 5063550 Humisphaera borealis strain M1803 chromosome, complete genome blastn 137995 427 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
9046693 9046693 PRJEB50332_P_NODE_3208_length_324_cov_1.114068_g3126_i0 PRJEB50332 3208 324 1.114068 3.60958032 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 364 3.439999999999999e-96   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g3126 i0 87.195 44.7746913580247 328 32 100 8 1 324 1600613 1600292 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 14507 364 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
9046731 9046731 PRJEB50332_P_NODE_6648_length_244_cov_1.808743_g6566_i0 PRJEB50332 6648 244 1.808743 4.41333292 Urbifossiella limnaea 2528023 Bacteria Bacteria 318 1.9699999999999998e-82   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g6566 i0 93.088 3.86065573770492 217 15 89 0 6 222 5053910 5054126 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 942 318 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
17971098 17971098 PRJEB50332_P_NODE_9835_length_225_cov_1.585366_g9753_i0 PRJEB50332 9835 225 1.585366 3.5670735 Lacipirellula parvula 2650471 Bacteria Bacteria 302 1.8e-77   NTclustered gi|1761017769|dbj|AP021861.1| 2650471 g9753 i0 91.031 0.991111111111111 223 20 99 0 1 223 3022423 3022201 Lacipirellula parvula PX69 DNA, complete genome blastn 223 302 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula parvula

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