RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA438687 · 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
435262 435262 PRJNA438687_S_NODE_1621_length_327_cov_3.698630_g1531_i0 PRJNA438687 1621 327 3.69863 12.0945201 Lentisphaera profundi 1658616 Bacteria Bacteria 257 6.0700000000000006e-64   NTclustered gi|2445967839|gb|CP117812.1| 1658616 g1531 i0 81.231 704.207951070336 325 55 99 5 3 325 2265261 2265581 Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence blastn 230276 257 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Lentisphaera Lentisphaera profundi
1091241 1091241 PRJNA438687_S_NODE_7141_length_163_cov_1.226562_g7051_i0 PRJNA438687 7141 163 1.226562 1.99929606 Bacteria 2 Bacteria Bacteria 226 7.559999999999997e-55   NTclustered gi|2189495548|gb|CP091727.1| 2053569 g7051 i0 91.515 25.361963190184 165 12 100 2 1 163 949604 949768 MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome blastn 4134 226 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
5538963 5538963 PRJNA438687_S_NODE_2525_length_279_cov_3.848361_g2435_i0 PRJNA438687 2525 279 3.848361 10.73692719 Victivallales bacterium 2212475 Bacteria Bacteria 244 3.95e-60   NTclustered gi|2622071908|emb|OY787460.1| 2212475 g2435 i0 82.971 62.5268817204301 276 42 98 5 1 274 6140239 6140511 MAG: Victivallales bacterium isolate c43507a4-3b0a-454f-a213-a96987c4837a genome assembly, chromosome: 1 blastn 17445 244 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
25317378 25317378 PRJNA438687_S_NODE_4100_length_219_cov_4.945652_g4010_i0 PRJNA438687 4100 219 4.945652 10.83097788 Bacteria 2 Bacteria Bacteria 154 5.16e-33   NTclustered gi|2126063867|gb|CP085689.1| 2886196 g4010 i0 82.955 71.5388127853881 176 25 79 5 10 183 2384145 2383973 Lentisphaerae bacterium WC36 chromosome, complete genome blastn 15667 154 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium WC36

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