RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond" and tax_clade = "CRuMs"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • CRuMs · 14 ✖

analysis 1

  • diamond · 14 ✖

tax_phylum 0

tax_kingdom 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
2896505 2896505 PRJNA1237347_P_NODE_5963_length_3189_cov_8.916881_g5127_i0 PRJNA1237347 5963 3189 8.916881 284.35933509 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 2.4200000000000008e-59   NR YP_009245594.1 190327 g5127 i0 47.6 0.473189087488241 252 116 23.6 4 843 91 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
5442257 5442257 PRJNA1237347_P_NODE_21885_length_1686_cov_8.623063_g5127_i2 PRJNA1237347 21885 1686 8.623063 145.38484218 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 4.3999999999999995e-62   NR YP_009245594.1 190327 g5127 i2 47.6 0.895017793594306 252 116 44.7 4 84 836 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
6751080 6751080 PRJNA293022_P_NODE_69206_length_168_cov_0.873950_g68469_i0 PRJNA293022 69206 168 0.87395 1.468236 Diphylleia rotans 190327 Root_unresolved Root_unresolved 79 5.23e-16   NR YP_009245594.1 190327 g68469 i0 72.9 2.66071428571429 48 13 85.7 0 19 162 157 204 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 447 79 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
7778046 7778046 PRJEB6055_S_NODE_547_length_328_cov_13.105802_g523_i0 PRJEB6055 547 328 13.105802 42.98703056 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 147 7.78e-40   NR BAN33725.1 856889 g523 i0 75.3 7.52743902439024 93 23 85.1 0 325 47 345 437 BAN33725.1 elongation factor 1alpha [Mantamonas plastica] diamond 2469 148 0.993243243243243 Eukaryota CRuMs         Mantamonadidae Mantamonas Mantamonas plastica
9270714 9270714 PRJNA1237347_P_NODE_40548_length_1197_cov_9.782918_g5127_i3 PRJNA1237347 40548 1197 9.782918 117.10152846 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 7.05e-64   NR YP_009245594.1 190327 g5127 i3 47.6 1.26065162907268 252 116 62.9 4 843 91 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
15358235 15358235 PRJEB3181_S_NODE_2973_length_324_cov_2401.508651_g2680_i0 PRJEB3181 2973 324 2401.508651 7780.88802924 Mantamonas plastica 856889 Root_unresolved Root_unresolved 115 1.14e-27   NR BAN33725.1 856889 g2680 i0 71.8 7.08333333333333 78 22 72.2 0 1 234 360 437 BAN33725.1 elongation factor 1alpha [Mantamonas plastica] diamond 2295 115 1 Eukaryota CRuMs         Mantamonadidae Mantamonas Mantamonas plastica
17135327 17135327 PRJNA565584_P_NODE_80614_length_331_cov_1.624031_g79463_i0 PRJNA565584 80614 331 1.624031 5.37554261 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 173 4.54e-48   NR YP_009245626.1 190327 g79463 i0 70.9 63.8066465256798 110 32 99.7 0 1 330 127 236 YP_009245626.1 NADH dehydrogenase subunit 11 [Diphylleia rotans] diamond 21120 173 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
17981188 17981188 PRJEB64798_P_NODE_80875_length_214_cov_6.509091_g79109_i0 PRJEB64798 80875 214 6.509091 13.92945474 Diphylleia rotans 190327 Root_unresolved Root_unresolved 60.8 9.75e-10   NR YP_009245588.1 190327 g79109 i0 81.8 1.4018691588785 33 6 46.3 0 102 4 92 124 YP_009245588.1 ribosomal protein S12 [Diphylleia rotans] diamond 300 60.8 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
19462994 19462994 PRJNA1237347_P_NODE_13056_length_2199_cov_9.753057_g5127_i1 PRJNA1237347 13056 2199 9.753057 214.46972343 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 1.0699999999999999e-60   NR YP_009245594.1 190327 g5127 i1 47.6 0.686221009549795 252 116 34.2 4 2116 1364 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
24568704 24568704 PRJNA1237347_P_NODE_399540_length_280_cov_1.115942_g392967_i0 PRJNA1237347 399540 280 1.115942 3.1246376 Diphylleia rotans 190327 Root_unresolved Root_unresolved 116 6.71e-30   NR YP_009245594.1 190327 g392967 i0 65.2 0.953571428571429 89 27 95.4 1 13 279 129 213 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 267 116 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
30434561 30434561 PRJNA857143_S_NODE_173513_length_251_cov_1.252809_g172420_i0 PRJNA857143 173513 251 1.252809 3.14455059 Diphylleia rotans 190327 Root_unresolved Root_unresolved 79 7.31e-15   NR YP_009245579.1 190327 g172420 i0 43 1.02788844621514 86 41 93.2 1 234 1 505 590 YP_009245579.1 NADH dehydrogenase subunit 5 [Diphylleia rotans] diamond 258 79 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
31598961 31598961 PRJNA674048_P_NODE_27956_length_168_cov_0.873950_g27753_i0 PRJNA674048 27956 168 0.87395 1.468236 Diphylleia rotans 190327 Root_unresolved Root_unresolved 53.1 2.81e-6   NR YP_009245583.1 190327 g27753 i0 56.4 0.696428571428571 39 17 69.6 0 167 51 468 506 YP_009245583.1 cytochrome c oxydase subunit 1 [Diphylleia rotans] diamond 117 53.1 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
32122888 32122888 PRJNA1112809_P_NODE_45418_length_584_cov_2.103718_g42177_i0 PRJNA1112809 45418 584 2.103718 12.28571312 Diphylleia rotans 190327 Root_unresolved Root_unresolved 113 7.57e-26   NR YP_009245621.1 190327 g42177 i0 82 1.88013698630137 61 11 31.3 0 583 401 338 398 YP_009245621.1 NADH dehydrogenase subunit 7 [Diphylleia rotans] diamond 1098 113 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
32239222 32239222 PRJNA975724_S_NODE_76918_length_253_cov_1.250000_g76737_i0 PRJNA975724 76918 253 1.25 3.1625 Diphylleia rotans 190327 Root_unresolved Root_unresolved 121 1.3e-30   NR YP_009245621.1 190327 g76737 i0 80.6 5.56126482213439 67 13 79.4 0 4 204 332 398 YP_009245621.1 NADH dehydrogenase subunit 7 [Diphylleia rotans] diamond 1407 121 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans

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