RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1104180 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1487101 1487101 PRJNA1104180_P_NODE_25842_length_242_cov_0.911243_g25699_i0 PRJNA1104180 25842 242 0.911243 2.20520806 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 219 2.0299999999999993e-52   NTclustered gi|2874253710|emb|OY969475.1| 2283092 g25699 i0 83.193 2.66942148760331 238 40 98 0 5 242 2613487 2613724 MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 blastn 646 219 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
2762979 2762979 PRJNA1104180_P_NODE_14463_length_280_cov_4.111111_g14321_i0 PRJNA1104180 14463 280 4.111111 11.5111108 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 283 8.4e-72   NTclustered gi|2874254027|emb|OY970352.1| 171953 g14321 i0 85.159 37.5464285714286 283 34 100 7 1 280 2367132 2366855 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 10513 283 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
2762993 2762993 PRJNA1104180_P_NODE_15703_length_273_cov_2.120000_g15561_i0 PRJNA1104180 15703 273 2.12 5.7876 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 167 8.579999999999999e-37   NTclustered gi|2874253885|emb|OY970060.1| 171953 g15561 i0 90.476 38.1062271062271 126 12 46 0 26 151 4819171 4819296 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 10403 167 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7865119 7865119 PRJNA1104180_P_NODE_23747_length_245_cov_0.895349_g23604_i0 PRJNA1104180 23747 245 0.895349 2.19360505 Terriglobus roseus 392734 Bacteria Bacteria 220 5.73e-53   NTclustered gi|1085637902|emb|LT629690.1| 392734 g23604 i0 88.108 7.56734693877551 185 22 76 0 58 242 237328 237144 Terriglobus roseus strain GAS232 genome assembly, chromosome: I blastn 1854 220 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus
14241078 14241078 PRJNA1104180_P_NODE_16252_length_270_cov_2.842640_g16110_i0 PRJNA1104180 16252 270 2.84264 7.675128 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 145 3.9699999999999995e-30   NTclustered gi|2893358426|emb|OZ220718.1| 2910147 g16110 i0 87.805 1.55925925925926 123 15 46 0 110 232 3587084 3587206 MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1 blastn 421 145 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
14241178 14241178 PRJNA1104180_P_NODE_22332_length_247_cov_2.166667_g22189_i0 PRJNA1104180 22332 247 2.166667 5.35166749 Acidobacteriota bacterium 1978231 Bacteria Bacteria 171 5.91e-38   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g22189 i0 80.822 1.82995951417004 219 40 88 2 15 232 3200483 3200700 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 452 171 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
14241234 14241234 PRJNA1104180_P_NODE_25632_length_242_cov_0.911243_g25489_i0 PRJNA1104180 25632 242 0.911243 2.20520806 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 200 7.359999999999999e-47   NTclustered gi|2874253885|emb|OY970060.1| 171953 g25489 i0 81.743 2.94628099173554 241 42 99 2 3 242 256789 257028 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 713 200 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14241241 14241241 PRJNA1104180_P_NODE_25992_length_242_cov_0.875740_g25849_i0 PRJNA1104180 25992 242 0.87574 2.1192908 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 165 2.68e-36   NTclustered gi|2874254056|emb|OY970380.1| 2651171 g25849 i0 82.54 2.34297520661157 189 31 78 2 9 196 5139795 5139608 MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1 blastn 567 165 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
15514961 15514961 PRJNA1104180_P_NODE_19873_length_252_cov_1.413408_g19730_i0 PRJNA1104180 19873 252 1.413408 3.56178816 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 248 2.72e-61   NTclustered gi|2814788339|emb|OY761475.2| 2910147 g19730 i0 89.34 48.5634920634921 197 21 78 0 1 197 492047 492243 MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1 blastn 12238 248 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
16789533 16789533 PRJNA1104180_P_NODE_23754_length_245_cov_0.895349_g23611_i0 PRJNA1104180 23754 245 0.895349 2.19360505 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|325147105|gb|HQ597086.1| 171953 g23611 i0 100 100.040816326531 245 0 100 0 1 245 345 101 Uncultured Acidobacteria bacterium clone AEG_08_075 16S ribosomal RNA gene, partial sequence blastn 24510 453 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19338285 19338285 PRJNA1104180_P_NODE_27116_length_234_cov_4.291925_g26973_i0 PRJNA1104180 27116 234 4.291925 10.0431045 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 254 5.35e-63   NTclustered gi|2874254027|emb|OY970352.1| 171953 g26973 i0 86.383 210.388888888889 235 28 99 2 1 231 2368487 2368253 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 49231 254 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20613435 20613435 PRJNA1104180_P_NODE_14117_length_282_cov_2.478469_g13975_i0 PRJNA1104180 14117 282 2.478469 6.98928258 Acidobacteriota bacterium 1978231 Bacteria Bacteria 320 6.46e-83   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g13975 i0 88.148 85.5921985815603 270 31 95 1 3 271 3298190 3298459 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 24137 320 1 Bacteria   Pseudomonadati Acidobacteriota         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);;