RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1218816 · 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
9974361 9974361 PRJNA1218816_P_NODE_52588_length_255_cov_1.148352_g52155_i0 PRJNA1218816 52588 255 1.148352 2.9282976 Bacteria 2 Bacteria Bacteria 322 1.6e-83   NTclustered gi|2518556548|emb|OX638380.1| 412056 g52155 i0 89.764 152.670588235294 254 22 99 3 1 253 3921429 3921679 MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1 blastn 38931 324 0.993827160493827 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10537383 10537383 PRJNA1218816_P_NODE_56389_length_248_cov_0.880000_g55956_i0 PRJNA1218816 56389 248 0.88 2.1824 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 159 1.28e-34   NTclustered gi|2874253952|emb|OY970277.1| 412056 g55956 i0 78.431 36.4072580645161 255 47 100 8 1 248 2749712 2749459 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 blastn 9029 159 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
14362609 14362609 PRJNA1218816_P_NODE_63112_length_241_cov_0.916667_g62679_i0 PRJNA1218816 63112 241 0.916667 2.20916747 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 411 3.109999999999999e-110   NTclustered gi|403081880|gb|JX240789.1| 156588 g62679 i0 97.51 99.8921161825726 241 5 100 1 1 241 1426 1187 Uncultured Verrucomicrobia bacterium clone MLS125 16S ribosomal RNA gene, partial sequence blastn 24074 411 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
22723210 22723210 PRJNA1218816_P_NODE_59558_length_245_cov_0.895349_g59125_i0 PRJNA1218816 59558 245 0.895349 2.19360505 Coraliomargarita 442430 Bacteria Bacteria 191 4.49e-44   NTclustered gi|470486190|ref|NR_076741.1| 395922 g59125 i0 81.048 166.216326530612 248 40 100 6 1 245 1714 1471 Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence blastn 40723 191 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Coraliomargaritaceae Coraliomargarita Coraliomargarita akajimensis

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