RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1112809" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1112809 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
26941279 26941279 PRJNA1112809_P_NODE_90542_length_353_cov_0.900000_g87267_i0 PRJNA1112809 90542 353 0.9 3.177 Sceloporus undulatus 8520 Chordata Chordata 131 1.26e-32   NR XP_042317564.1 8520 g87267 i0 75 3.90084985835694 92 23 78.2 0 1 276 1296 1387 XP_042317564.1 uncharacterized protein LOC121927762 [Sceloporus undulatus] diamond 1377 131 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Phrynosomatidae Sceloporus Sceloporus undulatus
27090703 27090703 PRJNA1112809_P_NODE_150642_length_263_cov_1.215789_g147367_i0 PRJNA1112809 150642 263 1.215789 3.19752507 root 1 Root_unresolved Root_unresolved 43.5 0.0101   NR XP_062835347.1 28377 g147367 i0 44.7 1.81368821292776 47 25 52.5 1 257 120 49 95 XP_062835347.1 chelonianin [Anolis carolinensis] diamond 477 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Dactyloidae Anolis Anolis carolinensis
27415812 27415812 PRJNA1112809_P_NODE_187043_length_243_cov_0.905882_g183768_i0 PRJNA1112809 187043 243 0.905882 2.20129326 Rhineura floridana 261503 Chordata Chordata 52.8 1.12e-5   NR XP_061442803.1 261503 g183768 i0 57.8 1.11111111111111 45 18 55.6 1 109 243 1 44 XP_061442803.1 sushi domain-containing protein 2 isoform X3 [Rhineura floridana] diamond 270 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Rhineuridae Rhineura Rhineura floridana
27438557 27438557 PRJNA1112809_P_NODE_52263_length_523_cov_2.355556_g48998_i0 PRJNA1112809 52263 523 2.355556 12.31955788 root 1 Root_unresolved Root_unresolved 49.3 0.00301   NR XP_068421904.1 9764 g48998 i0 28.5 1.02103250478011 137 60 65.4 4 159 500 353 474 XP_068421904.1 collagen alpha-1(I) chain-like [Eschrichtius robustus] diamond 534 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Eschrichtiidae Eschrichtius Eschrichtius robustus
28426063 28426063 PRJNA1112809_P_NODE_193366_length_241_cov_0.916667_g190091_i0 PRJNA1112809 193366 241 0.916667 2.20916747 Lepidochelys kempii 8472 Chordata Chordata 114 1.31e-29   NR CAM4594941.1 8472 g190091 i0 63.6 3.75933609958506 77 28 95.9 0 10 240 69 145 CAM4594941.1 unnamed protein product [Lepidochelys kempii] diamond 906 114 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Cheloniidae Lepidochelys Lepidochelys kempii
28678655 28678655 PRJNA1112809_P_NODE_154247_length_259_cov_2.344086_g150972_i0 PRJNA1112809 154247 259 2.344086 6.07118274 Balaenoptera physalus 9770 Chordata Chordata 44.7 9.53e-4   NR KAB0394236.1 9770 g150972 i0 87 0.266409266409266 23 3 26.6 0 189 257 29 51 KAB0394236.1 hypothetical protein E2I00_005928, partial [Balaenoptera physalus] diamond 69 44.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Balaenopteridae Balaenoptera Balaenoptera physalus
28710185 28710185 PRJNA1112809_P_NODE_104007_length_323_cov_2.008000_g100732_i0 PRJNA1112809 104007 323 2.008 6.48584 Leucoraja erinaceus 7782 Chordata Chordata 67.4 1.19e-10   NR XP_055493235.1 7782 g100732 i0 58.5 1.85758513931889 53 22 49.2 0 155 313 114 166 XP_055493235.1 uncharacterized protein LOC129698247 [Leucoraja erinaceus] diamond 600 67.4 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Rajiformes Rajidae Leucoraja Leucoraja erinaceus
28804554 28804554 PRJNA1112809_P_NODE_167768_length_250_cov_0.870056_g164493_i0 PRJNA1112809 167768 250 0.870056 2.17514 Pogona vitticeps 103695 Chordata Chordata 79.3 4.51e-15   NR XP_020667434.1 103695 g164493 i0 65.1 1.524 63 16 68.4 1 246 76 24 86 XP_020667434.1 STE20-related kinase adapter protein beta [Pogona vitticeps] diamond 381 79.3 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Agamidae Pogona Pogona vitticeps
29183879 29183879 PRJNA1112809_P_NODE_167889_length_250_cov_0.870056_g164614_i0 PRJNA1112809 167889 250 0.870056 2.17514 Mus musculus 10090 Chordata Chordata 70.5 7.13e-12   NR BAA20419.1 10090 g164614 i0 54.7 0.9 75 34 90 0 1 225 257 331 BAA20419.1 reverse transcriptase, partial [Mus musculus] diamond 225 70.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
29309930 29309930 PRJNA1112809_P_NODE_162309_length_252_cov_1.586592_g159034_i0 PRJNA1112809 162309 252 1.586592 3.99821184 Hemicordylus capensis 884348 Chordata Chordata 143 2.05e-37   NR XP_053149414.1 884348 g159034 i0 69.9 2.96428571428571 83 25 98.8 0 251 3 955 1037 XP_053149414.1 LOW QUALITY PROTEIN: uncharacterized protein K02A2.6-like [Hemicordylus capensis] diamond 747 143 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Cordylidae Hemicordylus Hemicordylus capensis
29973124 29973124 PRJNA1112809_P_NODE_200971_length_210_cov_4.124088_g197696_i0 PRJNA1112809 200971 210 4.124088 8.6605848 Staurois parvus 386267 Chordata Chordata 53.1 9.17e-7   NR CAI9548327.1 386267 g197696 i0 58 0.714285714285714 50 16 64.3 1 135 1 47 96 CAI9548327.1 unnamed protein product [Staurois parvus] diamond 150 53.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
30153547 30153547 PRJNA1112809_P_NODE_114232_length_306_cov_0.939914_g110957_i0 PRJNA1112809 114232 306 0.939914 2.87613684 root 1 Root_unresolved Root_unresolved 54.7 4.58e-6   NR XP_012785987.2 9978 g110957 i0 39.3 8.3921568627451 61 37 59.8 0 51 233 22 82 XP_012785987.2 POTE ankyrin domain family member B-like isoform X3 [Ochotona princeps] diamond 2568 54.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Lagomorpha Ochotonidae Ochotona Ochotona princeps
30162492 30162492 PRJNA1112809_P_NODE_75632_length_398_cov_1.886154_g72357_i0 PRJNA1112809 75632 398 1.886154 7.50689292 Staurois parvus 386267 Chordata Chordata 44.3 0.00426   NR CAI9623369.1 386267 g72357 i0 50 0.28643216080402 38 19 28.6 0 153 40 25 62 CAI9623369.1 unnamed protein product [Staurois parvus] diamond 114 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
30573150 30573150 PRJNA1112809_P_NODE_152233_length_261_cov_2.063830_g148958_i0 PRJNA1112809 152233 261 2.06383 5.3865963 Chroicocephalus maculipennis 287016 Chordata Chordata 45.4 0.0052   NR NWT39875.1 287016 g148958 i0 42.4 0.758620689655172 66 31 72.4 2 17 205 103 164 NWT39875.1 ATS1 metalloproteinase [Chroicocephalus maculipennis] diamond 198 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Aves Charadriiformes Laridae Chroicocephalus Chroicocephalus maculipennis
31901197 31901197 PRJNA1112809_P_NODE_170717_length_249_cov_0.875000_g167442_i0 PRJNA1112809 170717 249 0.875 2.17875 Ciona intestinalis 7719 Chordata Chordata 58.5 1.06e-7   NR XP_026691420.1 7719 g167442 i0 38.7 1.80722891566265 75 40 86.7 2 217 2 343 414 XP_026691420.1 uncharacterized protein LOC100183735 isoform X2 [Ciona intestinalis] diamond 450 58.5 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Phlebobranchia Cionidae Ciona Ciona intestinalis
32534152 32534152 PRJNA1112809_P_NODE_118319_length_299_cov_2.340708_g115044_i0 PRJNA1112809 118319 299 2.340708 6.99871692 Apodemus sylvaticus 10129 Chordata Chordata 44.3 0.0145   NR XP_052040237.1 10129 g115044 i0 34.7 2.02675585284281 101 58 95.3 4 7 291 7 105 XP_052040237.1 tumor necrosis factor receptor superfamily member 5 isoform X2 [Apodemus sylvaticus] diamond 606 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Apodemus Apodemus sylvaticus

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