contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Gastrotricha"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1894205 | 1894205 | PRJNA642647_P_NODE_3282_length_194_cov_4.038217_g3232_i0 | PRJNA642647 | 3282 | 194 | 4.038217 | 7.83414098 | Aspidiophorus tetrachaetus | 1194610 | Gastrotricha | other_Eukaryota | 276 | 9.13e-70 | NTclustered | gi|389075663|gb|JN185540.1| | 1194610 | g3232 | i0 | 92.347 | 100.170103092784 | 196 | 11 | 100 | 4 | 1 | 194 | 1476 | 1669 | Aspidiophorus tetrachaetus voucher TK99 28S ribosomal RNA gene, partial sequence | blastn | 19433 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Aspidiophorus | Aspidiophorus tetrachaetus | ||
| 10087060 | 10087060 | PRJNA642647_P_NODE_2648_length_213_cov_1.829545_g2598_i0 | PRJNA642647 | 2648 | 213 | 1.829545 | 3.89693085 | Chaetonotus | 68038 | Gastrotricha | other_Eukaryota | 348 | 2.13e-91 | NTclustered | gi|1748014074|gb|MN496276.1| | 2614565 | g2598 | i0 | 96.262 | 100.657276995305 | 214 | 5 | 100 | 2 | 1 | 213 | 1893 | 2104 | Chaetonotus aff. haideri MK-2019 voucher GA_10.18 large subunit ribosomal RNA gene, partial sequence | blastn | 21440 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus aff. haideri MK-2019 | ||
| 10822218 | 10822218 | PRJNA642647_P_NODE_4129_length_177_cov_3.292857_g4079_i0 | PRJNA642647 | 4129 | 177 | 3.292857 | 5.82835689 | Chaetonotus sp. 2 MK-2019 | 2594615 | Gastrotricha | other_Eukaryota | 255 | 1.06e-63 | NTclustered | gi|1701710056|gb|MK310449.1| | 2594615 | g4079 | i0 | 94.578 | 51.045197740113 | 166 | 7 | 93 | 2 | 1 | 164 | 5990 | 6155 | Chaetonotus sp. 2 MK-2019 voucher IC_56.19 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9035 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus sp. 2 MK-2019 | ||
| 16461354 | 16461354 | PRJNA642647_P_NODE_4413_length_172_cov_10.185185_g4363_i0 | PRJNA642647 | 4413 | 172 | 10.185185 | 17.5185182 | Chaetonotus | 68038 | Gastrotricha | other_Eukaryota | 287 | 3.63e-73 | NTclustered | gi|1418591743|gb|MF325887.1| | 2259391 | g4363 | i0 | 99.367 | 90.6046511627907 | 158 | 1 | 92 | 0 | 2 | 159 | 411 | 568 | Chaetonotus subtilis isolate AMU241.26 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, region | blastn | 15584 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus subtilis | ||
| 17195940 | 17195940 | PRJNA642647_P_NODE_374_length_575_cov_2.715613_g326_i0 | PRJNA642647 | 374 | 575 | 2.715613 | 15.61477475 | Lepidodermella intermedia | 1194613 | Gastrotricha | other_Eukaryota | 691 | 0 | NTclustered | gi|389075585|gb|JN185514.1| | 1194613 | g326 | i0 | 88.601 | 96.0782608695652 | 579 | 48 | 99 | 9 | 4 | 575 | 1033 | 466 | Lepidodermella intermedia voucher TK126 28S ribosomal RNA gene, partial sequence | blastn | 55245 | 691 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella intermedia | ||
| 23570707 | 23570707 | PRJNA642647_P_NODE_3339_length_193_cov_2.756410_g3289_i0 | PRJNA642647 | 3339 | 193 | 2.75641 | 5.3198713 | Lepidodermella aff. intermedia MK-2020 | 2797310 | Gastrotricha | other_Eukaryota | 346 | 6.82e-91 | NTclustered | gi|1946637706|gb|MW377596.1| | 2797310 | g3289 | i0 | 99.474 | 87.1088082901554 | 190 | 1 | 98 | 0 | 1 | 190 | 217 | 28 | Lepidodermella aff. intermedia MK-2020 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence. | blastn | 16812 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella aff. intermedia MK-2020 | ||
| 24844299 | 24844299 | PRJNA642647_P_NODE_2000_length_244_cov_5.130435_g1950_i0 | PRJNA642647 | 2000 | 244 | 5.130435 | 12.5182614 | Lepidodermella minus | 1194614 | Gastrotricha | other_Eukaryota | 440 | 4.019999999999999e-119 | NTclustered | gi|389075429|gb|JN185474.1| | 1194615 | g1950 | i0 | 99.585 | 99.25 | 241 | 1 | 99 | 0 | 4 | 244 | 587 | 827 | Lepidodermella minus minus voucher TK166 18S ribosomal RNA gene, partial sequence | blastn | 24217 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella minus | ||
| 24844322 | 24844322 | PRJNA642647_P_NODE_4200_length_176_cov_2.352518_g4150_i0 | PRJNA642647 | 4200 | 176 | 2.352518 | 4.14043168 | Lepidodermella minus | 1194614 | Gastrotricha | other_Eukaryota | 324 | 2.85e-84 | NTclustered | gi|389075429|gb|JN185474.1| | 1194615 | g4150 | i0 | 100 | 99.4034090909091 | 175 | 0 | 99 | 0 | 1 | 175 | 89 | 263 | Lepidodermella minus minus voucher TK166 18S ribosomal RNA gene, partial sequence | blastn | 17495 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella minus |
Advanced export
JSON shape: default, array, newline-delimited
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);;