RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 8 ✖

analysis 1

  • blastn · 8 ✖

tax_clade 0

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
6403055 6403055 PRJEB28062_P_NODE_48646_length_513_cov_5.518182_g46299_i0 PRJEB28062 48646 513 5.518182 28.30827366 Luteitalea pratensis 1855912 Bacteria Bacteria 691 0   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g46299 i0 94.619 87.5341130604289 446 24 87 0 46 491 654773 654328 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 44905 691 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis
8951835 8951835 PRJEB28062_P_NODE_45968_length_530_cov_4.470460_g43627_i0 PRJEB28062 45968 530 4.47046 23.693438 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 623 8.789999999999998e-174   NTclustered gi|76574288|gb|DQ139436.1| 171953 g43627 i0 89.754 156.966037735849 488 49 92 1 21 507 488 1 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 83192 623 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
10228573 10228573 PRJEB28062_P_NODE_94529_length_331_cov_3.298450_g92167_i0 PRJEB28062 94529 331 3.29845 10.9178695 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 364 3.5299999999999986e-96   NTclustered gi|2874253700|emb|OY969426.1| 2651171 g92167 i0 87.697 87.0030211480363 317 34 95 5 5 319 2972410 2972723 MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 blastn 28798 364 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
16289527 16289527 PRJEB28062_P_NODE_100073_length_314_cov_19.734440_g97710_i0 PRJEB28062 100073 314 19.73444 61.9661416 Bacteria 2 Bacteria Bacteria 104 8e-18   NTclustered gi|2874253940|emb|OY970265.1| 171953 g97710 i0 100 49.4203821656051 56 0 18 0 225 280 3790412 3790467 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1 blastn 15518 104 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
17875106 17875106 PRJEB28062_P_NODE_102655_length_307_cov_1.905983_g100292_i0 PRJEB28062 102655 307 1.905983 5.85136781 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 231 3.4299999999999996e-56   NTclustered gi|2874254049|emb|OY970373.1| 171953 g100292 i0 82.042 34.1889250814332 284 39 91 10 8 285 6604426 6604703 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 10496 231 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19151083 19151083 PRJEB28062_P_NODE_81976_length_370_cov_22.158249_g79614_i0 PRJEB28062 81976 370 22.158249 81.9855213 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 302 3.1600000000000006e-77   NTclustered gi|2874253862|emb|OY969918.1| 171953 g79614 i0 83.434 1.72432432432432 332 47 89 7 27 354 3213773 3214100 MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1 blastn 638 302 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20424943 20424943 PRJEB28062_P_NODE_18877_length_867_cov_4.892947_g16871_i0 PRJEB28062 18877 867 4.892947 42.42185049 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 243 4.83e-59   NTclustered gi|2874253677|emb|OY969111.1| 171953 g16871 i0 80.769 1.43483275663206 312 59 36 1 530 840 1280877 1281188 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 blastn 1244 243 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22976890 22976890 PRJEB28062_P_NODE_47779_length_518_cov_29.438202_g45433_i0 PRJEB28062 47779 518 29.438202 152.48988636 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 787 0   NTclustered gi|76574288|gb|DQ139436.1| 171953 g45433 i0 95.547 264.812741312741 494 18 95 4 27 518 1 492 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 137173 787 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium

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