RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA602115" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA602115 · 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
575773 575773 PRJNA602115_P_NODE_7061_length_238_cov_1.446328_g7036_i0 PRJNA602115 7061 238 1.446328 3.44226064 Rhagoletis zephyria 28612 Arthropoda Arthropoda 183 7.27e-42   NTclustered gi|1048070852|ref|XM_017631906.1| 28612 g7036 i0 82.609 23.9957983193277 207 36 87 0 32 238 407 201 PREDICTED: Rhagoletis zephyria 60S ribosomal protein L23-like (LOC108375759), mRNA blastn 5711 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
575807 575807 PRJNA602115_P_NODE_8241_length_218_cov_0.815287_g8216_i0 PRJNA602115 8241 218 0.815287 1.77732566 Hydrometra stagnorum 446445 Arthropoda Arthropoda 206 1.4e-48   NTclustered gi|1131051030|gb|KX821841.1| 446445 g8216 i0 84.348 53.0779816513761 230 15 100 12 1 218 1278 1058 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 11571 206 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
1851463 1851463 PRJNA602115_P_NODE_4522_length_294_cov_1.493562_g4497_i0 PRJNA602115 4522 294 1.493562 4.39107228 Vespula vulgaris 7454 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2313475109|ref|XM_051002196.1| 7454 g4497 i0 100 0.0952380952380952 28 0 10 0 258 285 3023 3050 PREDICTED: Vespula vulgaris putative uncharacterized protein DDB_G0271606 (LOC127067363), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula vulgaris
15171087 15171087 PRJNA602115_P_NODE_11212_length_202_cov_1.815603_g11187_i0 PRJNA602115 11212 202 1.815603 3.66751806 Speleorchestes 386823 Arthropoda Arthropoda 93.5 1.04e-14   NTclustered gi|1282187772|gb|KY921977.1| 2051766 g11187 i0 86.905 34.470297029703 84 9 42 2 1 84 1284 1203 Speleorchestes sp. AD937 voucher UMMZ BMOC 07-0814-002 AD937 28S ribosomal RNA gene, partial sequence blastn 6963 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD937
16445580 16445580 PRJNA602115_P_NODE_10413_length_205_cov_0.888889_g10388_i0 PRJNA602115 10413 205 0.888889 1.82222245 Arthropoda 6656 Arthropoda Arthropoda 67.6 6.39e-7   NTclustered gi|2617312082|ref|XM_060791195.1| 42062 g10388 i0 93.478 20.6243902439024 46 2 22 1 1 45 8491 8446 PREDICTED: Drosophila nasuta dynein beta chain, ciliary (LOC132785202), mRNA blastn 4228 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
17720776 17720776 PRJNA602115_P_NODE_2094_length_412_cov_2.367521_g2069_i0 PRJNA602115 2094 412 2.367521 9.75418652 root 1 Root_unresolved Root_unresolved 756 0   NTclustered gi|51557702|gb|AY603576.1| 179676 g2069 i0 99.757 516.041262135922 412 1 100 0 1 412 32 443 Culicoides sonorensis clone Cssg00031 putative salivary protein mRNA, partial cds blastn 212609 761 0.993429697766097 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides sonorensis

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