RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA846086" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA846086 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
4661294 4661294 PRJNA846086_P_NODE_3384_length_250_cov_0.870056_g3318_i0 PRJNA846086 3384 250 0.870056 2.17514 Chironomus tentans 7153 Arthropoda Arthropoda 457 4.1099999999999985e-124   NTclustered gi|1834412|emb|X99212.1| 7153 g3318 i0 99.6 96.584 250 1 100 0 1 250 6954 7203 Chironomus tentans partial 18S rRNA gene, 5.8S rRNA gene, partial 28S rRNA gene, internal transcribed spacers 1 and 2 and intergenic spacer blastn 24146 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
4661300 4661300 PRJNA846086_P_NODE_3704_length_248_cov_1.760000_g3638_i0 PRJNA846086 3704 248 1.76 4.3648 Timema monikensis 170555 Arthropoda Arthropoda 58.4 4.82e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g3638 i0 97.059 0.25 34 1 14 0 71 104 168543 168510 3_Tms_b3v08 blastn 62 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
5059183 5059183 PRJNA846086_P_NODE_324_length_671_cov_2.607023_g261_i0 PRJNA846086 324 671 2.607023 17.49312433 Neocaridina 274641 Arthropoda Arthropoda 1221 0   NTclustered gi|598323895|ref|NC_023823.1| 274642 g261 i0 99.552 80.6661698956781 670 3 99 0 2 671 11187 11856 Neocaridina denticulata mitochondrion, complete genome blastn 54127 1221 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Neocaridina Neocaridina denticulata
11434995 11434995 PRJNA846086_P_NODE_1189_length_341_cov_1.078358_g1123_i0 PRJNA846086 1189 341 1.078358 3.67720078 Neocaridina 274641 Arthropoda Arthropoda 604 1.9699999999999992e-168   NTclustered gi|2806412150|gb|PQ246621.1| 274642 g1123 i0 98.824 27 340 3 99 1 1 340 12361 12023 Neocaridina denticulata isolate morph-A mitochondrion, complete genome blastn 9207 604 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Neocaridina Neocaridina denticulata
14860805 14860805 PRJNA846086_P_NODE_5192_length_242_cov_1.704142_g5126_i0 PRJNA846086 5192 242 1.704142 4.12402364 Longitarsus dorsalis 346795 Arthropoda Arthropoda 91.6 4.62e-14   NTclustered gi|2918386009|emb|OZ238095.1| 346795 g5126 i0 86.364 23.6735537190083 88 7 36 4 31 116 8982107 8982191 Longitarsus dorsalis genome assembly, chromosome: 2 blastn 5729 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
16135548 16135548 PRJNA846086_P_NODE_2133_length_277_cov_1.294118_g2067_i0 PRJNA846086 2133 277 1.294118 3.58470686 Neocaridina denticulata 274642 Arthropoda Arthropoda 496 9.8e-136   NTclustered gi|2806412150|gb|PQ246621.1| 274642 g2067 i0 98.917 64.5812274368231 277 3 100 0 1 277 3902 3626 Neocaridina denticulata isolate morph-A mitochondrion, complete genome blastn 17889 496 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Neocaridina Neocaridina denticulata
17411097 17411097 PRJNA846086_P_NODE_574_length_493_cov_2.290476_g508_i0 PRJNA846086 574 493 2.290476 11.29204668 Neocaridina denticulata 274642 Arthropoda Arthropoda 606 8.189999999999998e-169   NTclustered gi|47078722|gb|AY596945.1| 274643 g508 i0 96.467 14 368 11 74 2 1 367 303 669 Neocaridina denticulata sinensis trypsin gene, partial cds blastn 6902 606 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Neocaridina Neocaridina denticulata
19959248 19959248 PRJNA846086_P_NODE_1576_length_302_cov_1.266376_g1510_i0 PRJNA846086 1576 302 1.266376 3.82445552 Trachypeplus jacobsoni 2172479 Arthropoda Arthropoda 80.5 1.29e-10   NTclustered gi|1421723530|ref|NC_037837.1| 2172479 g1510 i0 76.22 6.98344370860927 164 31 53 8 135 293 10621 10781 Trachypeplus jacobsoni mitochondrion, complete genome blastn 2109 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Tingidae Trachypeplus Trachypeplus jacobsoni
21633250 21633250 PRJNA846086_P_NODE_4517_length_245_cov_0.895349_g4451_i0 PRJNA846086 4517 245 0.895349 2.19360505 Aphididae 27482 Arthropoda Arthropoda 411 3.17e-110   NTclustered gi|11034|emb|X62623.1| 7029 g4451 i0 97.131 68.216326530612207 244 6 99 1 2 245 1137 1379 A.pisum gene for 18S ribosomal RNA blastn 16713 414 0.992753623188406 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
24182804 24182804 PRJNA846086_P_NODE_1479_length_312_cov_1.606695_g1413_i0 PRJNA846086 1479 312 1.606695 5.0128884 Portunidae 6757 Arthropoda Arthropoda 202 2.7399999999999997e-47   NTclustered gi|2705063975|ref|XM_064015087.1| 85552 g1413 i0 79.452 10.4166666666667 292 54 93 6 1 289 110 398 PREDICTED: Scylla paramamosain chymotrypsin BII-like (LOC135106258), mRNA blastn 3250 202 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
25059074 25059074 PRJNA846086_P_NODE_4880_length_244_cov_0.900585_g4814_i0 PRJNA846086 4880 244 0.900585 2.1974274 Aedes albopictus 7160 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2669910472|ref|XM_062855586.1| 7160 g4814 i0 96.97 2.79508196721311 33 1 14 0 206 238 2046 2078 PREDICTED: Aedes albopictus uncharacterized protein K02A2.6-like (LOC109428103), transcript variant X2, mRNA blastn 682 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus

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