contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4013890 | 4013890 | PRJNA1073183_P_NODE_6304_length_505_cov_2.254630_g6211_i0 | PRJNA1073183 | 6304 | 505 | 2.25463 | 11.3858815 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 520 | 1.13e-142 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g6211 | i0 | 85.519 | 24.239603960396 | 511 | 58 | 99 | 16 | 1 | 504 | 2395 | 1894 | Rotaria rotatoria mitochondrion, complete genome | blastn | 12241 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 7839645 | 7839645 | PRJNA1073183_P_NODE_1187_length_1091_cov_3.614931_g1131_i0 | PRJNA1073183 | 1187 | 1091 | 3.614931 | 39.43889721 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 525 | 5.439999999999999e-144 | NTclustered | gi|62362203|gb|AY942841.1| | 317012 | g1131 | i0 | 83.392 | 1.69477543538038 | 572 | 90 | 52 | 5 | 471 | 1039 | 633 | 64 | Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds | blastn | 1849 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 7839756 | 7839756 | PRJNA1073183_P_NODE_18027_length_308_cov_1.821277_g17932_i0 | PRJNA1073183 | 18027 | 308 | 1.821277 | 5.60953316 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 374 | 5.4e-99 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g17932 | i0 | 88.599 | 88.9772727272727 | 307 | 35 | 99 | 0 | 1 | 307 | 26859 | 26553 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 27405 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 10390784 | 10390784 | PRJNA1073183_P_NODE_8329_length_442_cov_1.043360_g8235_i0 | PRJNA1073183 | 8329 | 442 | 1.04336 | 4.6116512 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 272 | 3.0099999999999993e-68 | NTclustered | gi|402761851|gb|JX184057.1| | 104786 | g8235 | i0 | 79.369 | 1.19683257918552 | 412 | 65 | 91 | 18 | 1 | 402 | 873 | 472 | Habrotrocha constricta NADH dehydrogenase subunit 4 (ND4) gene, partial cds; mitochondrial | blastn | 529 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 11666161 | 11666161 | PRJNA1073183_P_NODE_8710_length_433_cov_0.855556_g8616_i0 | PRJNA1073183 | 8710 | 433 | 0.855556 | 3.70455748 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 409 | 2.15e-109 | NTclustered | gi|402761805|gb|JX184034.1| | 104786 | g8616 | i0 | 86.243 | 19.840646651270202 | 378 | 50 | 87 | 2 | 50 | 426 | 331 | 707 | Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 8591 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 12940764 | 12940764 | PRJNA1073183_P_NODE_11051_length_387_cov_1.245223_g10956_i0 | PRJNA1073183 | 11051 | 387 | 1.245223 | 4.81901301 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 359 | 1.94e-94 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g10956 | i0 | 86.503 | 39.4935400516796 | 326 | 44 | 84 | 0 | 56 | 381 | 26040 | 26365 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 15284 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 12940871 | 12940871 | PRJNA1073183_P_NODE_17771_length_310_cov_8.995781_g17676_i0 | PRJNA1073183 | 17771 | 310 | 8.995781 | 27.8869211 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 231 | 3.47e-56 | NTclustered | gi|183178949|gb|EU432548.1| | 96448 | g17676 | i0 | 89.189 | 3.98064516129032 | 185 | 20 | 60 | 0 | 1 | 185 | 34649 | 34465 | Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds | blastn | 1234 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 14216092 | 14216092 | PRJNA1073183_P_NODE_33752_length_242_cov_0.911243_g33657_i0 | PRJNA1073183 | 33752 | 242 | 0.911243 | 2.20520806 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 159 | 1.2499999999999999e-34 | NTclustered | gi|183178964|gb|EU432549.1| | 96448 | g33657 | i0 | 84.146 | 0.677685950413223 | 164 | 26 | 68 | 0 | 75 | 238 | 2362 | 2199 | Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds | blastn | 164 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 16764406 | 16764406 | PRJNA1073183_P_NODE_7294_length_472_cov_1.709273_g7200_i0 | PRJNA1073183 | 7294 | 472 | 1.709273 | 8.06776856 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 357 | 8.69e-94 | NTclustered | gi|62362199|gb|AY942839.1| | 317012 | g7200 | i0 | 81.69 | 14.6525423728814 | 426 | 78 | 90 | 0 | 39 | 464 | 512 | 87 | Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds | blastn | 6916 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 18038823 | 18038823 | PRJNA1073183_P_NODE_17295_length_315_cov_0.933884_g17200_i0 | PRJNA1073183 | 17295 | 315 | 0.933884 | 2.9417346 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 505 | 1.8799999999999995e-138 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g17200 | i0 | 95.597 | 58.3269841269841 | 318 | 8 | 100 | 5 | 1 | 315 | 2041 | 2355 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 18373 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 20588065 | 20588065 | PRJNA1073183_P_NODE_10357_length_398_cov_4.855385_g10263_i0 | PRJNA1073183 | 10357 | 398 | 4.855385 | 19.3244323 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 337 | 9.399999999999998e-88 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g10263 | i0 | 82.398 | 1.51758793969849 | 392 | 63 | 98 | 6 | 10 | 398 | 10923 | 10535 | Rotaria rotatoria mitochondrion, complete genome | blastn | 604 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 21863992 | 21863992 | PRJNA1073183_P_NODE_1978_length_873_cov_2.462500_g1906_i0 | PRJNA1073183 | 1978 | 873 | 2.4625 | 21.497625 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 449 | 2.6699999999999995e-121 | NTclustered | gi|183178964|gb|EU432549.1| | 96448 | g1906 | i0 | 86.7 | 3.20618556701031 | 406 | 52 | 56 | 2 | 306 | 710 | 19955 | 19551 | Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds | blastn | 2799 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;