RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1120586" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1120586 · 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
1550308 1550308 PRJNA1120586_P_NODE_14162_length_336_cov_2.883895_g13971_i0 PRJNA1120586 14162 336 2.883895 9.6898872 Urbifossiella limnaea 2528023 Bacteria Bacteria 337 7.81e-88   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g13971 i0 84.956 248.738095238095 339 44 100 5 1 336 4211930 4212264 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 83576 337 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
1550469 1550469 PRJNA1120586_P_NODE_24882_length_277_cov_3.346154_g24691_i0 PRJNA1120586 24882 277 3.346154 9.26884658 Urbifossiella limnaea 2528023 Bacteria Bacteria 348 2.9e-91   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g24691 i0 89.455 125.72202166065 275 29 99 0 1 275 2019590 2019864 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 34825 348 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
1550828 1550828 PRJNA1120586_P_NODE_44562_length_231_cov_5.567901_g44371_i0 PRJNA1120586 44562 231 5.567901 12.86185131 uncultured Gemmata sp. 459262 Bacteria Bacteria 394 2.98e-105   NTclustered gi|330376222|gb|JF731389.1| 459262 g44371 i0 97.403 99.987012987013 231 6 100 0 1 231 432 202 Uncultured Gemmata sp. clone BacTopLow012 16S ribosomal RNA gene, partial sequence blastn 23097 394 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata uncultured Gemmata sp.
22705390 22705390 PRJNA1120586_P_NODE_50638_length_227_cov_1.069620_g50447_i0 PRJNA1120586 50638 227 1.06962 2.4280374 Bacteria 2 Bacteria Bacteria 196 8.829999999999999e-46   NTclustered gi|2874254043|emb|OY970367.1| 120965 g50447 i0 82.667 291.396475770925 225 35 99 4 1 225 3454566 3454786 MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 blastn 66147 196 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
23980679 23980679 PRJNA1120586_P_NODE_3439_length_580_cov_2.802348_g3252_i0 PRJNA1120586 3439 580 2.802348 16.2536184 Limnoglobus 2731450 Bacteria Bacteria 695 0   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g3252 i0 88.356 309.872413793103 584 61 100 6 1 580 2002294 2002874 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 179726 699 0.994277539341917 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24502457 24502457 PRJNA1120586_P_NODE_9740_length_386_cov_1.640379_g9549_i0 PRJNA1120586 9740 386 1.640379 6.33186294 Frigoriglobus tundricola 2774151 Bacteria Bacteria 532 1.08e-146   NTclustered gi|1870286614|gb|CP053452.2| 2774151 g9549 i0 91.582 151.253886010363 392 23 99 5 1 383 4959452 4959842 Frigoriglobus tundricola strain PL17 chromosome, complete genome blastn 58384 532 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola

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