RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA591000 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
14593766 14593766 PRJNA591000_P_NODE_11292_length_426_cov_1.566751_g9714_i0 PRJNA591000 11292 426 1.566751 6.67435926 Actinomycetota bacterium 2900548 Bacteria Bacteria 90.1 3.48e-18   NR NCZ93813.1 2900548 g9714 i0 40.1 1 142 59 99.3 3 2 424 21 137 NCZ93813.1 hypothetical protein [Actinomycetota bacterium] diamond 426 90.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26921496 26921496 PRJNA591000_P_NODE_6022_length_585_cov_3.645683_g4756_i0 PRJNA591000 6022 585 3.645683 21.32724555 Collinsella tanakaei 626935 Bacteria Bacteria 157 2.0099999999999997e-46   NR WP_204568384.1 626935 g4756 i0 97.4 0.4 78 2 40 0 344 111 1 78 WP_204568384.1 hypothetical protein, partial [Collinsella tanakaei] diamond 234 157 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Coriobacteriaceae Collinsella Collinsella tanakaei
27111141 27111141 PRJNA591000_P_NODE_5782_length_601_cov_3.741259_g4553_i0 PRJNA591000 5782 601 3.741259 22.48496659 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 89.4 2.3e-19   NR HWI02368.1 2201156 g4553 i0 56.7 0.484193011647255 97 41 48.4 1 78 368 3 98 HWI02368.1 TetR family transcriptional regulator [Acidimicrobiales bacterium] diamond 291 89.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
27269289 27269289 PRJNA591000_P_NODE_11363_length_425_cov_1.676768_g9785_i0 PRJNA591000 11363 425 1.676768 7.126264 Actinomycetes bacterium 1883427 Bacteria Bacteria 54.3 2.26e-5   NR HUV48224.1 1883427 g9785 i0 58.5 0.585882352941177 41 17 28.9 0 283 405 60 100 HUV48224.1 hypothetical protein [Actinomycetes bacterium] diamond 249 54.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
28058764 28058764 PRJNA591000_P_NODE_10205_length_442_cov_1.016949_g8638_i0 PRJNA591000 10205 442 1.016949 4.49491458 Rubrobacter calidifluminis 1392640 Bacteria Bacteria 44.3 0.0488   NR WP_273845372.1 1392640 g8638 i0 55.8 0.29185520361991 43 18 28.5 1 2 127 115 157 WP_273845372.1 HNH endonuclease [Rubrobacter calidifluminis] diamond 129 44.3 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae Rubrobacter Rubrobacter calidifluminis
28153743 28153743 PRJNA591000_P_NODE_14725_length_385_cov_1.196629_g13123_i0 PRJNA591000 14725 385 1.196629 4.60702165 Actinomycetota bacterium 2900548 Bacteria Bacteria 55.5 3.46e-7   NR NBR99991.1 2900548 g13123 i0 68.6 0.545454545454545 35 11 27.3 0 105 1 12 46 NBR99991.1 hypothetical protein [Actinomycetota bacterium] diamond 210 55.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28279621 28279621 PRJNA591000_P_NODE_26_length_2586_cov_29.072741_g17_i0 PRJNA591000 26 2586 29.072741 751.82108226 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 196 5.409999999999998e-55   NR MBV5322740.1 2497619 g17 i0 68.3 0.142691415313225 123 39 14.3 0 15 383 1 123 MBV5322740.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 369 196 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
28374474 28374474 PRJNA591000_P_NODE_10306_length_440_cov_1.644769_g8736_i0 PRJNA591000 10306 440 1.644769 7.2369836 Nonomuraea sp. NPDC 1883105 Bacteria Bacteria 46.2 0.014   NR WP_357654825.1 3154630 g8736 i0 48.3 0.395454545454545 58 29 38.9 1 171 1 133 190 WP_357654825.1 GIY-YIG nuclease family protein [Nonomuraea sp. NPDC050680] diamond 174 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC050680
29100828 29100828 PRJNA591000_P_NODE_1348_length_1033_cov_6.356574_g953_i0 PRJNA591000 1348 1033 6.356574 65.66340942 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 189 7.94e-52   NR MBF6557027.1 2201156 g953 i0 58.2 0.458857696030978 158 64 45.6 2 962 492 110 266 MBF6557027.1 terminase [Acidimicrobiales bacterium] diamond 474 189 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29100829 29100829 PRJNA591000_P_NODE_15488_length_307_cov_4.705036_g13882_i0 PRJNA591000 15488 307 4.705036 14.44446052 Actinomycetota bacterium 2900548 Bacteria Bacteria 47.8 0.00107   NR MEW6635344.1 2900548 g13882 i0 40.4 0.45928338762215 47 28 45.9 0 157 17 187 233 MEW6635344.1 hypothetical protein [Actinomycetota bacterium] diamond 141 47.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29195617 29195617 PRJNA591000_P_NODE_7689_length_502_cov_10.355180_g6206_i0 PRJNA591000 7689 502 10.35518 51.9830036 Actinomycetota bacterium 2900548 Bacteria Bacteria 185 9.03e-51   NR MEY4558069.1 2900548 g6206 i0 58.2 1.96613545816733 165 66 96.8 1 500 15 1378 1542 MEY4558069.1 hypothetical protein [Actinomycetota bacterium] diamond 987 185 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29795218 29795218 PRJNA591000_P_NODE_15871_length_199_cov_3.117647_g14265_i0 PRJNA591000 15871 199 3.117647 6.20411753 Actinomycetota bacterium 2900548 Bacteria Bacteria 92 8.71e-20   NR MTA78424.1 2900548 g14265 i0 70.8 0.979899497487437 65 19 98 0 3 197 402 466 MTA78424.1 phage major capsid protein [Actinomycetota bacterium] diamond 195 92 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30535469 30535469 PRJNA591000_P_NODE_633_length_1304_cov_11.000000_g430_i0 PRJNA591000 633 1304 11 143.44 Mycobacteriales 85007 Bacteria Bacteria 49.3 0.00865   NR WP_304042684.1 1404244 g430 i0 62.9 0.324386503067485 35 13 8.1 0 739 635 4 38 WP_304042684.1 ERF family protein [Corynebacterium glyciniphilum] diamond 423 49.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium glyciniphilum
30585040 30585040 PRJNA591000_P_NODE_11133_length_428_cov_1.689223_g9555_i0 PRJNA591000 11133 428 1.689223 7.22987444 Nocardia jiangxiensis 282685 Bacteria Bacteria 46.2 0.0136   NR WP_387405672.1 282685 g9555 i0 58.3 0.764018691588785 36 15 25.2 0 260 367 236 271 WP_387405672.1 nucleoside hydrolase [Nocardia jiangxiensis] diamond 327 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia jiangxiensis
30616704 30616704 PRJNA591000_P_NODE_7893_length_496_cov_1.342612_g6391_i0 PRJNA591000 7893 496 1.342612 6.65935552 Arthrobacter silvisoli 2291022 Bacteria Bacteria 58.2 1.66e-6   NR WP_115790039.1 2291022 g6391 i0 71.1 0.229838709677419 38 11 23 0 494 381 14 51 WP_115790039.1 phage tail tube protein [Arthrobacter silvisoli] diamond 114 58.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter silvisoli
31027730 31027730 PRJNA591000_P_NODE_13735_length_398_cov_0.970190_g12143_i0 PRJNA591000 13735 398 0.97019 3.8613562 Actinomycetota bacterium 2900548 Bacteria Bacteria 67.4 4.84e-10   NR NBU93425.1 2900548 g12143 i0 96.9 0.241206030150754 32 1 24.1 0 3 98 193 224 NBU93425.1 hypothetical protein [Actinomycetota bacterium] diamond 96 67.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31849655 31849655 PRJNA591000_P_NODE_6237_length_572_cov_1.322284_g4932_i0 PRJNA591000 6237 572 1.322284 7.56346448 Rhodoluna lacicola 529884 Bacteria Bacteria 174 6.48e-50   NR WP_264914073.1 529884 g4932 i0 57.8 2.71678321678322 173 71 89.7 1 2 514 171 343 WP_264914073.1 Gfo/Idh/MocA family protein [Rhodoluna lacicola] diamond 1554 174 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna lacicola
32102810 32102810 PRJNA591000_P_NODE_5678_length_609_cov_1.458621_g4469_i0 PRJNA591000 5678 609 1.458621 8.88300189 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 97.8 1.15e-19   NR MBV5322711.1 2497619 g4469 i0 40 1.91133004926108 185 73 82.3 6 15 515 341 505 MBV5322711.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 1164 97.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
32622265 32622265 PRJNA591000_P_NODE_16260_length_170_cov_1.787234_g14654_i0 PRJNA591000 16260 170 1.787234 3.0382978 Candidatus Planktophila 622681 Bacteria Bacteria 101 1.07e-24   NR MBP6148092.1 2175601 g14654 i0 94.2 4.58823529411765 52 3 91.8 0 170 15 152 203 MBP6148092.1 3-oxoacyl-ACP reductase FabG [Candidatus Planktophila sp.] diamond 780 101 1 Bacteria   Bacillati Actinomycetota Actinomycetes Candidatus Nanopelagicales Candidatus Nanopelagicaceae Candidatus Planktophila Candidatus Planktophila sp.
32671776 32671776 PRJNA591000_P_NODE_1080_length_1111_cov_22.389094_g758_i0 PRJNA591000 1080 1111 22.389094 248.74283434 Mycobacterium tuberculosis 1773 Bacteria Bacteria 72.4 3.72e-11   NR MBX4388563.1 1773 g758 i0 49.2 0.356435643564356 65 33 17.6 0 536 730 97 161 MBX4388563.1 zinc ribbon domain-containing protein [Mycobacterium tuberculosis] diamond 396 72.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis

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