RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA312899 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1065152 1065152 PRJNA312899_P_NODE_92021_length_165_cov_0.879310_g91579_i0 PRJNA312899 92021 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 300 4.46e-77   NTclustered gi|18147017|dbj|AB047764.1| 6306 g91579 i0 99.394 30.0787878787879 165 1 100 0 1 165 1297 1133 Meloidogyne incognita DNA, polymorphic marker for virulence, isolate:MIGD-VI blastn 4963 300 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne incognita
9307144 9307144 PRJNA312899_P_NODE_18868_length_434_cov_53.031169_g18427_i0 PRJNA312899 18868 434 53.031169 230.15527346 Oigolaimella attenuata 669116 Nematoda Nematoda 309 2.25e-79   NTclustered gi|256709322|gb|GQ422336.1| 669116 g18427 i0 83.483 45.3732718894009 333 53 76 2 87 418 373 42 Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds blastn 19692 309 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Diplogasteridae Oigolaimella Oigolaimella attenuata
22056051 22056051 PRJNA312899_P_NODE_42678_length_271_cov_10.099099_g42236_i0 PRJNA312899 42678 271 10.099099 27.36855829 Longidorus macrosoma 188093 Nematoda Nematoda 401 2.1399999999999994e-107   NTclustered gi|49339465|gb|AY580055.1| 188093 g42236 i0 93.165 5.53505535055351 278 12 100 4 1 271 1911 2188 Longidorus macrosoma 28S ribosomal RNA gene, 28S-18S intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence blastn 1500 401 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Dorylaimida Longidoridae Longidorus Longidorus macrosoma
23332287 23332287 PRJNA312899_P_NODE_82299_length_174_cov_2.432000_g81857_i0 PRJNA312899 82299 174 2.432 4.23168 Caenorhabditis elegans 6239 Nematoda Nematoda 75 3.12e-9   NTclustered gi|687867785|emb|LK929889.1| 6239 g81857 i0 97.674 2.18965517241379 43 1 25 0 1 43 1252 1210 Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0001390 blastn 381 75 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);;