RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA874604 · 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
8505802 8505802 PRJNA874604_P_NODE_92887_length_243_cov_0.905882_g92535_i0 PRJNA874604 92887 243 0.905882 2.20129326 uncultured Granulicella sp. 1241325 Bacteria Bacteria 294 3.3e-75   NTclustered gi|2836016424|emb|OZ196154.1| 1241325 g92535 i0 88.477 23.6213991769547 243 28 100 0 1 243 265550 265308 MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 7 blastn 5740 294 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.
8505826 8505826 PRJNA874604_P_NODE_94167_length_243_cov_0.905882_g93815_i0 PRJNA874604 94167 243 0.905882 2.20129326 uncultured Acidobacteria bacterium Rifle_16ft_4_minimus_37967 1665087 Bacteria Bacteria 117 7.6600000000000005e-22   NTclustered gi|874576316|gb|KT007012.1| 1665087 g93815 i0 80.795 9.23868312757202 151 27 62 2 23 172 22405 22256 Uncultured Acidobacteria bacterium Rifle_16ft_4_minimus_37967 genomic sequence blastn 2245 117 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteria bacterium Rifle_16ft_4_minimus_37967
14880550 14880550 PRJNA874604_P_NODE_77052_length_248_cov_1.760000_g76700_i0 PRJNA874604 77052 248 1.76 4.3648 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 95.3 3.67e-15   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g76700 i0 79.562 1.90725806451613 137 24 54 4 48 181 2167061 2166926 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 473 95.3 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
14881012 14881012 PRJNA874604_P_NODE_98992_length_241_cov_0.916667_g98640_i0 PRJNA874604 98992 241 0.916667 2.20916747 Terriglobia bacterium 2081523 Bacteria Bacteria 52.8 0.022   NTclustered gi|2874253792|emb|OY969776.1| 2081523 g98640 i0 100 0.116182572614108 28 0 12 0 136 163 3654419 3654392 MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
18704292 18704292 PRJNA874604_P_NODE_92155_length_243_cov_1.582353_g91803_i0 PRJNA874604 92155 243 1.582353 3.84511779 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 159 1.2499999999999999e-34   NTclustered gi|2874253700|emb|OY969426.1| 2651171 g91803 i0 79.747 61.0123456790123 237 34 97 13 15 243 3105664 3105434 MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 blastn 14826 159 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
23803692 23803692 PRJNA874604_P_NODE_21559_length_392_cov_1.206897_g21207_i0 PRJNA874604 21559 392 1.206897 4.73103624 Luteitalea sp. TBR-22 2802971 Bacteria Bacteria 209 2.1e-49   NTclustered gi|2131947417|dbj|AP024452.2| 2802971 g21207 i0 81.319 72.8775510204082 273 37 68 12 113 378 3669290 3669025 Vicinamibacteria bacterium TBR-22 DNA, complete genome blastn 28568 209 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp. TBR-22
23804884 23804884 PRJNA874604_P_NODE_83399_length_246_cov_1.248555_g83047_i0 PRJNA874604 83399 246 1.248555 3.0714453 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 54.7 0.006   NTclustered gi|2874253836|emb|OY969886.1| 171953 g83047 i0 96.875 0.130081300813008 32 1 13 0 153 184 2338574 2338543 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
25078437 25078437 PRJNA874604_P_NODE_67820_length_252_cov_1.513966_g67468_i0 PRJNA874604 67820 252 1.513966 3.81519432 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 287 5.75e-73   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g67468 i0 88.285 1.50396825396825 239 28 95 0 9 247 4386668 4386430 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 379 287 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183

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