RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond" and bioproject = "PRJNA715461"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 4

tax_superkingdom 3

tax_clade 2

bioproject 1

  • PRJNA715461 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
26608497 26608497 PRJNA715461_S_NODE_241_length_557_cov_22.675620_g186_i0 PRJNA715461 241 557 22.67562 126.3032034 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 45.4 0.0235   NR WP_395514416.1 251699 g186 i0 48.3 0.47935368043088 89 18 43.6 7 89 331 16 84 WP_395514416.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 267 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27146282 27146282 PRJNA715461_S_NODE_42_length_1011_cov_101.067164_g3_i1 PRJNA715461 42 1011 101.067164 1021.78902804 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.0222   NR WP_395514389.1 251699 g3 i1 41.5 0.364985163204748 123 58 33.5 4 213 551 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27241493 27241493 PRJNA715461_S_NODE_43_length_1010_cov_95.964781_g3_i2 PRJNA715461 43 1010 95.964781 969.2442881 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.0222   NR WP_395514389.1 251699 g3 i2 41.5 0.365346534653465 123 58 33.6 4 212 550 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27652335 27652335 PRJNA715461_S_NODE_4_length_1610_cov_61.886792_g3_i0 PRJNA715461 4 1610 61.886792 996.3773512 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 50.1 0.0128   NR WP_395585354.1 251699 g3 i0 40.6 0.37639751552795 202 76 31.9 15 662 1174 53 241 WP_395585354.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 606 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27684110 27684110 PRJNA715461_S_NODE_44_length_1010_cov_95.080043_g3_i3 PRJNA715461 44 1010 95.080043 960.3084343 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 48.5 0.00896   NR WP_395514389.1 251699 g3 i3 41.5 0.365346534653465 123 58 33.6 4 212 550 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27715726 27715726 PRJNA715461_S_NODE_1124_length_236_cov_2.368098_g1050_i0 PRJNA715461 1124 236 2.368098 5.58871128 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42.4 0.0444   NR WP_395585825.1 251699 g1050 i0 52.5 0.775423728813559 61 13 57.2 4 16 150 6 66 WP_395585825.1 hypothetical protein [Pseudomonas syringae group genomosp. 7] diamond 183 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28157625 28157625 PRJNA715461_S_NODE_45_length_1009_cov_106.264957_g3_i4 PRJNA715461 45 1009 106.264957 1072.21341613 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.0222   NR WP_395514389.1 251699 g3 i4 40.7 0.365708622398414 123 59 33.6 4 211 549 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28251984 28251984 PRJNA715461_S_NODE_46_length_1008_cov_96.957219_g3_i5 PRJNA715461 46 1008 96.957219 977.32876752 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.0221   NR WP_395514389.1 251699 g3 i5 40.7 0.366071428571429 123 59 33.6 4 210 548 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28283401 28283401 PRJNA715461_S_NODE_86_length_887_cov_10.504914_g50_i0 PRJNA715461 86 887 10.504914 93.17858718 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 50.4 0.00107   NR WP_395587487.1 251699 g50 i0 43.1 0.344983089064262 102 38 32.5 7 466 179 65 152 WP_395587487.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 306 50.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28536474 28536474 PRJNA715461_S_NODE_47_length_1005_cov_110.755365_g3_i6 PRJNA715461 47 1005 110.755365 1113.09141825 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.022   NR WP_395514389.1 251699 g3 i6 40.7 0.958208955223881 123 59 33.7 4 207 545 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 963 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28599558 28599558 PRJNA715461_S_NODE_647_length_327_cov_3.787402_g573_i0 PRJNA715461 647 327 3.787402 12.38480454 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 44.3 0.0196   NR WP_395588025.1 251699 g573 i0 47.4 0.715596330275229 78 24 58.7 6 322 131 8 82 WP_395588025.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 234 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28883480 28883480 PRJNA715461_S_NODE_1008_length_248_cov_2.594286_g934_i0 PRJNA715461 1008 248 2.594286 6.43382928 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 67.4 6.94e-11   NR WCF05138.1 6161 g934 i0 67.3 0.592741935483871 49 16 59.3 0 244 98 186 234 WCF05138.1 WTAP [Dugesia japonica] diamond 147 67.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
29167930 29167930 PRJNA715461_S_NODE_629_length_333_cov_1.015385_g555_i0 PRJNA715461 629 333 1.015385 3.38123205 ssRNA phage SRR7473382_3 2786628 Viruses Viruses 61.6 2.69e-9   NR YP_010769287.1 2786628 g555 i0 50.8 1.0990990990991 61 30 55 0 331 149 81 141 YP_010769287.1 coat protein [ssRNA phage SRR7473382_3] diamond 366 61.6 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Darnbovirus Darnbovirus asiadaptatum
29462148 29462148 PRJNA715461_S_NODE_910_length_263_cov_1.378947_g836_i0 PRJNA715461 910 263 1.378947 3.62663061 Fungi 4751 Fungi Fungi 70.5 4.09e-13   NR KAI8325436.1 61414 g836 i0 70.8 4.3574144486692 48 14 54.8 0 4 147 88 135 KAI8325436.1 hypothetical protein GQ54DRAFT_315690 [Martensiomyces pterosporus] diamond 1146 70.5 1 Eukaryota Opisthokonta Fungi Zoopagomycota Kickxellomycetes Kickxellales Kickxellaceae Martensiomyces Martensiomyces pterosporus
29830726 29830726 PRJNA715461_S_NODE_1011_length_248_cov_0.914286_g937_i0 PRJNA715461 1011 248 0.914286 2.26742928 Cavenderia fasciculata 261658 Evosea other_Eukaryota 50.4 6.91e-5   NR XP_004352170.1 261658 g937 i0 62.9 0.423387096774194 35 13 42.3 0 243 139 54 88 XP_004352170.1 BCAP29/BCAP31 family protein [Cavenderia fasciculata] diamond 105 50.4 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Cavenderiaceae Cavenderia Cavenderia fasciculata
29957074 29957074 PRJNA715461_S_NODE_1091_length_241_cov_0.904762_g1017_i0 PRJNA715461 1091 241 0.904762 2.18047642 Galdieria yellowstonensis 3028027 Rhodophyta other_Eukaryota 80.1 1.96e-15   NR KAK4526145.1 3028027 g1017 i0 43.9 2.04149377593361 82 43 98.3 1 237 1 313 394 KAK4526145.1 hypothetical protein GAYE_SCF20G4059 [Galdieria yellowstonensis] diamond 492 80.1 1 Eukaryota     Rhodophyta Bangiophyceae Galdieriales Galdieriaceae Galdieria Galdieria yellowstonensis
30020497 30020497 PRJNA715461_S_NODE_51_length_983_cov_101.438462_g3_i8 PRJNA715461 51 983 101.438462 997.14008146 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.8 0.0158   NR WP_395514389.1 251699 g3 i8 39 0.485249237029502 159 81 44.9 6 83 523 2 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 477 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30083340 30083340 PRJNA715461_S_NODE_52_length_982_cov_104.408141_g3_i9 PRJNA715461 52 982 104.408141 1025.28794462 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 46.6 0.0391   NR WP_395514389.1 251699 g3 i9 42.3 0.375763747454175 123 57 34.5 4 184 522 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30209630 30209630 PRJNA715461_S_NODE_292_length_514_cov_7.020408_g227_i0 PRJNA715461 292 514 7.020408 36.08489712 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 48.9 0.00156   NR WP_395569021.1 251699 g227 i0 36.5 0.863813229571984 148 41 63 7 406 83 4 138 WP_395569021.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 444 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30494349 30494349 PRJNA715461_S_NODE_1193_length_229_cov_28.115385_g1119_i0 PRJNA715461 1193 229 28.115385 64.38423165 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 43.5 0.00448   NR WP_395588448.1 251699 g1119 i0 46.8 0.812227074235808 62 22 81.2 3 8 193 2 52 WP_395588448.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 186 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30525777 30525777 PRJNA715461_S_NODE_53_length_978_cov_100.122652_g3_i10 PRJNA715461 53 978 100.122652 979.19953656 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 43.9 0.0406   NR WP_395588968.1 251699 g3 i10 43.4 0.254601226993865 83 23 24.5 6 174 413 4 65 WP_395588968.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 249 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31031628 31031628 PRJNA715461_S_NODE_55_length_977_cov_101.570796_g3_i12 PRJNA715461 55 977 101.570796 992.34667692 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 48.5 0.00852   NR WP_395514389.1 251699 g3 i12 41.5 0.377686796315251 123 58 34.7 4 179 517 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31821785 31821785 PRJNA715461_S_NODE_57_length_976_cov_105.656700_g3_i14 PRJNA715461 57 976 105.6567 1031.209392 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.4 0.0211   NR WP_395514389.1 251699 g3 i14 40.7 0.378073770491803 123 59 34.7 4 178 516 38 156 WP_395514389.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 369 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31948380 31948380 PRJNA715461_S_NODE_377_length_445_cov_10.198925_g303_i0 PRJNA715461 377 445 10.198925 45.38521625 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 44.7 0.00944   NR WP_395588048.1 251699 g303 i0 40.5 0.782022471910112 116 19 66.7 8 94 390 9 91 WP_395588048.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 348 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7

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