RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA400209" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400209 · 23 ✖

analysis 1

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
2964750 2964750 PRJNA400209_P_NODE_723_length_607_cov_205.972318_g585_i0 PRJNA400209 723 607 205.972318 1250.25197026 Alteromonas macleodii 28108 Bacteria Bacteria 1109 0   NTclustered gi|2321920657|emb|OX359241.1| 28108 g585 i0 100 42.7215815485997 600 0 99 0 8 607 1102973 1102374 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 25932 1109 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
3631799 3631799 PRJNA400209_P_NODE_1423_length_398_cov_1.200542_g1250_i0 PRJNA400209 1423 398 1.200542 4.77815716 Alteromonas 226 Bacteria Bacteria 158 7.85e-34   NTclustered gi|1911976082|gb|CP046142.1| 28108 g1250 i0 100 39.0552763819096 85 0 57 0 235 319 471319 471235 Alteromonas macleodii strain F12 plasmid unnamed2 blastn 15544 158 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
4241073 4241073 PRJNA400209_P_NODE_3204_length_296_cov_14.790262_g3026_i0 PRJNA400209 3204 296 14.790262 43.77917552 Alteromonas macleodii 28108 Bacteria Bacteria 547 2.8799999999999986e-151   NTclustered gi|2321920657|emb|OX359241.1| 28108 g3026 i0 100 35.1858108108108 296 0 100 0 1 296 3409235 3408940 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 10415 547 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
4908975 4908975 PRJNA400209_P_NODE_1404_length_402_cov_1.316354_g1233_i0 PRJNA400209 1404 402 1.316354 5.29174308 Alteromonas 226 Bacteria Bacteria 267 1.26e-66   NTclustered gi|2321920657|emb|OX359241.1| 28108 g1233 i0 100 19.2213930348259 144 0 55 0 259 402 56604 56747 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 7727 267 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
4908978 4908978 PRJNA400209_P_NODE_1824_length_342_cov_4.849840_g1646_i0 PRJNA400209 1824 342 4.84984 16.5864528 Alteromonas 226 Bacteria Bacteria 265 3.81e-66   NTclustered gi|996042317|gb|CP014323.1| 28108 g1646 i0 99.315 30.3099415204678 146 1 66 0 1 146 2085860 2086005 Alteromonas macleodii strain D7 chromosome, complete genome blastn 10366 265 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
6184083 6184083 PRJNA400209_P_NODE_1705_length_357_cov_1.463415_g1527_i0 PRJNA400209 1705 357 1.463415 5.22439155 Alteromonas 226 Bacteria Bacteria 226 1.8799999999999994e-54   NTclustered gi|2256046077|gb|CP098772.1| 28108 g1527 i0 100 11.436974789916 122 0 65 0 236 357 4253370 4253249 Alteromonas macleodii strain QZ9-9 chromosome, complete genome blastn 4083 226 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
8067307 8067307 PRJNA400209_P_NODE_3347_length_206_cov_56.435028_g3169_i0 PRJNA400209 3347 206 56.435028 116.25615768 Alteromonas macleodii 28108 Bacteria Bacteria 379 7.269999999999998e-101   NTclustered gi|2321920657|emb|OX359241.1| 28108 g3169 i0 100 54.9029126213592 205 0 99 0 1 205 12944 12740 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 11310 379 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
8733800 8733800 PRJNA400209_P_NODE_1427_length_396_cov_1.757493_g1254_i0 PRJNA400209 1427 396 1.757493 6.95967228 Alteromonas 226 Bacteria Bacteria 219 3.53e-52   NTclustered gi|996042317|gb|CP014323.1| 28108 g1254 i0 93.289 24.1792929292929 149 3 60 1 248 396 3797574 3797715 Alteromonas macleodii strain D7 chromosome, complete genome blastn 9575 219 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
8733804 8733804 PRJNA400209_P_NODE_1747_length_351_cov_128.024845_g1569_i0 PRJNA400209 1747 351 128.024845 449.36720595 Alteromonas 226 Bacteria Bacteria 649 0   NTclustered gi|996042317|gb|CP014323.1| 28108 g1569 i0 100 98.7663817663818 351 0 100 0 1 351 2054262 2054612 Alteromonas macleodii strain D7 chromosome, complete genome blastn 34667 649 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
10617893 10617893 PRJNA400209_P_NODE_3349_length_200_cov_62.695906_g3171_i0 PRJNA400209 3349 200 62.695906 125.391812 Alteromonas macleodii 28108 Bacteria Bacteria 337 4.28e-88   NTclustered gi|2321920657|emb|OX359241.1| 28108 g3171 i0 100 38.155 182 0 91 0 19 200 4495702 4495883 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 7631 337 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
11284284 11284284 PRJNA400209_P_NODE_1389_length_404_cov_2.000000_g1218_i0 PRJNA400209 1389 404 2 8.08 Alteromonas 226 Bacteria Bacteria 163 1.7199999999999998e-35   NTclustered gi|996042317|gb|CP014323.1| 28108 g1218 i0 100 25.9059405940594 88 0 55 0 317 404 3430456 3430543 Alteromonas macleodii strain D7 chromosome, complete genome blastn 10466 163 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
12559685 12559685 PRJNA400209_P_NODE_3370_length_152_cov_2.235772_g3192_i0 PRJNA400209 3370 152 2.235772 3.39837344 Psychrobacter 497 Bacteria Bacteria 265 1.47e-66   NTclustered gi|307335075|gb|HM236417.1| 180588 g3192 i0 98.026 321.960526315789 152 3 100 0 1 152 845 694 Psychrobacter faecalis strain DSM 14664 23S ribosomal RNA gene, partial sequence blastn 48938 265 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter faecalis
13167753 13167753 PRJNA400209_P_NODE_1431_length_395_cov_1.967213_g1258_i0 PRJNA400209 1431 395 1.967213 7.77049135 Alteromonas macleodii 28108 Bacteria Bacteria 311 5.65e-80   NTclustered gi|2321920657|emb|OX359241.1| 28108 g1258 i0 97.312 28.6987341772152 186 0 68 1 10 190 3021817 3022002 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 11336 311 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
16383377 16383377 PRJNA400209_P_NODE_1593_length_371_cov_28.178363_g1416_i0 PRJNA400209 1593 371 28.178363 104.54172673 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 237 9.07e-58   NTclustered gi|1821599135|gb|MT210812.1| 232 g1416 i0 99.237 80.0134770889488 131 1 47 0 241 371 1499 1369 Alteromonas sp. strain 116.6 16S ribosomal RNA gene, partial sequence blastn 29685 237 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas sp.
16383382 16383382 PRJNA400209_P_NODE_2013_length_329_cov_1.103333_g1835_i0 PRJNA400209 2013 329 1.103333 3.62996557 Moraxellaceae 468 Bacteria Bacteria 165 3.81e-36   NTclustered gi|2324932141|gb|CP087796.1| 476 g1835 i0 100 156.237082066869 89 0 46 0 241 329 59177 59089 Moraxella bovis strain SAM57957 chromosome, complete genome blastn 51402 165 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Moraxella Moraxella bovis
18265605 18265605 PRJNA400209_P_NODE_3335_length_222_cov_2.067358_g3157_i0 PRJNA400209 3335 222 2.067358 4.58953476 Alteromonas macleodii 28108 Bacteria Bacteria 411 2.8199999999999996e-110   NTclustered gi|2321920657|emb|OX359241.1| 28108 g3157 i0 100 43.5225225225225 222 0 100 0 1 222 1861188 1860967 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 9662 411 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
18265606 18265606 PRJNA400209_P_NODE_3355_length_192_cov_14.687117_g3177_i0 PRJNA400209 3355 192 14.687117 28.19926464 Alteromonas macleodii 28108 Bacteria Bacteria 355 1.13e-93   NTclustered gi|2321920657|emb|OX359241.1| 28108 g3177 i0 100 44.359375 192 0 100 0 1 192 4050277 4050468 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 8517 355 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
18932487 18932487 PRJNA400209_P_NODE_1755_length_350_cov_89.043614_g1577_i0 PRJNA400209 1755 350 89.043614 311.652649 Alteromonas 226 Bacteria Bacteria 647 0   NTclustered gi|996042317|gb|CP014323.1| 28108 g1577 i0 100 97.72 350 0 100 0 1 350 867915 867566 Alteromonas macleodii strain D7 chromosome, complete genome blastn 34202 647 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
19539744 19539744 PRJNA400209_P_NODE_1176_length_474_cov_0.826966_g1016_i0 PRJNA400209 1176 474 0.826966 3.91981884 Nevskia ramosa 64002 Bacteria Bacteria 128 7.45e-25   NTclustered gi|1004607053|gb|KT865761.1| 64002 g1016 i0 98.63 21.57805907173 73 0 27 1 1 72 2514 2586 Nevskia ramosa strain DSM 11499 23S ribosomal RNA gene, partial sequence blastn 10228 128 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Nevskia Nevskia ramosa
19539767 19539767 PRJNA400209_P_NODE_436_length_765_cov_1.979620_g332_i0 PRJNA400209 436 765 1.97962 15.144093 Alteromonas macleodii 28108 Bacteria Bacteria 634 5.989999999999999e-177   NTclustered gi|2321920657|emb|OX359241.1| 28108 g332 i0 100 17.281045751634 343 0 63 0 250 592 789066 788724 Alteromonas macleodii isolate Alteromonas macleodii MIT1002 genome assembly, chromosome: cMIT1002 blastn 13220 634 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
22757939 22757939 PRJNA400209_P_NODE_3278_length_292_cov_7.186312_g3100_i0 PRJNA400209 3278 292 7.186312 20.98403104 Alteromonas 226 Bacteria Bacteria 538 1.6999999999999994e-148   NTclustered gi|996042317|gb|CP014323.1| 28108 g3100 i0 100 61.1164383561644 291 0 99 0 1 291 2332546 2332836 Alteromonas macleodii strain D7 chromosome, complete genome blastn 17846 538 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
22757940 22757940 PRJNA400209_P_NODE_638_length_641_cov_0.998366_g505_i0 PRJNA400209 638 641 0.998366 6.39952606 Alteromonas 226 Bacteria Bacteria 195 1e-44   NTclustered gi|2321924787|emb|OX359243.1| 28108 g505 i0 100 13.9017160686427 105 0 47 0 296 400 57690 57586 Alteromonas macleodii isolate Alteromonas macleodii BGP9 genome assembly, chromosome: cBGP9 blastn 8911 195 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii
25307137 25307137 PRJNA400209_P_NODE_1540_length_380_cov_2.054131_g1364_i0 PRJNA400209 1540 380 2.054131 7.8056978 Alteromonas 226 Bacteria Bacteria 147 1.62e-30   NTclustered gi|2256046077|gb|CP098772.1| 28108 g1364 i0 100 13.95 79 0 51 0 243 321 3555647 3555569 Alteromonas macleodii strain QZ9-9 chromosome, complete genome blastn 5301 147 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas macleodii

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