RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA421571" 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

  • PRJNA421571 · 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
11903189 11903189 PRJNA421571_P_NODE_93970_length_250_cov_0.870056_g91421_i0 PRJNA421571 93970 250 0.870056 2.17514 Opitutus sp. GAS368 1882749 Bacteria Bacteria 143 1.31e-29   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g91421 i0 78.855 68.248 227 37 89 8 1 223 2052656 2052437 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 17062 143 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368
14452964 14452964 PRJNA421571_P_NODE_80132_length_277_cov_0.970588_g77583_i0 PRJNA421571 80132 277 0.970588 2.68852876 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 324 4.89e-84   NTclustered gi|2874253779|emb|OY969763.1| 412056 g77583 i0 88.806 117.635379061372 268 25 95 5 14 277 3833276 3833542 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 32585 324 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16388756 16388756 PRJNA421571_P_NODE_88133_length_258_cov_2.064865_g85584_i0 PRJNA421571 88133 258 2.064865 5.3273517 Verrucomicrobiota 74201 Bacteria Bacteria 335 2.079999999999999e-87   NTclustered gi|183579829|emb|AM905426.1| 320771 g85584 i0 90.625 95.0736434108527 256 18 98 5 4 256 1244 992 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 24529 337 0.99406528189911 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
17001610 17001610 PRJNA421571_P_NODE_87194_length_260_cov_2.379679_g84645_i0 PRJNA421571 87194 260 2.379679 6.1871654 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 257 4.68e-64   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g84645 i0 85.385 2.88461538461538 260 24 99 7 4 260 1386366 1386118 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 750 257 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
18275347 18275347 PRJNA421571_P_NODE_65675_length_318_cov_1.885714_g63126_i0 PRJNA421571 65675 318 1.885714 5.99657052 Pedosphaera parvula 1032527 Bacteria Bacteria 429 1.18e-115   NTclustered gi|183579829|emb|AM905426.1| 320771 g63126 i0 91.195 141.74213836478 318 24 100 3 1 318 979 666 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 45074 429 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula

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