RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939415 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2190512 2190512 PRJNA939415_P_NODE_22542_length_327_cov_4.940945_g22121_i0 PRJNA939415 22542 327 4.940945 16.15689015 Caenorhabditis elegans 6239 Nematoda Nematoda 604 1.8799999999999993e-168   NTclustered gi|413006566|emb|Z92784.2| 6239 g22121 i0 100 86.0366972477064 327 0 100 0 1 327 26611 26937 Caenorhabditis elegans Cosmid F31C3, complete sequence blastn 28134 604 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
3467090 3467090 PRJNA939415_P_NODE_84623_length_250_cov_0.870056_g84201_i0 PRJNA939415 84623 250 0.870056 2.17514 Caenorhabditis elegans 6239 Nematoda Nematoda 451 1.91e-122   NTclustered gi|1972265711|ref|NM_066779.7| 6239 g84201 i0 99.595 3.004 247 1 99 0 1 247 247 1 Caenorhabditis elegans Uncharacterized protein (ZK632.9), mRNA blastn 751 451 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
10185214 10185214 PRJNA939415_P_NODE_44568_length_289_cov_1.902778_g44146_i0 PRJNA939415 44568 289 1.902778 5.49902842 Caenorhabditis 6237 Nematoda Nematoda 534 2.18e-147   NTclustered gi|1279388950|gb|MG551689.1| 6239 g44146 i0 100 101 289 0 100 0 1 289 543 831 Caenorhabditis elegans isolate C.eleg_AM151 small subunit ribosomal RNA gene, partial sequence blastn 29189 534 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
11118654 11118654 PRJNA939415_P_NODE_16509_length_382_cov_11.508091_g16089_i0 PRJNA939415 16509 382 11.508091 43.96090762 Caenorhabditis elegans 6239 Nematoda Nematoda 701 0   NTclustered gi|1879207294|gb|MT797802.1| 6239 g16089 i0 99.738 92.3952879581152 382 1 100 0 1 382 643 262 Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence blastn 35295 701 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
11118768 11118768 PRJNA939415_P_NODE_21789_length_333_cov_4.911538_g21369_i0 PRJNA939415 21789 333 4.911538 16.35542154 Caenorhabditis elegans 6239 Nematoda Nematoda 512 1.2e-140   NTclustered gi|27543236|gb|AY171138.1| 6239 g21369 i0 93.064 103.927927927928 346 11 100 1 1 333 760 1105 Caenorhabditis elegans isolate CB4855 NADH dehydrogenase subunit 6 (ND6) gene, partial cds; NADH dehydrogenase subunit 4L (ND4L) gene, complete cds; tRNA-Trp and tRNA-Glu genes, complete sequence; 12S ribosomal RNA gene, complete sequence; tRNA-Ser, tRNA-Asn, and tRNA-Tyr genes, complete sequence; and NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial genes for mitochondrial products blastn 34608 512 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
11460051 11460051 PRJNA939415_P_NODE_13849_length_416_cov_2.731778_g13430_i0 PRJNA939415 13849 416 2.731778 11.36419648 Caenorhabditis 6237 Nematoda Nematoda 763 0   NTclustered gi|2460759835|gb|OQ645709.1| 6239 g13430 i0 99.76 100.067307692308 416 1 100 0 1 416 5 420 Caenorhabditis elegans strain H60A small subunit ribosomal RNA gene, partial sequence blastn 41628 763 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
13668729 13668729 PRJNA939415_P_NODE_22991_length_323_cov_7.064000_g22570_i0 PRJNA939415 22991 323 7.064 22.81672 Caenorhabditis elegans 6239 Nematoda Nematoda 597 3.11e-166   NTclustered gi|413006566|emb|Z92784.2| 6239 g22570 i0 100 100.938080495356 323 0 100 0 1 323 29430 29108 Caenorhabditis elegans Cosmid F31C3, complete sequence blastn 32603 597 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
13669368 13669368 PRJNA939415_P_NODE_5591_length_817_cov_8.452957_g5196_i0 PRJNA939415 5591 817 8.452957 69.06065869 Caenorhabditis elegans 6239 Nematoda Nematoda 1504 0   NTclustered gi|413006566|emb|Z92784.2| 6239 g5196 i0 99.878 99.7747858017136 817 1 100 0 1 817 28107 28923 Caenorhabditis elegans Cosmid F31C3, complete sequence blastn 81516 1504 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
15284295 15284295 PRJNA939415_P_NODE_28392_length_310_cov_3.628692_g27970_i0 PRJNA939415 28392 310 3.628692 11.2489452 Metazoa 33208 Nematoda Nematoda 169 2.7599999999999997e-37   NTclustered gi|158821894|gb|EU195958.1| 473172 g27970 i0 92.373 36.3225806451613 118 9 38 0 30 147 1892 2009 Protorhabditis sp. JB122 28S ribosomal RNA gene, partial sequence blastn 11260 169 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Protorhabditis Protorhabditis sp. JB122
21658688 21658688 PRJNA939415_P_NODE_35697_length_303_cov_12.060870_g35275_i0 PRJNA939415 35697 303 12.06087 36.5444361 Caenorhabditis 6237 Nematoda Nematoda 560 3.79e-155   NTclustered gi|28396069|gb|AY204194.1| 6239 g35275 i0 100 101.234323432343 303 0 100 0 1 303 585 887 Caenorhabditis elegans clone yk805b2 nuclear receptor (NHR-108) pseudogene mRNA, complete sequence blastn 30674 560 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans

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