RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA560029 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
543982 543982 PRJNA560029_S_NODE_28221_length_266_cov_1.196891_g27997_i0 PRJNA560029 28221 266 1.196891 3.18373006 Pterocles gutturalis 240206 Chordata Chordata 70.9 2.05e-12   NR KFV14947.1 240206 g27997 i0 73.9 2.00751879699248 46 12 51.9 0 129 266 164 209 KFV14947.1 hypothetical protein N339_02630, partial [Pterocles gutturalis] diamond 534 70.9 1 Eukaryota Opisthokonta Metazoa Chordata Aves Pterocliformes Pteroclidae Pterocles Pterocles gutturalis
28058041 28058041 PRJNA560029_S_NODE_21625_length_295_cov_1.387387_g21401_i0 PRJNA560029 21625 295 1.387387 4.09279165 Physeter macrocephalus 9755 Chordata Chordata 48.1 8.44e-4   NR XP_054942793.1 9755 g21401 i0 52 0.508474576271186 50 24 50.8 0 81 230 49 98 XP_054942793.1 LOW QUALITY PROTEIN: ceruloplasmin-like [Physeter macrocephalus] diamond 150 48.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Physeteridae Physeter Physeter macrocephalus
28735177 28735177 PRJNA560029_S_NODE_16647_length_320_cov_5.599190_g16423_i0 PRJNA560029 16647 320 5.59919 17.917407999999998 Mammalia 40674 Chordata Chordata 87.8 1.06e-17   NR XP_038318957.1 9615 g16423 i0 49.4 6.515625 77 39 72.2 0 320 90 355 431 XP_038318957.1 LOW QUALITY PROTEIN: thioredoxin domain-containing protein 5 isoform X1 [Canis lupus familiaris] diamond 2085 87.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Canidae Canis Canis lupus
28861348 28861348 PRJNA560029_S_NODE_35248_length_242_cov_0.875740_g35024_i0 PRJNA560029 35248 242 0.87574 2.1192908 Chordata 7711 Chordata Chordata 124 5.95e-35   NR OCT55195.1 8355 g35024 i0 75 42.6198347107438 80 20 99.2 0 240 1 23 102 OCT55195.1 hypothetical protein XELAEV_18003923mg, partial [Xenopus laevis] diamond 10314 125 0.992 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Pipidae Xenopus Xenopus laevis
29271691 29271691 PRJNA560029_S_NODE_17189_length_317_cov_3.053279_g16965_i0 PRJNA560029 17189 317 3.053279 9.67889443 Ovis 9935 Chordata Chordata 77.4 1.27e-15   NR KAI4531582.1 230172 g16965 i0 83 0.889589905362776 47 8 44.5 0 1 141 84 130 KAI4531582.1 hypothetical protein MG293_018096 [Ovis ammon polii] diamond 282 77.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis ammon
29966672 29966672 PRJNA560029_S_NODE_30871_length_255_cov_3.093407_g30647_i0 PRJNA560029 30871 255 3.093407 7.88818785 Chiroptera 9397 Chordata Chordata 50.1 3.83e-5   NR KAF6447562.1 9407 g30647 i0 46 1.10588235294118 50 27 58.8 0 45 194 24 73 KAF6447562.1 hypothetical protein HJG63_011989 [Rousettus aegyptiacus] diamond 282 50.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Pteropodidae Rousettus Rousettus aegyptiacus
30756530 30756530 PRJNA560029_S_NODE_24174_length_283_cov_2.857143_g23950_i0 PRJNA560029 24174 283 2.857143 8.08571469 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 112 2.7100000000000004e-26   NR CAG5083690.1 34765 g23950 i0 70.4 4.49469964664311 71 21 75.3 0 1 213 689 759 CAG5083690.1 Oidioi.mRNA.OKI2018_I69.PAR.g10437.t1.cds [Oikopleura dioica] diamond 1272 113 0.991150442477876 Eukaryota Opisthokonta Metazoa Chordata Appendicularia Copelata Oikopleuridae Oikopleura Oikopleura dioica
32323967 32323967 PRJNA560029_S_NODE_16479_length_321_cov_4.733871_g16255_i0 PRJNA560029 16479 321 4.733871 15.19572591 Hyperolius riggenbachi 752182 Chordata Chordata 57.4 6.23e-7   NR XP_068111481.1 752182 g16255 i0 70.3 0.345794392523364 37 11 34.6 0 321 211 330 366 XP_068111481.1 adenosine kinase isoform X2 [Hyperolius riggenbachi] diamond 111 57.4 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Hyperoliidae Hyperolius Hyperolius riggenbachi

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