RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA816047 · 6 ✖

analysis 1

  • blastn · 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
25729662 25729662 PRJNA816047a_S_NODE_44034_length_314_cov_20.539419_g41374_i0 PRJNA816047 44034 314 20.539419 64.49377566 Lepadella patella 231622 Rotifera other_Eukaryota 355 2e-93   NTclustered gi|83285192|gb|DQ297739.1| 231622 g41374 i0 94.421 79.0095541401274 233 9 74 4 81 311 1 231 Lepadella patella 28S ribosomal RNA gene, partial sequence blastn 24809 355 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Lepadellidae Lepadella Lepadella patella
25770839 25770839 PRJNA816047b_S_NODE_5346_length_627_cov_34.817690_g3151_i0 PRJNA816047 5346 627 34.81769 218.3069163 Ploima 84394 Rotifera other_Eukaryota 340 1.19e-88   NTclustered gi|1859640894|gb|MN970216.1| 360698 g3151 i0 79.637 19.0861244019139 496 84 78 16 72 559 12520 12034 Proales similis mitochondrion, complete genome blastn 11967 340 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Proalidae Proales Proales similis
25904572 25904572 PRJNA816047a_S_NODE_15051_length_521_cov_75.147321_g12431_i0 PRJNA816047 15051 521 75.147321 391.51754241 Ploima 84394 Rotifera other_Eukaryota 316 1.64e-81   NTclustered gi|1859640894|gb|MN970216.1| 360698 g12431 i0 79.167 10.5028790786948 480 83 91 16 50 521 12520 12050 Proales similis mitochondrion, complete genome blastn 5472 318 0.993710691823899 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Proalidae Proales Proales similis
26014327 26014327 PRJNA816047d_S_NODE_75508_length_266_cov_2.089202_g73673_i0 PRJNA816047 75508 266 2.089202 5.55727732 Rotaria rotatoria 231624 Rotifera other_Eukaryota 309 1.31e-79   NTclustered gi|270267490|ref|NC_013568.1| 231624 g73673 i0 92.237 4.36466165413534 219 15 82 2 49 266 2417 2200 Rotaria rotatoria mitochondrion, complete genome blastn 1161 309 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria rotatoria
26272083 26272083 PRJNA816047a_S_NODE_21734_length_435_cov_26.060773_g19084_i0 PRJNA816047 21734 435 26.060773 113.36436255 Philodina citrina 468664 Rotifera other_Eukaryota 580 4.33e-161   NTclustered gi|407227484|emb|FR856884.1| 468664 g19084 i0 93.995 3.75402298850575 383 23 88 0 51 433 2032 2414 Philodina citrina complete mitochondrial genome blastn 1633 580 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina citrina
26551227 26551227 PRJNA816047b_S_NODE_34192_length_288_cov_5.269767_g31880_i0 PRJNA816047 34192 288 5.269767 15.17692896 Philodina citrina 468664 Rotifera other_Eukaryota 411 3.819999999999999e-110   NTclustered gi|407227484|emb|FR856884.1| 468664 g31880 i0 95.019 2.01736111111111 261 13 91 0 23 283 9399 9659 Philodina citrina complete mitochondrial genome blastn 581 411 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina citrina

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