RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA902515" 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 · 8 ✖

bioproject 1

  • PRJNA902515 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
5984632 5984632 PRJNA902515_P_NODE_5545_length_333_cov_1.200000_g5522_i0 PRJNA902515 5545 333 1.2 3.996 Akkermansia muciniphila 239935 Bacteria Bacteria 604 1.9199999999999991e-168   NTclustered gi|2566447905|gb|CP114597.1| 239935 g5522 i0 99.399 99.2762762762763 333 2 100 0 1 333 692406 692738 Akkermansia muciniphila strain MmAkkUCB1 chromosome, complete genome blastn 33059 604 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
7259548 7259548 PRJNA902515_P_NODE_8646_length_282_cov_1.373206_g8623_i0 PRJNA902515 8646 282 1.373206 3.87244092 Akkermansia muciniphila 239935 Bacteria Bacteria 516 7.67e-142   NTclustered gi|1805960388|gb|CP029703.1| 239935 g8623 i0 99.645 69 282 1 100 0 1 282 1047222 1046941 Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome blastn 19458 516 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
8899537 8899537 PRJNA902515_P_NODE_11647_length_252_cov_0.871508_g11624_i0 PRJNA902515 11647 252 0.871508 2.19620016 Akkermansia 239934 Bacteria Bacteria 466 6.89e-127   NTclustered gi|1888387165|gb|CP058562.1| 239935 g11624 i0 100 100 252 0 100 0 1 252 485221 485472 Akkermansia muciniphila strain AK32 chromosome, complete genome blastn 25200 466 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
11084879 11084879 PRJNA902515_P_NODE_15529_length_243_cov_0.917647_g15506_i0 PRJNA902515 15529 243 0.917647 2.22988221 Prosthecobacter fusiformis 48464 Bacteria Bacteria 350 6.94e-92   NTclustered gi|12583974|gb|AF245378.1|AF245378 48464 g15506 i0 92.593 67.7736625514403 243 18 100 0 1 243 1353 1111 Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence blastn 16469 350 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter fusiformis
17459476 17459476 PRJNA902515_P_NODE_15734_length_243_cov_0.917647_g15711_i0 PRJNA902515 15734 243 0.917647 2.22988221 Akkermansia muciniphila 239935 Bacteria Bacteria 444 3.09e-120   NTclustered gi|1805960388|gb|CP029703.1| 239935 g15711 i0 99.588 93.9794238683128 243 1 100 0 1 243 2255604 2255846 Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome blastn 22837 444 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
21283114 21283114 PRJNA902515_P_NODE_11937_length_251_cov_0.876404_g11914_i0 PRJNA902515 11937 251 0.876404 2.19977404 Akkermansia muciniphila 239935 Bacteria Bacteria 453 5.34e-123   NTclustered gi|1805953094|gb|CP029699.1| 239935 g11914 i0 99.203 98.00796812749 251 2 100 0 1 251 2749571 2749321 Akkermansia muciniphila strain EB-AMDK-25 chromosome, complete genome blastn 24600 453 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
21283148 21283148 PRJNA902515_P_NODE_13397_length_248_cov_0.891429_g13374_i0 PRJNA902515 13397 248 0.891429 2.21074392 Akkermansia muciniphila 239935 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|1779063263|dbj|AP021898.1| 239935 g13374 i0 99.597 99.5201612903226 248 1 100 0 1 248 2741149 2740902 Akkermansia muciniphila JCM 30893 DNA, complete genome blastn 24681 453 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
25107332 25107332 PRJNA902515_P_NODE_16460_length_205_cov_5.636364_g16437_i0 PRJNA902515 16460 205 5.636364 11.5545462 uncultured sludge bacterium A35 117472 Bacteria Bacteria 113 8.1e-21   NTclustered gi|13171302|gb|AF234744.1| 117472 g16437 i0 85.586 9.10243902439024 111 13 54 3 82 192 1498 1391 Uncultured sludge bacterium A35 16S ribosomal RNA gene, partial sequence blastn 1866 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     uncultured sludge bacterium A35

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