RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA937226" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA937226 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27341212 27341212 PRJNA937226_S_NODE_25183_length_169_cov_1.166667_g25056_i0 PRJNA937226 25183 169 1.166667 1.97166723 Scylla paramamosain 85552 Arthropoda Arthropoda 41.2 0.0475   NR KAK8382285.1 85552 g25056 i0 57.7 0.461538461538462 26 11 46.2 0 83 6 101 126 KAK8382285.1 hypothetical protein O3P69_015309 [Scylla paramamosain] diamond 78 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
27941084 27941084 PRJNA937226_S_NODE_4565_length_316_cov_1.947566_g4438_i0 PRJNA937226 4565 316 1.947566 6.15430856 Araneus ventricosus 182803 Arthropoda Arthropoda 45.8 0.00209   NR GBN35168.1 182803 g4438 i0 40 0.474683544303797 50 29 46.5 1 154 300 30 79 GBN35168.1 hypothetical protein AVEN_143803-1 [Araneus ventricosus] diamond 150 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28737425 28737425 PRJNA937226_S_NODE_3267_length_355_cov_15.428105_g3140_i0 PRJNA937226 3267 355 15.428105 54.76977275 Metazoa 33208 Arthropoda Arthropoda 49.7 4.36e-4   NR XP_023015979.1 7539 g3140 i0 59 2.29014084507042 39 15 32.1 1 224 111 292 330 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 813 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
29677214 29677214 PRJNA937226_S_NODE_25990_length_167_cov_1.762712_g25863_i0 PRJNA937226 25990 167 1.762712 2.94372904 Frankliniella occidentalis 133901 Arthropoda Arthropoda 100 4.88e-26   NR KAE8739888.1 133901 g25863 i0 98.1 0.970059880239521 54 1 97 0 165 4 51 104 KAE8739888.1 hypothetical protein FOCC_FOCC014612 [Frankliniella occidentalis] diamond 162 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
31636755 31636755 PRJNA937226_S_NODE_14996_length_208_cov_2.823899_g14869_i0 PRJNA937226 14996 208 2.823899 5.87370992 Rhagoletis zephyria 28612 Arthropoda Arthropoda 42.4 0.0322   NR XP_017469695.1 28612 g14869 i0 44.9 0.706730769230769 49 24 66.3 1 154 17 162 210 XP_017469695.1 PREDICTED: uncharacterized protein LOC108361562 [Rhagoletis zephyria] diamond 147 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
32301582 32301582 PRJNA937226_S_NODE_17859_length_194_cov_4.531034_g17732_i0 PRJNA937226 17859 194 4.531034 8.79020596 Periplaneta americana 6978 Arthropoda Arthropoda 43.9 0.00763   NR KAJ4444746.1 6978 g17732 i0 55.6 0.556701030927835 36 16 55.7 0 17 124 373 408 KAJ4444746.1 hypothetical protein ANN_06543 [Periplaneta americana] diamond 108 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana

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