RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 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
364416 364416 PRJNA168635_P_NODE_22381_length_175_cov_2.420635_g21965_i0 PRJNA168635 22381 175 2.420635 4.23611125 Victivallaceae bacterium 2793042 Bacteria Bacteria 161 2.3499999999999997e-35   NTclustered gi|2621704067|emb|OY761536.1| 2793042 g21965 i0 86.806 321.72 144 19 82 0 32 175 1448355 1448212 MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1 blastn 56301 161 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae   Victivallaceae bacterium
10568816 10568816 PRJNA168635_P_NODE_7289_length_313_cov_19.916667_g6877_i0 PRJNA168635 7289 313 19.916667 62.33916771 Lentisphaera profundi 1658616 Bacteria Bacteria 326 1.56e-84   NTclustered gi|2445967839|gb|CP117812.1| 1658616 g6877 i0 86.577 276.134185303514 298 36 95 4 1 297 2073320 2073614 Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence blastn 86430 326 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Lentisphaera Lentisphaera profundi
18216251 18216251 PRJNA168635_P_NODE_26115_length_168_cov_1.100840_g25699_i0 PRJNA168635 26115 168 1.10084 1.8494112 Victivallales bacterium 2212475 Bacteria Bacteria 172 1.04e-38   NTclustered gi|2622071908|emb|OY787460.1| 2212475 g25699 i0 88.276 251.583333333333 145 16 86 1 24 168 6141189 6141332 MAG: Victivallales bacterium isolate c43507a4-3b0a-454f-a213-a96987c4837a genome assembly, chromosome: 1 blastn 42266 172 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
18905689 18905689 PRJNA168635_P_NODE_2375_length_530_cov_8.573805_g1996_i0 PRJNA168635 2375 530 8.573805 45.4411665 Bacteria 2 Bacteria Bacteria 169 4.9499999999999995e-37   NTclustered gi|2126063867|gb|CP085689.1| 2886196 g1996 i0 78.755 73.9622641509434 273 43 50 11 255 518 2383973 2384239 Lentisphaerae bacterium WC36 chromosome, complete genome blastn 39200 169 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium WC36
20180272 20180272 PRJNA168635_P_NODE_20156_length_182_cov_1.165414_g19740_i0 PRJNA168635 20156 182 1.165414 2.12105348 Bacteria 2 Bacteria Bacteria 87.9 4.24e-13   NTclustered gi|2126063867|gb|CP085689.1| 2886196 g19740 i0 75.843 9.81318681318681 178 40 100 3 7 182 2383988 2383812 Lentisphaerae bacterium WC36 chromosome, complete genome blastn 1786 87.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium WC36

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