RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJDB14275" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJDB14275 · 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
3834823 3834823 PRJDB14275_P_NODE_7744_length_159_cov_1.016667_g7685_i0 PRJDB14275 7744 159 1.016667 1.61650053 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 217 4.41e-52   NTclustered gi|2874253974|emb|OY970299.1| 412056 g7685 i0 92.667 0.943396226415094 150 11 94 0 1 150 3307708 3307857 MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 blastn 150 217 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
15310721 15310721 PRJDB14275_P_NODE_7053_length_169_cov_1.261538_g6994_i0 PRJDB14275 7053 169 1.261538 2.13199922 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 110 3.28e-27   NR MFO1006063.1 2026779 g6994 i0 87.3 0.976331360946746 55 7 97.6 0 1 165 205 259 MFO1006063.1 formylglycine-generating enzyme family protein [Planctomycetaceae bacterium] diamond 165 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28232349 28232349 PRJDB14275_P_NODE_7366_length_164_cov_1.952000_g7307_i0 PRJDB14275 7366 164 1.952 3.20128 Parachlamydiales bacterium 2052178 Bacteria Bacteria 52 7.88e-7   NR MFA6917207.1 2052178 g7307 i0 47.7 0.804878048780488 44 23 80.5 0 134 3 9 52 MFA6917207.1 hypothetical protein [Parachlamydiales bacterium] diamond 132 52 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales     Parachlamydiales bacterium
28895539 28895539 PRJDB14275_P_NODE_5568_length_204_cov_1.230303_g5509_i0 PRJDB14275 5568 204 1.230303 2.50981812 Verrucomicrobiales bacterium VVV1 2015575 Bacteria Bacteria 73.2 4.1e-13   NR OYV06667.1 2015575 g5509 i0 59.7 0.985294117647059 67 21 98.5 2 202 2 301 361 OYV06667.1 MAG: hypothetical protein CFE26_05085, partial [Verrucomicrobiales bacterium VVV1] diamond 201 73.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium VVV1
31675782 31675782 PRJDB14275_P_NODE_6677_length_176_cov_1.189781_g6618_i0 PRJDB14275 6677 176 1.189781 2.09401456 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 99.4 2.6599999999999998e-24   NR MBT6048643.1 2268189 g6618 i0 73.7 0.971590909090909 57 14 95.5 1 170 3 11 67 MBT6048643.1 DNA cytosine methyltransferase [Candidatus Scalindua sp.] diamond 171 99.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
31802235 31802235 PRJDB14275_P_NODE_6777_length_174_cov_1.088889_g6718_i0 PRJDB14275 6777 174 1.088889 1.89466686 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 73.6 1e-14   NR MCG3177451.1 2035772 g6718 i0 59.6 0.982758620689655 57 21 98.3 1 172 2 5 59 MCG3177451.1 hypothetical protein [Candidatus Omnitrophota bacterium] diamond 171 73.6 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota 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);;