RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA207343 · 22 ✖

analysis 1

  • blastn · 22 ✖
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
366973 366973 PRJNA207343_S_NODE_7241_length_220_cov_6.983607_g6704_i0 PRJNA207343 7241 220 6.983607 15.3639354 Dioscorea cayenensis 29710 Plants Plants 353 4.77e-93   NTclustered gi|1221815427|dbj|LC219413.1| 55577 g6704 i0 96.279 7.74545454545455 215 8 98 0 1 215 2107 1893 Dioscorea rotundata mitochondrial DNA, contig: TDr_Mt_scaffold40_size3084, cultivar: TDr96_F1 blastn 1704 353 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Dioscoreales Dioscoreaceae Dioscorea Dioscorea cayenensis
3606309 3606309 PRJNA207343_S_NODE_11463_length_151_cov_239.807018_g10926_i0 PRJNA207343 11463 151 239.807018 362.10859718 root 1 Root_unresolved Root_unresolved 84.2 4.37e-12   NTclustered gi|73646992|gb|DQ115326.1| 3635 g10926 i0 93.103 257.35761589404 58 2 37 2 96 151 340 397 Gossypium hirsutum strain CNH 123 genomic sequence blastn 38861 84.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
4883899 4883899 PRJNA207343_S_NODE_4844_length_323_cov_760.419580_g4307_i0 PRJNA207343 4844 323 760.41958 2456.1552434 root 1 Root_unresolved Root_unresolved 78.7 5e-10   NTclustered gi|73646992|gb|DQ115326.1| 3635 g4307 i0 92.727 114.260061919505 55 2 16 2 1 53 394 340 Gossypium hirsutum strain CNH 123 genomic sequence blastn 36906 78.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
4883968 4883968 PRJNA207343_S_NODE_8724_length_187_cov_1497.980000_g8187_i0 PRJNA207343 8724 187 1497.98 2801.2226 root 1 Root_unresolved Root_unresolved 71.3 4.42e-8   NTclustered gi|73646992|gb|DQ115326.1| 3635 g8187 i0 100 118.839572192513 38 0 20 0 1 38 706 669 Gossypium hirsutum strain CNH 123 genomic sequence blastn 22223 71.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
4883979 4883979 PRJNA207343_S_NODE_9204_length_179_cov_892.922535_g8667_i0 PRJNA207343 9204 179 892.922535 1598.33133765 root 1 Root_unresolved Root_unresolved 84.2 5.38e-12   NTclustered gi|73646992|gb|DQ115326.1| 3635 g8667 i0 94.643 209.927374301676 56 0 30 3 126 179 340 394 Gossypium hirsutum strain CNH 123 genomic sequence blastn 37577 84.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
6158607 6158607 PRJNA207343_S_NODE_2685_length_544_cov_419.998028_g2171_i0 PRJNA207343 2685 544 419.998028 2284.78927232 root 1 Root_unresolved Root_unresolved 82.4 6.82e-11   NTclustered gi|73646992|gb|DQ115326.1| 3635 g2171 i0 96.078 62.625 51 0 9 2 1 50 389 340 Gossypium hirsutum strain CNH 123 genomic sequence blastn 34068 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
6158664 6158664 PRJNA207343_S_NODE_5525_length_283_cov_86.284553_g4988_i0 PRJNA207343 5525 283 86.284553 244.18528499 root 1 Root_unresolved Root_unresolved 78.7 4.31e-10   NTclustered gi|73646992|gb|DQ115326.1| 3635 g4988 i0 94.231 122.742049469965 52 1 18 2 1 51 390 340 Gossypium hirsutum strain CNH 123 genomic sequence blastn 34736 78.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
6744501 6744501 PRJNA207343_S_NODE_3526_length_429_cov_8.849490_g2993_i0 PRJNA207343 3526 429 8.84949 37.9643121 Quercus robur 38942 Plants Plants 241 8.23e-59   NTclustered gi|2293041731|ref|XR_007650647.1| 38942 g2993 i0 91.061 43.2750582750583 179 14 41 2 39 216 2778 2601 PREDICTED: Quercus robur 28S ribosomal RNA (LOC126711687), rRNA blastn 18565 241 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
7433833 7433833 PRJNA207343_S_NODE_4706_length_333_cov_115.222973_g4169_i0 PRJNA207343 4706 333 115.222973 383.69250009 root 1 Root_unresolved Root_unresolved 69.4 3.12e-7   NTclustered gi|73646992|gb|DQ115326.1| 3635 g4169 i0 100 69.2012012012012 37 0 11 0 297 333 673 709 Gossypium hirsutum strain CNH 123 genomic sequence blastn 23044 69.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
7433863 7433863 PRJNA207343_S_NODE_6446_length_245_cov_244.576923_g5909_i0 PRJNA207343 6446 245 244.576923 599.21346135 root 1 Root_unresolved Root_unresolved 69.4 2.2e-7   NTclustered gi|73646992|gb|DQ115326.1| 3635 g5909 i0 100 95.4081632653061 37 0 15 0 209 245 685 649 Gossypium hirsutum strain CNH 123 genomic sequence blastn 23375 69.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
8708524 8708524 PRJNA207343_S_NODE_10967_length_156_cov_1856.210084_g10430_i0 PRJNA207343 10967 156 1856.210084 2895.68773104 root 1 Root_unresolved Root_unresolved 71.3 3.55e-8   NTclustered gi|73646992|gb|DQ115326.1| 3635 g10430 i0 100 151.948717948718 38 0 24 0 1 38 673 710 Gossypium hirsutum strain CNH 123 genomic sequence blastn 23704 71.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
8708610 8708610 PRJNA207343_S_NODE_4447_length_350_cov_333.150160_g3910_i0 PRJNA207343 4447 350 333.15016 1166.02556 root 1 Root_unresolved Root_unresolved 78.7 5.45e-10   NTclustered gi|73646992|gb|DQ115326.1| 3635 g3910 i0 92.857 107.362857142857 56 1 15 3 297 350 340 394 Gossypium hirsutum strain CNH 123 genomic sequence blastn 37577 78.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
9983905 9983905 PRJNA207343_S_NODE_10048_length_167_cov_2312.376923_g9511_i0 PRJNA207343 10048 167 2312.376923 3861.66946141 root 1 Root_unresolved Root_unresolved 134 4.86e-27   NTclustered gi|73646992|gb|DQ115326.1| 3635 g9511 i0 97.468 293.75449101796403 79 1 47 1 90 167 745 667 Gossypium hirsutum strain CNH 123 genomic sequence blastn 49057 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
9984002 9984002 PRJNA207343_S_NODE_4228_length_368_cov_2.664653_g3691_i0 PRJNA207343 4228 368 2.664653 9.80592304 root 1 Root_unresolved Root_unresolved 431 3.8399999999999997e-116   NTclustered gi|1221815326|dbj|LC219388.1| 55577 g3691 i0 89.049 8.09510869565217 347 38 94 0 2 348 2299 2645 Dioscorea rotundata mitochondrial DNA, contig: TDr_Mt_scaffold15_size5671, cultivar: TDr96_F1 blastn 2979 431 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Dioscoreales Dioscoreaceae Dioscorea Dioscorea cayenensis
9984058 9984058 PRJNA207343_S_NODE_6628_length_240_cov_1.758621_g6091_i0 PRJNA207343 6628 240 1.758621 4.2206904 Poales 38820 Plants Plants 396 8.659999999999997e-106   NTclustered gi|2581912921|emb|OY737857.1| 4568 g6091 i0 100 814.133333333333 214 0 90 0 11 224 26549391 26549178 Triticum monococcum genome assembly, chromosome: UA blastn 195392 396 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum monococcum
9984124 9984124 PRJNA207343_S_NODE_9888_length_169_cov_9.704545_g9351_i0 PRJNA207343 9888 169 9.704545 16.40068105 Magnoliopsida 3398 Plants Plants 285 1.28e-72   NTclustered gi|2526104522|ref|XR_009020649.1| 34305 g9351 i0 98.758 90.603550295858 161 1 95 1 10 169 2810 2650 PREDICTED: Lotus japonicus 28S ribosomal RNA (LOC130741768), rRNA blastn 15312 287 0.993031358885017 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
13120780 13120780 PRJNA207343_S_NODE_7011_length_227_cov_4.010526_g6474_i0 PRJNA207343 7011 227 4.010526 9.10389402 Nothoceros vincentianus 56934 Plants Plants 128 3.27e-25   NTclustered gi|1765925914|gb|MN575700.1| 56934 g6474 i0 79.245 0.700440528634361 159 33 70 0 7 165 2624 2782 Nothoceros vincentianus internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 159 128 1 Eukaryota Embryophyta Viridiplantae Streptophyta Anthocerotopsida Dendrocerotales Dendrocerotaceae Nothoceros Nothoceros vincentianus
13809302 13809302 PRJNA207343_S_NODE_2711_length_540_cov_405.079523_g2195_i0 PRJNA207343 2711 540 405.079523 2187.4294242 root 1 Root_unresolved Root_unresolved 84.2 1.88e-11   NTclustered gi|73646992|gb|DQ115326.1| 3635 g2195 i0 93.103 71.9648148148148 58 2 10 2 485 540 340 397 Gossypium hirsutum strain CNH 123 genomic sequence blastn 38861 84.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
16358415 16358415 PRJNA207343_S_NODE_8233_length_197_cov_2.906250_g7696_i0 PRJNA207343 8233 197 2.90625 5.7253125 Poaceae 4479 Plants Plants 361 2.5e-95   NTclustered gi|1214171912|gb|KY636002.1| 4483 g7696 i0 100 186.091370558376 195 0 99 0 1 195 96533 96339 Aegilops bicornis voucher AE 788 chloroplast, partial genome blastn 36660 361 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops bicornis
17633572 17633572 PRJNA207343_S_NODE_6174_length_255_cov_5.477064_g5637_i0 PRJNA207343 6174 255 5.477064 13.9665132 Poaceae 4479 Plants Plants 453 5.44e-123   NTclustered gi|1214171912|gb|KY636002.1| 4483 g5637 i0 99.597 190.619607843137 248 1 97 0 8 255 97502 97255 Aegilops bicornis voucher AE 788 chloroplast, partial genome blastn 48608 453 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops bicornis
20182029 20182029 PRJNA207343_S_NODE_6936_length_229_cov_270.020833_g6399_i0 PRJNA207343 6936 229 270.020833 618.34770757 root 1 Root_unresolved Root_unresolved 84.2 7.24e-12   NTclustered gi|73646992|gb|DQ115326.1| 3635 g6399 i0 94.545 160.921397379913 55 1 23 2 177 229 340 394 Gossypium hirsutum strain CNH 123 genomic sequence blastn 36851 84.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
23318808 23318808 PRJNA207343_S_NODE_10039_length_168_cov_1.473282_g9502_i0 PRJNA207343 10039 168 1.473282 2.47511376 Orcuttia tenuis 251267 Plants Plants 252 1.3e-62   NTclustered gi|2879581020|emb|OZ217233.1| 251267 g9502 i0 99.281 189.422619047619 139 1 83 0 30 168 49063 49201 Orcuttia tenuis genome assembly, organelle: plastid:chloroplast blastn 31823 252 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Orcuttia Orcuttia tenuis

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