RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA888104" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA888104 · 4 ✖

analysis 1

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
2137570 2137570 PRJNA888104_P_NODE_14062_length_274_cov_1.424390_g13993_i0 PRJNA888104 14062 274 1.42439 3.9028286 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g13993 i0 100 0.102189781021898 28 0 10 0 11 38 43390403 43390430 Satyrium ilicis genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
8515068 8515068 PRJNA888104_P_NODE_16547_length_253_cov_1.983696_g16478_i0 PRJNA888104 16547 253 1.983696 5.01875088 Artemia sorgeloosi 3034414 Arthropoda Arthropoda 468 1.92e-127   NTclustered gi|2035777536|gb|MZ168851.1| 3034414 g16478 i0 100 99.6640316205534 253 0 100 0 1 253 315 63 Artemia sorgeloosi isolate SOR15 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 25215 468 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia sorgeloosi
16165224 16165224 PRJNA888104_P_NODE_9553_length_323_cov_1.598425_g9484_i0 PRJNA888104 9553 323 1.598425 5.16291275 Timema shepardi 629360 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|1937848848|emb|OC002462.1| 629360 g9484 i0 96.875 0.0990712074303406 32 0 10 1 115 146 51447 51477 2_Tsi_b3v08 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema shepardi
21264274 21264274 PRJNA888104_P_NODE_22657_length_229_cov_0.912500_g22588_i0 PRJNA888104 22657 229 0.9125 2.089625 Artemia franciscana 6661 Arthropoda Arthropoda 283 6.65e-72   NTclustered gi|2743031514|ref|XR_010618616.1| 6661 g22588 i0 88.936 2.05240174672489 235 18 100 4 1 229 2193 2425 PREDICTED: Artemia franciscana uncharacterized LOC136031935 (LOC136031935), transcript variant X1, ncRNA blastn 470 283 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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