RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1180292 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1592513 1592513 PRJNA1180292_P_NODE_13082_length_242_cov_0.923077_g12950_i0 PRJNA1180292 13082 242 0.923077 2.23384634 Verrucomicrobia bacterium IMCC26134 1637999 Bacteria Bacteria 128 3.52e-25   NTclustered gi|807238858|gb|CP011265.1| 1637999 g12950 i0 91.398 1.02892561983471 93 8 38 0 150 242 2297745 2297653 Verrucomicrobia bacterium IMCC26134, complete genome blastn 249 128 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium IMCC26134
4144744 4144744 PRJNA1180292_P_NODE_11804_length_245_cov_0.906977_g11672_i0 PRJNA1180292 11804 245 0.906977 2.22209365 Luteolibacter sp. SL250 2995170 Bacteria Bacteria 174 4.52e-39   NTclustered gi|2381117106|gb|CP113054.1| 2995170 g11672 i0 79.921 3.44897959183673 254 38 99 7 1 243 668947 668696 Luteolibacter sp. SL250 chromosome blastn 845 174 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. SL250
7971102 7971102 PRJNA1180292_P_NODE_13027_length_242_cov_0.923077_g12895_i0 PRJNA1180292 13027 242 0.923077 2.23384634 Opitutus terrae 107709 Bacteria Bacteria 180 9.58e-41   NTclustered gi|177839040|gb|CP001032.1| 452637 g12895 i0 85.799 1.37603305785124 169 24 70 0 12 180 252214 252046 Opitutus terrae PB90-1, complete genome blastn 333 180 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
10521502 10521502 PRJNA1180292_P_NODE_2809_length_407_cov_0.808383_g2677_i0 PRJNA1180292 2809 407 0.808383 3.29011881 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 348 4.45e-91   NTclustered gi|2874253690|emb|OY969416.1| 412056 g2677 i0 82.169 85.4029484029484 415 64 100 9 1 407 1316363 1316775 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 34759 348 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10521578 10521578 PRJNA1180292_P_NODE_9689_length_249_cov_0.886364_g9557_i0 PRJNA1180292 9689 249 0.886364 2.20704636 Horticoccus luteus 2862869 Bacteria Bacteria 178 3.56e-40   NTclustered gi|2077391884|gb|CP080507.1| 2862869 g9557 i0 79.6 1.69076305220884 250 49 100 2 1 249 732319 732071 Horticoccus luteus strain KSB-15 chromosome, complete genome blastn 421 178 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Horticoccus Horticoccus luteus
11244520 11244520 PRJNA1180292_P_NODE_10209_length_248_cov_0.891429_g10077_i0 PRJNA1180292 10209 248 0.891429 2.21074392 Verrucomicrobiota 74201 Bacteria Bacteria 329 9.249999999999998e-86   NTclustered gi|183579829|emb|AM905426.1| 320771 g10077 i0 90.8 159.516129032258 250 18 100 4 1 248 68 314 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 39560 331 0.993957703927492 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);;