RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA879067 · 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
9784097 9784097 PRJNA879067_P_NODE_84988_length_318_cov_1.775510_g81502_i0 PRJNA879067 84988 318 1.77551 5.6461218 Luteolibacter sp. Populi 3230487 Bacteria Bacteria 359 1.57e-94   NTclustered gi|2774618348|gb|CP161812.1| 3230487 g81502 i0 87.066 1.33018867924528 317 41 99 0 2 318 446523 446207 Luteolibacter sp. Populi chromosome, complete genome blastn 423 359 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. Populi
9784277 9784277 PRJNA879067_P_NODE_92128_length_290_cov_2.571429_g88642_i0 PRJNA879067 92128 290 2.571429 7.4571441 Actomonas aquatica 2866162 Bacteria Bacteria 52.8 0.027   NTclustered gi|2647674565|gb|CP139781.1| 2866162 g88642 i0 100 0.096551724137931 28 0 10 0 262 289 1509966 1509993 Actomonas aquatica strain WL0086 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Actomonas Actomonas aquatica
19090406 19090406 PRJNA879067_P_NODE_29155_length_779_cov_16.766289_g25870_i0 PRJNA879067 29155 779 16.766289 130.60939131 root 1 Root_unresolved Root_unresolved 54.7 0.022   NTclustered gi|226525317|gb|FJ872374.1| 156588 g25870 i0 100 0.0744544287548139 29 0 4 0 347 375 1792 1764 Uncultured Verrucomicrobia bacterium clone 184 genomic sequence blastn 58 54.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
19981675 19981675 PRJNA879067_P_NODE_40476_length_618_cov_2.467890_g37028_i0 PRJNA879067 40476 618 2.46789 15.2515602 Termitidicoccus mucosus 1184151 Bacteria Bacteria 248 7.28e-61   NTclustered gi|2724066732|gb|CP109796.1| 1184151 g37028 i0 85.714 5.05663430420712 238 31 38 3 356 591 4295974 4295738 Termitidicoccus mucosus strain TSB47 chromosome, complete genome blastn 3125 248 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Termitidicoccus Termitidicoccus mucosus
22533091 22533091 PRJNA879067_P_NODE_89578_length_300_cov_1.696035_g86092_i0 PRJNA879067 89578 300 1.696035 5.088105 Verrucomicrobium spinosum 2736 Bacteria Bacteria 392 1.4499999999999994e-104   NTclustered gi|12583973|gb|AF245377.1| 240016 g86092 i0 90.604 141.846666666667 298 25 99 2 5 300 268 564 Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence blastn 42554 392 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium spinosum

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