RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax_clade = "CRuMs"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • CRuMs · 14 ✖

bioproject 1

  • PRJNA744060 · 14 ✖

analysis 1

  • blastn · 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
723458 723458 PRJNA744060_P_NODE_43081_length_254_cov_9.558011_g42752_i0 PRJNA744060 43081 254 9.558011 24.27734794 Diphylleia rotans 190327 Root_unresolved Root_unresolved 470 5.37e-128   NTclustered gi|1200177731|gb|MF039365.1| 190327 g42752 i0 100 76.6850393700787 254 0 100 0 1 254 1516 1769 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19478 470 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
7102371 7102371 PRJNA744060_P_NODE_55346_length_201_cov_4.554688_g55017_i0 PRJNA744060 55346 201 4.554688 9.15492288 Diphylleia rotans 190327 Root_unresolved Root_unresolved 364 1.98e-96   NTclustered gi|19682865|gb|AF420478.1| 190327 g55017 i0 99.502 38.8358208955224 201 0 99 1 1 200 1301 1501 Diphylleia rotans small subunit ribosomal RNA gene, partial sequence blastn 7806 364 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
9651753 9651753 PRJNA744060_P_NODE_30728_length_295_cov_4.094595_g30399_i0 PRJNA744060 30728 295 4.094595 12.07905525 Diphylleia rotans 190327 Root_unresolved Root_unresolved 159 1.57e-34   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g30399 i0 85.714 4.07796610169492 154 18 52 4 1 152 53550 53701 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 1203 159 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
9651822 9651822 PRJNA744060_P_NODE_3528_length_830_cov_13.117569_g3254_i0 PRJNA744060 3528 830 13.117569 108.8758227 Diphylleia rotans 190327 Root_unresolved Root_unresolved 1517 0   NTclustered gi|1200177731|gb|MF039365.1| 190327 g3254 i0 99.639 29.7650602409639 830 3 100 0 1 830 5054 4225 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 24705 1517 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
10926860 10926860 PRJNA744060_P_NODE_13069_length_443_cov_12.675676_g12740_i0 PRJNA744060 13069 443 12.675676 56.15324468 Diphylleia rotans 190327 Root_unresolved Root_unresolved 806 0   NTclustered gi|2733486389|gb|PP809657.1| 190327 g12740 i0 99.549 60.6636568848758 443 1 100 1 1 443 1033 592 Diphylleia rotans isolate Col24 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 26874 806 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
12202433 12202433 PRJNA744060_P_NODE_16330_length_398_cov_2.920000_g16001_i0 PRJNA744060 16330 398 2.92 11.6216 Diphylleia rotans 190327 Root_unresolved Root_unresolved 736 0   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g16001 i0 100 12.678391959799 398 0 100 0 1 398 56590 56193 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 5046 736 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
12203121 12203121 PRJNA744060_P_NODE_55490_length_198_cov_4.480000_g55161_i0 PRJNA744060 55490 198 4.48 8.8704 Diphylleia rotans 190327 Root_unresolved Root_unresolved 355 1.17e-93   NTclustered gi|1200177731|gb|MF039365.1| 190327 g55161 i0 98.99 53.3585858585859 198 2 100 0 1 198 4234 4037 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10565 355 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
14752058 14752058 PRJNA744060_P_NODE_22852_length_339_cov_2.206767_g22523_i0 PRJNA744060 22852 339 2.206767 7.48094013 Diphylleia rotans 190327 Root_unresolved Root_unresolved 627 4.1799999999999996e-175   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g22523 i0 100 17.2684365781711 339 0 100 0 1 339 56741 57079 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 5854 627 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
16026202 16026202 PRJNA744060_P_NODE_5013_length_704_cov_6.950872_g4711_i0 PRJNA744060 5013 704 6.950872 48.93413888 Diphylleia rotans 190327 Root_unresolved Root_unresolved 1295 0   NTclustered gi|1200177731|gb|MF039365.1| 190327 g4711 i0 99.858 43.9247159090909 704 1 100 0 1 704 2700 3403 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 30923 1295 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
17301312 17301312 PRJNA744060_P_NODE_26474_length_316_cov_3.691358_g26145_i0 PRJNA744060 26474 316 3.691358 11.66469128 Diphylleia rotans 190327 Root_unresolved Root_unresolved 582 8.489999999999998e-162   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g26145 i0 100 2.20253164556962 315 0 99 0 1 315 29311 29625 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 696 582 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
19850168 19850168 PRJNA744060_P_NODE_23736_length_333_cov_2.100000_g23407_i0 PRJNA744060 23736 333 2.1 6.993 Diphylleia rotans 190327 Root_unresolved Root_unresolved 616 8.87e-172   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g23407 i0 100 440.198198198198 333 0 100 0 1 333 45733 45401 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 146586 616 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
22400736 22400736 PRJNA744060_P_NODE_30558_length_296_cov_2.242152_g30229_i0 PRJNA744060 30558 296 2.242152 6.63676992 Diphylleia rotans 190327 Root_unresolved Root_unresolved 547 2.8799999999999986e-151   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g30229 i0 100 78.3006756756757 296 0 100 0 1 296 17055 17350 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 23177 547 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
23676543 23676543 PRJNA744060_P_NODE_4499_length_742_cov_4.139013_g4203_i0 PRJNA744060 4499 742 4.139013 30.71147646 Diphylleia rotans 190327 Root_unresolved Root_unresolved 1365 0   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g4203 i0 99.865 42.9986522911051 742 1 100 0 1 742 17104 16363 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 31905 1365 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
24949650 24949650 PRJNA744060_P_NODE_23440_length_335_cov_1.801527_g23111_i0 PRJNA744060 23440 335 1.801527 6.03511545 Diphylleia rotans 190327 Root_unresolved Root_unresolved 619 6.91e-173   NTclustered gi|1016881912|ref|NC_029886.1| 190327 g23111 i0 100 100.44776119403 335 0 100 0 1 335 45807 46141 Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome blastn 33650 619 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);;