RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB83101" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB83101 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
9069058 9069058 PRJEB83101_P_NODE_34928_length_313_cov_1.908333_g34623_i0 PRJEB83101 34928 313 1.908333 5.97308229 Agamidae 81953 Chordata Chordata 187 1.7299999999999996e-55   NR XP_020669830.1 103695 g34623 i0 84.6 1.99361022364217 104 16 99.7 0 312 1 89 192 XP_020669830.1 zona pellucida sperm-binding protein 3-like [Pogona vitticeps] diamond 624 187 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Pogona Pogona vitticeps
9070098 9070098 PRJEB83101_P_NODE_73688_length_248_cov_1.777143_g73383_i0 PRJEB83101 73688 248 1.777143 4.40731464 Pogona vitticeps 103695 Chordata Chordata 144 1.63e-39   NR XP_020658093.1 103695 g73383 i0 85.4 0.991935483870968 82 12 99.2 0 1 246 298 379 XP_020658093.1 glycosylated lysosomal membrane protein [Pogona vitticeps] diamond 246 144 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Pogona Pogona vitticeps
27152956 27152956 PRJEB83101_P_NODE_89142_length_232_cov_3.616352_g88837_i0 PRJEB83101 89142 232 3.616352 8.38993664 Muridae 10066 Chordata Chordata 42.4 0.0437   NR NP_081292.1 10090 g88837 i0 94.4 1.83620689655172 71 4 91.8 0 232 20 96 166 NP_081292.1 translocation protein SEC62 isoform 2 [Mus musculus] diamond 426 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
27539977 27539977 PRJEB83101_P_NODE_83664_length_243_cov_1.182353_g83359_i0 PRJEB83101 83664 243 1.182353 2.87311779 Phrynocephalus forsythii 171643 Chordata Chordata 72 1.67e-12   NR KAJ7317650.1 171643 g83359 i0 70.7 1.01234567901235 82 11 98.8 2 242 3 17 87 KAJ7317650.1 hypothetical protein JRQ81_003812 [Phrynocephalus forsythii] diamond 246 72 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Phrynocephalus Phrynocephalus forsythii
29371260 29371260 PRJEB83101_P_NODE_47909_length_280_cov_0.893720_g47604_i0 PRJEB83101 47909 280 0.89372 2.502416 Bos indicus 9915 Chordata Chordata 54.3 4.82e-6   NR XP_070626341.1 9915 g47604 i0 93.5 0.332142857142857 31 2 33.2 0 3 95 545 575 XP_070626341.1 collagen alpha-1(I) chain-like [Bos indicus] diamond 93 54.3 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos indicus
29402716 29402716 PRJEB83101_P_NODE_13609_length_517_cov_0.860360_g13312_i0 PRJEB83101 13609 517 0.86036 4.4480612 Hemidactylus mandebensis 1643449 Chordata Chordata 179 1.36e-53   NR YP_010485136.1 1643449 g13312 i0 72.1 3.29013539651838 140 39 81.2 0 422 3 74 213 YP_010485136.1 ATP synthase F0 subunit 6 [Hemidactylus mandebensis] diamond 1701 179 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Gekkonidae Hemidactylus Hemidactylus mandebensis
29623259 29623259 PRJEB83101_P_NODE_63090_length_255_cov_2.005495_g62785_i0 PRJEB83101 63090 255 2.005495 5.11401225 Phrynocephalus forsythii 171643 Chordata Chordata 86.7 9.01e-18   NR KAJ7311176.1 171643 g62785 i0 68.3 0.741176470588235 63 20 74.1 0 194 6 290 352 KAJ7311176.1 hypothetical protein JRQ81_006783 [Phrynocephalus forsythii] diamond 189 86.7 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Phrynocephalus Phrynocephalus forsythii
30287498 30287498 PRJEB83101_P_NODE_81712_length_244_cov_1.192982_g81407_i0 PRJEB83101 81712 244 1.192982 2.91087608 Phrynocephalus forsythii 171643 Chordata Chordata 138 8.62e-37   NR KAJ7310384.1 171643 g81407 i0 71.6 0.995901639344262 81 23 99.6 0 2 244 2 82 KAJ7310384.1 hypothetical protein JRQ81_007297 [Phrynocephalus forsythii] diamond 243 138 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Phrynocephalus Phrynocephalus forsythii
31867443 31867443 PRJEB83101_P_NODE_65277_length_253_cov_0.866667_g64972_i0 PRJEB83101 65277 253 0.866667 2.19266751 Rousettus aegyptiacus 9407 Chordata Chordata 42 0.0385   NR KAF6447834.1 9407 g64972 i0 56.8 0.438735177865613 37 14 41.5 1 152 48 106 142 KAF6447834.1 hypothetical protein HJG63_012168 [Rousettus aegyptiacus] diamond 111 42 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Pteropodidae Rousettus Rousettus aegyptiacus
32113468 32113468 PRJEB83101_P_NODE_85938_length_242_cov_0.923077_g85633_i0 PRJEB83101 85938 242 0.923077 2.23384634 Testudines 8459 Chordata Chordata 84.7 5.3e-17   NR CAM4422698.1 8472 g85633 i0 59.2 5.60330578512397 76 30 94.2 1 15 242 301 375 CAM4422698.1 unnamed protein product [Lepidochelys kempii] diamond 1356 84.7 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Cheloniidae Lepidochelys Lepidochelys kempii
32152396 32152396 PRJEB83101_P_NODE_29698_length_337_cov_3.678030_g29393_i0 PRJEB83101 29698 337 3.67803 12.3949611 Phrynocephalus forsythii 171643 Chordata Chordata 172 6.74e-53   NR KAJ7313365.1 171643 g29393 i0 77.9 2.01186943620178 113 24 99.7 1 2 337 13 125 KAJ7313365.1 hypothetical protein JRQ81_004662 [Phrynocephalus forsythii] diamond 678 172 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Phrynocephalus Phrynocephalus forsythii
32532247 32532247 PRJEB83101_P_NODE_26159_length_359_cov_1.237762_g25854_i0 PRJEB83101 26159 359 1.237762 4.44356558 Hemidactylus frenatus 47729 Chordata Chordata 109 4.1e-25   NR YP_003002174.1 47729 g25854 i0 61.1 0.793871866295265 95 37 79.4 0 359 75 500 594 YP_003002174.1 NADH dehydrogenase subunit 5 [Hemidactylus frenatus] diamond 285 109 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Gekkonidae Hemidactylus Hemidactylus frenatus

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