RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA728642" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA728642 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3264280 3264280 PRJNA728642_P_NODE_5983_length_420_cov_1.979827_g5712_i0 PRJNA728642 5983 420 1.979827 8.3152734 Urbifossiella limnaea 2528023 Bacteria Bacteria 460 5.669999999999998e-125   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g5712 i0 88.52 158.592857142857 392 29 93 12 32 420 2018957 2019335 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 66609 460 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
12192375 12192375 PRJNA728642_P_NODE_9910_length_323_cov_1.232000_g9639_i0 PRJNA728642 9910 323 1.232 3.97936 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 178 4.8e-40   NTclustered gi|2874253903|emb|OY970228.1| 100233 g9639 i0 78.289 3.24458204334365 304 47 91 16 30 323 5066743 5067037 MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1 blastn 1048 178 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
12674602 12674602 PRJNA728642_P_NODE_3450_length_561_cov_1.682377_g3181_i0 PRJNA728642 3450 561 1.682377 9.43813497 Isosphaeraceae 1763524 Bacteria Bacteria 673 0   NTclustered gi|1730068067|gb|CP042997.1| 406548 g3181 i0 88.475 140.479500891266 564 55 100 10 4 561 5179488 5178929 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 78809 673 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
14741745 14741745 PRJNA728642_P_NODE_10972_length_306_cov_0.991416_g10701_i0 PRJNA728642 10972 306 0.991416 3.03373296 Verrucomicrobium sp. GAS474 1882831 Bacteria Bacteria 372 1.93e-98   NTclustered gi|1085974270|emb|LT629781.1| 1882831 g10701 i0 89.262 284.415032679739 298 30 97 1 9 306 3537422 3537717 Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I blastn 87031 372 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp. GAS474
19839753 19839753 PRJNA728642_P_NODE_15556_length_253_cov_1.283333_g15285_i0 PRJNA728642 15556 253 1.283333 3.24683249 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 383 7.17e-102   NTclustered gi|2874254106|emb|OY970189.1| 100233 g15285 i0 93.774 212.284584980237 257 12 100 3 1 253 5934832 5935088 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 53708 383 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);;