RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1196438 · 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
4149900 4149900 PRJNA1196438_P_NODE_31204_length_300_cov_5.911894_g30778_i0 PRJNA1196438 31204 300 5.911894 17.735682 Lacipirellula limnantheis 2528024 Bacteria Bacteria 470 6.5e-128   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g30778 i0 95 1 300 14 100 1 1 300 5899736 5900034 Lacipirellula limnantheis strain I41 chromosome blastn 300 470 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
9251149 9251149 PRJNA1196438_P_NODE_50968_length_271_cov_4.065657_g50541_i0 PRJNA1196438 50968 271 4.065657 11.01793047 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 279 1.05e-70   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g50541 i0 85.24 2.77121771217712 271 40 100 0 1 271 5818583 5818313 Planctomyces sp. SH-PL62, complete genome blastn 751 279 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
13796662 13796662 PRJNA1196438_P_NODE_36791_length_294_cov_1.945701_g36365_i0 PRJNA1196438 36791 294 1.945701 5.72036094 Rubinisphaera 1649490 Bacteria Bacteria 425 1.39e-114   NTclustered gi|470488120|ref|NR_076852.1| 119 g36365 i0 97.581 165.520408163265 248 6 84 0 46 293 2038 2285 Planctomyces brasiliensis strain DSM 5305 23S ribosomal RNA gene, complete sequence blastn 48663 425 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Rubinisphaera Rubinisphaera brasiliensis
14352177 14352177 PRJNA1196438_P_NODE_46092_length_279_cov_2.165049_g45665_i0 PRJNA1196438 46092 279 2.165049 6.04048671 Urbifossiella limnaea 2528023 Bacteria Bacteria 276 1.4e-69   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g45665 i0 86.454 1.61290322580645 251 34 96 0 29 279 4292957 4293207 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 450 276 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
15625934 15625934 PRJNA1196438_P_NODE_44613_length_281_cov_4.019231_g44186_i0 PRJNA1196438 44613 281 4.0192310000000004 11.29403911 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 143 1.49e-29   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g44186 i0 79.476 0.814946619217082 229 25 76 10 1 213 73547 73325 Planctomyces sp. SH-PL62, complete genome blastn 229 143 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
18174920 18174920 PRJNA1196438_P_NODE_57235_length_262_cov_2.227513_g56808_i0 PRJNA1196438 57235 262 2.227513 5.83608406 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 224 4.789999999999999e-54   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g56808 i0 82.129 3.72900763358779 263 45 100 2 1 262 2741447 2741708 Planctomyces sp. SH-PL62, complete genome blastn 977 224 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
19449282 19449282 PRJNA1196438_P_NODE_52216_length_270_cov_1.482234_g51789_i0 PRJNA1196438 52216 270 1.482234 4.0020318 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 379 9.989999999999998e-101   NTclustered gi|2874253757|emb|OY969698.1| 100233 g51789 i0 91.912 273.377777777778 272 20 100 2 1 270 4422000 4422271 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 73812 379 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae 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);;